Data Scientist- Mid Level

Allitsolutions LLC; Raleigh (NC); Presencial; USD 83.000 - 124.000; Jornada completa

Descripción de la vacante

All IT Solutions LLC in Raleigh, NC seeks a Data Scientist- Mid Level to join a client engagement. The role is on-site in Raleigh with responsibilities spanning data pipelines, data warehousing, and analytics using Azure Synapse, Fabric, and AI services.

You will design and optimize ETL/ELT pipelines, develop SQL/PLSQL scripts, and collaborate with stakeholders to deliver Power BI-ready datasets and predictive analytics. Familiarity with Azure OpenAI and governance tools is beneficial.

Responsabilidades

• Design, build, and maintain robust enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or PL/SQL procedures
• 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

Descripción del empleo

Data Scientist- Mid LevelAll IT SolutionsUnited States · Raleigh, NC, USAWorkplace Type — On-siteEmployment Type — ContractWe are currently seeking a qualified Data Scientist- Mid Level to support this engagement. Please review the complete requirements, work location, employment type, and screening questions before applying. Candidates whose experience closely matches the position will be contacted directly by the AIS recruiting team.Job SummaryAll IT Solutions is seeking a Data Scientist- Mid Level to join a client engagement.ResponsibilitiesThe 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 servicesDesign, build, and maintain robust enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or PL/SQL proceduresManage and optimize Azure Synapse Analytics (SQL and Spark pools) and Microsoft Fabric LakehouseDevelop, test, and tune complex SQL and PL/SQL scripts, stored procedures, packages, and functions to support data integrationCollaborate with business users to define analytical goals and build Power BI-ready datasetsIntegrate AI and machine learning insights using Azure Machine Learning and Azure OpenAI ServiceEnforce data governance, quality, and security via Microsoft Purview and Microsoft Entra IDBuild cross-functional reporting, dashboards, and predictive analytics modelsRequired QualificationsExperience 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)Knowledge of Azure OpenAI or generative AI data integration (3 Years)ABOUT ALL IT SOLUTIONS LLCHeadquartered in Mount Laurel, New Jersey, All IT Solutions LLC is a technology and workforce solutions company serving government and commercial organizations throughout the United States. AIS provides IT staffing and staff augmentation, cybersecurity, IT consulting, custom software development, cloud services, data engineering, artificial intelligence, application development, and related technology solutions.AIS is an NMSDC/EMSDC-certified Minority Business Enterprise and an NYC Department of Small Business Services-certified M/WBE. We participate in E-Verify and are committed to maintaining professional, transparent, and compliant hiring practices.EQUAL EMPLOYMENT OPPORTUNITYAll IT Solutions LLC is an equal opportunity employer. Employment decisions are made based on qualifications, merit, performance, and legitimate business requirements without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, military or veteran status, or any other characteristic protected by applicable federal, state, or local law.Reasonable accommodations are available to qualified applicants with disabilities during the application and interview process.RECRUITMENT NOTICEAll IT Solutions LLC is a staffing and technology services company and may receive fees or compensation from client organizations for recruiting, staffing, placement, or workforce services. Candidates are never charged an application, recruitment, placement, or interview fee by All IT Solutions LLC.Any commercial rates, fees, or staffing arrangements are between All IT Solutions LLC and its clients and do not require payment from the candidate.Official recruiting communications will come from an authorized All IT Solutions representative or an @allitsolutions.us email address.ApplyApply Now: https://careers.allitsolutions.net/jobs/data-scientist-mid-level-2026-c9e92b9a/apply