Elect - Data Warehouse/BI Developer 2

Short Description:
The Virginia Department of Elections is seeking an Azure
Business Intelligence Developer with a minimum of 3-5 years' experience to work
with an existing software development team on an ongoing project.
Max vendor rate

Complete Description:
This position will work in an Agile/Scrum development
environment with an existing data and analytics team to design, develop, test,
and support solutions that enable data-driven decision-making across the agency.
The candidate will lead and contribute to the design and implementation of
scalable data warehouse and business intelligence systems, applying principles
and techniques of data architecture, integration, and analytics. The position
requires experience with cloud-native data warehousing platforms, ETL
development, and a strong understanding of enterprise data management best
practices.

Skills:
SkillRequired / DesiredAmountof ExperienceExpertise RatingMoveAt least 3 years of hands-on experience designing, developing, and supporting enterprise data warehouse and business intelligence solutions.Required3YearsStrong proficiency with ETL/ELT tools such as SQL Server Integration Services (SSIS) and Azure Data FactoryRequired3YearsExperience working with cloud-based data platforms such as Azure Synapse Analytics or Microsoft Fabric.Required3YearsProficiency in SQL development, including writing complex queries, stored procedures, views, and optimizing performance for large datasets.Required3YearsExperience building and maintaining star schema data models, fact and dimension tables, and metadata documentation.Required3YearsExperience with data visualization and reporting tools, especially Power BI Service.Required3YearsStrong understanding of data governance, quality, and lineage principles.Required3YearsExperience integrating data from diverse structured and semi-structured sources including relational databases, flat files, APIs, and cloud storage.Required3YearsFamiliarity with source control and DevOps practices, including CI/CD pipelines for data integration workflows.Required3YearsStrong analytical and troubleshooting skills for diagnosing data anomalies, ETL failures, and performance bottlenecks.Required3YearsDemonstrated ability to collaborate with business stakeholders to translate requirements into technical specifications and data pipelines.Required3YearsStrong communication skills, both written and verbal, for documenting data models, workflows, and data contracts.Required3YearsExperience working in Agile/Scrum or DevOps environments.Required3YearsMicrosoft certifications such as Azure Data Engineer Associate (DP-203) or SQL Server certifications are highly desirable.Required3YearsBachelors degree in Computer Science, Information Systems, Data Science, or a related field is highly desirable.Highly desired3Years

Global Candidate Requirements:
Global Candidate Requirements
Skill
Required / Desired
Amount
of Experience

Questions:
Question 1
Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment?
Question 2
Please list candidate's email address.
Question 3
What city and state is your candidate currently located?

Agency Interview Type:
Web Cam Interview Only

Work Arrangement:
Remote