Data Analyst Data Warehouse Analytics and BI
WFA Digital Insight
As the demand for data-driven insights continues to surge, skilled data analysts are in high demand. With a 25% growth in job postings over the past year, this role is an exciting opportunity for professionals to make a tangible impact. OWL Services, a leading provider of sales, installation, and service solutions, is looking for a Data Analyst to join their team. With a strong focus on report development, model expansion, and data reliability, this position requires a unique blend of technical expertise and business acumen. Candidates should be prepared to navigate complex data systems and reconcile disparate source-system definitions to drive business growth.
Job Description
About the Role
The Data Analyst position at OWL Services is a hands-on role that requires a deep understanding of data analysis, reporting, and business operations. As a key member of the Data Warehouse & BI team, you will be responsible for developing, maintaining, and extending Power BI reports, dashboards, and semantic models to drive business insights. You will work closely with stakeholders across the organization to elicit requirements, understand operational context, and translate business questions into reliable reporting.The ideal candidate will have a strong background in data analysis, with expertise in SQL, Power BI, and data modeling. You will be responsible for reconciling disparate source-system definitions, setting up data in a scalable and consumable way, and partnering with stakeholders to surface findings, anomalies, and improvement opportunities.
OWL Services is a premier sales, installation, and service provider with a strong reputation for customer service. With 33 offices and distribution centers across the US, the company offers a dynamic and supportive work environment that encourages collaboration and innovation.
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 a scalable and consumable way to enable the organization to be most well-suited for 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
What We Are Looking For
- 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, 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 and maintain relationships with stakeholders
Nice to Have
- Experience with dbt, Fivetran, and Power Apps
- Knowledge of data governance and data quality best practices
- Certification in data analysis or a related field
Benefits and Perks
- Competitive salary and benefits package
- Opportunity to work with a leading provider of sales, installation, and service solutions
- Collaborative and dynamic work environment
- Professional development and growth opportunities
- Flexible work arrangements and remote work options
- Access to cutting-edge tools and technologies
- Recognition and reward for outstanding performance
How to Stand Out
- Develop a strong portfolio of your data analysis and visualization work to showcase your skills to potential employers
- Familiarize yourself with the latest data analysis tools and technologies, including SQL, Power BI, and cloud data warehouses
- Practice communicating complex data insights to non-technical stakeholders to improve your interpersonal skills
- Be prepared to discuss your experience with data modeling, data governance, and data quality best practices
- Research the company and role to understand the specific challenges and opportunities you will face as a Data Analyst
- Prepare to discuss your experience with dbt, Fivetran, and Power Apps, and how you have applied these tools in previous roles
This is a remote position listed on WFA Digital, the platform for professionals who work from anywhere. Browse more remote jobs across all categories.