ETL Developer / Data Modeler

Dear Candidate,

My name is Manisha Singh and I am a recruiter at Stellent IT LLC. I am reaching out to you on an exciting job opportunity with one of our clients.

Should you be interested, please send me a copy of your resume in word format along with your LinkedIn URL.

NOTE: Clearance Required: Must get a Treasury Public Trust (4-6 weeks, quicker if a candidate already has a DOD clearance). Ideally someone with an active Treasury PT

Job Title: ETL Developer / Data Modeler

Job Location: These roles are hybrid, on site at Treasury HQ in Washington, DC (1-2 days a week), but they will entertain remote candidates as well, especially if they already have a Treasury PT.

Duration: 6+ Months (Potential Extension)

Interview Process: 1 Video Interview

Responsibilities

Design, develop, and maintain ETL/ELT processes leveraging SQL Server Integration Services (SSIS) and/or Azure Data Factory.

Support enterprise data warehouse initiatives and develop scalable dimensional data models.

Integrate multiple data sources into centralized warehouse environments.

Create and optimize complex T-SQL queries, stored procedures, views, functions, indexes, and dynamic SQL.

Develop reporting and analytics solutions using SSRS and/or Power BI.

Collaborate with business and technical stakeholders to gather requirements and translate them into database structures, datasets, and reporting solutions.

Support data quality, data governance, and data lifecycle management initiatives.

Assist with migration efforts from on-premises data platforms to Azure-based solutions.

Develop and maintain SSAS Tabular Models and DAX expressions.

Promote adoption and utilization of enterprise data products and reporting capabilities.

Required Qualifications

10+ years of T-SQL data engineering experience.

Strong expertise writing complex queries, stored procedures, views, indexes, functions, and dynamic SQL.

5+ years of ETL/ELT development using SQL Server Integration Services (SSIS) and/or Azure Data Factory.

5+ years of data warehousing experience.

3+ years of dimensional data modeling experience.

2+ years of experience with SSRS and/or Power BI.

1+ year of experience developing SSAS Tabular Models and DAX expressions.

Strong communication skills and the ability to work directly with business stakeholders to translate requirements into technical solutions.

Preferred Qualifications

Microsoft Azure experience, including IaaS and PaaS services.

Azure Synapse Analytics development experience.

Experience developing Power BI semantic models.

Experience migrating SSIS packages to Azure Data Factory pipelines.

Experience supporting enterprise reporting, analytics, and business intelligence environments.