Data Engineer - Remote-Az

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

• Designs and implements business intelligence and extract, transform, and load (ETL) solutions using programming, performance tuning, data modeling. Creates databases optimized for performance, implementing schema changes, and maintaining data architecture standards across all of the business’s databases. Serves as a liaison between the Database Administration department and development teams.

Required Qualifications
Required Work Experience

• 4 years of experience in computer programming, query design, and databases
• 6 years of experience in computer programming, query design, and databases (Senior level)

Required Education

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

Preferred Qualifications
Preferred Work Experience

• 6+ years of experience Database administration with SQL Server (Senior)
• 6+ years of experience building and managing complex Data Integration solutions (Senior)
• 4+ years of experience Database administration with SQL Server
• 4+ years of experience building and managing complex Data Integration solutions.
• 4+ years of experience in computer programming, query design, and databases
• 6+ years of experience in computer programming, query design, and databases (Senior)

Preferred Education

• Master’s Degree in Information Technology or related field (Senior)
• Bachelor’s Degree in Information Technology or related field preferred

Essential Job Functions And Responsibilities
Data Engineer – Performs job functions with general supervision and peer review

• Adhere to established source control versioning policies and procedures
• Communicate status of work assignments to stakeholders and management.
• Create logic, system, and program flows for complex systems, including interfaces and metadata
• Implement and maintain operational and disaster-recovery procedures.
• Responsible for technical and production support documentation in accordance with department standards and industry best practices.
• Contribute to the team’s knowledge base with useful information such as adopted standards, procedure documentation, problem resolution advice, etc.
• Maintain current knowledge on new developments in technology-related industries
• Support Enterprise database clustering, mirroring, replication among other SQL Server technologies.
• Participate in the promotion of SQL Server best practices
• Learn area’s direct flow; and how it affects surrounding systems and operational areas.
• Research and experiment with emerging Data Integration technologies and tools.
• Work with the team to establish and reinforce disciplined software development, processes, standards, and error recovery procedures are deployed; ensuring a high degree of data quality.
• Analyze files and map data from one system to another
• Architect, design, construct, test, tune, deploy, and support Data Integration solutions for various data management systems.
• Meet timeliness and accuracy goals.
• Design & Implement Extract, Transform, and Load (ETL) solutions utilizing SSIS
• Participate in all aspects of the Software Development Life Cycle
• Participate in corporate quality and data governance programs
• Collaborate with other technology teams and architects to define and develop solutions.
• Develop, write and implement processing requirements and post implementation review
• Apply data mining rules
• 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 the review of code and/or systems for proper design standards, content and functionality.
• Write and execute unit test plans. Track and resolve any processing issues.
• Facilitate and/or create new procedures and processes that support advancing technologies or capabilities

Senior - Performs job functions with minimal supervision in a Lead capacity

• Lead, develop and mentor staff by providing opportunities for growth through delegation, training, and assignment to various project teams.
• DAtabase Architecture
• Training
• Participate and/or lead complex technical projects.
• BI Production Reporting
• 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.
• Act as primary operational contact for internal and external customers when needed or in the absence of manager.
• Provide peer-level review and mentoring to peers.
• Research, analyze, track and resolve complex production problems.
• Act as a subject matter expert in two or more of areas as assigned:
• Evaluate high-level project information and assess project components to forecast work effort required.
• Ensure Service Level Agreements between department and operational or technical areas are met.
• Assist the manager in the day-to-day operations of the department.
• Database Architecture and Support
• Build, support, and maintain complex processes, programs, and data.

ALL LEVELS

• 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.
• 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.

competencies
Required Competencies

• Working technical knowledge of current software protocols and Internet standards to the extent that they apply to database administration.
• Intermediate proficiency in T-SQL, NZ-SQL, PostgreSQL, NoSQL, Hadoop, data tuning, enterprise data modeling and schema change management.
• Intermediate knowledge of Microsoft SQL databases and database administration
• Strong object-oriented design and analysis skills
• Working technical knowledge of PowerShell.
• Advanced knowledge of business intelligence, programming, and data analysis sotfware
• Excellent database troubleshooting skills
• Required Job Skills (Applies to All Levels)
• Experience consuming, organizing and analyzing JSON and XML messages as data.
• Intermediate PC proficiency in spreadsheet, database and word processing software
• Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones

