SQL Server ETL Architect

Position: SQL Server ETL Architect
Location: New York, United States
Remuneration: Not Mentioned
Who is hiring?

We are currently working with a leading Data Consulting client in the US that specializes in all things data and analytics including big data, modern data architecture, cloud migration, enterprise data management, business intelligence, data visualization, advanced analytics, and machine learning.

They seek to hire a Senior Data Engineer to assist them in building an on-prem solution first, then migrating this solution into Azure  Cloud-based solution in the later phase of the project,  with SQL Server (SSIS) & ETL Architecture experience.

 

What will you be doing?
The position will be responsible for mapping multiple Microsoft SQL and MySQL source databases to centralized SQL Server target system(s) intended to supply business intelligence and general reporting systems. Additionally, this individual will be called upon to employ these systems in the creation of models, reports, and interfaces based on criteria determined through collaboration with analysts, stakeholders or other requestors (including external agencies), complete with recommended improvements to – or new requirements for – these reporting structures. Will assist general management with gathering/developing requirements associated with strategic and annual business planning, budgeting, cost control, and external reporting.


Qualifications:
-3 year of current or recent Database Developer experience required.
-Working knowledge if MySQL and SQL Server Demonstrate the ability to establish and maintain database standards and data retrieval methodologies
-Basic knowledge if SQL Server Integration Services (SSIS), SQL Data Transformation Services (DTS), SQL Scriptwriting, Views, Triggers, and Stored Procedures

Responsibilities:
-Develop, implement and manage data warehouse environment, related source databases and business intelligence solutions focusing on data modeling and database development. 
-Work with data architects, business analysts and stakeholders to design robust, scalable database and data extraction, transformation and loading (ETL) solutions. 
Why you shouldn’t miss this opportunity?
Responsibilities Develops, implements and manages data warehouse environment, related source databases and business intelligence solutions focusing on data modeling and database development. Will work with data architects, business analysts and stakeholders to design robust, scalable database and data extraction, transformation and loading (ETL) solutions. The position will be responsible for mapping multiple Microsoft SQL and MySQL source databases to centralized SQL Server target system(s) intended to supply business intelligence and general reporting systems. Additionally, this individual will be called upon to employ these systems in the creation of models, reports, and interfaces based on criteria determined through collaboration with analysts, stakeholders or other requestors (including external agencies), complete with recommended improvements to – or new requirements for – these reporting structures. Will assist general management with gathering/developing requirements associated with strategic and annual business planning, budgeting, cost control, and external reporting. Qualifications Bachelor of Science REQUIRED Minimum of 1 year of current or recent Database Developer experience required Working knowledge if MySQL and SQL Server Demonstrate ability to establish and maintain database standards and data retrieval methodologies Basic knowledge if SQL Server Integration Services (SSIS), SQL Data Transformation Services (DTS), SQL Script writing, Views, Triggers, and Stored Procedures
Strategy & Architecture(Data Architect), Database Design, SQL, Big Data, ETL, SSIS (SQL Server Integration Services)

Apply Now

We're always looking for high skilled professionals.