Data Analytics Engineer Consultant

Addison Group
Oklahoma City, OK, United States
2 days ago
Apply on addisongroup.gosnaphop.com
Prepare application

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$208,000.0 - $228,800.0
Working hours
Shift work

Tech stack

Data Analysis Business Logic Automation of Tests Code Review Data Integrity Data Structures Data Warehousing Dimensional Modeling Human Resources Information System (HRIS) Octopus Deploy Operational Data Store Oracle Databases
+11 more
Performance Tuning Power BI Cloud Services Technical Data Management Systems Snowflake Cypress (Programming Language) Data Strategy Microsoft Fabric Data Analytics Tools for Reporting Software Version Control

Job description

Overview: Our client is seeking a Senior Data Analytics Engineer Consultant to support the implementation of a new enterprise data platform and analytics environment. This role serves as the bridge between data engineering, business stakeholders, and reporting teams by transforming enterprise data into trusted, reporting-ready datasets and reusable business metrics. The ideal candidate will have strong experience with Snowflake, advanced SQL, dimensional modeling, analytics engineering, and business intelligence solutions. This consultant will help establish enterprise reporting standards while enabling meaningful insights through curated datasets and scalable analytical models., Key Responsibilities: Develop curated analytical models, dimensional structures, semantic-ready datasets, and reusable business logic for enterprise reporting. Write, optimize, test, and document complex SQL used for transformations, metrics, reporting, and analytical consumption. Translate business requirements into consistent dimensions, facts, measures, hierarchies, calculations, and reporting rules. Partner with business stakeholders, data stewards, analysts, and developers to define requirements and resolve conflicting data definitions. Develop and maintain documentation for business terms, calculations, lineage, source mappings, assumptions, and data usage guidelines. Implement automated testing for data quality, metric consistency, referential integrity, completeness, and regression prevention. Support reconciliation efforts and user acceptance testing by validating outputs against existing reports and source systems. Prepare Snowflake datasets and analytical models for Power BI and other reporting tools. Assist with semantic models, performance optimization, row-level security, and governed self-service reporting practices. Analyze and improve existing reporting solutions, analytical models, and data structures as assigned. Promote standardization and reuse of business logic across departments and reporting platforms. Transfer knowledge and best practices to analysts, developers, and support personnel., Manufacturing Data Analyst Employment Status: Full-Time, Salaried/Exempt Location: Waukegan, IL Schedule: Onsite daily Monday through Friday from 8 am - 5 pm CT. Salary: $75,000 - $95,000 Position Overview The Manufacturing Data Analyst will enhance su… Recommended *, Job Title: Data Engineer Industry: Energy / Utilities Location (city, state): Oklahoma City, OK Assignment Type: Contract Pay: $50.00 - $65.00 / hour depending on experience Work Schedule: Monday-Friday, standard business hours. Remote candidates will … Recommended *, 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 k… Recommended *, Title: Purchasing Manager Employment Status: Full-Time, Exempt Schedule/Location: Onsite daily 8 am - 5 pm CT in Waukegan, IL Salary Range: $80,000 - $125,000 Position Overview The Purchasing Manager oversees and directs all procurement activities for … Recommended *, Role: Octopus Deploy Governance Consultant Location: 100% Remote Pay: $90/hr Duration: 5 Week Contract Internal Job ID: 10077519 Benefits: Benefits are available the 1st day of the month following 60 days of employment. The following benefits available… Recommended *, Remote Data Engineer Compensation: $59-61 / HR Benefits: This position is eligible for medical, dental, vision, and 401(k). Requirements: *Microsoft Fabric: Data Factory, Pipelines, Lakehouse, Warehouse, Notebooks, Dataflows Gen2, and semantic models. … Recommended *, Job Title: Principal Strategy - Business Data Analyst Location: Coppell, TX Pay: Full-Time Conversion: $135,000-$165,000 annually + bonus (target ~20%) + equity awards Work Schedule: Hybrid schedule: 4 days onsite, 1 day remote Benefits: Medical, Denta… Recommended *, Title: Contracts Consultant Type: Contract Pay: $45 - $55 / hour Location: 100% remote, with optional access to a DC office Schedule: Full-time Benefits: This position is eligible for medical, dental, vision, and 401(k) Overview An organization is seek… Recommended *, Buyer Employment Status: Full-Time, Salaried/Exempt Location: Waukegan, IL Schedule: Onsite daily Monday through Friday from 8 am - 5 pm CT. Salary: $70,000 - $90,000 Position Overview The Buyer (Chemicals/Liquids) will support procurement execution fo… Recommended *, Role: Mechanical Engineer Location: East Pittsburgh, PA Pay: $79,000 - $83,000 / year Benefits: This role is eligible for medical, dental, vision, HSA, life, and short/long term disability insurance, Wellness Rewards and 401K. The Opportunity Our Globa… Recommended *, Location - Chicagoland Metro or Louisville KY on-site/Remote Title Strategic Sourcing Manager Salary 130k+ bonus Benfits - Med, Life, Dental , PTO Our client is seeking an Experienced Strategic Sourcing Manager to develop and implement strategies for i… Recommended *, Title: Controls Project Manager (Building Automation Systems) Location: Houston, TX Salary: $110-130k No sponsorship available Benefits: Health, dental, and vision insurance, Retirement plan options, Ongoing training and professional development opport… Recommended *, Title: Service Manager Onsite: Monday-Friday Location: Northwest Suburbs - Chicagoland Salary: $90,000-$110,000 + Bonus Benefits: Healthcare, Dental, PTO, 401k Position Overview We are seeking an experienced Service Manager to lead all service operatio… Recommended *, Project Executive - MEP (Electrical & Mechanical) Location: Houston, Texas Compensation: $130,000 - $160,000 Role Summary Seeking an experienced Project Executive with 15+ years of commercial MEP construction experience to provide senior leadership acr… Recommended *, Position Title: Data Strategy Associate Location: Sherman Oaks, CA (on site 4 days) Compensation: $95,000 - $115,000 / Annually Benefits: Medical, Dental, 401k, Vision, STD/LTD Turn Data Into Deals This isn’t a back-office analytics role. You’ll sit at… Recommended *, Product Engineer Location: Buffalo, NY Salary: $80,000-$100,000 Benefits: Medical, dental, vision, 401k, PTO The Product Engineer will evaluate new product opportunities and help determine which concepts should move forward. This business-focused role … Recommended *, Job Title: Manufacturing Engineer Location (city, state): Forney, TX Assignment Type: Direct Hire Pay: $85-130K Position is eligible for medical, dental, vision, and 401(k) About The Company: Our client is a rapidly growing manufacturer focused on inno… Recommended *, Job Title: Product Engineer Industry: Automotive Manufacturing / Remanufacturing Location (city, state): Oklahoma City, OK Assignment Type: Direct Hire Pay: $77,000-$115,000 annually, depending on experience Work Schedule: Monday-Friday | 6:00 AM-2:30 … Recommended *, Key Responsibilities: Develop curated analytical models, dimensional structures, semantic-ready datasets, and reusable business logic for enterprise reporting. Write, optimize, test, and document complex SQL used for transformations, metrics, reporting, and analytical consumption. Translate business requirements into consistent dimensions, facts, measures, hierarchies, calculations, and reporting rules. Partner with business stakeholders, data stewards, analysts, and developers to define requirements and resolve conflicting data definitions. Develop and maintain documentation for business terms, calculations, lineage, source mappings, assumptions, and data usage guidelines. Implement automated testing for data quality, metric consistency, referential integrity, completeness, and regression prevention. Support reconciliation efforts and user acceptance testing by validating outputs against existing reports and source systems. Prepare Snowflake datasets and analytical models for Power BI and other reporting tools. Assist with semantic models, performance optimization, row-level security, and governed self-service reporting practices. Analyze and improve existing reporting solutions, analytical models, and data structures as assigned. Promote standardization and reuse of business logic across departments and reporting platforms. Transfer knowledge and best practices to analysts, developers, and support personnel.

