Senior Data Engineer

Job Description

Job Description

We are looking for an experienced Senior Data Engineer to strengthen our data ecosystem in Greenwich, Connecticut. This role will drive the development of reliable, scalable data pipelines, reporting capabilities, and platform enhancements that support critical business operations. The ideal candidate brings deep expertise in Microsoft-based data environments, strong SQL and ETL skills, and a practical approach to solving complex integration challenges.

Responsibilities:
• Build, enhance, and tune data pipelines, integration workflows, and core data platforms to support scalable and dependable information delivery.
• Translate business needs into technical solutions by partnering with internal teams and external vendors on data integration, reporting, and analytics initiatives.
• Create and implement automated processes that reduce manual effort, improve accuracy, and increase operational efficiency across data-related functions.
• Oversee production data jobs, investigate failures, resolve high-priority issues, and participate in after-hours support when needed.
• Produce technical design documents, process specifications, and operational documentation to promote consistency, maintainability, and knowledge sharing.
• Develop and deploy reporting and dashboard solutions that improve visibility into business performance while maintaining appropriate access controls and data security.
• Lead the ongoing improvement of database and integration performance, with attention to scalability, reliability, and long-term platform stability.
• Contribute to cloud-oriented data engineering efforts, including support for modernization initiatives involving services such as Azure-based platforms.
• Support application and data connectivity by implementing and maintaining API-based integrations where required.• 5+ years of experience in information technology with substantial hands-on work in relational databases, ETL development, data warehousing, reporting, and dashboard creation.
• Advanced expertise in SQL and T-SQL, including writing, troubleshooting, and optimizing complex queries, stored procedures, and database objects.
• Strong experience with Microsoft SQL Server and SQL Server Integration Services (SSIS) in enterprise data environments.
• Proven ability to lead complex data integration efforts and oversee ETL processes from design through production support.
• Working knowledge of source control and collaborative development practices, including experience with Microsoft DevOps or similar tools.
• Familiarity with API integrations and the ability to connect data solutions across systems and applications.
• Experience with Microsoft business intelligence tools such as Power BI and related reporting technologies is preferred.
• Exposure to modern cloud and big data platforms, including Azure Data Factory, Azure Databricks, PySpark, Snowflake, or similar technologies, is a plus.