Job Description

Additional Locations: Durham - Mobile



Blue Cross NC is investing in technologists that will allow us to improve the health and well-being of our customers and communities. We are accelerating our digital transformation by scaling out our teams across IT to meet these ambitious but credible goals. If you have a heart to serve our customers and a passion for innovation, this is where you should look. In our roles, you will make a direct difference to our customers, you will make an immediate impact to our teams and solutions, and you have the potential of making a positive and lasting impact to our strategy and solutions long-term.

IT is different here. Our work as technology specialists pushes the boundaries of what\xe2\x80\x99s possible in health care. You will build solutions that make a real difference in people\xe2\x80\x99s lives. Driven by the importance of their work, our team members innovate to elevate. We\xe2\x80\x99re encouraged to be curious, collaborate, and turn ideas into solutions that can make health care better for all.
In this role, you will join a fast-paced, focused, product-oriented team delivering new capabilities to our internal business customers through enhanced data products and services. Innovation is valued here and you will have the opportunity to think outside the box with a matrixed team of diverse professionals focused on making health care easier, simpler, and less costly for thousands of members here in North Carolina. Bring your skills in Python, Ab Initio, Snowflake, Teradata, AWS and help us not stop until health care is better for all!

If you are ready to make a career out of making a difference, then you are the person for this team.

As an ETL Data Engineer, you will work closely with senior engineers, data integration analysts, data scientists and other stakeholders to analyze, design and develop data integrations and data assets to meet the needs of our business partners. The ETL Data Engineer will design and grow a data infrastructure that powers our ability to make timely and data-driven decisions.

Support the development and execution of the Enterprise Data, Analytics and Unified Delivery Strategy across the Blue Cross NC organization by overseeing the evaluation, high level use case development and design of strategic data assets. Support the technical design and delivery of highly complex solutions and delivery of strategic data assets and/or of highly complex solutions using data assets housed within the Blue Cross NC organization.

What You Will Do

Define and extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient programming processes

Document, and test moderate data systems that bring together data from disparate sources, making it available to data scientists, and other users using scripting and/or programming languages

Write and refine code to ensure performance and reliability of data extraction and processing

Participate in requirements gathering sessions with business and technical staff to distill technical requirement from business requests

Develop SQL queries to extract data for analysis and model construction

Own delivery of moderately sized data engineering projects

Design and develop scalable, efficient data pipeline processes to handle data ingestion, cleansing, transformation, integration, and validation required to provide access to prepared data sets to analysts and data scientists

Ensure performance and reliability of data processes

Document and test data processes including performance of through data validation and verification

Collaborate with cross functional team to resolve data quality and operational issues and ensure timely delivery of products

Develop and implement scripts for database and data process maintenance, monitoring, and performance tuning

Analyze and evaluate databases in order to identify and recommend improvements and optimization

What You Bring

Bachelor\xe2\x80\x99s degree and 3 years of experience with Data Integration, Data Warehouses, Operational Data Stores, Data Lakes and Big Data platforms

Direct experience with at least one ETL development language/technology such as AbInitio, DataStage, Informatica, Python, R

Advanced SQL knowledge and experience with database technologies such as DB2, Teradata, Snowflake, AWS

In lieu of degree, 5 years of the experience as stated above

Hiring Preferences

Experience in healthcare or insurance

Experience collaborating effectively with vendors and business partners for solution delivery

Blue Cross Blue Shield