Data Engineer - Government Program Finance (Hybrid)

CareFirst BlueCross BlueShield; Baltimore (MD); On-site; USD 80,000 - 159,000; Full time

Job summary

CareFirst BlueCross BlueShield seeks a Data Engineer to develop innovative data solutions supporting actuarial analytics, focusing on medical economics and government program analytics. You will work with actuaries to create trend analytics tools and dashboards, and assist with ad hoc reporting, ensuring data integrity across claim and provider data.

The role requires proficiency in SQL and experience with BI tools; Azure Data Factory and Snowflake are preferred as the company moves to

Qualifications

• Proficiency in at least one programming language (SQL/NoSQL/Python).
• Experience with data warehouses, ETL/ELT, BI tools, testing and defect management.
• Healthcare data familiarity is a plus.

Responsibilities

• Develops and enhances data models and solutions for analytics framework.
• Interprets data, analyzes patterns, and provides actionable insights.
• Supports actuaries with data needs and ad hoc requests.
• Ensures data quality, auditing, scalability, and performance.

Skills

SQL

NoSQL

Python

Education

Bachelor's degree in Data Sciences, IT, CS or Engineering

Tools

SSIS

SSAS

Azure Data Factory

Informatica Intelligent Cloud Services

Snowflake

Job description

Resp & Qualifications

The Data Engineer, working within the Finance Data Systems and Decision Support area, is a highly motivated professional responsible for developing innovative and complex data solutions and applications to support actuarial analytics specializing in medical economics. With a critical eye towards data integrity and a growing understanding of claim and provider data, the Data Engineer will work closely with actuaries to produce trend analytics tools and dashboards and assist with ad hoc reporting and analysis. Additionally, the Data Engineer will partner with actuaries to support the financial impact analysis related to the building of and changes to Government Program analytics.

Purpose

The Data Engineer, working within the Finance Data Systems and Decision Support area, is a highly motivated professional responsible for developing innovative and complex data solutions and applications to support actuarial analytics specializing in medical economics. With a critical eye towards data integrity and a growing understanding of claim and provider data, the Data Engineer will work closely with actuaries to produce trend analytics tools and dashboards and assist with ad hoc reporting and analysis. Additionally, the Data Engineer will partner with actuaries to support the financial impact analysis related to the building of and changes to Government Program analytics.

The Data Engineer is expected to have a basic understanding of the health care business and is strongly encouraged to quickly improve on this business knowledge to perform analysis more independently on the data to validate accuracy and proper reporting based on established business rules.

The Data Engineer is expected to make decisions, with management guidance, on the appropriate data sources to use, the optimal approach to solving business problems, and to ensure that results tie to appropriate controls.

The Data Engineer is expected to be proficient in SQL. Experience in Microsoft business intelligence tools is beneficial, specifically knowledge and experience of SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services). With the goal of moving to cloud-based tools, practical experience with Azure Data Factory is preferred along with IICS (Informatica Intelligent Cloud Services) and Snowflake.

The Data Engineer is expected to learn and understand the fundamentals of actuarial and financial analytics. This includes becoming familiar with actuarial terminology and basic calculations as well as with the underlying health care data being used for analysis to be able to explain reasons for outliers and to generally support in-depth questions and analytical results.

The Data Engineer will be responsible and accountable for all phases of the System Development Life Cycle. This requires an understanding of business need, the data needed to respond to the request, and the ability to execute on the building and delivery of accurate and timely reporting and data solutions.

This is a fast-paced, collaborative, and iterative environment requiring quick learning, agility, and flexibility.

Essential Functions

• Develops and enhances data models and solutions to enable business partners to build analytics framework and make data-driven business decisions. Works as the liaison in translating the business rules and supporting data needs from infrastructure systems (e.g., data warehouses, data lakes). Prepares and manipulates data using multiple technologies.
• Interprets data, analyzes patterns using various data quality check techniques, and provides ongoing reports. Executes quantitative analyses that translate data into actionable insights. Provides analytical and data-driven decision-making support for key projects. Designs, manages, and conducts quality control procedures for data sets using data from multiple systems.
• Develops data models by studying existing data warehouse architecture; evaluating alternative logical data models including planning and execution tables; applying metadata and modeling standards, guidelines, conventions, and procedures; planning data classes and sub-classes, indexes, directories, repositories, messages, sharing, replication, back-up, retention, and recovery.
• Support actuaries' data needs via ad hoc requests that may involve exploring new data sets.
• Improves data delivery engineering job knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
• Applies data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.
• Applies and implements best practices for data auditing, scalability, reliability and application performance.

Supervisory Responsibility

This position has no direct reports, however, may informally lead teams in a matrix environment.

Qualifications

Education Level: Bachelor's Degree in Data Sciences, Information Technology or Computer Science or Engineering OR in lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.

Experience: 3 years Hands‑on experience with database management systems, ELT/ETL systems, business intelligence tools, defect management and system testing.

Preferred Qualifications

• Existing knowledge and experience working with health care claims and enrollment data in the health insurance industry is highly preferred. Basic and fundamental understanding of health economics and advanced analytics methodology is desired for this role.

Knowledge, Skills And Abilities (KSAs)

• Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python).
• Knowledge and understanding of data exchange formats.
• Knowledge and understanding of database design and implementation concepts.
• Ability to recognize, analyze, and solve a variety of problems.
• Knowledge and understanding of data movement concepts.
• Excellent communication skills both written and verbal.
• Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence. Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging.

Salary Range

$80,136 - $159,159

Salary Range Disclaimer

The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the work is being performed. This compensation range is specific and considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience, education/training, internal peer equity, and market and business consideration. It is not typical for an individual to be hired at the top of the range, as compensation decisions depend on each case's facts and circumstances, including but not limited to experience, internal equity, and location. In addition to your compensation, CareFirst offers a comprehensive benefits package, various incentive programs/plans, and 401k contribution programs/plans (all benefits/incentives are subject to eligibility requirements).

Equal Employment Opportunity

CareFirst BlueCross BlueShield is an Equal Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.

Federal Disc/Physical Demand

Note: The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes him/her ineligible to perform work directly or indirectly on Federal health care programs.

Physical Demands

The associate is primarily seated while performing the duties of the position. Occasional walking or standing is required. The hands are regularly used to write, type, key and handle or feel small controls and objects. The associate must frequently talk and hear. Weights up to 25 pounds are occasionally lifted.

Sponsorship in US

Must be eligible to work in the U.S. without Sponsorship