Senior Data Analyst (Power BI / SQL)-[W2 ROLE]

Smarty, LLC
Charlotte, NC, United States
25 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours

Tech stack

Agile Methodology Business Analytics Applications Data Analysis Business Software Data Warehousing Dimensional Modeling Microsoft SQL Server Oracle (Applications) Power BI Standard Sql SQL Databases SQL Server Reporting Services
+5 more
SQL Server Analysis Services Freeform SQL Microsoft Power Automate Tools for Reporting Powerapps

Job description

We are seeking a Senior Data Analyst to join a dynamic team supporting enterprise reporting and business intelligence initiatives. The ideal candidate will have strong expertise in SQL, Power BI, Data Warehousing, SSRS, Power Apps, and Power Automate to develop reporting solutions, interactive dashboards, and data-driven insights that support business decision-making. Responsibilities

  • Design, develop, and maintain enterprise reports, dashboards, and analytical solutions.
  • Gather and analyze business requirements from stakeholders and translate them into technical solutions.
  • Write and optimize complex SQL queries against Oracle and SQL Server databases.
  • Develop interactive dashboards using Power BI Service and Power BI Desktop.
  • Build and maintain Paginated Reports using Power BI and SQL Server Reporting Services (SSRS).
  • Create advanced calculations and measures using DAX and MDX.
  • Develop business applications using Power Apps and automate workflows with Power Automate.
  • Query and analyze data from SQL Server Analysis Services (SSAS) Tabular and Multidimensional models.
  • Support and enhance enterprise data warehouse solutions.
  • Collaborate with Finance, Project Management, Resource Management, and IT teams to deliver reporting solutions.
  • Document reporting processes, data models, and warehouse structures.
  • Participate in testing, deployment, and production support activities.

Requirements

  • 5+ years of experience as a Data Analyst or Business Intelligence Analyst.
  • Strong hands-on experience with SQL (Oracle and/or SQL Server).
  • Experience developing reports and dashboards using Power BI.
  • Strong knowledge of DAX and MDX.
  • Experience with SQL Server Reporting Services (SSRS).
  • Experience developing solutions using Power Apps and Power Automate.
  • Experience working with SQL Server Analysis Services (SSAS).
  • Strong understanding of data warehousing concepts and dimensional modeling.
  • Excellent analytical, problem-solving, and communication skills.
  • Experience gathering business requirements and working directly with stakeholders.

Preferred Qualifications

  • Experience in the Energy or Utilities industry.
  • Knowledge of Finance or Project Management reporting.
  • Familiarity with Agile project environments.
  • Experience supporting enterprise reporting and analytics platforms.

Required Skills

  • SQL
  • Oracle
  • SQL Server
  • Power BI
  • DAX
  • MDX
  • SSRS
  • SSAS
  • Power Apps
  • Power Automate
  • Data Warehousing

About the company

Hayward Industries

  • Charlotte, NC Hayward Holdings Inc. (NYSE “HAYW”) is the largest manufacturer of residential swimming pool equipment in the world, with a significant presence in the commercial pool market that …

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

2:44 min

Integrating data analytics into the talent acquisition function

Kobi Kobi +1 · WWC 2025

4:06 min

Using ClickHouse as a foundation for fast analytics

Hellmar Becker Hellmar Becker · WWC Europe 2026

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

1:56 min

Creating immutable blockchain tables using standard SQL syntax

Wei Hu Wei Hu · WWC 2023

Videos

See all

Related articles

See all