Data Scientist (Azure Synapse / Power BI)
Job Description
We are seeking a mid-level Data Scientist to support an enterprise analytics and data organization. You will design, manage and optimize enterprise data pipelines, warehouses and analytics in Microsoft Azure. This role is onsite in Raleigh, NC, and open to local candidates in the Raleigh area only. The interview is in person, and the shift is 8 AM to 5 PM. Requirements: - 7+ years in enterprise data analytics or engineering with complex ETL workflows - 7+ years of advanced SQL and PL/SQL, including query optimization, tuning and indexing - 6+ years with PySpark, Python or Scala - 4+ years with Azure Synapse Analytics, Azure Data Factory and cloud data warehousing - 4+ years of data modeling, performance tuning and cost optimization in Azure - 3+ years with Microsoft Entra ID, RBAC and cloud security - 3+ years with Power BI semantic models and dataflows - 3+ years working in Agile (Scrum, Kanban or SAFe) - Nice to have: Azure OpenAI or generative AI data integration Responsibilities: - Build ETL and ELT pipelines with Azure Data Factory, Synapse Pipelines and PL/SQL - Manage Synapse SQL and Spark pools and the Microsoft Fabric Lakehouse - Write and tune SQL and PL/SQL for performance - Build Power BI ready datasets alongside business users - Bring Azure ML and Azure OpenAI insights into the analytics - Enforce governance through Microsoft Purview and Entra ID - Build dashboards and predictive models