Posted 2 days ago
Job id: a1Wcv000000Lz3hEAC
VSP – Data Warehouse/BI Developer 4 (797389)
North Chesterfield, Virginia
Physical Location
Enterprise Systems
Contract
Brooksource
-$60/hr
-k
Share This Job
Job Description:
Data Warehouse Developer
Hybrid Role (Richmond, VA)
Compensation: $48-52/hr (Max Vendor Rate: $85.73/hr)
ABOUT THE ROLE
The Virginia State Police (VSP) is seeking an experienced Data Warehouse Developer to support a critical Data Strategy initiative and help build a modern, enterprise-grade data platform. In this role, you will be responsible for designing, developing, and optimizing data pipelines and warehouse structures using AWS Glue, Snowflake, and Snowpipe. You will transform raw, disparate data into reliable, scalable, and well-governed datasets that power analytics, reporting, and operational decision-making across the agency. This position requires close collaboration with business stakeholders, subject matter experts, and technical teams to deliver robust data engineering solutions that meet the agency’s evolving needs.
WHAT YOU'LL DO
- Design, build, and maintain ETL/ELT pipelines using AWS Glue, including Glue Jobs, Workflows, Crawlers, and Catalog integration
- Develop and optimize Snowflake data models, schemas, and warehouse structures to support enterprise reporting and analytics
- Implement and manage Snowpipe for continuous data ingestion from structured and semi-structured sources
- Collaborate with internal and external teams to understand data requirements, source-system structures, and integration needs
- Build scalable, secure, and high-performance data ingestion and transformation processes aligned with best practices
- Perform data profiling, data quality assessments, and root-cause analysis for data issues across complex datasets
- Support data migration activities, including mapping, cleansing, validation, and reconciliation
- Develop and maintain comprehensive documentation for data pipelines, data models, and operational processes
- Work closely with business stakeholders, SMEs, and technical teams to translate requirements into robust data engineering solutions
- Ensure compliance with data governance, security, and privacy standards across all data assets
- Optimize Snowflake performance through clustering, partitioning, caching, and query tuning
- Support ad-hoc data engineering requests related to new integrations, data transformations, or enhancements
WHAT YOU BRING
- Proven experience as a Data Warehouse Developer, Data Engineer, or similar role
- Hands-on expertise with AWS Glue, including Glue Studio, Glue Jobs (PySpark/Python), Glue Catalog, and Glue Workflows
- Strong experience with Snowflake, including schema design, Snowflake SQL, performance tuning, and data sharing
- Practical experience implementing Snowpipe for automated data ingestion from cloud storage
- Strong SQL skills and experience working with large-scale relational and cloud-based databases
- Proficiency in Python for ETL/ELT development and automation
- Solid understanding of data modeling, data warehousing concepts, and ETL best practices
- Experience with data quality, data validation, and data reconciliation processes
- Ability to analyze complex data structures and troubleshoot data pipeline issues with precision
- Strong communication skills and ability to collaborate with cross-functional teams
- Proficiency with Microsoft Office tools, especially Excel, for data validation and documentation
- Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field
- Relevant certifications (AWS, Snowflake) are a plus
Disclaimer: Brooksource, Medasource, and Calculated Hire are part of the Eight Eleven Group family of companies and operate under Eight Eleven Group, LLC. All employees receive the same benefits, policies, and terms of employment.
EEO:
We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, ancestry, age, disability, genetic information, marital status, military or veteran status, citizenship, pregnancy (including childbirth, lactation, and related conditions), or any other protected status in accordance with applicable federal, state, and local laws.
Benefits & Perks:
Eight Eleven Group offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.
Pay Disclaimer:
The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
Share This Job
Apply For This Job
Related Jobs
Sorry, we couldn't find any jobs. Please try a different search.
About Us
Your need for talent is our reason for being. This driving mission has been at our core from the onset. When we started in 2000 at 811 Broad Ripple Avenue, we were a team of forward-thinking entrepreneurs determined to find a better way to connect the best and brightest talent with companies looking for future leaders. We still believe in this philosophy. Throughout the years, our passion, credibility, and grit have been the foundation and prowess of what is now Eight Eleven. Though our focus areas have continued to mindfully evolve, our unyielding commitment to relationships and our customers’ needs remain consistent and firmly rooted in our core values.