• Maintain confidentiality and privacy
• Knowledge of agile development practices
• Systems research and analysis. Ability to write and present business intelligence documentation
• Effective interpersonal skills and ability to maintain positive working relationship with others.
• Required Professional Competencies (Applies to All Levels)
• Verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.
• Perserverance in the face of resistance or setbacks.
• Demonstrate the ability to stay current on global threats and vulnerabilities.
• Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints.
• Strong analytical skills to support independent and effective decisions

• Advanced systems research and analysis expertise
• Responsible for technical and production support documentation in accordance with department standards and industry best practices.
• Collaborate with other technology teams and architects to define and develop solutions.
• Design & Implement Extract, Transform, and Load (ETL) solutions utilizing SSIS
• Build synergy with a diverse team in an ever changing environment
• Participation in one or more groups that aids in setting/enforcing standards and/or providing educational opportunities across the IT organization. (Senior only)
• Analyze files and map data from one system to another
• Create logic, system, and program flows for complex systems, including interfaces and metadata
• Apply data mining rules
• Master’s Degree in Information Technology or related field (Senior)
• Advanced knowledge of data mapping techniques
• N/A
• Facilitate and resolve customer requests and inquiries for all levels of management within the Corporation (Senior only)
• Architect, design, construct, test, tune, deploy, and support Data Integration solutions for various data management systems.
• Solid technical ability and problem solving skills
• Implement and maintain operational and disaster-recovery procedures.
• Participate in the review of code and/or systems for proper design standards, content and functionality.
• Ability to build lesson plans and deliver lessons to junior team members
• Maintain current knowledge on new developments in technology-related industries
• Communicate status of work assignments to stakeholders and management.
• Advanced proficiency in spreadsheet, SQL queries, database, flow charting, and word processing software
• Advanced knowledge of programming, database systems, and data management.
• MS SQL Certification or other certification in current programming languages
• Strong technical documentation skills and a strong ability to translate technical concepts so that they are easily understood by laypersons
• N/A
• Work with the team to establish and reinforce disciplined software development, processes, standards, and error recovery procedures are deployed; ensuring a high degree of data quality.
• Meet timeliness and accuracy goals.
• High-School Diploma or GED in general field of study
• Knowledge of HIPAA regulations
• Impeccable project management skills
• Knowledge of internal departments and operations
• Advanced knowledge of Business Objects
• Advanced knowledge of computer operating systems
• Bachelor’s Degree in Information Technology or related field preferred
• Advanced knowledge of decision support systems
• Facilitate and/or create new procedures and processes that support advancing technologies or capabilities
• N/A
• Advanced knowledge of decision support systems
• Participate in all aspects of the Software Development Life Cycle
• Develop, write and implement processing requirements and post implementation review
• Contribute to the team’s knowledge base with useful information such as adopted standards, procedure documentation, problem resolution advice, etc.
• Participate in corporate quality and data governance programs
• Research and experiment with emerging Data Integration technologies and tools.
• 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.
• Write and execute unit test plans. Track and resolve any processing issues.
• Required Leadership Experience and Competencies
• Support Enterprise database clustering, mirroring, replication among other SQL Server technologies.
• Ability to provide mentoring and peer review to junior team members
• Learn area’s direct flow; and how it affects surrounding systems and operational areas.
• Participate in the promotion of SQL Server best practices
• Adhere to established source control versioning policies and procedures

• Training
• BI Production Reporting
• Build, support, and maintain complex processes, programs, and data.
• Research, analyze, track and resolve complex production problems.
• 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.
• Lead, develop and mentor staff by providing opportunities for growth through delegation, training, and assignment to various project teams.
• Database Architecture and Support
• Act as a subject matter expert in two or more of areas as assigned:
• Assist the manager in the day-to-day operations of the department.
• Participate and/or lead complex technical projects.
• DAtabase Architecture
• Provide peer-level review and mentoring to peers.
• Evaluate high-level project information and assess project components to forecast work effort required.
• 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.

ALL LEVELS

• Participate in on-call rotation.
• Maintain current on new developments in technology-related industries.
• Perform all other duties as assigned.
• Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.
• 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.

competencies
Preferred Leadership Experience And Competencies (Applies To Senior Level)

• Ability to build lesson plans and deliver lessons to junior team members
• Ability to provide mentoring and peer review 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.