Data Integration Engineer II

About mPulse: mPulse is the leader in conversational AI and member engagement for healthcare. About mPulse: mPulse is the leader in conversational AI and member engagement for healthcare. We partner with the nation's most innovative health plans — Medicare Advantage, Medicaid, and Commercial — to engage members in conversations that close care gaps, improve Stars ratings, and drive better health outcomes. Our platform reaches tens of millions of Americans and is built on the belief that better health starts with better conversations. Job Summary We’re looking for a passionate, self-motivated, and detail-oriented individual to join our Data Operations team. In this role, you will design, develop, and maintain scalable data pipelines that power analytics, reporting, and product capabilities within the predict vertical of the organization. You will work closely 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, enjoys solving complex data problems, and is passionate about building reliable and well-documented data systems. Duties & 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 and reliable data assets. Collaborate with implementation teams to identify, investigate, and resolve data anomalies during data onboarding and integration processes. Partner with product engineering teams to ensure accurate data capture and alignment with application data specifications and business requirements. Provide data-related support to analytics and customer success teams, assisting with troubleshooting, reporting needs, and client data inquiries. Required Qualifications Bachelor’s or master’s degree in computer science, Engineering, or a 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 working with cloud-based data platforms and services, particularly within AWS (e.g., S3, Secrets Manager/Vault, DMS, or similar services). Hands-on experience with modern data warehousing platforms, such as Snowflake, PostgreSQL, Amazon Redshift, or Microsoft SQL Server. Experience developing, debugging, and maintaining workflow orchestration pipelines using Apache Airflow, including DAG development and operational support. Experience using dbt (data build tool) to develop, test, and manage modular SQL-based data transformation models within modern data warehouse environments. Experience with version control systems and collaborative development workflows, using tools such as GitHub or Bitbucket. Proficiency in Python, particularly for data manipulation, automation, and integration tasks. Familiarity with CI/CD practices and automation tools, such as Jenkins or GitHub Actions. Strong written and verbal communication skills, with the ability to collaborate effectively across technical and non-technical teams. Preferred Qualifications Experience supporting data quality monitoring, data observability, or automated validation frameworks. Familiarity with data science or machine learning workflows from a data