Data Engineer – Newton Center, MA – Onsite

 

As a Senior Data Engineer you will enable data-driven decision making by collecting, transforming and visualizing the data. You will design, build, maintain and troubleshoot data processing systems with emphasis on security, reliability, fault-tolerance, scalability, fidelity, and efficiency.

Section 2: Job Functions, Essential Duties and Responsibilities Essential Job Functions:

• Design, build and maintain data structures and data processing systems (tools, infrastructure, frameworks, services).

• Assist with Data Warehouse project definition and planning.

• Troubleshoot issues as they occur.

• Data Integration

o Services

▪ Design and build data ingestion tools, metrics, alerts and notifications, metadata management.

▪ Design and build data replication services and Change Data Capture (CDC) processes to incrementally update data in the data warehouse / data marts from Ascensus systems of record.

o ETL development

▪ Contribute to standards and best practices for implementing ETL tools in support of the DW vision and reference architecture.

▪ Build and maintain ETL solutions on Oracle using PL/SQL Version 06/01/2019 Page 2

▪ Participate in creating a long term ETL application support model. o Data Warehouse and Data Marts

▪ Adhere to technical standards and specifications addressing performance, security and orchestration of ETL and data warehouse / mart management.

▪ Organize metadata and define processes for loading data into and extracting data from the warehouse / marts.

o Quality Control o Peer code review and quality assurance duties throughout the data warehouse project life cycle; creating, executing and updating unit test plans and test cases for necessary projects and application releases.

• Assist with other tasks and projects as assigned `

Section 3: Experience, Skills, Knowledge Requirements Required skills and experience

• 5+ years of relevant experience in data/software development, including data warehousing and ETL tools, techniques and technology.

• Bachelor’s degree or equivalent work experience. • Strong knowledge of Data Warehousing and ETL design/tools. • Excellent analytical skills. • Excellent oral and written communication skills including active listening. Asking appropriate questions, clarifying information and writing clear, concise documents. • Extensive Oracle and Pl/SQL experience and skills • Good experience with relational databases like Sybase ASE, Oracle, MySQL. Preferred knowledge, skills and abilities: • Experience with PowerBI, Tableau • Experience with Informatica