Data Operation Lead (EDW, DBA, Data Lake)

Awarded the Best Place to Work 2021, Blue Cross Blue Shield of Arizona helps to fulfill its mission of improving the quality of life of Arizonans by delivering a variety of health insurance products and services to meet the diverse needs of individuals, families, and small and large businesses as well as providing information and tools to help individuals make better health decisions.

This remote work opportunity requires residency, and work to be performed, within the State of Arizona.

About the Job:

This role will be a technical lead for teams of consultants and clients in creating complex data solutions by providing conceptual, architectural and technical leadership for data warehouse initiatives. Healthcare insurance knowledge and working knowledge of cloud based data warehousing platforms is strongly preferred.The incumbent will:

• Lead the design, development, deployment of solutions including data ingestion, storage and manipulation.
• Design the technology framework, including data streams, integrations, transformations, databases, and data warehouses
• Be responsible to drive optimal data architecture that efficiently and effectively presents an integrated view of enterprise data for both operational and analytical business processes
• Have a deep understanding of data warehousing concepts, data update strategies, data modeling, data pipelines, and workflows
• He / she should have strong familiarity with data governance, data lineage, data processes, DML, and data architecture control execution
• Have the ability to drive large complex programs for data operations
• Be a self starter and take ownership
• Have a proven record of working with business stakeholders and MSP
• Be a Team player and ability to work in matrix organization

PURPOSE OF THE JOB

Develops technical documentation, designs, analyzes, tests, provides end user support and training for new applications and data structures; and provides post-implementation review for systems and reporting to support customers and management.

REQUIRED QUALIFICATIONS

1. Required Work Experience

1 year of college-level coursework in system requirements design and interpretation and/or support of production

systems (Lev 1)

3 years of experience in computer technology and/or information systems (Lev 2 - 4)

2 years of experience in data analysis, data management and integration, extracting and analysis reporting. (Lev 2-4)

2. Required Education

High-School Diploma or GED in general field of study (All Levels)

3. Required Licenses

N/A

4. Required Certifications

N/A

PREFERRED QUALIFICATIONS

1. Preferred Work Experience

2 years of experience in computer technology and/or information systems (Level 1 -2)

2 years of experience working in healthcare-related systems as a business / systems analyst or programmer (All Lev)

5 years of experience in data analysis, management, integration and reporting (Levels 3 - 4)

3 years of experience working in corporate enterprise-level systems as a business or systems analyst or programmer

(Levels 3 - 4)

2. Preferred Education

Bachelors Degree in Computer Science, Information Systems, Business, or related field (All Levels)

3. Preferred Licenses

N/A

4. Preferred Certifications

N/A

ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES

LEVEL 1 - Entry-level role; Performs job functions under close supervision or peer review

PRODUCTION SUPPORT

Track and resolve basic or routine processing problems, coordinating with all areas.

Research, analyze, track and resolve basic production problems.

Develop business objectives, processing requirements, and technical specifications.

Analyze files and map data from one system to another.

Responsible for production cycles, solving production incidents and notification of problems.

Write SQL queries needed for production support.

QUALITY ASSURANCE

Develop basic test data.

Process test files and analyze test results.

Perform execution of test cases/scripts; document results, log defects, and regression testing of defects.

Perform test execution and defect reporting utilizing testing tools.

Assist with root cause analysis and triage of key/critical defects for quick turn-around.

Monitor and track traceability of business requirements to text execution.

Participate in defect review meetings to explain and/or demonstrate defects.

Develop and maintain SQL queries to test results and to create mock up data for testing and reporting.

TECHNICAL ANALYSIS

Learn business and systems data and process flows; and how they affects surrounding systems and operational areas.

Research and analyze application procedural problems and provide recommendations for improvements and changes.

Develop functional & technical specifications, logic flows and other documentation as applicable.

Synthesize complex or diverse information, collect and research data, use intuition and experience to complement data, work flows and procedures.

Review computer system capabilities, workflow and scheduling limitations to determine if requested application or application change is possible within the existing system.

