Business Analytics Manager jobs in Orange, CA

• Guide clients and prospects in their evaluation of Business Intelligence solutions providing information and demonstrations to help them assess fit for their business
• Design, architect, implement and support simple to complex enterprise data warehouses using Microsoft SQL on-premises or cloud technologies including Azure and Snowflake
• Scope the implementation services required to help clients achieve their objectives including clinical details and health care KPIs.
• Ensure completion of tasks, milestones, and components including but not limited to functional specifications, design specifications, configurations, quality assurance, implementations, and project reviews
• Spearheads development of logical and physical data models, and ETL development, as needed
• Building reports, dashboards and scorecards using a variety of tools
• Train end users and system administrators
• Provide clients with ongoing technical support and troubleshooting
• Lead additional optimization projects as clients businesses change and grow
• Work on multiple projects at the same times
• Interact effectively with internal and external resources at all organizational levels

Basic Qualifications:

• Bachelor's degree or graduate degree and 6-8 years of related work experience degree with an emphasis in Math, Computer Science, Information Systems, Business or Health Care
• Proficiency with Microsoft SQL Server Database Engine (database development and tuning), Azure Data Factory, SQL Server -Integration Services (SSIS), SQL Server Reporting Services (SSRS)Experience using  T-SQL scripts (stored procedures, views, functions etc.) to manipulate data and simplify access to data
• Also will consider strong Oracle, SAP Hana, Microstrategy, and/or Snowflake analytics experience
• Experience with data modeling (3NF and dimensional data models), understanding of the appropriate purpose for each
• Strong focus and ability to manage and construct Dimensional Data Warehouses
• Deep understanding of health care data and business model
• Knowledge of data sources and models from multiple Electronic Medical Records (EMRs) including Epic or Cerner
• FHIR or HL7 experience preferred
• Experience with designing visualizations in multiple BI tools including Tableau and PowerBI
• Ability to communicate effectively, both in writing and verbally, with clinicians and health care leadership
• Ability to interact effectively with internal and external resources at all organizational levels
• Excellent project management, organization, and follow-up skills
• Strong critical thinking and problem-solving skills
• Must be a team player; able to work in virtual teams and independently
• Willingness and ability to travel
• Strong financial and business acumen, and ability to speak about technology in the language of health care
• Curiosity about business and technology
• Experience with the following will be a plus: SQL Server Analysis Services (SSAS)SQL Server Integration Services (SSIS)QlikView/QlikSense SharePoint Microsoft SQL Server