Job Details

Vector (1)

Back To Results
  • Posted Date Icon (2)

    Posted 3 days ago

  • Job Number Icon

    Job ID: JN -032026-566065

VSP – Data Warehouse/BI Developer 4 (797389)

  • City State Location Icon

    North Chesterfield, Virginia

  • Job Type Icon (2)

    Contract

  • Remote Option Icon (2)

    Physical Location

  • Job Category Icon (1)

    Enterprise Systems

  • Salary Icon (2)

    60/hr

  • Salary Icon (2)

    -

Apply Now

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:
Brooksource 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.

Apply For This Job

Related Jobs

Sorry, we couldn't find any jobs. Please try a different search.

About Us

Job-Details-About-Us-Image (2)

Beyond The Expected

At Brooksource, relationships are the foundation of everything we do. Since 2000, we’ve built lasting partnerships with clients, consultants, and internal teams to deliver an exceptional experience across every engagement. As a trusted IT and Engineering services provider, Brooksource supports Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our proprietary Workforce Transformation program. Whether you're hiring for software development, cloud computing, cybersecurity, data analytics, or enterprise IT, our customized staffing solutions are designed to align with your company’s unique goals, culture, and technology stack. We offer flexible hiring models, including contract, contract-to-hire, and direct placement to meet your evolving business needs.

We are a certified partner of leading platforms, including Salesforce, AWS, Microsoft, and Google Cloud, enabling us to deliver scalable, end-to-end technology solutions. With a growing national footprint, Brooksource is redefining expectations in IT consulting, engineering services, and technology workforce solutions.