Analytics Engineer

TEKsystems; Scottsdale (AZ); Hybrid; USD 76,000 - 101,000; Full time

Benefits offered by this job

Medical coverage

401(k)

Life Insurance

Disability coverage

HSA

Job summary

TEKsystems is seeking an Analytics Engineer in Scottsdale to build data models, semantic layers, and data marts enabling SAP data access in Snowflake.

Role emphasizes collaboration with Finance, Accounting, and Operations teams, strong Snowflake/dbt Core skills, and effective requirements gathering for scalable data solutions.

Qualifications

• Strong hands-on Snowflake experience.
• Strong dbt Core experience.
• Strong SQL and data-modeling fundamentals.
• Experience building data marts, semantic views, and semantic models.
• Experience translating business requirements into technical data solutions.
• Understanding of data workflows from raw source tables through end-user reporting.
• Experience with data-quality testing, governance, and documentation.
• Strong stakeholder engagement and requirements-gathering skills.
• Ability to work onsite in Scottsdale Tuesday through Thursday.

Responsibilities

• Lead requirements-gathering sessions and data model walkthroughs with business stakeholders.
• Translate business workflows, reporting needs, and success metrics into scalable data models.
• Build and maintain staging, intermediate, and mart-layer dbt models in Snowflake.
• Design semantic models and views for BI tools, self-service analytics, and LLM-enabled querying.
• Partner with SAP and integration teams to understand source data, relationships, and business rules.
• Build data marts supporting invoices, purchase orders, procurement, accounting, treasury, revenue, budget variance, and asset performance.
• Support Hex dashboards and workbooks with clean, documented datasets.
• Implement incremental loads, dbt tests, referential-integrity checks, null checks, and accepted-value constraints.
• Maintain data dictionaries, lineage, metric definitions, naming standards, and model documentation.

Skills

Snowflake experience

dbt Core

SQL

Data modeling

Data marts

Requirements gathering

Stakeholder engagement

Documentation

Onsite collaboration Scottsdale

Tools

Snowflake

dbt

SQL

Job description

Location: Scottsdale, AZ

Schedule: Hybrid, onsite Tuesday through Thursday

Duration: 12-month contract

Position Overview

Seeking an experienced Analytics Engineer to build data models, semantic layers, and data marts that make SAP financial and operational data accessible through Snowflake.

This is a stakeholder-facing role requiring direct collaboration with Finance, Accounting, Procurement, Operations and Maintenance, Asset Management, Trading, and Credit Risk teams. The ideal candidate combines strong Snowflake and dbt Core experience with excellent requirements-gathering, communication, and cross-functional collaboration skills.

Responsibilities

• Lead requirements-gathering sessions and data model walkthroughs with business stakeholders.
• Translate business workflows, reporting needs, and success metrics into scalable data models.
• Build and maintain staging, intermediate, and mart-layer dbt models in Snowflake.
• Design semantic models and views for BI tools, self-service analytics, and LLM-enabled querying.
• Partner with SAP and integration teams to understand source data, relationships, and business rules.
• Build data marts supporting invoices, purchase orders, procurement, accounting, treasury, revenue, budget variance, and asset performance.
• Support Hex dashboards and workbooks with clean, documented datasets.
• Implement incremental loads, dbt tests, referential-integrity checks, null checks, and accepted-value constraints.
• Maintain data dictionaries, lineage, metric definitions, naming standards, and model documentation.
• Use AI coding assistants to support SQL generation, model development, testing, and documentation while reviewing all generated output.

Required Qualifications

• Strong hands-on Snowflake experience
• Strong dbt Core experience
• Strong SQL and data-modeling fundamentals
• Experience building data marts, semantic views, and semantic models
• Experience translating business requirements into technical data solutions
• Understanding of data workflows from raw source tables through end-user reporting
• Experience with data-quality testing, governance, and documentation
• Strong stakeholder engagement, requirements-gathering, and communication skills
• Ability to work onsite in Scottsdale Tuesday through Thursday

Preferred Qualifications

• SAP ERP financial or operational data experience
• Hex or similar analytics platform experience
• Snowflake semantic models, Cortex Analyst, dbt Semantic Layer, or MetricFlow experience
• Dagster or similar orchestration experience
• dbt Analytics Engineer certification
• Experience supporting Finance, Accounting, Procurement, Operations, Asset Management, Trading, or Credit Risk teams
• Renewable energy, utilities, financial services, or other asset-intensive industry experience
• Familiarity with LLMs and AI-assisted analytics
• Experience with Claude Code, ChatGPT Codex, GitHub Copilot, or similar tools

Benefits

Eligibility requirements may apply. Available benefits may include:

• Medical, dental, and vision coverage
• 401(k) with pre-tax and Roth contribution options
• Life and AD&D insurance
• Short-term and long-term disability
• Health Savings Account
• Transportation benefits
• Employee Assistance Program
• Applicable paid time off and leave benefits

Note: This position is for an existing vacancy

Job Type & Location

This is a Contract to Hire position based out of Scottsdale, AZ.

Pay And Benefits

The pay range for this position is $55.00 - $73.00/hr. Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)

Job Type & Location

This is a Contract to Hire position based out of Scottsdale, AZ.

Application Deadline

This position is anticipated to close on Nov 12, 2026.

Workplace Type

This is a hybrid position in Scottsdale,AZ.

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems And TEKsystems Global Services

Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.