Data Analyst- Data Warehouse Analytics and BI
Role details
Job location
Tech stack
Job description
We are looking for a Data Analyst to join our Data Warehouse & BI team and help us expand the reach, depth, and operational impact of our modern data platform. This is a hands-on role focused on report development, model expansion, and the ongoing reliability of a production analytics stack that already drives company-wide reporting.
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
Requirements
Do you have experience in System tuning?, * 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
Benefits & conditions
4.54.5 out of 5 stars Irving, TX 75063 Remote $80,000 - $100,000 a year - Full-time, Pulled from the full job description
- Paid training
- 401(k) matching
- Vision insurance
- Health savings account
- Dental insurance
- Flexible spending account
- Life insurance, Compensation and Benefits
- 10 Paid Holidays
- Flexible Time Off
- 401(k) Company Match
- Health, Dental, and Vision Insurance
- HSA and FSA
- Disability & Occupational Accident Insurance
- Company-Paid Life Insurance Policy
- Employee Assistance Program (EAP)
- World-class paid training program for you to learn the skills for long term career success.