Requirements

Preferred Experience: Demonstrated experience in analytics engineering, business intelligence engineering, data warehousing, or related disciplines. Advanced SQL development and performance optimization skills. Experience developing analytical models in Snowflake or comparable cloud data platforms. Strong understanding of dimensional modeling, fact and dimension design, conformed dimensions, slowly changing dimensions, and enterprise metrics. Experience translating business and reporting requirements into scalable analytical solutions. Experience with automated testing, reconciliation, documentation, source control, and code review practices. Experience supporting Power BI reporting environments, semantic models, and performance optimization. Experience with dbt, Informatica, Snowflake-native transformation tools, or similar analytics engineering platforms. Experience with Oracle databases, reporting environments, or operational data stores is preferred. Experience supporting enterprise reporting, analytics, and business intelligence initiatives. Snowflake, Power BI, analytics, or data modeling certifications are a plus.

Ideal Candidate Profile: Strong communicator capable of bridging technical teams and business stakeholders. Analytical thinker who enjoys defining metrics, business rules, and enterprise reporting standards. Experienced in transforming complex datasets into meaningful and trusted business insights. Detail-oriented professional with a passion for data quality, governance, and consistency. Collaborative team player who excels in cross-functional environments. Comfortable facilitating discussions around business definitions, reporting requirements, and data interpretation. Self-motivated consultant capable of working independently while contributing to larger project goals. Dedicated to creating scalable, reusable, and well-documented analytical solutions that provide long-term value to the organization., Preferred Experience: Demonstrated experience in analytics engineering, business intelligence engineering, data warehousing, or related disciplines. Advanced SQL development and performance optimization skills. Experience developing analytical models in Snowflake or comparable cloud data platforms. Strong understanding of dimensional modeling, fact and dimension design, conformed dimensions, slowly changing dimensions, and enterprise metrics. Experience translating business and reporting requirements into scalable analytical solutions. Experience with automated testing, reconciliation, documentation, source control, and code review practices. Experience supporting Power BI reporting environments, semantic models, and performance optimization. Experience with dbt, Informatica, Snowflake-native transformation tools, or similar analytics engineering platforms. Experience with Oracle databases, reporting environments, or operational data stores is preferred. Experience supporting enterprise reporting, analytics, and business intelligence initiatives. Snowflake, Power BI, analytics, or data modeling certifications are a plus.

