ADF Architect

ADF Architect

Location Newton, MA

Major Functions/Responsibilities

• Design, develop and implement robust and extensible solutions to build segmentations using Customer Data Platform.
• 2+ year's experience in Azure Data Factory - ETL pipeline building
• Develop advanced SQL Procedures, Functions and SQL jobs.
• Performance tuning and optimization of ETL Jobs, SQL Queries and Scripts.
• Configure and maintain scheduled ETL jobs, data segments and refresh.
• Support exploratory data analysis, statistical analysis, and predictive analytics.
• Support production issues and maintain existing data systems by researching and trouble-shooting any issues/problems in a timely manner.
• Work closely with subject matter experts to identify and document based on the business requirements, functional specs and translate them into appropriate technical solutions.
• Responsible for estimating, planning, and managing the user stories, tasks and reports on Agile Projects.
• Proactive, great attention to detail, results-oriented problem solver.
• Maintain data integrity and monitor system health and troubleshoot any issues.

Preferred Experience

• 6+ years of experience in writing SQL queries and stored procedures to extract, manipulate and load data.
• 6+ years' experience with design, build, test, and maintain data integrations for data marts and data warehouses.
• 3+ years of experience in integrations Azure / AWS Data Lakes, Azure Data Factory & IDMC (Informatica Cloud Services).
• In depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
• Excellent verbal and written communication skills
• Collaboration with both onshore and offshore development teams.
• Good Understanding of Marketing tools like Sales Force Marketing cloud, Adobe Marketing or Microsoft Customer Insights Journey and Customer Data Platform will be important to this role.

Communication

• Facilitate project team meetings effectively.
• Effectively communicate relevant project information to superiors
• Deliver engaging, informative, well-organized presentations that are effectively tailored to the intended audience.
• Serve as a technical liaison with development partner.
• Serve as a communication bridge between applications team, developers and infrastructure team members to facilitate understanding of current systems
• Resolve and/or escalate issues in a timely fashion.

Understand how to communicate difficult/sensitive information tact