Lead Data Architect

Job Description

We have a position for a Lead Data Architect with one of our clients in New Hyde Park, NY for an initial contract duration of 4 months. No third party candidates considered for this position.

We are looking for a Data Architect to join our growing team This Data Architect will leverage their business and technical knowledge to develop production-ready data models by integrating multiple sources of data while also working with Solution Architect and Product Owner to understand business strategy and objectives, gather information, and ensure business requirements are being fulfilled throughout the entire data & analytics lifecycle.

Key Responsibilities

• To perform in this position successfully, an individual must be able to perform each essential duty satisfactorily.
• Facilitates database design sessions and translates business requirements into logical and physical system designs for moderate to large complex use cases and provide the source to target mapping designs for delivery
• Knowledge of modern cloud data model design patterns and ability to identify solutions that leverage these modeling techniques.
• Design the physical database model and implementation process that serves cross-functional areas. Designs the optimal data presentation environment for the customer and works with various reporting needs.
• Develops, tests and implements moderately complex ETL (extract, transformation, and load) routines.
• Provides data analysis and technical support for highly complex query optimization and database proficiency.
• Assists in leading the effort to ensure proper integration with existing data, standards, and business processes.
• aligning solutions with the ever-evolving data security space
• Ability to direct the work of others, including but not limited to directing ETL development demonstrating an understanding key concepts of ETL/ELT including best practices for optimization and scheduling.
• Addresses the customer needs, manages expectations and ensures system-wide integration. A strategic mindset for the importance and power of data across a spectrum of use cases and possibilities
• Develops, documents, and delivers complex ad-hoc queries of production data as requested. Works effectively with Product Owner and Solution Architect to determine needs, specifications, feasibility, and project priorities.