DataWarehouse Developer

MJDP Resources - West Chester, PA


The Data Warehouse Developer will responsible for maintaining and expanding our Microsoft SQL Server-based data warehouse solution. This includes importing data from various external data sources through an SSIS ETL process into staging databases, integrating those data sources into existing dimension/fact load process and SSAS OLAP cube, monitoring the ETL processes and resolving errors, administering the data warehouse server and databases in terms of performance and backups, working with business stakeholders to create SSRS reports and dashboards, and providing direct support to users of this reporting infrastructure.

Primary Responsibilities

- Create SSIS ETL packages to import data from source systems into staging databases

- Adjust existing T-SQL code for dimension and fact loads to add/adjust measures and dimensions/attributes.

- Create and modify database objects, such as Stored procedures, views, tables, functions, using T-SQL code.

- Work with customers to develop new report requirements, changes to existing reports, and identify reporting errors.

- Perform QA tests to ensure data integrity and quality.

- Collaborate with internal stakeholders on quality assurance and customer acceptance testing

- Use Azure DevOps for source code management, feature/functionality documentation, task management, and bug/issue tracking/reporting.


  • Bachelor’s degree in computer science, data science, or related field; or, comparable training or certifications.
  • Experience working on at least one enterprise data warehouse project.
  • Ability to gather and analyze the reporting requirements of business users.
  • 4+ years’ experience writing T-SQL Server Code.
  • 2+ years’ experience developing SSIS/ETL processes.
  • 2+ years’ experience developing SSRS Reports.
  • 2+ years’ experience administering SQL Server databases (performance, backups)
  • 2+ years working with Excel Pivot tables
  • 1+ years’ experience programming SSAS multidimensional OLAP cubes
  • Deep knowledge & understanding of database design, setup, and maintenance.
  • Ability to analyze and understand database models and structure of proprietary source systems.
  • Familiarity implementing PowerBI reports & dashboards

Posted On: Wednesday, September 8, 2021

Apply to this job