Data Analyst Data Warehouse Analytics and BI

You will work closely with stakeholders across the business, including operations, finance, dispatch, inventory, vendor management, and others. You need to be an expert at building and maintaining these relationships. They will help give you the context and information needed to deliver reporting and insights that enhances how the business runs.

Our source systems are varied and disparate, with multiple ERPs, each carrying its own schema, conventions, and quirks. A core part of the job is reconciling those differences and producing a sanitized & harmonized view where the business can compare like-for-like across entities and source systems. If you enjoy untangling messy data and turning it into something trustworthy, then this is the place for you.

What You Will Do

• Develop, maintain, and extend Power BI reports, dashboards, semantic models, and alerting across finance, operations, inventory, dispatch, and vendor management
• Write and optimize complex SQL against Snowflake to investigate data, build models, and answer business questions
• Build and refactor dbt models that standardize and harmonize data extracted from multiple ERPs into a unified, comparable schema
• Setup the data in scalable and consumable way to enable the organization to be most well suited humans and agents
• Reconcile disparate source-system definitions (chart of accounts, item masters, customer and vendor records, transaction types) so the business sees a true apples-to-apples view
• Partner with stakeholders across the business to elicit requirements, understand operational context, and translate business questions into reliable reporting
• Proactively surface findings, anomalies, and improvement opportunities discovered in the data
• Monitor Fivetran connectors, dbt runs, and Power BI refreshes; triage and resolve data quality and pipeline issues
• Respond to ad-hoc data requests that drive business decisions and initiatives
• Document data models, definitions, and report logic so knowledge is shared, not siloed

Required Qualifications

• 2+ years of professional experience as a data analyst, analytics engineer, or BI developer
• Extremely strong SQL skills, including comfort with CTEs, window functions, indexing, stored procedures, performance tuning, and debugging complex joins across large datasets.
• Understanding of relational databases and scalable design.
• Extremely strong Power BI skills, including:

• DAX and data modeling
• Calculation groups
• Alerting and operational enablement, including integration with Power Apps
• Performance tuning, row-level security, and report design best practices

• Familiarity with cloud data warehouses (Snowflake or OneLake referred) and modern ELT patterns
• Strong written and verbal communication, with the interpersonal skills to build trust and productive working relationships with business stakeholders
• Self-directed and comfortable working remotely and driving work without daily oversight
• Forward-thinking mindset with demonstrated experience using AI tools to enhance and accelerate analytics work, including model development, DAX authoring, documentation, code review, and stakeholder communication

Compensation And Benefits

• 10 Paid Holidays
• Flexible Time Off
• 401(k) Company Match
• Health, Dental, and Vision Insurance
• HSA and FSA
• Disability & Occupational Accident In