Maddisoft has the following immediate opportunity, let us know if you or someone you know would be interested. Send in your resume ASAP. - U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. Send in resume along with LinkedIn profile without which applications will not be considered. Call us NOW! ***Visa sponsorship is available for this position.
Job Title: Senior Data Analyst (Azure Data Engineering and Analytics)
Location: Raleigh, NC- Hybrid/In person Interview
About the Role
We are seeking a Senior Data Analyst to help a public-sector client design, manage and optimize enterprise data pipelines, data warehouses and analytics solutions within Microsoft Azure. You will turn complex data into business insights and drive advanced analytics using Azure Synapse Analytics, Microsoft Fabric and Azure AI services.
Key Responsibilities
- Design, build and maintain enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines or PL/SQL procedures
- Manage and optimize Azure Synapse Analytics (SQL and Spark pools) and Microsoft Fabric Lakehouse
- Develop, test and tune complex SQL and PL/SQL scripts, stored procedures, packages and functions to support data integration
- Work with business users to define analytical goals and build Power BI-ready datasets
- Integrate AI and machine learning insights using Azure Machine Learning and Azure OpenAI Service
- Enforce data governance, quality and security using Microsoft Purview and Microsoft Entra ID
- Build cross-functional reporting, dashboards and predictive analytics models
Required Skills and Experience
|
Skill
|
Requirement
|
Years
|
|
Enterprise data analytics, engineering and designing complex ETL workflows
|
Required
|
7
|
|
Azure Synapse Analytics, Azure Data Factory and cloud data warehousing
|
Required
|
4
|
|
Advanced SQL and PL/SQL, including query optimization, performance tuning and indexing strategies
|
Required
|
7
|
|
Hands-on PySpark, Python or Scala
|
Required
|
6
|
|
Data modeling, performance tuning and cost optimization in Azure
|
Required
|
4
|
|
Microsoft Entra ID, role-based access control (RBAC) and cloud security
|
Required
|
3
|
|
Power BI semantic models and dataflows
|
Required
|
3
|
|
Azure OpenAI or generative AI data integrati
|