Data Engineer (Louisiana)

Louisiana Blue; Baton Rouge (LA); On-site; USD 90,000 - 130,000; Full time

Job summary

Louisiana Blue is seeking a Data Integration Engineer to design and implement ETL/ELT processes and API integrations in a data-driven environment. You will work with Lead Data Engineers and cross-functional teams to deliver reliable data pipelines and data lake solutions.

The role requires strong SQL, data warehousing knowledge, and experience with cloud-based ETL tools. Louisiana residency preferred; US work authorization required. This is a full-time, on-site position based in Louisiana.

Qualifications

• Bachelor’s degree or equivalent experience in Computer Science or related field.
• 4+ years of IT experience with data integration or API solutions.
• Experience with ETL/ELT tools (Informatica, DataStage, SSIS) and cloud/data warehouse technologies.

Responsibilities

• Analyze data integration requirements and design integration solutions.
• Develop and debug ETL/ELT processes and API integrations.
• Ensure data quality and metadata capture across pipelines.
• Collaborate with data engineers and stakeholders in an agile environment.

Skills

ETL/ELT development

SQL queries

API integration

C# / Python

Data warehousing

Data integration patterns

Big Data

NoSQL

Education

Bachelor’s Degree in Computer Science or related field

Advanced degree or certification preferred

Tools

Informatica PowerCenter

DataStage

SSIS

Azure Data Factory

Teradata

Oracle

SQL Server

Data Lake

Sybase

NoSQL

Job description

We take great strides to ensure our employees have the resources to live well, be healthy, continue learning, develop skills, grow professionally and serve our local communities. We invite you to apply for a career with us.

Residency in or relocation to Louisiana is preferred for all positions.

Applicants must be authorized to work for Louisiana Blue in the United States without employer-sponsored immigration support. Louisiana Blue will not provide current or future employment-based immigration sponsorship or other immigration support for this opportunity, including H-1B, L-1, O-1, H-1B1, E-3, TN, or J-1 sponsorship or F-1 OPT/STEM OPT/CPT support. Applicants who would require such sponsorship or employer support during their employment should not pursue this opportunity.

Position Purpose

This position develops data integration solutions using data integration tools or other means based upon the direction determined by the agile team’s technical lead and in association with the Lead Data Engineers, Principal Data Engineers, and functional manager. This position complies with all laws and regulations associated with duties and responsibilities.

Nature And Scope

This position reports to the Manager of Enterprise Information Management

Activities Of Direct Reports

This position has no direct reports.

Necessary Contacts

To do this job effectively the incumbent has to be in contact with: All levels of BCBSLA personnel and outside vendors

Education

QUALIFICATIONS: Bachelor’s Degree in Computer Science or related field required. Four years of related experience can be used in lieu of a degree. Advanced degree or certification preferred. Requires knowledge in areas such as data mart, data warehouse, or data lake development, ETL/ELT data integration patterns, web and cloud-oriented systems integration and communication-based systems, languages such as C#, Python or Java. Additional training for integration tools used will be supplied. Must have a minimum of two years of professional information technology experience to include experience with deployment and support of data integration or API solutions.

Experience In One Of The Following Areas Is Required

• Support of a data warehousing, data mart, data lake, and/or business intelligence environment
• ETL/ELT development background with Informatica PowerCenter, DataStage, SSIS, or Azure Data Factory
• Development experience with Teradata, Oracle, SQL Server, Data Lake, or Sybase repositories
• Other programming language such as C#, Python, PL/SQL, SparkSQL, NoSQL
• Shared API for web or cloud applications development background
• Big Data technologies such as Hadoop, Spark, Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP)

Experience In The Following Areas Is Preferred

• BI tools or reporting experience with SSAS, SSRS, BOE, and/or Tableau
• Project Management Experience
• Healthcare Payer experience
• Experience working in an agile development methodology
• DevOps experience (automation of code or workflow through release pipeline)
• Data warehousing development lifecycle

The Following Skills Are Required

• Ability to independently design, develop and debug basic ETL/ELT or API solutions based on business requirements with feedback from the team’s technical lead
• Ability to independently evaluate the test results of others
• Ability to become self-sufficient with integration tools
• Ability to independently create basic integrations to build dimensional databases, data marts, data lake, and cubes with feedback from the team’s technical lead
• Strong analytical, problem-solving and decision-making skills along with the ability to react quickly to changing requirements due to product limitation or driven by enterprise need
• Ability to independently develop Unit Test Plans and Test Data with feedback from the team’s technical lead
• Ability to resolve the issues found in workflows, mappings, stored procedures, and data pipelines
• Develop basic system and integration test plans
• Ability to execute test plans and document results and discrepancies with feedback from the team’s technical lead
• Ability to write SQL queries using subqueries
• Strong knowledge of SQL data types and functions
• Very good communication and writing skills with an attention to detail

Accountabilities & Essential Functions

Analyzes data integration requirements and create integration solutions that support the application development efforts.

Modifies and implements database integration solutions to support business requirements.

Ensures capture of data integration metadata, lineage, and catalog through configuration and parameterization.

Develops, executes and evaluates data quality test plans such that the results and quality of the data assure compliance with corporate expectations.

Provides basic guidance on the data integration processes and procedures to Associate Data Engineers and other team members.

Follows the software development life-cycle as required to ensure that the company meets regulatory requirements.

Participates in the development of strategies for data acquisition, archive recovery, and database/data lake implementation.

Supports the management of data migrations/conversions and troubleshooting data processing issues.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable Accommodations may be made to enable individual with disabilities to perform the essential functions.

Job duties are performed in a normal and clean office environment with normal noise levels.

Work is predominately done while sitting or standing.

The ability to comprehend, document, calculate, visualize, and analyze are all required.

Additional Information

In support of our mission to improve the health and lives of Louisianians, we encourage the good health of its employees and visitors. We want to ensure that our employees have a work environment that will optimize personal health and well-being. Due to the acknowledged hazards from exposure to environmental tobacco smoke, and in order to promote good health, our company properties are smoke and tobacco free.

We perform background and pre-employment drug screening after an offer has been extended and prior to hire for all positions. As part of this process records may be verified and information checked with agencies including but not limited to the Social Security Administration, criminal courts, federal, state, and county repositories of criminal records, Department of Motor Vehicles and credit bureaus. Pursuant with sec 1033 of the Violent Crime Control and Law Enforcement Act of 1994, individuals who have been convicted of a felony crime involving dishonesty or breach of trust are prohibited from working in the insurance industry unless they obtain written consent from their state insurance commissioner.

Additionally, we are a Drug Free Workplace. A pre-employment drug screen will be required and any offer is contingent upon satisfactory drug testing results.

JOB CATEGORY: Data Analytics/Warehousing, & Business Intelligence