Analytics Engineer

ChatGPT Equities Invoicing Dashboard Operations Governance Purchasing Accounting Scalability Procurement Credit Risk Claude Code Data Quality Communication Data Modeling GitHub Copilot Data Dictionary Asset Management SAP Applications Inventory Staging Business Valuation Financial Services Workflow Management Development Testing Time Off Management Business Requirements Business Intelligence Referential Integrity Full Stack Development Stakeholder Engagement Operational Data Store Business Transformation Requirements Elicitation Self Service Technologies SQL (Programming Language) Snowflake (Data Warehouse) Cross-Functional Collaboration $114,400 - $151,840 / yr Posted yesterday, Seeking an experienced Analytics Engineer to build data models, semantic layers, and data marts that make SAP financial and operational data accessible through Snowflake., * 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.

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., * 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, * 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, 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 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.

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., 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.