Business Intelligence Developer

Position Summary

The Business Intelligence (BI) Developer supports Methodist Healthcare Ministries' mission by developing, maintaining, and analyzing healthcare data systems to inform strategic decisions. This role designs and delivers analytics, reports, and data visualizations to improve operational performance, compliance, and decision-making across the organization.

Salary

The annual salary rate begins at $88,429. Mid range at $112,747. Actual starting rate will be commensurate with experience and education.

Scope and Impact

The BI Developer supports the Business Intelligence Manager and contributes to data-driven initiatives across multiple departments. The role impacts organizational strategy, healthcare cost analysis, and performance improvement by ensuring high data quality and effective reporting. Responsibilities may extend to supporting regulatory compliance and developing tools used by senior leadership.

Decision-Making Authority

Exercises significant independence in designing and implementing databases, analytics models, and reporting tools. Makes recommendations regarding data design, performance optimization, and reporting enhancements while escalating strategic or policy-level decisions to the BI Manager.

Interactions / Working Relationships

Works closely with internal stakeholders, including management, IT, and data teams, as well as external partners to deliver reliable data and reporting solutions. Collaborates regularly with application developers, analysts, and program leads to ensure data integrity and effective business intelligence operations.

Essential Duties and Responsibilities

• Research, retrieve, and design analytics and reporting of healthcare and related data (15%).
• Develop SQL databases, stored procedures, functions, SSIS ETL packages, and Reporting Services reports (15%).
• Build and maintain Tableau visualizations for performance reporting and strategic analysis (10%).
• Conduct statistical analysis on large datasets to forecast costs, utilization trends, and engagement metrics (10%).
• Analyze benchmarking data and provide insights on healthcare utilization, cost, and quality measures (10%).
• Ensure data quality, accuracy, and compliance with reporting standards (10%).
• Collaborate with departments to define reporting requirements and deliver actionable insights (10%).
• Manage reporting services security and system performance tuning as needed (5%).
• Train junior developers and contribute to technical documentation and knowledge sharing (5%).
• Perform ad hoc data analysis and support other assigned projects (10%).

Supervisory or Leadership Responsibilities

This position does not supervise others but may provide mentorship or training to junior developers or analysts.

Qualifications

Minimum Qualifications (Required)

• Education: Bachelor's degree in Computer Science, Business, Mathematics, Statistics, or related field.
• Licenses/Certifications: Valid driver's license and auto liability insurance.
• Experience: 2 years of experience in data analysis, reporting, or SQL Server environment; experience developing reports and analytics.
• Other Required Skills/Knowledge: Strong analytical and problem-solving skills; proficiency in SQL Server Management Studio, SQL Server Reporting Services, and data modeling.

Preferred Qualifications

• Experience with Tableau Software or other BI tools.
• Working knowledge of Python or R.
• Experience with healthcare data, cost analysis, or utilization reporting.
• Advanced Excel proficiency (pivot tables, lookups, data validation).

Knowledge, Skills, and Abilities (KSAs)

Analytical thinking, problem-solving, attention to detail, communication, collaboration, and adaptability. Strong organizational and time-management skills; ability to translate data insights into actionable recommendations.

Language Skills

Fluency in English required (verbal and written). Ability to present complex data clearly to both technical and non-technical audiences.

Technology and Tools

Required: Microsoft SQL Server (2008/2012), SSIS, SSRS, Visual Studio, Microsoft Office Suite (Excel, Word, PowerPoint, Outlook).

Preferred: Tableau Software, Python, R, and experience with electronic health record (EHR) systems.

Work Environment and Physical Demands

• Work Setting : Primarily office-based, with occasional interaction in healthcare or clinical environments.
• Travel: Limited local travel may be required.
• Physical Requirements: Ability to sit, stand, walk, bend, and lift up to 25 pounds.