Senior Data Analytics Engineer

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401K

Job summary

Addison Group is seeking a Senior Data Analytics Engineer Consultant to drive the implementation of an enterprise data platform and analytics environment in Oklahoma City. You will bridge data engineering, stakeholders, and reporting teams to transform enterprise data into trusted datasets and scalable metrics.

The ideal candidate has deep SQL, Snowflake, dimensional modeling, and BI experience, with a focus on standardization, data quality, and governance across reporting platforms.

Qualifications

• Experience in analytics engineering or BI engineering.
• Advanced SQL development and performance optimization.
• Experience with Snowflake or similar cloud platforms.
• Knowledge of dimensional modeling and enterprise metrics.

Responsibilities

• Develop curated analytical models and semantic-ready datasets for reporting.
• Write, optimize, and document complex SQL for transformations and metrics.
• Translate requirements into dimensions, facts, measures, and rules.
• Collaborate with stakeholders, data stewards, analysts, and developers.
• Document business terms, lineage, mappings, and data usage guidelines.
• Implement automated data quality testing and regression prevention.
• Prepare Snowflake datasets for Power BI and other tools.
• Support semantic models and self-service reporting practices.
• Analyze and improve existing reporting and data structures.
• Promote standardization and reuse of business logic across teams.

Skills

Advanced SQL

Dimensional modeling

Analytics engineering

Business intelligence

Strong communication

Tools

Snowflake

Power BI

dbt

Informatica

Job description

Role: Senior Data Analytics Engineer Consultant

Position Type: Contract

Location: Oklahoma City

Pay Rate Range: $100-$110/hourly DOE

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 Analytics Engineer Consultant.

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.

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.

Why choose Addison IT?

• 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
• Professional Development: You are provided hiring process advice, resume revision, and employment term negotiation

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.

IND 005-010