Senior Data Engineer - Data Integration & Analytics Platforms

Senior Data Engineer – Data Integration & Analytics Platforms Healthcare Chaos Management (HCM) is a 40-year-old, nationally scaled healthcare revenue cycle company that is transforming into a cutting-edge Healthcare FinTech organization. We serve hospitals and healthcare systems across the U.S., blending human-centric service with intelligent automation to improve patient financial experiences and optimize healthcare revenue operations. Job Overview We are seeking an experienced and highly skilled Senior Data Engineer to join our growing technology team. In this role, you will be responsible for designing, building, and optimizing enterprise-grade data integration solutions that support analytics, reporting, and customer-facing data products. This is a critical role for a technical leader who can make sound architectural decisions, optimize performance, and collaborate across engineering, analytics, and business teams. Key Responsibilities Data Engineering & Architecture Design, develop, and maintain scalable, reliable data pipelines using distributed data processing frameworks and cloud analytics platforms. Architect complex data ingestion, transformation, and integration workflows to support analytics and reporting needs. Lead data modeling and data architecture decisions to ensure accuracy, performance, and scalability. Database & Performance Optimization Provide deep expertise in SQL Server or equivalent relational databases, including query optimization and performance tuning. Optimize, automate, and monitor production data pipelines to ensure high availability and data integrity. Collaboration & Technical Leadership Collaborate closely with analytics, engineering, and business stakeholders to deliver high-quality data solutions. Mentor team members and contribute to shared engineering standards, best practices, and documentation. Support a culture of continuous learning, knowledge sharing, and process improvement within the data engineering team. Key Performance Indicators (KPIs) Performance in this role will be measured by: Data Reliability: Stability and accuracy of production data pipelines Performance: Efficiency and optimization of data processing and query performance Delivery: Timely completion of data engineering initiatives and enhancements Collaboration: Effective cross-functional partnership and team contribution What We Offer Compensation: Competitive compensation package, commensurate with experience Medical, Dental & Vision Insurance: Comprehensive health plans for you and your family Life Insurance: Employee life insurance coverage Flexible Time Off: FTO for a balanced work-life experience 401(k) Plan: Company match to support your long-term financial goals Additional Benefits: Paid holidays, collaborative team culture, and opportunities for growth and advancement Minimum Qualifications Experience: Extensive experience working with SQL Server or similar relational database platforms Technical Skills: Advanced proficiency in SQL and Python Cloud Data Platforms: Experience building and maintaining cloud-based data pipelines Collaboration & Leadership: Strong communication, collaboration, and mentorship 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 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) Work Environment: Highly collaborative, team-oriented office environment. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the role. Join Us At HCM, you’ll play a key role in building the data foundation that powers analytics, automation, and intelligent decision-making across the organization. If you’re a seasoned data engineer who enjoys solving complex problems, mentoring others, and making a meaningful impact in a growing Healthcare FinTech company, we encourage you to apply and join our team. Benefits: 401(k) 401(k) matching Dental insurance Employee assistance program Flexible schedule Health insurance Life insurance Paid time off Vision insurance Application Question(s): Are you located within 50 miles of the Indianapolis area? What are your compensation needs? Education: Bachelor's (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