[Remote] Data Analyst- Data Warehouse Analytics and BI
Note: The job is a remote job and is open to candidates in USA. OWL Services is the premier sales, installation, program management and service provider to various sectors across the U.S. They are seeking a Data Analyst to join their Data Warehouse & BI team to enhance operational impact through report development and model expansion while ensuring the reliability of their analytics stack.
Responsibilities
- 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
Skills
- 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
- 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.
Company Overview
Company H1B Sponsorship