Junior Data Analyst - Azure Databricks

Junior Data Analyst - Azure Databricks
Address: 1020 Birch Ridge Drive, Raleigh, NC 27610
Work Arrangement: Hybrid (On-site required up to 3 days/week)
Engagement Type: Contract
Start Date: 08/01/2025
End Date: 07/31/2026

Local Candidates Only: All applicants must currently reside in the Raleigh/Durham/Chapel Hill, NC area. On-site presence is mandatory on Day 1 to collect equipment, with up to 3 days/week on-site required throughout the engagement


The North Carolina Department of Transportation (NCDOT) is seeking a Junior Data Analyst with hands-on experience in Azure Databricks , PySpark , and Power BI . The selected candidate will support enterprise data initiatives through building aggregations, dashboards, and reporting solutions. This role requires strong analytical capabilities and the ability to translate business needs into scalable, data-driven solutions.
You will work closely with technical leads, data engineers, and cross-functional stakeholders to deliver insight-driven data products and reporting tools.

Key Responsibilities:

• Perform data analysis , data mapping , and data quality assurance using Azure Databricks and related tools
• Write efficient Spark SQL and Python (PySpark) code to analyze large datasets
• Collaborate with data engineers and business users to define, design, and implement data models and visualizations
• Design and develop Power BI and Databricks native dashboards to present actionable insights
• Develop Gold-layer data products to support dashboards, APIs, and user interfaces
• Create and maintain documentation for data models , pipelines , dashboards , and reporting workflows
• Apply dimensional modeling , entity-relationship modeling , and data normalization/denormalization
• Conduct statistical analyses and use ML algorithms to uncover trends and support decision-making (preferred)
• Support project planning, design discussions, and change management documentation

Minimum Qualifications:

• 3+ years of hands-on experience with Azure Databricks , especially in enterprise environments
• Proficient in SQL and Python (PySpark) for querying, transforming, and analyzing data
• Experience with data modeling techniques: dimensional modeling , ER modeling , Data Vault , etc.
• Ability to collaborate across teams and translate complex data requirements into technical and visual solutions
• Strong verbal and written communication skills

Preferred Qualifications:

• Experience with data science concepts , including machine learning algorithms and statistical analysis
• Databricks Data Analyst Associate Certification
• Background in state/local government or public sector analytics projects

Recruiter Submission Template -

Full Name:
Degree Major with University & Completion Year:
Total experience as Junior Data Analyst - Azure Databricks?
Experience working in the governmental sector (local, state, or federal)?
Motivation for Interest in This Position:
Contact Number:
Email ID:
LinkedIn Profile URL:
Full Address (Street, City, State, Zip):
Notice Period (in weeks):
Current Work Authorization Status (e.g., US Citizen, Green Card, H1B, etc.):
Expected Hourly Rates:
Is it W2 / C2C, If C2C, May I know your corporation Name?
Are you ready to relocate on your own expenses and work Raleigh, NC - Hybrid?


Skills : Skill Required / Desired mount of Experience Candidate Experience Hands-on experience designing, deploying, and managing Azure Databricks architecture in enterprise environments Required 3 Strong understanding of data science concepts, including statistical learning and machine learning algorithms Desired 3 Proficiency in SQL and Python for developing queries, data transformations, and interactive dashboards Required 3 Experience with techniques like dimensional modeling, entity-relationship modeling, normalization/denormalization, or Data Vault Required 3 Excellent communication skills with proven ability to collaborate with cross-functional teams and translate business needs into technical solutions Required 5 Databricks Data Analyst Associate Certification Desired