ETL Developer / Data Modeler

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., AIR’s Tek Office is seeking an experienced Power BI Developer to join its talented group. The Power BI Developer will work closely with the AIR Modernization team and stakeholders …

• 1 month ago +

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.

• $104,000-122,000 per year

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