Translate business needs into technical solutions with knowledge of programming languages (SQL, C# or VB.net, ETL, SOA, and OLAP).

Participate in maintaining operational and disaster-recovery procedures.

Write or modify procedures for internal use, operational procedures, and computer operations, as applicable.

PROJECT MANAGEMENT

Participate on small to large scoped projects.

Use sound project management methodology and demonstrate solid time management skills.

Create and deliver presentations.

Monitor and create priority list(s) that are agreed to by user management.

LEVEL 2 - Performs job functions with general supervision and peer review

Research, analyze, track and resolve moderately complex production problems.

Work with IT Infrastructure team to develop and implement effective production monitoring.

Ensure the department leverages internal tools and applications effectively.

Build, support, and maintain moderately complex processes, programs, and data.

Participate or lead medium to large scoped projects.

Create moderately complex ad-hoc reports for internal usage and external usage.

Develop project plans, time estimates and project schedules based on prioritization and business requirements.

Research and become proficient in one or more applications or data marts.

LEVEL 3 - Performs job functions with moderate supervision

Research, analyze, track and resolve high complex production problems

Work with IT Infrastructure team to develop and implement effective production monitoring.

Ensure the department leverages internal tools and applications effectively

Build, support, and maintain moderately complex processes, programs, and data

Participate or lead Large scoped projects

Create complex ad-hoc reports for internal usage and external usage

Develop programs, time estimates and project schedules based on prioritization and business requirements

LEVEL 4 - Performs job functions with minimal supervision

Facilitate and/or create new procedures and processes that support advancing technologies or capabilities.

Research, analyze, track and resolve complex production problems.

Build, support, and maintain complex processes, programs, and data.

Evaluate high-level project information and assess project components to forecast work effort required.

Provide peer-level review and mentoring to levels 1 - 3.

Participate and/or lead complex technical projects.

Create complex ad-hoc reports for internal usage and external usage.

Act as a subject matter expert in two or more of areas as assigned: o BI Production Reporting o Application Architecture o Application Architecture and Support o Training

LEAD - Performs job functions in a lead capacity

Act as primary operational contact for internal and external customers when needed or in the absence of manager.

Ensure Service Level Agreements between department and operational or technical areas are met.

Lead, develop and mentor staff by providing opportunities for growth through delegation, training, and assignment to various project teams.

Inform manager of any issues impacting the efficient and effective performance of the department including system, resource, and informational barriers; Provide timely feedback to team member on performance.

Assist the manager in the day-to-day operations of the department.

ALL LEVELS

Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.

Maintain current 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. Participate in on-call rotation.

Participate in on-call rotation.

Perform all other duties as assigned.

REQUIRED COMPETENCIES

1. Required Job Skills (Applies to All Levels)

Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones.

Intermediate PC proficiency.

Intermediate proficiency in spreadsheet, database, flow charting, and word processing software.

Intermediate knowledge of data mapping techniques and data analysis software.

Intermediate knowledge of computer operating systems.

Intermediate knowledge of Microsoft Applications and Suites, Windows Server, and Microsoft SQL databases.

2. Required Professional Competencies (Applies to All Levels)

Strong analytical skills to support independent and effective decisions.

Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints.

Perserverance 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 business intelligence documentation.

Demonstrate the ability to stay current on global threats and vulnerabilities.

Experience working with and managing third parties.

Knowledge of business requirements development and user acceptance testing.

Maintain confidentiality and privacy.

Analytical knowledge necessary to generate reports based on available data and then make decisions based on

reported data.

Understanding of data governance best practices and data quality improvement principles.

3. Required Leadership Experience and Competencies

Facilitate and resolve customer requests and inquiries for all levels of management within the Corporation.

(Applies to Levels 2 - 4)

Build synergy with a diverse team in an ever changing environment. (Applies to Levels 3 - 4)

PREFERRED COMPETENCIES

1. Preferred Job Skills (Applies to All Levels)

o Knowledge of HIPAA regulations

Advanced proficiency in spreadsheet, SQL queries, database, flow charting, and word processing software

Advanced knowledge of data mapping techniques

Advanced knowledge of computer operating systems

Advanced knowledge of decision support systems

Advanced knowledge of programming, database systems, and data management.

Advanced knowledge of decision support systems

Advanced knowledge of Business Objects

2. Preferred Professional Competencies (Applies to All Levels)

Advanced systems research and analysis expertise

Impeccable project management skills

Solid technical ability and problem solving skills

Knowledge of internal departments and operations

Strong technical documentation skills and a strong ability to translate technical concepts so that they are easily

understood by laypersons

3. Preferred Leadership Experience and Competencies (Applies to Levels 3-4)

Ability to provide mentoring and peer review to junior team members

Ability to build lesson plans and deliver lessons to junior team members

Our Commitment

BCBSAZ does not discriminate in hiring or employment on the basis of race, ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected group.

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.