Job Title: Data Scientist
Location: Raleigh, NC
Job Type: W2 Contract
Interview Process: In-person only
***Only qualified Data Scientist candidates located in the Raleigh, NC area will be considered due to the position requiring an on-site presence***
Required Skills:
Experience in enterprise data analytics, engineering, and designing complex ETL workflows (7 Years)
Expertise in Azure Synapse Analytics, Azure Data Factory, and cloud data warehousing (4 Years)
Advanced SQL and PL/SQL skills, including query optimization, performance tuning, and indexing strategies (7 Years)
Hands-on experience with PySpark, Python, or Scala (6 Years)
Experience with data modeling, performance tuning, and cost optimization in Azure (4 Years)
Strong knowledge of Microsoft Entra ID, role-based access control (RBAC), and cloud security (3 Years)
Familiarity with Power BI semantic models and dataflows (3 Years)
Ability to organize, prioritize, and follow complex and/or detailed technical procedures (7 Years)
Experience with Agile (Scrum, Kanban, or SAFe) development (3 Years)
Preferred Skills:
Knowledge of Azure OpenAI or generative AI data integration (3 Years)
The client requires a Senior Data Analyst to help design, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions within Microsoft Azure. This role transforms complex data into business insights and drives advanced analytics using Azure Synapse Analytics, Microsoft Fabric, and Azure AI services
Job Responsibilities:
Design, build, and maintain robust 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
Collaborate 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 via Microsoft Purview and Microsoft Entra ID
Build cross-functional reporting, dashboards, and predictive analytics models