Ideal Candidate Profile: Strong communicator capable of bridging technical teams and business stakeholders. Analytical thinker who enjoys defining metrics, business rules, and enterprise reporting standards. Experienced in transforming complex datasets into meaningful and trusted business insights. Detail-oriented professional with a passion for data quality, governance, and consistency. Collaborative team player who excels in cross-functional environments. Comfortable facilitating discussions around business definitions, reporting requirements, and data interpretation. Self-motivated consultant capable of working independently while contributing to larger project goals. Dedicated to creating scalable, reusable, and well-documented analytical solutions that provide long-term value to the organization.

Benefits & conditions

  • Pay: We negotiate high salaries using U.S. Bureau of Labor Statistics

  • Benefits & Bonuses: You are eligible for medical, dental, vision insurance benefits, 401K, and monetary bonuses

  • Permanent Employment: Many of Addison’s job openings lead to potential permanent employment

  • Connections: You connect directly with hiring managers from renowned organizations

  • Options: You are presented with multiple employment options near your home, Operations Monitoring Technician (Entry Level) Wichita, KS Direct Hire $25-$30/hour Full-Time | Onsite | 6:00 PM - 6:00 AM (Night Shift) This position is eligible for medical, dental, vision, and 401(k) Our client is a well-established energy company w… Recommended *, Title Data Engineer Location: Hybrid - 2-3 days onsite, Tuesday-Thursday in the Chicago Suburbs Compensation: Up to $120K Benefits - Medical, Dental, PTO eligiable, Life Our client a well established organization is seeking a hands-on Data Engineer to … Recommended *, Position: Telephony Consultant Location: 100% Remote, must work CST or EST Hours Pay Rate: $80.00 - $90,00 / Per Hour Employment Type: 2 month contract Benefits: This position is eligible for medical, dental, vision, and 401(k). The ideal candidate is … Recommended *

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on addisongroup.gosnaphop.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

2:44 min

Integrating data analytics into the talent acquisition function

Kobi Kobi +1 · World Congress 2025

3:39 min

Addressing code review surrender and process exploitation

Laura Tacho Laura Tacho · World Congress 2026 Europe

1:33 min

Integrating internal APIs and maintaining data sovereignty

Mahran Meißner Mahran Meißner · World Congress 2026 Europe

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

56 sec

The hidden costs of delayed peer code reviews

Tim Gilboy Tim Gilboy

Videos

See all

Related articles

See all