Senior Data Analytics Engineer

Job Description

Job Description

Role: Senior Data Analytics Engineer Consultant

Position Type: Contract

Location: Oklahoma City

Pay Rate Range: Open, Based on Experience

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 . Please contact us today to discuss this opportunity!

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.