Job Description

Awarded a Healthiest Employer, Blue Cross Blue Shield of Arizona aims to fulfill its mission to inspire health and make it easy. AZ Blue offers 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

Create and maintain optimal data pipeline architecture that is coherent and scalable, based on best practices of integrating data into a consolidated repository.Build the infrastructure required for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources using SQL, cloud, and big data technologies.

  • End-to-end solutions architecture of enterprise data solutions and platforms
  • 10+ years’ experience architecting enterprise data solutions
  • 5+ years of relevant data management consulting or industry experience (Enterprise Data Architecture, EDW, ETL,  MDM, Data Catalogs and Lineage, Data Quality, Data Strategy
  • 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
  • Expertise in data platforms and technologies, including data lakes, data warehouses, data analytics, data management, data governance, business process automation
  • Experience architecting and developing cloud data solutions especially in Azure
  • 5+ years of hands-on experience building conceptual, logical, and physical data models

  • Experience with data warehousing  and data integration (ETL/ELT), using ETL tools.
  • Knowledge of modeling database schemas for large datasets.
  • Knowledge of metadata-driven enterprise reporting platforms.

Purpose of the job

  • As a member of delivery team, supports new development/project and production support, as the highest-level technology domain expert. Assesses business requirements; collects and identifies technical specifications; and develops technology solutions. Envisions and creates solutions that meet requirements; models pieces an infrastructure and points of integration; proves feasibility of a design; creates design artifacts required to deliver and maintain infrastructure; guides solution through to completion, implementation, and support in production.
  • With Enterprise Architecture team, ensures new technology solutions are designed for optimal access and usefulness, and leverages existing technologies for specific technical domain(s), and understands system-wide impacts. Assists in near/mid-term roadmap creation, to address gaps and move towards future state architecture to support growth, optimization and innovation.


Required Work Experience

  • 5 years’ experience in IS/business experience, programming, engineering and/or systems analysis and a proven track record of successfully delivering BI and/or data warehousing projects.
  • 2 years experience architecting BI solutions including Data Warehouses, Master Data Management, Dashboards and Reporting systems

Required Education

  • High-School Diploma or GED in general field of study

Required Licenses

  • N/A

Required Certifications

  • N/A


Preferred Work Experience

  • 5 years of experience with relational data structures, theories, principles and practices.
  • 1 year of experience with deployment / administration of Microsoft SQL reporting services (SSRS, SSAS, SSIS).
  • 2 years of experience with various BI tools like Tableau, MicroStrategy, Brio, Domo and Power BI
  • 2 years of experience modeling data to conceptual, logical and physical models
  • 2 years of experience with ETL tools

Preferred Education

  • Bachelor’s degree in Computer Science, Information Systems, or related field

Preferred Licenses

  • N/A

Preferred Certifications

  • Technical Certifications in Microsoft SQL
  • ITIL v3+ Practitioner Certification
  • Data solution certifications from governing bodies like TDWI, DAMA, Kimball, Hortonworks, Cloudera


  • Understand and document high-level master data management (MDM) requirements of the business and drive the definition of data standards and implementation best practices working with the BI and enterprise architecture teams.
  • Establish domain specific standards, near/mid-term strategy, and roadmaps (0-18 months), in adherence to, and in support of Enterprise standards, strategy and roadmaps.
  • Assist in creating the vision for future state technologies and architecture and participate in setting Enterprise standards and mid/long-term strategy/roadmaps (18-60 months), acting as domain specific subject matter experts.
  • Responsible for domain specific content/collateral, based on the EA standards/ methodologies, to document the current state and future state architecture.
  • Develop technology specifications and ensure that new technology solutions are designed for optimal access and usefulness, and leverage existing technologies when possible.
  • Apply architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability.
  • Participate and lead research and development efforts (proofs of concept, prototypes), as subject matter experts, when introducing new technologies.
  • Provide technical expertise to propose level of effort projections, work breakdown structures and technical resource planning for proposed and current work to support the Project Management Office (PMO) and Project Review Board (PRB) Processes.
  • Educate and influence others in order to gain buy-in on proposed solutions.
  • Provide input to management throughout the project management lifecycle (PMLC).
  • Assists managers with developing the service level agreements (SLAs) and deployment of key performance measures.
  • Participate in various phases of the SDLC to perform QA/architectural review functions and to ensure adherence to Enterprise Architecture (EA) technology standards and project specific solutions architecture. (i.e., design reviews).
  • Ensures technology solutions are production ready and meet the defined specifications, and that the solution can be maintained via production support methodologies and resources.
  • Assist in IS Service Management policy and processes to effectively support domain. Assisted processes would include Incident Management, Problem Management, Change Management, Knowledge Management and Performance Management.
  • Review the ongoing implementation solution for improvement opportunities.
  • Facilitate communications between IS workgroups and business stakeholders for technical issues and/or major changes; acting as the technical domain subject matter expert.
  • Provide technical guidance to coach and mentor team members; provide performance feedback to manager(s).
  • Keep current and informed of domain related technologies and best practices.
  • Serve as technical owner and IT focal point for domain specific solutions.
  • Provide coaching and mentoring to team members in the areas of technical skills and competencies.
  • The position requires a full-time work schedule.  Full-time is defined as working at least 40 hours per week, plus any overtime as requested or needed to perform job responsibilities.
  • Perform all other duties as assigned.


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

Required Professional Competencies

  • Demonstrated thorough understanding of modern enterprise architecture, hands-on experience with enterprise business intelligence platforms.
  • Integrity and Trust
  • Ability to utilize strong analytical skills, take appropriate risks, while dealing with ambiguity and make effective decisions using available data.
  • Ability to be approachable, develop peer relationships and build synergy with a diverse team in an ever-changing environment
  • Ability to take appropriate risks, using available information.
  • Anticipate downstream technical needs and steer architectural designs to appropriately factor in considerations.
  • Strong analytical skills to support independent and effective decisions..
  • Ability to be customer focused with strong verbal and written communications skills and the ability to interact professionally with a diverse group of executives, managers, and subject matter experts.
  • Demonstrated thorough understanding of modern enterprise architecture, hands-on experience with enterprise business intelligence platforms.
  • Knowledge and skills in data warehousing design, methodologies and tools.
  • Be driven for results and work effectively with management, project managers, business analysts, developers, engineers, architects, system administrators, and QA to conceive, design, and deliver successful BI solutions.
  • Able to operate at highly varying levels of abstraction including business strategy, product strategy, technical design and implementation
  • Work with all levels of management and functional areas in BCBSAZ and understand the potential implications of system changes to those areas.
  • Ability to be self-aware and emotionally intelligent, able to give and receive constructive feedback and continue self-development.

Required Leadership Experience and Competencies

  • Provide leadership, promote teamwork, meet objectives and exercise independent judgment
  • Experience leading and implementing projects and working collaboratively with other departments levels
  • Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints.
  • Ability to build synergy with a diverse team in an ever-changing environment


Preferred Job Skills

  • Expert knowledge designing highly redundant, scalable, multi-tier enterprise transaction processing systems from front end to back end.
  • Knowledge of HIPAA security and privacy standards.
  • In depth knowledge of healthcare and health plan data structures and business processes and workflows.

Preferred Professional Competencies

  • N/A

Preferred Leadership Experience and Competencies

  • N/A

Our Commitment

AZ Blue 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  If interested in this position, please apply.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online