Senior Data Engineer

Delta Dental; Alpharetta (GA); Remote; USD 171,000 - 197,000; Full time

Job summary

A leading company is seeking a Senior Data Engineer to design, develop, and maintain scalable data pipelines in a remote-friendly environment. This role involves extensive collaboration with various teams to ensure data integration, governance, and quality control. Ideal candidates will have significant experience in ETL development and data modeling, as well as proficiency in tools like Power BI and SQL. Join a team dedicated to leveraging data for impactful solutions.

Qualifications

• 6+ years of experience in Data Integration/ETL Development.
• Ability to work with APIs and Web services.
• Proficiency in data modeling techniques.

Responsibilities

• Design and maintain scalable data pipelines and ETL processes.
• Collaborate with cross-functional teams to understand data requirements.
• Troubleshoot data-related issues and develop effective solutions.

Skills

Data Integration

ETL Development

Data Engineering

Data Governance

Power BI Reporting

Python

SQL

Education

Bachelor’s degree in Computer Science

Tools

Matillion

Microsoft Azure Data Factory

Informatica

BODS

Tibco EBX

Tableau

Snowflake

Job description

EMPLOYER: Delta Dental Insurance Company

TITLE: Senior Data Engineer

Location: 1130 Sanctuary Pkwy, Alpharetta, GA 30009 – Telecommuting permissible from anywhere in the US.

Salary: $171,267-$196,500/yr

Job Description

Design, develop, and maintain scalable data pipelines and ETL processes to collect, transform, and store large volumes of data. Collaborate with cross-functional teams to understand data requirements, identify opportunities for data integration, and propose efficient data engineering solutions. Implement data governance and quality control measures to ensure data accuracy, consistency, and integrity throughout the data lifecycle. Lead the evaluation, selection, and implementation of data engineering technologies, tools, and frameworks. Collaborate with data scientists and analysts to support their data needs, providing efficient access to relevant datasets. Develop and maintain data models, schemas, and documentation to facilitate data understanding and accessibility. Work closely with infrastructure and DevOps teams to ensure data systems are secure, reliable, and properly integrated with existing infrastructure. Perform data profiling, analysis, and data mining tasks to identify patterns, trends, and insights in large datasets. Collaborate with stakeholders to identify business requirements and translate them into technical data engineering solutions. Implement data warehousing and data mart solutions to support reporting and analytics needs. Stay up to date with emerging data engineering technologies and best practices, and proactively recommend improvements to existing systems. Troubleshoot and resolve data-related issues, ensuring minimal disruption to data pipelines and systems. Collaborate with data privacy and compliance teams to ensure adherence to data privacy regulations and industry standards. Conduct performance monitoring and capacity planning to anticipate and address future data engineering needs. Develop and maintain data governance policies, procedures, and documentation. Participate in data architecture discussions and provide input on data storage, data flow, and data integration strategies. Collaborate with stakeholders to define and implement data retention and archival strategies. Continuously monitor and optimize data engineering processes, striving for efficiency, reliability, and scalability.

Qualifications

Bachelor’s degree or foreign degree equivalent in Computer Science, or related field, with six (6) years of progressive, post-baccalaureate experience in Data Integration/ETL Development, TDV, Data Engineering, Data Governance, Power BI Reporting, or related roles.

Base Pay Information

The national base pay range at the end is a good-faith estimate of what Delta Dental may pay for new hires. Actual pay may vary based on Delta Dental’s assessment of the candidate’s knowledge, skills, abilities (KSAs), related experience, education, certifications, and ability to meet minimum qualifications. Other factors include prevailing wages in the work location and internal equity.

Pay Grade 22. $171,267 - $196,500

CONTACT: Reference job # 1078812 and send resume to [e-mail].

Responsibilities

• Extensive experience with ELT/ETL tools like Matillion, Microsoft Azure Data Factory, Informatica, BODS, or custom scripts.
• Proficiency in languages such as Python or SQL.
• Experience with building data pipelines and orchestration for moving data from source to target systems. Understanding of data modeling techniques and best practices.
• Ability to work with APIs and Web services to integrate different data sources.
• Experience with relational (SQL), Non-Relational (NoSQL) databases including SQL Server, Oracle, MongoDB, and Snowflake.
• Knowledge of data governance, compliance standards, and data security best practices.
• Experience in implementing master data management solutions using tools like Tibco EBX.
• Experience in designing and implementing semantic data models to support data services and analytical reporting using tools like Tibco Data Virtualization (TDV), Snowflake, Tableau, Business Objects, and Power BI.
• Experience in building advanced analytical solutions including reports, dashboards, and scorecards using tools like Power BI and Tableau.
• Ability to troubleshoot data-related issues and develop effective solutions.
• Strong analytical skills to understand complex data requirements and translate them into technical solutions.