Azure Synapse Specialist / Data Engineer

Azure Sypnase Specialist / Data Engineer - (On Site) Fairfield, CT

Position Overview:

• You'll own the complete data warehouse lifecycle, from design and development to implementation, operations, and ongoing support.
• You'll be instrumental in driving our on-premise and cloud data warehouses forward to meet critical business needs.
• Receive a highly competitive compensation package paired with comprehensive benefits.

Job Duties and Responsibilities:

• Design, develop, implement, and support our enterprise Microsoft Azure Data Warehouse.
• Provide support in designing and overseeing enterprise-grade data pipelines and data stores.
• Maintain compliance with SOX and all other pertinent regulatory and compliance policies and requirements.
• 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.
• Apply expert-level analytical and problem-solving skills to diagnose and resolve intricate technical issues.
• Create, maintain, and continuously enhance scalable data pipelines, while also developing new data source integrations to accommodate the growing volume and complexity of data.
• Designing, implementing, and managing data extraction, transformation, and loading (ETL) processes.
• Create comprehensive technical specification documents and application interface designs.
• Create data processing and integration solutions for both batch and real-time scenarios, proficiently handling structured and unstructured data.
• Leading and participating in design discussions, code reviews, and project-related team meetings.
• Providing mentoring and guidance to junior team members, promoting a culture of knowledge sharing and collaborative problem-solving.
• Ensuring data security and compliance with relevant regulations and best practices in all data operations.
• Aid in troubleshooting and resolving data and system issues, as necessary.

Preferred Qualifications:

• Bachelor's degree or higher in Information Technology or related field.
• 7+ years of hands-on Data Warehouse architecture and development experience
• Demonstrated expertise in Microsoft SQL Server and/or Azure development.
• Exhibit a thorough understanding of Data Lake architectures, including raw, enriched, and curated layer concepts, and ETL/ELT operations.
• Understand database design, data warehousing concepts, big data platforms, and ETL operations.
• 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.
• Experience with DevOps tools like Azure DevOps, Jenkins, Maven etc.
• Experience in building/operating/maintaining fault tolerant and scalable data processing integrations.
• Strong level of understanding on Azure Data Factory, SQL/Synapse, ADLS, and Azure DevOps.
• Ability to conduct data profiling, cataloging, and mappings for technical design and construction of data flows.
• Strong problem-solving skills with emphasis on optimization data pipelines.
• Experience working with third party providers and vendors for critical support requirements.
• US citizenship, green card holder or permanent US residency required.

Azure Synapse Software engineer
Azure Synapse Software engineer
Azure Synapse Software engineer
Azure Synapse Software engineer