BI Developer - Lead

Company: Medica
Location: Madison
Posted on: April 22, 2025

Job Description:

DescriptionResponsibilities:

• 
  
• Build excellent relationships with customers of our team as you work to understand requirements and design solutions for needed dashboards, reports and analyses
  
• Develop a deep understanding of Medica's data warehouse and other data sources
  
• Design and develop new dashboards and reporting applications from end to end (data loading/modeling, reports, and visualizations)
  
• Maintain and update existing dashboards
  
• Assist in team project planning / project-management
  
  Required:
  
  • 
    
  • Bachelor's degree in computer science, mathematics, information systems, software engineering, related field or equivalent experience
    
  • 5+ years of relevant experience including substantial work with BI tools and data visualization/reporting
    
  • Experience with health insurance data and analytics
    
  • Advanced proficiency writing SQL
    
  • Understanding of data warehouse concepts (star schemas, joins, indexes, etc.)
    
  • Strong communication skills and experience working with a team
    
  • The ability to work both collaboratively and independently
    
    Nice to have:
    
    • 
      
    • Experience with Snowflake data warehouse
      
    • Experience with SAS
      
    • Experience with Oracle Analytics or Oracle Business Intelligence
      
    • Experience using Git for version control and collaborating using tools like GitHub, GitLab
      
      The full salary range for this position is $113,100 - $193,900. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to compensation, Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.
      The compensation and benefits information is provided as of the date of this posting. Medica's compensation and benefits are subject to change at any time, with or without notice, subject to applicable law.
      We are an Equal Opportunity employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.Qualifications
      Experience5+ years of relevant experience including substantial work with BI tools and data visualization/reporting (required)
      
      Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
      
      This employer is required to notify all applicants of their rights pursuant to federal employment laws.
      For further information, please review the notice from the Department of Labor.

Keywords: Medica, Crystal Lake , BI Developer - Lead, IT / Software / Systems , Madison, Illinois