Senior Data Engineer - Data Integration & Analytics Platforms

Senior Data Engineer responsible for designing, building, and optimizing enterprise-grade data integration solutions to support analytics, reporting, and customer-facing data products, with technical leadership across engineering, analytics, and business teams.

Responsibilities

• Build and maintain scalable data pipelines using distributed processing frameworks and cloud analytics platforms.
• Design and optimize complex data ingestion, transformation, and integration workflows to support analytics and reporting needs.
• Guide data modeling and architecture decisions to ensure accuracy, performance, and scalability.
• Leverage SQL Server or equivalent relational databases, focusing on query optimization and performance tuning.
• Improve, automate, and monitor production data pipelines to ensure high availability and data integrity.
• Collaborate with analytics, engineering, and business stakeholders to deliver robust data solutions.
• Mentor team members and contribute to engineering standards, best practices, and documentation.
• Promote continuous learning, knowledge sharing, and process improvements within the data engineering team.

Requirements

• Substantial experience with SQL Server or similar relational database platforms.
• Advanced proficiency in SQL and Python.
• Proven track record building and maintaining cloud-based data pipelines.
• Effective communication, collaboration, and mentoring abilities.

Technologies

• Microsoft Azure
• Azure Databricks
• Microsoft Fabric
• Delta Lake
• Azure Data Factory
• Azure SQL Database
• Power BI
• Azure DevOps
• GitHub Actions

What We Offer

• Competitive compensation package aligned with experience
• Medical, dental, and vision insurance for you and your family
• Life insurance coverage
• Flexible time off for work-life balance
• 401(k) plan with company matching
• Paid holidays and a collaborative team environment
• Opportunity for growth and advancement

Benefits

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible schedule
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Join Us

At HCM, you will help establish the data foundation powering analytics, automation, and intelligent decision-making across the organization. Senior data engineers who enjoy solving complex problems, mentoring teammates, and making a meaningful impact in a growing healthcare FinTech environment are encouraged to apply and become part of our team.

Work Environment & Physical Requirements

• Location: Hybrid role based in Indianapolis, IN
• Schedule: Full-time, in-office a minimum of three days per week (four days preferred)
• Environment: Highly collaborative, team-oriented office setting with accommodations available for disabled applicants as needed

Minimum Qualifications

• Experience: Extensive experience with SQL Server or similar relational database platforms
• Technical Skills: Advanced SQL and Python
• Cloud Data Platforms: Experience building and maintaining cloud-based data pipelines
• Collaboration & Leadership: Strong communication, collaboration, and mentoring skills

Preferred Platforms & Tools

• Microsoft Azure
• Azure Databricks, Microsoft Fabric, Delta Lake
• Azure Data Factory
• Azure SQL Database
• Power BI
• CI/CD tools such as Azure DevOps or GitHub Actions

Education

Bachelor's degree preferred.

Experience

• Microsoft Azure: 3 years (Required)
• Power BI: 3 years (Required)
• SQL: 4 years (Required)
• Python: 4 years (Required)
• Building cloud-based data pipelines: 3 years (Required)

Work Location

Hybrid remote in Indianapolis, IN 46230