Analytics Engineer: AI-Driven BI & Data Modeling

Vari; Coppell (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

401k & profit-sharing

Wellness program

Insurance discounts

Paid time off

Team building events

Career mentoring

Job summary

Vari is seeking an experienced analytics engineer to drive BI analytics and AI-powered insights. You will own dashboards, data models, and ETL pipelines while partnering with Sales, Operations, Finance, and Marketing. This role combines technical depth with business fluency to deliver trusted analyses.

You’ll work on star schemas, implement T-SQL ETL, and explore AI-enabled analytics to embed insights across the organization in Coppell, Texas. 3+ years of analytics experience is expected.

Qualifications

• 3+ years of experience in analytics engineering, BI, or data analyst role with demonstrable statistical depth
• Strong proficiency in SQL Server and T-SQL for data querying, transformation, and analysis
• Advanced Power BI skills, including DAX, Power Query, semantic modelling, and row-level security
• Working knowledge of Python or R for data analysis and statistical modelling (e.g. pandas, scikit-learn, tidyverse, ggplot2, or similar)
• Hands-on experience with statistical analysis techniques such as forecasting, regression, segmentation, or A/B testing
• Demonstrated business acumen, the ability to connect data findings to business outcomes and communicate their strategic relevance
• Proven track record of managing stakeholder relationships: gathering requirements, setting expectations, and delivering analytical work that earns trust
• Experience working with Salesforce data as a reporting or analytical source
• Familiarity with dimensional modelling concepts and star schema design
• Exceptional communication skills, able to translate complex analysis into clear, compelling narratives and recommendations for non-technical audiences

Responsibilities

• Lead the design and delivery of dashboards, reports, and analytical products using Power BI and other modern BI tools
• Apply statistical analysis techniques, including regression, forecasting, segmentation, cohort analysis, and hypothesis testing, to surface meaningful patterns and trends
• Build and maintain advanced data models incorporating DAX, calculated measures, and KPI frameworks aligned to business strategy
• Serve as a trusted analytics partner to business stakeholders across Sales, Operations, Finance, and Marketing, proactively identifying opportunities where data can drive better decisions
• Lead requirements-gathering conversations with business teams; translate ambiguous or complex business questions into well-scoped analytical problems and clear deliverables
• Present analytical findings and recommendations confidently to both technical and non-technical audiences, including senior leadership
• Leverage AI and machine learning capabilities within the BI stack (e.g. Power BI Copilot, Azure AI, Python- or R-based ML models) to augment analysis and automate insight delivery
• Use Python or R (e.g. pandas, NumPy, scikit-learn, statsmodels, tidyverse, caret) for exploratory data analysis, statistical modelling, and scripted reporting workflows
• Champion self-service analytics by publishing governed well-documented semantic models and training end users across the business
• Monitor report adoption, data quality, and metric consistency; proactively identify and resolve discrepancies
• Document metric definitions, analytical methodologies, and report lineage to promote a data-literate culture
• Contribute to the design and build of star schema structures in SQL Server, including dimension tables, fact tables, and aggregate layers
• Write and maintain T-SQL stored procedures and ETL logic supporting staging-to-DWH data flows
• Integrate data from key source systems including Salesforce CRM and other operational platforms
• Support source-to-target mapping documentation and data lineage tracking for new data domains
• Collaborate with the broader data team on pipeline reliability, performance tuning, and warehouse architecture

Skills

SQL & T-SQL

Power BI

Python or R

Statistical analysis

Stakeholder management

Tools

SQL Server

Power BI

T-SQL

Python

R

Salesforce

Job description

Vari is seeking an experienced analytics engineer to drive BI analytics and AI-powered insights. You will own dashboards, data models, and ETL pipelines while partnering with Sales, Operations, Finance, and Marketing. This role combines technical depth with business fluency to deliver trusted analyses.

You’ll work on star schemas, implement T-SQL ETL, and explore AI-enabled analytics to embed insights across the organization in Coppell, Texas. 3+ years of analytics experience is expected.