IEHP

Developer I – BI & Analytics

IEHP

full-time

Posted on:

Location Type: Hybrid

Location: Rancho Cucamonga • California • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $91,250 - $120,910 per year

Job Level

Junior

Tech Stack

MS SQL ServerSQLTableau

About the role

  • Model and support enterprise data warehouse, data marts and cubes in the creation of a modern, highly effective enterprise reporting platform at IEHP following industry best practices and patterns
  • Contribute to the technical development of reporting and analytical solutions for IEHP business stakeholders that provide critical insight into business performance.
  • Collaborate with other IEHP departments and data stewards to assess and prioritize needs, and assist with developing strategies, plans, policies and procedures related to providing effective reporting solutions.
  • Identify, analyze and interpret trends or patterns in complex data sets, draw meaningful business insight and translate them to a self-service report
  • Identify and communicate issues and risks to management in a timely manner
  • Contribute towards reporting security requirements, architecture, design and implementation, including the definition of comprehensive security controls to enforce the IEHP security strategy
  • Contribute to development and enforcement of IEHP reporting standards
  • Gather, select, compile and analyze health plan data, with emphasis on data maintained with data warehouse
  • Establish and maintain effective working relationships with others throughout the IEHP organization
  • Demonstrate a commitment to support IEHP’s strategic priorities to become a 5-Star Health Plan and incorporate LEAN principles into daily work.

Requirements

  • One (1) or more years in analytics, data science and business intelligence
  • Experience in developing reporting using Business Intelligence tools (such as Tableau, Microsoft Power BI, MicroStrategy)
  • Experience in report writing and analysis, including experience working with large data sets that have complex relational designs and with unstructured data sets
  • Experience in database design, query development, table joins and report development and creation
  • Data analysis experience in the areas of medical or health services is preferred
  • Bachelor’s degree in a quantitative field from an accredited institution required
  • Working knowledge of diagnosis and procedure coding, medical terminology, knowledge of managed care, claims payment processes, and insurance terminology required
  • Knowledge of data visualization and Business Intelligence tools is required (such as Tableau, Microsoft Power BI, MicroStrategy)
  • Strong data analysis, data presentation, spreadsheet, and database capabilities
  • Strong expertise in the Microsoft platform for business intelligence and reporting: Microsoft SQL Server, SSAS, Power BI, SSRS, Access and Excel
  • Strong analysis and critical thinking skills
  • Excellent interpersonal/ communication skills
  • Proven ability to: Multi-task while maintaining careful attention-to-detail
  • Handle multiple projects, data input, and strong problem-solving capability
  • Be an independent self-starter who is driven to success, takes great pride in accomplishments and works with a sense of urgency to meet deadlines and address competing priorities
Benefits
  • Competitive salary
  • Hybrid schedule
  • State of the art fitness center on-site
  • Medical Insurance with Dental and Vision
  • Life, short-term, and long-term disability options
  • Career advancement opportunities and professional development
  • Wellness programs that promote a healthy work-life balance
  • Flexible Spending Account – Health Care/Childcare
  • CalPERS retirement 457(b) option with a contribution match
  • Paid life insurance for employees
  • Pet care insurance

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data analysisreport writingdatabase designquery developmenttable joinsreport developmentdata visualizationdata presentationspreadsheet capabilitiesdatabase capabilities
Soft skills
interpersonal skillscommunication skillsattention to detailproblem-solvingcritical thinkingmulti-taskingindependent self-startertime managementcollaborationcommitment to strategic priorities