Overview
Hybrid1 time go to onsite in one month when required other wise fully remote
$40 - $50
Contract - W2
Contract - Independent
Contract - 12 Year(s)
No Travel Required
Skills
Agile
Analytical Skill
Analytics
Business Intelligence
Cloud Computing
Cloud Storage
Collaboration
Communication
Computer Science
Continuous Integration
Data Architecture
Data Governance
Data Integration
Data Warehouse
Decision-making
Data Management
ELT
Extract
Transform
Load
Information Systems
Data Science
Data Visualization
DevOps
Data Processing
Continuous Delivery
Microsoft Power BI
Microsoft SQL Server
SQL
Scrum
Software Development
Star Schema
Stored Procedures
Microsoft Azure
Job Details
Title: Data Warehouse/BI Developer 2 (763312)
Location: Richmond, VA 23219
Note: This is a remote position
Job 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.
- 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.
Required Skills
- At least 3 years Experience of hands-on experience designing, developing, and supporting enterprise data warehouse and business intelligence solutions.
- 3 years Experience in Strong proficiency with ETL/ELT tools such as SQL Server Integration Services (SSIS) and Azure Data Factory
- Experience working with cloud-based data platforms such as Azure Synapse Analytics or Microsoft Fabric.
- Proficiency in SQL development, including writing complex queries, stored procedures, views, and optimizing performance for large datasets.
- Experience building and maintaining star schema data models, fact and dimension tables, and metadata documentation.
- Experience with data visualization and reporting tools, especially Power BI Service.
- Strong understanding of data governance, quality, and lineage principles.
- Experience integrating data from diverse structured and semi-structured sources including relational databases, flat files, APIs, and cloud storage.
- Familiarity with source control and DevOps practices, including CI/CD pipelines for data integration workflows.
- Strong analytical and troubleshooting skills for diagnosing data anomalies, ETL failures, and performance bottlenecks.
- Demonstrated ability to collaborate with business stakeholders to translate requirements into technical specifications and data pipelines.
- Strong communication skills, both written and verbal, for documenting data models, workflows, and data contracts.
- Experience working in Agile/Scrum or DevOps environments.
- Microsoft certifications such as Azure Data Engineer Associate (DP-203) or SQL Server certifications are highly desirable.
- A bachelor s degree in computer science, information systems, data science, or a related field is highly desirable.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.