Analytics Engineer

TEKsystems; United States; Hybrid; USD 76,000 - 101,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

401(k) with pre-tax and Roth

Life and AD&D insurance

Disability insurance

Health Savings Account

Transportation benefits

Employee Assistance Program

Paid time off

Job summary

TEKsystems is seeking an Analytics Engineer in Scottsdale to build data models, semantic layers, and data marts that expose SAP data via Snowflake. The role requires close collaboration with Finance, Accounting, Procurement, Operations, Asset Management, Trading, and Credit Risk teams.

The ideal candidate brings strong Snowflake and dbt Core experience, plus excellent requirements gathering and cross-functional communication skills. Hybrid work, onsite Tue-Thu, 12-month contract to hire.

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.

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.

Skills

Snowflake

dbt Core

SQL

Data modeling

Stakeholder engagement

Communication

Requirements gathering

Data quality testing

Job description

Analytics Engineer

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

• 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 jobclassification 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 & visionCritical Illness, Accident, and Hospital401(k) Retirement Plan Pre-tax and Roth post-tax contributions availableLife Insurance (Voluntary Life & AD&D for the employee and dependents)Short and long-term disabilityHealth Spending Account (HSA)Transportation benefitsEmployee Assistance ProgramTime 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.