NC Fast Data Scientist- Mid Level

CCS Global Tech; Raleigh (NC); Presencial; USD 120 000 - 150 000; Tempo integral

Resumo da oferta

CCS Global Tech is a rapidly growing IT company delivering Microsoft-based solutions and analytics capabilities. This role focuses on designing and maintaining robust ETL/ELT pipelines with Azure tools, building governance, and enabling data-driven decisions with Power BI-ready datasets.

You will use Azure Synapse, Data Factory, and SQL/PLSQL to optimize data warehousing, collaborate with business users, and integrate AI insights via Azure OpenAI Service, while ensuring security with Entra ID

Qualificações

• 7+ years of enterprise data analytics, engineering and ETL workflow design.
• 4+ years in Azure Synapse Analytics, Azure Data Factory and cloud data warehousing.
• 7+ years of advanced SQL and PL/SQL with optimization and indexing.
• 6+ years hands-on PySpark, Python or Scala.
• 4+ years data modeling, performance tuning and Azure cost optimization.
• 3+ years Microsoft Entra ID, RBAC and cloud security knowledge.
• 3+ years familiarity with Power BI semantic models and dataflows.
• 7+ years ability to organize, prioritize and follow complex technical procedures.
• 3+ years Experience with Agile (Scrum, Kanban, SAFe).
• 3 years knowledge of Azure OpenAI or generative AI data integration.

Responsabilidades

• Design, build, and maintain robust enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or PL/SQL.
• 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.
• 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 Purview and Entra ID.
• Build cross-functional reporting, dashboards, and predictive analytics models

Conhecimentos

ETL workflows

Azure Synapse

SQL & PL/SQL

PySpark/Python/Scala

Data modeling

RBAC & security

Power BI

Attention to detail

Agile methodologies

Azure OpenAI / Generative AI

Ferramentas

Azure Data Factory

Azure Synapse

Microsoft Purview

Microsoft Entra ID

Azure OpenAI Service

Descrição da oferta de emprego

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.

Roles/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

Mandatory Skills:

1. Experience in enterprise data analytics, engineering, and designing complex ETL workflows. 7 Years
2. Expertise in Azure Synapse Analytics, Azure Data Factory, and cloud data warehousing 4 years
3. Advanced SQL and PL/SQL skills, including query optimization, performance tuning, and indexing strategies 7 Years
4. Hands-on experience with PySpark, Python, or Scala- 6 years
5. Experience with data modeling, performance tuning, and cost optimization in Azure- 4 years
6. Strong knowledge of Microsoft Entra ID, role-based access control (RBAC), and cloud security 3 years
7. Familiarity with Power BI semantic models and dataflows 3 years
8. Ability to organize, prioritize, and follow complex and/or detailed technical procedures 7 Years
9. Experience with Agile (Scrum, Kanban, or SAFe) development 3 years

Desirable Skills:

1. Knowledge of Azure OpenAI or generative AI data integration 3 years