Senior ETL Developer - .net and SQL Server

DRC is one of the largest educational assessment and curriculum/instruction companies in the industry.

We serve the K-12 and adult education sector, Federal and state governments, licensure boards and associations, and commercial clients worldwide.

About Data Recognition Corporation

With over thirty years of proven experience in reporting and analytics, DRC supports Educational Technology (Ed Tech), Federal Research, and Commercial Services. We strive to provide modern, cloud-based advanced analytics solutions that create value and drive progress.

Job Description

We are seeking a Senior ETL Developer to join our team. This role will focus on designing, developing, and maintaining SSIS packages for ETL operations using the Microsoft SQL Server stack.

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.

Requirements:

• 4 years of 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 of experience with SQL Server Analysis Services (SSAS) for analytical and ad-hoc queries.

Preferred Qualifications:

• 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.

Qualifications:

• Proven experience as an ETL Developer or similar role in data warehouse projects.
• Excellent problem-solving and analytical skills.
• Strong written and verbal communication skills.

Benefits:

DRC offers a comprehensive benefits program that allows employees to make choices that best meet their current and future needs. We offer many benefits, including medical, wellness, dental, and vision insurance, a 401(k), flexible spending and health savings accounts, short and long-term disability insurance, and life insurance.

About Us:

Data Recognition Corporation is an Affirmative Action/Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.