Senior Data Engineer - Informatica & Snowflake

Jarred Taylor, Senior Data Engineer

Baltimore, **234, 410-***-****, ************@*****.***

SUMMARY Highly accomplished Senior Data Engineer with 15+ years of experience in designing, building, and operating end-to-end data pipelines. Expertise includes Informatica, Snowflake, complex SQL, and data warehousing solutions for regulatory compliance and advanced analytics. Proven ability to develop automated validation frameworks, resolve data anomalies, and serve as a subject matter expert on regulated data. Adept at collaborating with cross- functional teams to enhance data quality and support strategic initiatives, driving data-driven decision-making.

WORK EXPERIENCE

Senior Data Engineer

CareFirst BlueCross BlueShield, Inc.

04/2022 – Present

Spearheaded BCBSA-required extracts and federal/state regulatory deliverables, including Maryland Medicaid and CMS/state reporting; designed, built, and operated end-to-end data pipelines in Informatica and Snowflake utilizing complex SQL.

Managed the production of member, claim, and provider datasets for the Maryland Medicaid Special Investigations Unit (SIU) and collaborated with six external data science vendors to enable advanced fraud, waste, and abuse detection.

Developed and maintained automated validation and reconciliation frameworks (row counts, referential integrity, trend/variance checks) to assure that all BCBSA and government submissions are accurate, complete, and timely.

Investigated and resolved data anomalies across SIU/MD Medicaid domains; partnered with Data Governance, Compliance, and Government Programs to remediate upstream issues and improve data quality and lineage.

Served as a subject matter expert on regulated data and outbound files, clarifying business rules and metric logic to Actuarial, Finance, SIU, and Compliance while supporting audits and data calls. Engineered Informatica mappings and Snowflake data structures to facilitate the legacy migration from FACETS to Snowflake (“FACETS GREENFIELD”), establishing reusable patterns and standards for payer data feeds. Participated in Agile/Scrum ceremonies and utilized Jira for story management, collaborating with an offshore team to enhance the SDLC and CI/CD for data engineering assets.

Partner Manager

Goldfinger Holdings LLC

04/2016 – 04/2022

Oversaw the Microsoft Partner Network (Cloud Solution Provider, DevOps, Office 365, Dynamics CRM) and led teams delivering cloud hosting and DevOps services across AWS, Azure, Rackspace, and private cloud. Instituted a Salesforce-based Sales & Marketing analytics warehouse (SQL Server + SSIS), integrating Salesforce and Pardot for enhanced pipeline and campaign analysis.

Served as a certified Salesforce Administrator, crafting custom reports, fields, and AppExchange-ready packages while supporting customer-facing conferences and demonstrations for hosted solutions and DevOps tooling. Lead Business Intelligence Solutions Engineer

CareFirst BlueCross BlueShield, Inc.

03/2006 – 08/2016

Directed BI engineering for the CareFirst Business Intelligence Platform, bolstering PCMH (Patient-Centered Medical Home) and other corporate initiatives with clinical and financial analytics. Deployed and managed MicroStrategy 10.x (DEV/TEST/PROD) and crafted ETL and analytic solutions using SSIS/SSAS/SSRS, SQL Server, SAS, and dashboards to deliver KPIs to physicians and executive Medical Management.

Developed attribution and stratification logic for member risk scores and episode grouping utilizing Truven, Optum, MARA, and MedVantage/IMS tools, facilitating panel-based care and quality measurement. Functioned as the primary DBA for healthcare analytics SQL Server environments and contributed to a BI Center of Excellence, piloting new Microsoft BI and Power BI features for payer analytics. Senior Programmer / Analyst

CareFirst BlueCross BlueShield, Inc.

05/2002 – 03/2006

Created and supported claims imaging and OCR workflow solutions for multiple lines of business using VB/.NET and SQL Server. Constructed data marts, DTS-based ETL, and reporting interfaces to support claims processing, check imaging, and archival systems, enhancing operational visibility for claims and finance.

Programmer / Analyst

American Psych Systems

01/2000 – 05/2002

Designed and executed SQL Server-based data warehouses and operational databases to support behavioral health claims adjudication and government reporting (including Puerto Rico Medicaid-related obligations). Re-engineered legacy RBASIC processes into VB + SQL Server ETL and reporting solutions, improving performance and reliability for payer deliverables.

Programmer/Analyst

Paradigm Software LLC

Cultivated early-career expertise in SQL Server, Visual Basic, Access, reporting, and hardware/software integration, including contributions to healthcare data conversions and data warehouse/reporting solutions for Maryland Medicaid and other clients.

Programmer/Analyst

CMG Health Inc.

Established early-career fundamentals in SQL Server, Visual Basic, Access, reporting, and hardware/software integration, including efforts on healthcare data conversions and data warehouse/reporting solutions for Maryland Medicaid and other clients.

PC Technician/Technical Writer

National Instruments Company

Formulated early-career foundation in SQL Server, Visual Basic, Access, reporting, and hardware/software integration, including work on healthcare data conversions and data warehouse/reporting solutions for Maryland Medicaid and other clients.

Consulting

Guilford Pharmaceuticals

Developed early-career knowledge in SQL Server, Visual Basic, Access, reporting, and hardware/software integration, contributing to healthcare data conversions and data warehouse/reporting solutions for Maryland Medicaid and other clients.

SKILLS Snowflake SQL Server

Informatica IICS / PowerCenter SSIS/SSRS/SSAS

MicroStrategy SAS

Dundas OLAP/cubes

ADF ADO

GitHub Advanced SQL

shell scripting VB/.NET legacy support

Jira Git/TFS

CI/CD-oriented SDLC Medical & pharmacy claims

membership provider

PCMH risk scores

episode groupers (Truven, Optum,

MARA)

HEDIS/quality

BCBSA extracts CMS/state submissions

Medicaid Data warehousing

conformed dimensions data quality frameworks

reconciliation & lineage BI/analytics solutions design Snowflake DW AWS/Azure hosting exposure

on-prem + hybrid architectures Agile/Scrum delivery Kafka Mulesoft

Databricks NDW/BCBSA

SQL Server (2000–2019) SQL Server (2000–2025)

dashboarding/reporting tools shell/batch scripting Snowflake on cloud TFS/Git

Salesforce (Admin, reporting) Pardot

Atlassian Jira/Confluence Python

Agile Framework ETL/ELT

Database Design Monitoring

Data Quality Frameworks Analytical Skills

Communication Skills DevOps Practices

Data Modeling Business Context Understanding

Contact this candidate