Highlights
Required 7 Years Expertise in Azure Synapse Analytics, Azure Data Factory, and cloud data warehousing Required 4 Years Advanced SQL and PL/SQL skills, including query optimization, performance tuning, and indexing strategies Required 7 Years Hands-on experience with PySpark, Python, or Scala Required 6 Years Experience with data modeling, performance tuning, and cost optimization in Azure Required 4 Years Strong knowledge of Microsoft Entra ID, role-based access control (RBAC), and cloud security Required 3 Years Familiarity with Power BI semantic models and dataflows Required 3 Years Knowledge of Azure OpenAI or generative AI data integration Highly desired 3 Years Ability to organize, prioritize, and follow complex and/or detailed technical procedures Required 7 Years Experience with Agile (Scrum, Kanban, or SAFe) development Required 3 Years Description Questions Answers Question 1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. Question 12 Please provide candidate's current location (City and State), NOT a Yes or No response Question 13 Please list all the certifications candidate has around relational databases including ORACLE, SQL Server etc.
Numbers & Facts
| Location | Raleigh, NC |
| Industry | Computer/IT Services |
| Company Size | 100 to 499 employees |
| Year Founded | 1997 |
| Website | https://www.tscti.com/careers-0 |
Description
Client requires the services of a Senior Data Analyst who will 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.
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.
| Skills | Required | Required Experience | Candidate Experience | Last Used |
| Experience in enterprise data analytics, engineering, and designing complex ETL workflows. | Required | 7 | Years | |
| Expertise in Azure Synapse Analytics, Azure Data Factory, and cloud data warehousing | Required | 4 | Years | |
| Advanced SQL and PL/SQL skills, including query optimization, performance tuning, and indexing strategies | Required | 7 | Years | |
| Hands-on experience with PySpark, Python, or Scala | Required | 6 | Years | |
| Experience with data modeling, performance tuning, and cost optimization in Azure | Required | 4 | Years | |
| Strong knowledge of Microsoft Entra ID, role-based access control (RBAC), and cloud security | Required | 3 | Years | |
| Familiarity with Power BI semantic models and dataflows | Required | 3 | Years | |
| Knowledge of Azure OpenAI or generative AI data integration | Highly desired | 3 | Years | |
| Ability to organize, prioritize, and follow complex and/or detailed technical procedures | Required | 7 | Years | |
| Experience with Agile (Scrum, Kanban, or SAFe) development | Required | 3 | Years |
| Description | Questions | Answers |
| Question 1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement? | |
| Question 2 | All work must be completed on-site. Do you agree to this requirement? | |
| Question 3 | Your candidate must be able to attend an in-person interview. Do you agree to this requirement? | |
| Question 4 | What is your candidate's email address? | |
| Question 5 | How soon can your candidate start if selected for this opportunity? | |
| Question 10 | Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the Vendor to adhere to any applicable compensation laws including payment for overtime hours. Do you agree to this requirement? | |
| Question 11 | Have you thoroughly validated, and attest to the accuracy of, the credentials listed throughout your candidate's VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440? | |
| Question 12 | Please provide candidate's current location (City and State), NOT a Yes or No response | |
| Question 13 | Please list all the certifications candidate has around relational databases including ORACLE, SQL Server etc. Azure and other cloud services. |
About Company
22nd Century Technologies, Inc., is one of the fastest growing IT Service Integrator and Workforce Solution companies in the United States. Founded in 1997, 22nd Century Technologies is a Certified National Minority Business Enterprise with 6,000+ people including 600+ Cyber SMEs nationwide supporting our customers in all 50 states, Canada, and Mexico. With HQs in Somerset, NJ and Mclean, VA, 22nd Century has 14 offices throughout the United States. As part of our unrelenting focus on quality and compliance, 22nd Century Technologies’ delivery is based on Certified Matured Processes including CMMI L3 Dev & SVC, ISO 20000, ISO 27001, and ISO 9001 quality processes. With a strong focus on the public sector, 22nd Century currently holds government contracts with 14 out of 15 Federal Executive agencies including DoD, 37 other Federal agencies, 50 States, 115+ Local agencies, and 37 School Districts. In the last three years, we have expanded our services to Fortune 500 and other commercial clients and currently support 80+ commercial clients.
Recognized among “Best Company to Work For” by Forbes, 22nd Century Technologies, Inc., consistently exceeds our clients’ expectations by focusing on their absolute satisfaction with jobs while keeping our employees motivated.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
Similar Job Searches
Research Manager Jobs in Raleigh, NCScience Manager Jobs in Raleigh, NCClinical Research Manager Jobs in Raleigh, NCEnvironmental Manager Jobs in Raleigh, NCDirector Of Research And Development Jobs in Raleigh, NCDirector Of Research Jobs in Raleigh, NCScience Director Jobs in Raleigh, NCResearch Specialist Jobs in Raleigh, NCData Scientist Jobs in Morrisville, NCData Scientist Jobs in Durham, NC