Data Warehouse/BI Developer Job at Cyber Resource, Richmond, VA

dGFWVm1LTnlwUWpQT3VNN0pWeVFubm5wRGc9PQ==
  • Cyber Resource
  • Richmond, VA

Job Description

Description:

A Data Warehouse Developer who can self‑manage, partner with BSAs and PMs, and translate business needs into actionable, analytics‑ready data solutions. This role requires strong data engineering skills in SQL Server, data modeling using Kimball methodologies, and hands‑on development of data marts, SSIS ETL pipelines, and data flow design documentation. The developer must be able to deep-dive profile source systems, design and implement database projects in Visual Studio, manage code in GIT, and validate data accuracy through testing. Experience building dashboards is helpful but secondary.

This role is ideal for someone who thrives in a self‑directed environment, communicates clearly with both technical and non‑technical partners, and takes pride in delivering clean, well‑modeled, well‑tested data.

Key Responsibilities:

  • Data profiling — Analyze and understand source systems to determine data availability, quality, and extraction logic.
  • Data modeling — Design dimensional models and star schemas to support analytics and reporting needs.
  • Data flow design — Produce clear, detailed mapping documents that translate business rules into technical specifications.
  • SQL Server data mart development — Build and optimize tables, views, stored procedures, and indexes.
  • Visual Studio database projects — Create and maintain database projects for versioned, repeatable deployments.
  • GIT source control — Manage code changes, branching, and collaboration workflows.
  • SSIS ETL development — Build, schedule, and monitor ETL packages to load data marts reliably and efficiently.
  • Data validation testing — Ensure accuracy, completeness, and alignment with business rules.
  • Dashboard/report creation (nice‑to‑have) — Build basic dashboards or visualizations using tools such as Power BI or Tableau.
  • Skill

    Required / Desired

    Data profiling Required 5 Years
    Data modeling Required 5 Years
    SQL Server data mart development Required 5 Years
    SSIS ETL development Required 5 Years
    Source Control Required 3 Years
    Dashboard/report creation Desired 3 Years

Job Tags

Similar Jobs

Solar Pros

Solar Sales Representative - Austin Job at Solar Pros

 ...Ready to build a career, not just a job, right here in Austin, TX? At Solar Pros , we help Austin homeowners cut energy costs while supporting cleaner, more reliable energy. With over 10 years of proven leadership in the solar industry, we know how to train motivated... 

Confidential

Freelance Writer Job at Confidential

 ...journalist/content writer with experience writing real estate features or business spotlights to support advertising sections in the newspaper. AP Style experience is preferred. We will only consider writers currently living in the Bay Area. Send your cover letter, resume... 

University of Cincinnati

Visiting Assistant Professor, Mathematical Sciences, College of Arts and Sciences Job at University of Cincinnati

 ...Department of Mathematical Sciences is dedicated to excellence in both research and teaching. The department has a graduate program offering...  ...UC prioritizes work-life balance with a generous time-off policy, including: Vacation and sick time pro-rated by FTE. Includes... 

SGS Consulting

Business Analyst Jr Job at SGS Consulting

Job Responsibilities: Analyze data related to the complaint management process and identify trends, issues, and improvement opportunities. Use Excel and other Microsoft tools to organize data, perform calculations, create reports, and support decision-making. ...

Hampton Bar Harbor

Laundry Attendant Job at Hampton Bar Harbor

 ...Join our 'Heart of the House' team you are the key to keeping our hotel clean, fresh, and sparkling every day! A Hilton Lighthouse Award winning property, we are the only seasonal Hampton hotel in the Hilton brand portfolio, open each year from May through...