PURPOSE OF THE JOB- Query and analyze data related to quality measures with the goal of accurately reporting findings to other departments and Executive Leadership for making informed decisions.
- Designs, implements and maintains data extracts from enterprise data stores for both internal and external customers.
- Assists with the implementation, optimization, and ongoing support of the Enterprise Data Warehouse (EDW), ensuring scalable architecture, data integrity, operational stability, and continuous enhancement to meet evolving business needs. Provide solutions based on BCBSAZ SQL database design and implementation standards, corporate policies, industry best practices, and customer-based business requirements.
REQUIRED QUALIFICATIONSRequired Work Experience - 1 year of experience in computer programming (SQL), query design, data management technologies and techniques, and databases (Applies to Level 1)
- 2 years of experience in computer programming (SQL), query design, data management technologies and techniques, and databases (Applies to Level 2)
- 3 years of experience in computer programming (SQL), query design, data management technologies and techniques, and databases (Applies to Level 3)
Required Education - Bachelor's degree in Data Analytics, Health informatics, Epidemiology, Public Health, Biostatistics, Statistics, Applied Math, Data Science, Business intelligence or other related field
PREFERRED QUALIFICATIONS Preferred Work Experience - Familiarity with AHCCCS Medicaid, NCQA HEDIS, and CMS Medicare Stars Ratings is desirable
- Experience with extensive data analysis on healthcare payer data across multiple functional areas (e.g. Membership, Provider, Lab, Medical and Pharmacy Claims etc.,)
- 2 years of experience in working with healthcare systems
- 4 years of experience in computer programming, query design, and databases
- 4 years of experience with data management technologies and techniques
- Intermediate knowledge of SQL and/or SSIS, Snowflake and Tableau/Power BI
Preferred Education - Master's Degree in Data Analytics, Health informatics, Epidemiology, Public Health, Biostatistics, Statistics, Applied Math, Data Science, Business intelligence or other related field
Preferred Certifications - MS SQL or SSIS Certification
ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES - Creates and maintains meaningful analytics, visualization, reports and presentations most appropriate to users based on their role that enable insights to actionable next steps
- Creates ad-hoc reports and provides analytic support, using project management tools to gather user requirements and confirm user acceptance
- Suggests and implements automation of business processes, such as on-demand reports and interactive dashboards; identifies and implements opportunities to streamline and improve processes
- Analyze monthly and quarterly performance measure reporting
- Design, implement and maintain data extracts from enterprise data stores for both internal and external customers
- Design & Implement Extract, Transform, and Load (ETL) solutions including SQL programming based on BCBSAZ database design and implementation standards
- Design and code systems, programs, and interfaces, using the appropriate structured programming techniques and programming languages
- Oversee and mentor junior analysts
- Track and resolve any processing issues
- Analyze files and map data from one system to another
- Develop programs, time estimates and project schedules based on prioritization and business requirements
- Demonstrate solid time management skills
- Meet timeliness and accuracy goals
- Communicate status of work assignments to stakeholders and management
- Maintain knowledge on new developments in technology-related industries
- Participate in corporate quality and data governance programs
- The position requires a full-time work schedule. Full-time is defined as working at least 40 hours per week, plus any additional hours as requested or as needed to meet business requirements
- Perform all other duties as assigned
REQUIRED COMPETENCIES Required Job Skills - Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones
- Intermediate PC proficiency
- Intermediate proficiency in spreadsheet, database and word processing software
- Intermediate knowledge of Microsoft SQL databases.
- Demonstrated problem solving skills
Required Professional Competencies - Strong analytical skills to support independent and effective decisions
- Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints
- Perseverance in the face of resistance or setbacks
- Effective interpersonal skills and ability to maintain positive working relationship with others
- Verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts
- Systems research and analysis. Ability to write and present technical documentation
- Knowledge of business requirements development and user acceptance testing
- Maintain confidentiality and privacy
Required Leadership Experience and Competencies - Facilitate and resolve customer requests and inquiries for all levels of management in Corporation
- Build synergy with a diverse team in an ever changing environment
C
orporate Responsibilities - Comply with BCBSAZ corporate and departmental policies and procedures, including, but not limited to Code Blue, Compliance, HIPAA, Computer Responsibility, Accreditation Standards, Attendance, Staff Qualifications and Quality Management Accountabilities
PREFERRED COMPETENCIES Preferred Job Skills - Advanced PC proficiency
- Advanced knowledge of Microsoft Applications and Suites and Microsoft SQL databases.
- Intermediate proficiency in SQL Programming language
- Intermediate proficiency in SSIS, Power BI/Tableau, and data modeling
- Strong technical documentation skills
- Strong understanding of relevant big data & digital technologies, with the ability to harness their potential to drive customer and business value
Preferred Professional Competencies - Solid technical ability and problem solving skills
- Strong ability to translate technical concepts so that they are easily understood by laymen.
- Strong personal impact and the ability to inspire confidence and positive action
- Demonstrated ability to stay current on global threats and vulnerabilities.
- Experience working with and managing third parties
Preferred Leadership Experience and Competencies - Strong communications and influencing skills
- Ability to adapt to shifting priorities, demands, and tight timelines through analytical and problem solving capabilities
- Ability to mentor and provide peer review to lower levels
- Ability to build lesson plans and deliver lessons to junior team member
- Demonstrated vision in problem solving
- Ability to manage a solution and just not a checklist
- Advanced systems research and analysis expertise
Thank you for your interest in Blue Cross Blue Shield of Arizona. For more information on our company, see azblue.com. If interested in this position, please apply.
