SQL Server Datawarehouse Developer (US Remote)

Make Corporation

SQL Server Datawarehouse Developer

JP-AA08

Duration: 6-12 Months+

Location : 100% remote (or onsite in Downtown Chicago, if preferred)

This role will involve new database development, ETL development in SSIS, data maintenance and hygiene, data integration, Upgrades, migrations, optimization/optimization of existing databases and Data Warehouse integration. In the first 3 month period, you will be helping to build out data warehouse integration. This project is a multi-year ongoing project and has the highly likely potential for contract extension

Essential Functions:

  • Understanding Data Warehouse concepts and data models
  • Develop complex queries and stored procedures using T-SQL
  • Design and develop ETL Processes according to established business requirements
  • Independently analyze and solve complex problems
  • Evaluate large and complex data sets
  • Write and maintain technical documentation
  • Manage source code versioning and deployments
  • SSIS Development, including package configurations, performance optimization and debugging
  • SQL Query performance tuning/optimization
  • Participate in design and code reviews and ensure adherence to best practices

Required Skills:

  • Expert level knowledge of SQL, t-SQL and/or PL/SQL
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Query Performance and Optimization Tuning

Other helpful skills (not required):

  • Data Modeling
  • Oracle PL/SQL
  • Experience with non-for-Profit organizations, fundraising applications, Team Approach, Personify and/or CRM systems.

    • provided by Dice SQL Server, ETL SSIS, TSQL, Tuning, database development
View this job on