Senior Business Intelligence Developer

Company: Collective Health
Location: Lehi
Posted on: April 17, 2024

Job Description:

We all depend on healthcare throughout our lifetimes, for ourselves, and our families and friends, but it is notoriously difficult to navigate and understand. As an industry that comprises 20% of the US economy we think healthcare should work better for all of us. At Collective Health we believe it's time for a new day in healthcare where as members we are informed and empowered to make the right care choices when the decisions are urgent and critical. - Collective Health is expanding its Customer Experience team! We believe health benefits should be simple, accessible, and technology-driven. But moreover, we believe healthcare should be grounded by the people that it serves. To accomplish this, we are reimagining the operational core of health insurance. We are seeking leaders to help deliver on this vision.
We are looking for a Senior Business Intelligence Developer to help further develop and measure the customer experience delivered by our Customer Experience teams. In this role, you will work closely with the Customer Experience team, serving as a thought partner in coordinating and collaborating internally on the design, execution, and measurement of our customer experience. You will be responsible for driving the data and reporting strategy to help achieve our customer experience operational strategy. -
What you'll do:

• 
  
• Business Intelligence Experience: Utilize your extensive experience developing and deploying business intelligence solutions, specifically with Looker, to design, develop, and maintain complex analytics and data models.
  
• Data Modeling: Apply your deep understanding of data modeling principles to design efficient and scalable data structures, ensuring optimal performance and data integrity.
  
• Advanced SQL Knowledge: Leverage your expertise in SQL to write complex queries, optimize performance, and extract insights from large datasets.
  
• Python Proficiency: Utilize your working knowledge of Python to automate data extraction, transformation, and loading processes, as well as to develop custom analytics solutions.
  
• Data Landscape: Develop a holistic, deep understanding of the various data sources used for reporting. Identify gaps in existing reporting and propose innovative solutions to bridge those gaps.
  
• Stakeholder Engagement: Lead conversations with stakeholders from various departments to understand their analytical requirements, provide insights, and develop tailored business intelligence solutions to support their decision-making processes.
  
• Representation in Technical and Non-Technical Forums: Act as a liaison between the data Data Operations team and other departments, effectively communicating technical concepts to non-technical stakeholders and vice versa.
  
• Leadership: Take the lead in driving discussions and providing guidance on best practices in data analysis, visualization, and reporting, while ensuring alignment with organizational goals and objectives.
  
• Mentorship: Provide mentorship and guidance to junior staff members, fostering their professional growth and helping them develop their technical and analytical skills.
  
• Project Management: Manage development sprints and distribute work based on roadmap initiatives and business needs, ensuring timely delivery of high-quality BI solutions.
  
• Documentation: Create and maintain comprehensive documentation for developed BI solutions, including data models, workflows, and technical specifications. Ensure that documentation is up-to-date, easily accessible, and serves as a valuable resource for team members and stakeholders
  
  To be successful in this role, you'll need:
  
  • 
    
  • Proven experience (3-5 years) as a Business Intelligence Developer or in a similar role.
    
  • Extensive experience with data analysis / visualization tools (i.e., Looker, LookML, Tableau, Power BI, Presto SQL) to develop front-end reports to meet the needs of end-users in a user-friendly way. -
    
  • Strong proficiency in data modeling techniques and best practices.
    
  • Outstanding communication skills - both written and verbal - with comfort presenting to executive audiences, leading discussion, and synthesizing complex information into concise communications. -
    
  • Advanced knowledge of SQL and the ability to write complex queries for data analysis and reporting.
    
  • Working knowledge of Python for data manipulation and automation.
    
  • Analytical, interpretive and problem solving skills, which require interpreting large amounts of data and its impact to operations, ability to consolidate and tell a story.
    
  • Outstanding analytical and problem-solving skills, with proven track record to synthesize complex information into clear tangible recommendations
    
  • Proven experience in mentoring and guiding junior staff members.
    
  • Strong project management skills, with the ability to manage multiple tasks and prioritize effectively.
    
  • Agility to navigate through ambiguity - comfortable with establishing new processes when gaps are present.
    
  • Ability to work collaboratively in a fast-paced, team-oriented environment.
    
  • Fluent in Microsoft and/or Google productivity software
    
    Pay Transparency Statement -
    This is a hybrid position based out of our San Francisco or Lehi office, with the expectation of being in office at least two weekdays per week. #LI-hybrid -
    The actual pay rate offered within the range will depend on factors including geographic location, qualifications, experience, and internal equity. In addition to the salary, you will be eligible for stock options and benefits like health insurance, 401k, and paid time off. Learn more about our benefits at https://jobs.collectivehealth.com/#benefits. San Francisco, CA Pay Range $113,600-$142,000 USD Lehi, UT Pay Range $86,400-$108,000 USD About Collective Health
    Founded in 2013, Collective Health's ecosystem of innovative partners across care and benefits delivery, and powerful and flexible technology better enable employees and their families to understand, navigate, and pay for healthcare. By reducing the administrative lift of delivering health benefits, providing an intuitive member experience, and helping improve health outcomes, the company guides employees toward healthier lives and companies toward healthier bottom lines. Collective Health is headquartered in San Mateo, CA with locations in Chicago, IL, and Lehi, UT. For more, please visit collectivehealth.com.
    We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Collective Health is committed to providing support to candidates who require reasonable accommodation during the interview process. If you need assistance, please contact recruiting-accommodations@collectivehealth.com.
    Privacy Notice
    For more information about why we need your data and how we use it, please see our privacy policy: https://collectivehealth.com/privacy-policy/.

Keywords: Collective Health, Draper , Senior Business Intelligence Developer, IT / Software / Systems , Lehi, Utah