The Iowa Clinic · 18 hours ago
BI Developer - (Full-Time)
West Des Moines, IA
Full-time
Onsite
Entry, Mid Level
1+ years expThe Iowa Clinic is a locally owned healthcare provider led by physicians, committed to delivering exceptional care. The BI Developer will lead and support reporting projects, build impactful dashboards, and collaborate with clinical and business leaders to optimize communication and project delivery.
HealthcareHospitalHealth CareMedical
Responsibilities
Demonstrates ability to consistently meet expectations with minimal supervision while working in-person
Develop reporting, analysis, and support for presentations, dashboards, and projects delivered in a timely manner, following internal reporting standards
Execute high-quality analysis, including trending, anomaly detection, and root cause analysis
Identify and drive process improvements, including the creation of standard and ad-hoc reports
Collects, cleans, and prepares data from internal and external sources for use in building reports and analyses
Creates, maintains and trouble shoots data queries, dashboards and reports
Maintains awareness of applicable laws and/or regulations affecting area of responsibility. Remains current on law/regulation changes, recognizes implications to the organization and recommends/implements courses of action to ensure compliance. Assumes accountability for enhancing own knowledge in new developments affecting the financial affairs of the organization through professional organizations, journals, workshops, in-services, etc
Maintains confidentiality of all patient and corporate/physician financial information
Promotes a positive, professional image of The Iowa Clinic Management Company and The Iowa Clinic both internally and externally
Participates in management, departmental and interdepartmental meetings as assigned
Performs other tasks as assigned
Qualification
Required
Ability to gather requirements, translate business needs into technical specifications, and validate outputs with stakeholders
Strong problem-solving and analytical thinking skills
Experience supporting cross-functional teams such as Finance, Operations, Clinical, and Billing
Ability to simplify complex data concepts for non-technical audiences
Understanding of dimensional modeling, star/snowflake schemas, fact/dimension tables
Advanced SQL proficiency (CTEs, window functions, performance tuning)
Experience with relational databases such as SQL Server, Azure SQL, PostgreSQL, or Oracle
Familiarity with stored procedures, ETL frameworks, and query optimization
Proficiency with business intelligence tools including Tableau, Power BI or related tools
Accuracy and attention to detail including reconciliation and validation, ability to prioritize and multitask while meeting deadlines
Bachelor's degree or equivalent work experience
7-10 years of progressive experience in physician practice billing and coding, including demonstrated leadership or supervisory responsibility
In-depth knowledge of federal, state, and third-party payer billing and coding regulations
Bachelor's degree in analytics, statistics, mathematics, engineering or a related field
1-3 years of previous experience in business analytics
Demonstrated experience with data reporting, querying, and manipulation of large data sets
Preferred
Professional coding certification (e.g., CPC, CCS, RHIA, RHIT) strongly preferred
Financial experience preferred
Previous health care related analytics experience preferred
Experience building dashboards and data processing with business intelligence tools such as Tableau, Power BI, or a similar tool
Experience with data coding languages such as Python, R, SQL, or related tools
Benefits
One of the best 401(k) programs in central Iowa, including employer match and profit sharing
Employee incentives to share in the Clinic’s success
Generous PTO accruals
And paid holidays
Health, dental and vision insurance
Quarterly volunteer opportunities through a variety of local nonprofits
Training and development programs
Opportunities to have fun with your colleagues, including TIC night at the Iowa Cubs, employee appreciation tailgate party, Adventureland day, State Fair tickets, annual holiday party, drive-in movie night… we could go on and on
Monthly departmental celebrations, jeans days and clinic-wide competitions
Employee rewards and recognition program
Health and wellness program with up to $350/year in incentives
Employee feedback surveys
All employee meetings, team huddles and transparent communication
Company
The Iowa Clinic
The Iowa Clinic offers orthopedics, cardiology, colorectal surgery, dermatology, electrodiagnostic medicine and healthcare services.
1001-5000 employees
H1B Sponsorship
The Iowa Clinic has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2023 (3)
2022 (1)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Ben Vallier
CEO
Recent News
Company data provided by crunchbase