Data Jobs in Carmel, IN

1 job found

Include remote jobs

2mo ago

Business Intelligence & SQL Data Engineer

American Pain Consortium Carmel, IN

Carmel, IN

2mo ago Closed

Full time Analytics Business Analytics Business Intelligence

This position is no longer accepting applications (closed Jun 19, 2026).

Job Description

The Business Intelligence & SQL Data Engineer role at American Pain Consortium is based onsite in Carmel, IN, delivering Power BI, SQL Server, and enterprise data warehouse leadership.

Responsibilities

Create, enhance, and sustain organization-wide Power BI dashboards and reports.
Architect and tune SQL Server databases for performance and reliability.
Build advanced T-SQL queries, views, stored procedures, and ETL pipelines.
Develop and maintain dimensional models using star schemas and manage Bronze, Silver, and Gold data layers.
Monitor and optimize indexing strategies, execution plans, and overall query performance.
Assist data integration across EMR, scheduling, and billing systems to align datasets.
Ensure backup integrity, disaster recovery readiness, and data availability.
Support data integrations and migrations during acquisitions.
Establish naming conventions, documentation standards, and change governance.
Ensure data integrity through validation and reconciliation processes.
Monitor data quality and address discrepancies.
Collaborate with leadership to translate business requirements into scalable data solutions.
Maintain SQL Server virtual machines in coordination with IT infrastructure.
Assist with performance planning, storage growth forecasting, and patch coordination.
Work with the CIO and executive leadership on analytics strategy.
Develop standardized dashboards to support operational and financial reporting needs.
Build and manage semantic models and DAX measures.
Improve report performance and refresh reliability.
Maintain Power BI gateways, authentication, and scheduled refresh processes.
Collaborate with Finance and Operations to deliver AR, revenue cycle, KPI, and acquisition reporting.
Support self-service reporting initiatives and uphold data governance standards.

Requirements

Strong verbal and written communication abilities.
Solid analytical and problem-solving skills.
Meticulous attention to detail and accuracy.
Ability to juggle multiple priorities in a fast-paced setting.
Strong documentation and organizational capabilities.
Capability to translate technical concepts for non-technical stakeholders.
Ability to translate business requirements into technical solutions.
Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or related field preferred.
Three to seven-plus years of experience with Microsoft SQL Server.
Proficiency in T-SQL (joins, CTEs, stored procedures, performance tuning).
Three or more years of Power BI experience (DAX, semantic models, dataflows).
Experience designing star schemas or dimensional models.
Experience supporting production SQL environments.
Healthcare or financial reporting experience preferred.

Technologies

Power BI
Microsoft SQL Server
T-SQL
DAX
Power BI Dataflows
Power BI Gateways

Benefits

Medical, Dental, and Vision Insurance
Paid Time Off
Paid Holidays
401(k) matching
Referral program
Tuition reimbursement
Health insurance
Dental insurance
Vision insurance
Other benefits

Who we are

American Pain Consortium’s mission is to empower providers to deliver exceptional patient care.
As an employer, our mission is to empower every team member to reach their maximum potential and contribute to our shared success, built on hiring the brightest minds in the business.

View full job page →

Get Data Jobs in Carmel, IN alerts

New Data Jobs in Carmel, IN, daily.