> Markdown version of [/jobs/ext/1332584-senior-data-analyst-power-bi-sql-w2-role](https://www.wearedevelopers.com/jobs/ext/1332584-senior-data-analyst-power-bi-sql-w2-role). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

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

- **Company:** Smarty, LLC
- **Location:** Charlotte, NC, United States
- **Experience:** Expert
- **Contract:** Temporary to permanent
- **Skills:** 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, SQL Server Analysis Services, Freeform SQL, Microsoft Power Automate, Tools for Reporting, Powerapps
- **Published:** July 18, 2026
- **Apply:** https://www.careerjet.com/jobad/us92863b576ceb30222f24e30daaa6f61a

## About the Role

* 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

## 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.


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)
- [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)