DataJobs.io
← Back to all jobs

Job Description

Work onsite in Raleigh, NC as a mid-level Data Scientist supporting a client engagement focused on modern enterprise analytics. This contract role centers on building and improving enterprise data pipelines, data warehouses, and analytics solutions in Microsoft Azure, while integrating AI and machine learning insights for reporting and predictive analytics.

What you will do

  • Design, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions on Microsoft Azure.
  • Use Azure Synapse Analytics, Microsoft Fabric, and Azure AI services to transform complex data into business insights and advanced analytics.
  • Design, build, and maintain enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or PL/SQL procedures.
  • Manage and optimize Azure Synapse Analytics across SQL and Spark pools, and support Microsoft Fabric Lakehouse workloads.
  • Develop, test, and tune SQL and PL/SQL artifacts including stored procedures, packages, and functions for data integration.
  • Collaborate with business users to define analytical goals and create Power BI-ready datasets.
  • Integrate AI and machine learning insights using Azure Machine Learning and Azure OpenAI Service for reporting and predictive analytics.
  • Enforce data governance, quality, and security with Microsoft Purview and Microsoft Entra ID.
  • Build cross-functional reporting, dashboards, and predictive analytics models.

Key skills and experience

  • Enterprise data analytics and engineering experience, including 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, RBAC, and cloud security (3 Years).
  • Familiarity with Power BI semantic models and dataflows (3 Years).
  • Ability to organize, prioritize, and follow complex technical procedures (7 Years).
  • Experience working in Agile development (Scrum, Kanban, or SAFe) (3 Years).
  • Knowledge of Azure OpenAI or generative AI data integration (3 Years).

Tools you will work with

Microsoft Azure, Azure Synapse Analytics, Microsoft Fabric, Azure AI services, Azure Data Factory, Synapse Pipelines, PL/SQL, SQL, Azure Machine Learning, Azure OpenAI Service, Microsoft Purview, Microsoft Entra ID, RBAC, PySpark, Python, Scala, Power BI, Power BI semantic models, Power BI dataflows, ETL/ELT, and stored procedures, packages, and functions, including Spark pools and Microsoft Fabric Lakehouse.

Similar Jobs