Role Overview

The ideal candidate will have expert-level skills in T-SQL and a robust understanding of data warehousing technologies to help us build and maintain a modern enterprise data warehouse on Azure. This role will require deep technical knowledge in Azure Data Factory, SQL Server, CDC (Change Data Capture), and Azure Synapse, as well as proficiency in developing PowerBI reports. The ideal candidate will have experience with data migrations and a background in financial data, ensuring data governance throughout the lifecycle of the project. The Data Engineer will collaborate closely with the product owner to align the data architecture with business needs, driving data initiatives that support strategic business goals.

Status

Full Time, Exempt

Key Responsibilities:

• Design, construct, and manage the enterprise data warehouse and data architecture on the Azure platform.
• Develop and optimize data pipelines using Azure Data Factory, implementing CDC mechanisms for real-time data processing.
• Manage and enhance database solutions with SQL Server, leveraging T-SQL for complex data manipulation and extraction.
• Utilize Azure Synapse for large scale data analytics solutions, optimizing data storage and performance.
• Create insightful, actionable PowerBI reports and dashboards to meet business analysis needs.
• Engage in data migration projects, ensuring accuracy and integrity of data transfers.
• Work directly with the product owner to understand and fulfill data requirements, ensuring that the data architecture supports and enhances business processes.
• Implement and maintain strict data governance practices to ensure data security, quality, and compliance with industry standards, particularly in financial environments.
• Document all systems, processes, and metadata to maintain transparency and sustainability of the data architecture.

Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Science, or a related field.
• 3-5 Years experience with T-SQL and a proven track record in developing and managing large scale data warehouses.
• Strong experience with Microsoft Azure services, including Azure Data Factory, SQL Server, CDC, and Synapse.
• Proficiency in creating and managing PowerBI reports.
• Demonstrable experience with data migrations and handling sensitive financial data.
• Deep understanding of data governance principles and practices.

Preferred Qualifications:

• Experience with dbt (data build tool) is highly desirable.
• Prior experience in a financial services environment, understanding complex data needs and regulatory requirements.
• Certifications in Azure data technologies, data engineering, or related fields.