Business Intelligence Developer III

Salary Range:  $91,536.00 (Min.) - $121,286.00 (Mid.) - $151,034.00 (Max.)

Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2 million members, we make sure our members get the right care at the right place at the right time.

Mission: L.A. Care’s mission is to provide access to quality health care for Los Angeles County's vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose.

Job Summary

The Business Intelligence Developer III position works on projects to meet business application needs.  This position is a key contributor in creating and supporting standard and ad hoc reports to IT and Business Senior Management. This position is responsible for working with Business Analysts and key business contacts to translate functional and technical specifications into a comprehensive reporting design; Assists in requirements analysis, data analysis, data mapping, report development & testing, report modifications and documentation; Determines and develops strategy and framework for consistent report standards. Under limited supervision, the individual performs research/audit and analyzes high level complex/advanced data; defines, designs and develops new/enhanced reports in support of strategic planning, portfolio and project management, resource management and development of standard processes; works closely with business clients to resolve issues and enhance systems utilizing problem solving skill; assesses and evaluates technology needs to recommend solution options;  performs interface analysis on detail level.  Acts as a  Subject Matter Expert, serves as a resource and mentor for other staff. 

Duties

Liaison between Information Technology ( I.T.) Business Intelligence developmental team and business clients and defining solutions.  Work with Business Analysts and key business contacts to translate functional and technical specifications into a comprehensive reporting design.

Design of database architectures, data warehouses and data migrations. Designs, programs, tests, debugs, maintains and documents hardware/software for an advanced level of projects to meet business application needs interpreting policies, procedures and guidelines. 

Accountable for creating business intelligence packages, and implementing user reporting solutions based upon business requirement and content knowledge. Determine development strategy and framework for consistent report development standards. Create and support standard and ad hoc reports to IT and Business Senior Management. 

Meet with technical leaders to document and vet business requirements, identify effective reporting techniques, identify the best data sources for reach report field, identify risks and constraints, and design reporting formats.  

Perform project management activities to drive projects to completion on schedule with junior team members and mid-Level business professionals.  Complete projects/tasks on a timely basis, according to commitments made to stakeholders and management.

Develop, implement, and maintain ETL (extract, transform, and load) solutions to bring new data into the data warehouse. 

Applies subject expertise in evaluating business operations and processes. Identifies areas where technical solutions would improve business performance. Consults across business operations, providing mentorship, and contributing specialized knowledge. Ensures that the facts and details are correct so that the project’s/program's deliverable  meets the needs of the department, organization and legislation's policies, standards, and best practices. Provides training, recommends process improvements, and mentors junior level staff, department interns, etc. as needed.

Perform other duties as assigned. 

Duties Continued

Education Required

Bachelor's DegreeIn lieu of degree, equivalent education and/or experience may be considered.

Education Preferred

Master's Degree

Experience

Required:

At least 5 years of experience in Business Intelligence and OBIEE reporting development.

At least 5 years of experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Management Studio (SSMS).

Hands-on experience developing reports using various tools and processes.

Skills

Required:

Must have knowledge with creating Extract, Transform and Load (ETL) technology.

Ability to multitask and prioritize work.

Ability to adapt to changing tools and technologies.

Must possess communication skills to work with the project team to determine and document reporting requirements.

Advanced knowledge of applicable hardware/software configurations and programming.

Excellent verbal and written communication skills. 

Service oriented, decisiveness, emotional intelligence, knowledge of the business, problem solving/analytical thinking, Quantitative Prioritization, Results oriented, team focus.

Licenses/Certifications Required

Licenses/Certifications Preferred

Required Training

Physical Requirements

Light

Additional Information

May be required to be on-call.

Salary Range Disclaimer: The expected pay range is based on many factors such as geography, experience, education, and the market.  The range is subject to change.

L.A. Care offers a wide range of benefits including

• Paid Time Off (PTO)
• Tuition Reimbursement
• Retirement Plans
• Medical, Dental and Vision
• Wellness Program
• Volunteer Time Off (VTO)