Data Engineer (Louisiana)

Blue Cross and Blue Shield of Louisiana • Baton Rouge, LA

2d

About The Position

The Data Engineer develops data integration solutions using integration tools or other methods, following direction from the agile team’s technical lead and working with Lead Data Engineers, Principal Data Engineers, and the functional manager. The role complies with laws and regulations associated with its duties and responsibilities and reports to the Manager of Enterprise Information Management. It has no direct reports and involves contact with all levels of BCBSLA personnel and outside vendors.

The position analyzes data integration requirements and creates or modifies integration solutions to support application development and business needs. It helps ensure data integration metadata, lineage, and catalog information are captured; develops and evaluates data quality test plans; supports data migrations and conversions; and troubleshoots data processing issues. The role also provides basic guidance on integration processes and procedures and follows the software development life cycle to help meet regulatory requirements.

The job is performed in a normal, clean office environment with normal noise levels. Work is predominantly performed sitting or standing. Residency in or relocation to Louisiana is preferred. Applicants must be authorized to work in the United States without employer-sponsored immigration support.

Requirements

• Bachelor’s degree in Computer Science or a related field, or four years of related experience in lieu of a degree.
• At least two years of professional information technology experience, including deployment and support of data integration or API solutions.
• Experience in at least one of the following areas: supporting a data warehousing, data mart, data lake, or business intelligence environment; ETL/ELT development using Informatica PowerCenter, DataStage, SSIS, or Azure Data Factory; development with Teradata, Oracle, SQL Server, Data Lake, or Sybase repositories; programming with C#, Python, PL/SQL, SparkSQL, or NoSQL; shared API development for web or cloud applications; or Big Data technologies such as Hadoop, Spark, AI, ML, or NLP.
• Knowledge of data mart, data warehouse, or data lake development; ETL/ELT integration patterns; web- and cloud-oriented systems integration and communication-based systems; and languages such as C#, Python, or Java.
• 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 others’ test results.
• Ability to become self-sufficient with integration tools.
• Ability to independently create basic integrations for dimensional databases, data marts, data lakes, and cubes, with feedback from the team’s technical lead.
• Strong analytical, problem-solving, and decision-making skills, including the ability to respond quickly to changing requirements.
• Ability to independently develop unit test plans and test data with feedback from the team’s technical lead.
• Ability to resolve issues in workflows, mappings, stored procedures, and data pipelines.
• Ability to 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 and strong knowledge of SQL data types and functions.
• Very good communication and writing skills, with attention to detail.
• Authorization to work for Louisiana Blue in the United States without employer-sponsored immigration support.

Nice To Haves

• Advanced degree or certification.
• 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, including automation of code or workflow through a release pipeline.
• Data warehousing development lifecycle experience.
• Residency in or relocation to Louisiana.

Responsibilities

• Analyze data integration requirements and create integration solutions that support application development efforts.
• Modify and implement database integration solutions to support business requirements.
• Ensure data integration metadata, lineage, and catalog information are captured through configuration and parameterization.
• Develop, execute, and evaluate data quality test plans to confirm data quality meets corporate expectations.
• Provide basic guidance on data integration processes and procedures to Associate Data Engineers and other team members.
• Follow the software development life cycle as required to help ensure compliance with regulatory requirements.
• Participate in developing strategies for data acquisition, archive recovery, and database or data lake implementation.
• Support data migrations and conversions and troubleshoot data processing issues.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level