Sign upLog in

Data Warehouse Developer

OP Consulting Group LLC

Richmond, VA

Apply
JOB DETAILS
SKILLS
Change Management, Data Analysis, Data Mart, Data Modeling, Data Profiling, Data Quality, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Dimensional Modeling, Git, Loading/Unloading, Microsoft SQL Server, Microsoft Visual Studio, Power BI, Precision Testing, Reporting Dashboards, SQL Server Integration Services (SSIS), Source Code/Configuration Management (SCM), Star Schema, Stored Procedures, Tableau, Validation Testing
LOCATION
Richmond, VA
POSTED
3 days ago

Join our team as a Data Warehouse Developer where you will have the opportunity to work on-site in the vibrant city of Richmond. This role is perfect for those who are passionate about data engineering and enjoy collaborating with various stakeholders to develop analytics-ready data solutions.

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.

Required Skills:

  • Data profiling - 5 years of experience
  • Data modeling - 5 years of experience
  • SQL Server data mart development - 5 years of experience
  • SSIS ETL development - 5 years of experience
  • Source Control - 3 years of experience
  • Dashboard/report creation - Desired, 3 years of experience

Global Candidate Requirements:

  • Must physically reside within the US for the duration of the assignment.
  • Available for in-person interviews and on-site work.

Questions:

  • Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment?
  • What is your candidate’s email address?
  • What city and state is your candidate currently located?
  • Is your candidate available to interview and work on-site?

About the Company

O

OP Consulting Group LLC

Resume Resources

Free Resume TemplatesFree Resume Builder