BI Developer - Lead

About the position

The BI Developer - Lead position is focused on building strong relationships with customers to understand their requirements and design effective solutions for dashboards, reports, and analyses. The role involves developing a deep understanding of Medica's data warehouse and other data sources, designing and developing new dashboards and reporting applications from end to end, maintaining and updating existing dashboards, and assisting in team project planning and project management.

Responsibilities

• 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

Requirements

• 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-haves

• 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

Benefits

• Competitive medical, dental, vision insurance
• Paid time off (PTO)
• Holidays
• Paid volunteer time off
• 401K contributions
• Caregiver services
• Generous total rewards package