Senior Data Engineer

Addison Group; Norman (OK); On-site; USD 152,000 - 207,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401K

Job summary

Addison Group is seeking a Senior Data Engineer Consultant for a contract role in Oklahoma City. You will design, build, and support data pipelines that consolidate multiple systems into a centralized analytics platform built on Snowflake.

The ideal candidate has hands-on enterprise data engineering experience, strong SQL skills, and familiarity with Snowflake, dbt, and Informatica. Collaboration with architects and stakeholders is essential.

Qualifications

• Hands-on data engineering in complex enterprise environments.
• Strong SQL development, optimization, and performance tuning.
• Experience with Snowflake data loading, transformation, security, and governance.

Responsibilities

• Design, develop, test, and support enterprise data pipelines.
• Develop source-to-target ingestion and transformation processes.
• Write and optimize SQL in Snowflake and Oracle environments.

Skills

Advanced SQL

Data modeling

ETL/ELT

Collaboration

Education

Bachelor's degree in CS/related field

Tools

Snowflake

dbt

Informatica

Oracle

Job description

Role

Senior Data Engineer Consultant

Position Type

Contract

Location

Oklahoma City

Pay Rate Range

Ideally around $110/hourly pay rate- Keeping bill rate around $150/hourly but I let them know it will be tough- so if we have someone higher, let me know.

Benefits

You are eligible for medical, dental, vision insurance benefits, 401K

Are you looking for a growth opportunity for a reputable company with a positive work environment? Our client is looking for a Senior Data Engineer Consultant.

Overview

Our client is seeking a Senior Data Engineer Consultant to support the implementation of a new enterprise data warehouse platform built on Snowflake. This individual will play a critical role in designing, developing, and supporting enterprise data pipelines that consolidate information from multiple business systems into a centralized reporting and analytics environment. The consultant will work alongside architects, business stakeholders, and technical teams to build scalable data solutions while also supporting existing production data environments during the transition. This is a long-term opportunity for an experienced data engineering professional who thrives in complex enterprise environments and enjoys solving large-scale data integration challenges.

Key Responsibilities

Design, develop, test, deploy, document, and support enterprise data pipelines and transformation processes. Develop and maintain source-to-target ingestion and transformation pipelines for structured enterprise data. Write, optimize, test, and troubleshoot complex SQL in Snowflake and Oracle environments. Implement transformation logic, dimensional models, historical data loads, reference data management, and reconciliation controls. Support identity matching, master data management, crosswalks, and governance-related data processes. Partner with source system stakeholders to profile data, identify anomalies, document business rules, and resolve data quality issues. Develop automated data quality checks, monitoring, auditing, exception handling, and operational alerting processes. Create and execute unit, integration, regression, performance, and reconciliation testing for data pipelines. Tune workloads and queries for performance, reliability, scalability, and cost optimization. Utilize source control, code review, and deployment practices to support enterprise development standards. Document data flows, transformations, dependencies, runbooks, recovery procedures, and support processes. Troubleshoot and resolve production data issues across data warehouse and operational reporting environments. Transfer knowledge to internal teams and assist with establishing sustainable data engineering standards and best practices.

Preferred Experience

Demonstrated experience performing hands-on data engineering in complex enterprise environments. Advanced SQL development, optimization, and performance tuning expertise. Strong production experience with Snowflake, including data loading, transformation, security, workload optimization, and operational support. Experience building and supporting ETL, ELT, data integration, and orchestration pipelines. Strong understanding of dimensional modeling, normalized database structures, historical data management, slowly changing dimensions, and source-to-target mapping. Experience implementing automated testing, monitoring, reconciliation, and data quality controls. Experience utilizing Git-based source control and structured software development practices. Experience supporting Oracle databases, operational data stores, or enterprise data warehouse environments. Experience with dbt, Informatica, or comparable enterprise data integration platforms is highly preferred. Experience integrating enterprise systems such as ERP, HCM, CRM, admissions, learning management, or comparable business applications. Snowflake certifications or related data engineering certifications are a plus.

Ideal Candidate Profile

Senior-level data engineering professional capable of working independently in complex environments. Strong problem solver with exceptional SQL and data modeling expertise. Comfortable balancing new platform implementation efforts while supporting existing production workloads. Detail-oriented with a strong focus on data quality, governance, reliability, and operational excellence. Collaborative team player who can effectively work with architects, business stakeholders, and technical teams. Excellent communicator capable of translating technical concepts into business value. Passionate about establishing scalable processes, reusable frameworks, and long-term engineering standards. Experience supporting large enterprise data initiatives, analytics platforms, or institutional reporting environments is highly desirable.

Addison Group is an Equal Opportunity Employer. Addison Group provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state, and local laws. Addison Group complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. Reasonable accommodation is available for qualified individuals with disabilities, upon request.