Azure Data Architect

Are you an experienced Azure Data Architect looking to build a new Azure Data Warehouse from the ground up? Do you like working in a small environment where you have the opportunity to design, develop, implement and modernize a critical Data Warehouse environment? A successful Financial Services leader is expanding their Azure Data Architecture and Engineering team. Sr Azure Data Architect/Data Engineer opportunity! Competitive compensation, tremendous benefit package and 401k. Cutting edge technology, incredible culture and working environment!

Employee testimonials:

• Fantastic Place to Work. Hope to finish out the rest of my career with this great company!
• Good salary and package deal Friendly environment Great career advancement Everyone loves working here and you feel it!
• Great company, culture, and work-life balance!

Title: Azure Data Architect/Engineer

Location: Stamford, CT

Salary: $170,000 $190,000 + Generous Bonus, Incredible benefits and retirement package!

Responsibilities:

• Sr Azure Datawarehouse Architect/Engineer responsible for playing a lead role in the design, development, implementation and support of new Azure Data Warehouse/Azure Data Lake. You will develop a flexible, enterprise-level environment that integrates multiple warehouses to guarantee precise, comprehensive, consistent, and timely data, using Azure Synapse, DataBricks, Azure Data Factory. As a Subject Matter Expert in technical requirements, this position will play a crucial role in supporting and implementing data projects, as well as engaging effectively with users and other IT staff.
• Provide support in designing and overseeing enterprise-grade data pipelines and data stores, essential for the development of advanced analytics programs, machine learning models, and statistical methods.
• Implement automation and streamline processes to optimize the entire data and analytics platform, ensuring efficient throughput and high-performance outcomes.
• Recognize, devise, and execute internal process enhancements, including automation of manual tasks, optimizing data delivery, and redesigning architecture or infrastructure to enhance scalability.
• Collate large, intricate datasets that align with functional and non-functional business demands.
• Develop processes that facilitate data transformation, manage data structures, metadata, dependencies, and workload management.
• Collaborate with business users to understand functional and data requirements, contributing to the enhancement of data models and pipelines.
• Designing, implementing, and managing data extraction, transformation, and loading (ETL) processes.
• Deliver Business Intelligence solutions that are 95% defect-free providing that adequate written business requirements, development time, and business test review were afforded during the project

Requirements:

• Bachelor s degree with a minimum of 10 years of related experience.
• 10+ years of hands-on Data Warehouse architecture and development experience
• Experience deploying modern data solutions leveraging components like Azure functions, Azure Data Factory, Data Flows, Azure Data Lake, Azure SQL, Azure Synapse, Streaming Analytics or equivalent on another cloud provider such as AWS or Google Cloud.
• Exhibit a thorough understanding of Data Lake architectures, including raw, enriched, and curated layer concepts, and ETL/ELT operations
• Exhibit a solid understanding of database design, data warehousing concepts, big data platforms, and ETL operations
• Strong level of understanding on Azure Data Factory, SQL/Synapse, ADLS, and Azure DevOps.
• Experience working with data integration techniques & self-service data preparation.
• Experience in requirements analysis, design, and prototyping.
• Experienced using Azure Synapse Analytics and DataBricks
• Demonstrated expertise in Microsoft SQL Server and/or Azure development.