Data Integration Engineer II - Scalable ETL/ELT Pipelines

Mpulse Mobile, Inc; Northern (KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Mpulse Mobile, Inc. is seeking a data engineer to design, build, and maintain scalable data pipelines powering analytics, reporting, and product capabilities across the organization's data verticals.

You will collaborate with product engineering, implementation, analytics, and customer success teams to ensure data is accurate, reliable, and accessible. The ideal candidate has strong SQL and data warehousing experience and enjoys solving complex data problems, with hands-on experience in AWS,

Qualifications

• Bachelor’s or Master’s degree in computer science, engineering, or related technical field, or equivalent practical experience.
• Minimum of 3 years of professional experience in data engineering, data integration, or a related role.
• Strong proficiency in SQL, including complex querying, data transformation, and query performance optimization.
• Experience with cloud-based data platforms, particularly AWS services (S3, Secrets Manager, DMS, etc.).
• Hands-on experience with modern data warehousing platforms (Snowflake, PostgreSQL, Redshift, SQL Server).
• Experience developing, debugging, and maintaining workflow orchestration pipelines using Apache Airflow.

Responsibilities

• Design, develop, and maintain scalable data integration pipelines (ETL/ELT) to support data ingestion, transformation, cleansing, curation, and unification across multiple data sources.
• Develop and support end-to-end data pipeline components, including ingestion, validation, transformation, cleansing, and curated data layer development.
• Monitor, maintain, and optimize production data pipelines to ensure reliability, performance, and successful execution of scheduled workflows.
• Create and maintain comprehensive technical documentation for data pipelines, workflows, and data models.
• Develop tools and frameworks to support automated data profiling, data quality monitoring, and unit testing to ensure high-quality data assets.
• Collaborate with implementation teams to identify, investigate, and resolve data anomalies during onboarding and integration processes.
• Partner with product engineering teams to ensure accurate data capture and alignment with application data specs and business requirements.
• Provide data-related support to analytics and customer success teams, assisting with troubleshooting and reporting needs.

Skills

SQL proficiency

Problem solving

Collaboration

Communication

Education

Bachelor's or Master’s in CS or related field

Tools

Apache Airflow

dbt

Snowflake

AWS

Python

GitHub

Job description

Mpulse Mobile, Inc. is seeking a data engineer to design, build, and maintain scalable data pipelines powering analytics, reporting, and product capabilities across the organization's data verticals.

You will collaborate with product engineering, implementation, analytics, and customer success teams to ensure data is accurate, reliable, and accessible. The ideal candidate has strong SQL and data warehousing experience and enjoys solving complex data problems, with hands-on experience in AWS,