Senior Data Engineer (ETL / Python Developer)
Senior Data Engineer (ETL / Python Developer)Enterprise Data Warehouse (EDW) & Analytics ProgramWork ArrangementRemoteTravelPeriodic travel as required based on project or customer needsReports ToEDW Delivery Lead / Data Engineering ManagerAbout the RoleWe are seeking a hands-on Senior Data Engineer (ETL / Python Developer) to support a large-scale Enterprise Data Warehouse (EDW) and Analytics Program. This role is responsible for designing, developing, and maintaining scalable data ingestion and transformation pipelines that support healthcare analytics, regulatory reporting, and enterprise decision support.The ideal candidate will bring strong expertise in ETL development, Python engineering, Teradata, and modern cloud-based data platforms. This position requires close collaboration with architects, analysts, QA teams, project managers, subject matter experts, developers, and business intelligence teams to deliver high-quality, reliable data solutions in a regulated and audit-sensitive environment.Key ResponsibilitiesData Pipeline Development & EngineeringDesign, develop, and maintain enterprise ETL pipelines using Azure Data Factory (ADF), Informatica PowerCenter, and Python-based frameworks.Build and optimize scalable data processing solutions using Python, Apache Spark, and Databricks.Develop and optimize SQL queries, stored procedures, and database objects across platforms such as Snowflake, Oracle, and SQL Server.Apply data engineering best practices to ensure performance, scalability, reliability, reusability, and security.Analytics, Reporting & Data QualitySupport healthcare analytics and regulatory reporting initiatives.Develop robust data validation, reconciliation, and audit-ready data pipelines.Partner with analysts, QA teams, and reporting stakeholders to ensure data quality, accuracy, and timeliness.Implement controls and monitoring processes to maintain trusted and compliant data assets.Modernization, Operations & CollaborationParticipate in cloud migration and modernization initiatives leveraging Azure-based data architectures.Support production operations, incident management, troubleshooting, and root cause analysis.Contribute to code reviews, source control management, and CI/CD processes using Azure DevOps and GitHub.Collaborate across cross-functional teams to deliver scalable and maintainable data solutions.Required Qualifications5+ years of experience in data engineering with a focus on enterprise data warehousing.5+ years of hands-on ETL development experience using Informatica PowerCenter, Teradata, Azure Data Factory, or similar technologies.5+ years of experience developing solutions in Python for data engineering and automation.5+ years of experience working with Teradata, including Teradata loading and utility tools.3+ years of experience with Spark-based processing frameworks such as Databricks.Strong SQL expertise and experience working with relational databases, including Snowflake, Oracle, and SQL Server.3+ years of experience with Snowflake, including SnowSQL and Snowpark (Python).Experience with source control and DevOps practices using Azure DevOps, GitHub, and CI/CD pipelines.Strong analytical, problem-solving, and troubleshooting skills.Ability to work effectively in a fast-paced, collaborative environment.Willingness to travel periodically as required.Preferred QualificationsBachelor's degree or higher in Computer Science, Engineering, Analytics, or a related field.Azure certifications related to Data Engineering or Analytics.Experience supporting Enterprise Data Warehouse (EDW) environments.Healthcare, payer, public sector, or regulated-industry analytics experience.Data modeling experience in enterprise data warehouse environments.Automation and orchestration scripting using PowerShell or Bash.Experience designing, integrating, or consuming REST APIs within data platforms.Familiarity with data quality frameworks, reconciliation processes, and audit support requirements.Location & Work ModelWork Arrangement: Remote (U.S.-based)Travel: Periodic travel may be required based on project or customer needs.Technical Skills SummaryData Engineering & ETLAzure Data Factory (ADF)Informatica PowerCenterTeradataETL Design & DevelopmentProgramming & ProcessingPythonApache SparkDatabricksDatabases & WarehousingSnowflakeSnowSQLSnowpark (Python)OracleSQL ServerAdvanced SQLDevOps & CollaborationAzure DevOpsGitHubCI/CD PipelinesAdditional SkillsData Quality & ReconciliationData ModelingAPI Integration (REST)PowerShellBash