Business Intelligence & SQL Data Engineer

Business Intelligence & SQL Data Engineer 3.2 3.2 out of 5 stars Carmel, IN 46032 Full-time American Pain Consortium 33 reviews Full-time 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 member of our team to realize their maximum professional potential and create an environment conducive to our shared success. As we look to partner with providers and add value, we also look to add value to our growing team by hiring the brightest minds in the business. We truly understand that our most valuable assets are our team members. American Pain Consortium started in 1993 with a passionate physician who has built a team of leaders to committed to developing the company around passionate, career-driven people and we are proud to boast an organization comprised of them. Job Summary Are you ready to take your career to the next level? AThe Business Intelligence & SQL Systems Engineer provides both strategic leadership and hands-on technical expertise for the organization's Power BI reporting environment, SQL Server infrastructure, and enterprise data warehouse. This role is responsible for designing and maintaining scalable data architecture, ensuring SQL Server performance and reliability, and delivering accurate executive reporting across clinical, operational, and financial domains. The Engineer will serve as the organization's subject matter expert in data modeling, semantic layer development, and SQL optimization while partnering closely with Finance, Operations, IT, and Executive Leadership. This role will support consistent and reliable reporting across clinical, operational, and financial domains in partnership with Operations, Finance, and IT teams. Join our team and be a part of American Pain Consortium! Essential Duties & Responsibilities (What You'll Do) Business Intelligence & Power BI Design, develop, and maintain enterprise Power BI dashboards and reports. SQL Server & Data Warehouse Design, maintain, and optimize SQL Server databases. Develop complex T-SQL queries, views, stored procedures, and ETL processes. Build and maintain dimensional models (star schema) and Bronze/Silver/Gold data layers. Monitor and tune indexing strategies, execution plans, and query performance. Support integration and alignment of data across multiple EMR, scheduling, and billing systems Ensure backup integrity, disaster recovery readiness, and data availability. Support acquisition integrations and data migrations. Data Architecture & Governance Establish naming conventions, documentation standards, and change governance. Ensure data integrity, validation, and reconciliation processes. Monitor data quality and resolve discrepancies. Partner with leadership to translate business requirements into scalable data solutions. Infrastructure & Collaboration Maintain SQL Server virtual machines in coordination with IT infrastructure. Support performance planning, storage growth forecasting, and patch coordination. Collaborate with 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. Optimize report performance and refresh reliability. Maintain Power BI gateways, authentication, and scheduled refresh processes. Partner with Finance and Operations to deliver AR, revenue cycle, KPI, and acquisition reporting. Support self-service reporting initiatives and data governance standards. Minimum Qualifications (What We Are Looking For) Excellent verbal and written communication skills. Strong analytical and problem-solving abilities. High attention to detail and accuracy. Ability to manage multiple priorities in a fast-paced environment. Strong documentation and organizational skills. Ability to communicate technical concepts to non-technical stakeholders. Ability to translate business requirements into technical solutions Education and/or Experience Requirements Bachelor's Degree in Information Systems, Computer Science, Data Analytics, or related field preferred. 3-7+ years experience with Microsoft SQL Server. Strong T-SQL experience (joins, CTEs, stored procedures, performance tuning). 3+ years experience with Microsoft Power BI (DAX, semantic models, dataflows). Experience designing star schema or dimensional models. Experience supporting production SQL environments. Healthcare or financial reporting experience preferred. Competencies To perform the job successfully, an individual should demonstrate the following, which is included, but not limited, to: Problem Solving

• Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics. Customer Service
• Responds promptly to customer needs; Responds to requests for service and assistance; Meets commitments. Respect for Others
• Treats patients, physicians, and colleagues in a professional, respectful, compassionate manner Respect for Privacy
• Handles all patient, company, and staff information in a confidential manner compliant with all state and federal regulations and the APC Code of Conduct.

Project Management | Develops project plans; Coordinates projects; Communicates changes and progress; Completes projects on time and budget. Physical Requirements To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Standing and/or walking 30% of time Sitting 70% of the time Occasional lifting, stooping, kneeling, crouching, and reaching. Supervisory Responsibilities This position does not initially have direct supervisory responsibilities but may provide technical leadership or mentorship to analysts and reporting staff. Benefits (Work Perks) Included for all full-time positions: Medical, Dental, and Vision Insurance Paid Time Off Paid Holidays Matching 401K plan Other Equal Employment Opportunity American Pain Consortium Management, its affiliates, and subsidiaries are an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, protected veteran status, national origin, sexual orientation, gender identity or expression (including transgender status), genetic information or any other characteristic protected by applicable law.

Job Type:

Full-time Benefits:

401(k) matching Dental insurance Health insurance Paid time off Referral program Tuition reimbursement Vision insurance

Education:

Bachelor's (Preferred) Ability to

Commute:

Carmel, IN 46032 (Preferred) Willingness to travel: 75% (Preferred)

Work Location:

In person