As the Data Architect Lead Engineer, you will be primarily responsible for developing the full life cycle of a Enterprise Data solution (data movement and visualization), including requirements analysis, platform selection, technical architecture design, application design and development, testing, and Test and Deployment in a Cloud based environment. The position will focus on building out a consumer insights strategy and building advanced analytics to deliver capabilities against that strategy using industry best practices meeting functional, non-functional and performance related position requires to develop DFTs, Pipelines, datasets, deployment, execution, monitoring and support the data flow from source to target.
The position requires to review the work of team and guide team in developing of code with best possible standards. Experience using advanced software and system design skills in an environment using Microsoft Azure (Azure SQL Managed Instance, Data Factory, Azure Monitoring, Azure DevOps, Event Hubs, Azure AD Security, Azure Virtual Machines, Azure Monitoring/Log Analytics).
6+ years of experience with data warehouse technical architectures, ETL/ ELT, reporting/analytic tools and scripting.
Experience in MS SQL Server DB.
Experience writing complex SQL queries (to clean and transform data)
Demonstrated excellent written/oral communication skills, technical documentation skills, user liaison skills, and personal interaction abilities