This job is closed
We regret to inform you that the job you were interested in has been closed. Although this specific position is no longer available, we encourage you to continue exploring other opportunities on our job board.
About the position
Today, DRC’s business units serve the K-12 and adult education sector, Federal and state governments, licensure boards and associations, and commercial clients worldwide! DRC has more than thirty years of proven experience in reporting and analytics, supporting Educational Technology (Ed Tech), Federal Research, and Commercial Services. We're committed to being an innovative and disruptive force in the reporting and analytics space as a company. We desire to provide modern, cloud-based advanced analytics solutions that create value and drive progress.
Responsibilities
- Develop, design, tune and maintain SSIS packages to perform ETL operations.
- Extract data from SQL databases, apply necessary transformations and load it into SQL/NoSQL databases.
- Export Microsoft Analysis Services cubes.
- Ensure process efficiencies and maintain data quality.
- Work with the entire Microsoft SQL Server stack.
Requirements
- 4+ years experience and proficiency in SQL Server Integration Services (SSIS Packages) for ETL operations.
- Strong knowledge of SQL Server DB Engine (T-SQL) for database operations.
- 4+ years Experience with SQL Server Analysis Services (SSAS) for analytical and ad-hoc queries.
- Familiarity with Visual Studio for developing solutions using projects.
Nice-to-haves
- Experience with PowerShell Scripting for task automation and configuration management.
- Knowledge of .NET (SQL Server CLR) for creating stored procedures, user-defined types, triggers, aggregates, etc.
Job Keywords
Hard Skills
- Adult Education
- Advanced Analytics
- Disruptive Innovation
- K-12 Education
- Technology Education
A Smarter and Faster Way to Build Your Resume