Senior Data Engineer

We are seeking a talented and experienced Data Engineer and Developer to join our Data Management and Analytics team. As a Data Engineer and Developer, you will play a pivotal role in delivering impactful insights by designing and building data pipelines, integrating multiple platforms (Snowflake, Salesforce, nCino), developing data solutions, and solving challenging data problems to support our rapidly growing business.

Responsibilities:

• Design, develop, and maintain robust and scalable data pipelines using Azure Data Factory, DBT, and Microsoft Fabric to stage and integrate data into our Enterprise Data Warehouse.
• Develop integration solutions between Snowflake, Salesforce, Workday, and nCino, ensuring data consistency, reliability, and compliance with business needs.
• Proactively identify opportunities to reduce data flow complexity and risk while proposing innovative, best-in-class solutions.
• Implement data engineering solutions following guiding principles and best practices when detailed requirements are unavailable.
• Monitor and maintain production ETL processes and resolve support issues, ensuring operational excellence and performance.
• Develop objects (tables, views, stored procedures, triggers) in Snowflake along with tasks to support data processes.
• Work with BAs and the business to refine requirements and deliver against those requirements within the timeframe committed.
• Manage work tasks and update status on work tasks on ADO (Azure DevOps), communicate status and updates to management, stakeholders and peers to deliver work products on time.

Qualifications:

• 5+ years of experience as a data engineer supporting enterprise data warehouse solutions.
• Hands-on experience with Azure Data Factory, DBT, and Microsoft Fabric for developing modern ETL/ELT pipelines.
• Experience with Talend, and PowerBI
• Experience at banking institutions or within the financial services industry.
• Hands-on experience with Snowflake for data warehousing and analytics.
• Proven experience integrating enterprise systems, particularly Salesforce and nCino.
• Proficient in SQL, PowerShell, and Python for data transformation and scripting.
• Demonstrated critical thinking mindset with the ability to independently drive end-to-end solutioning, even in the absence of detailed requirements.
• Strong knowledge of data governance/controls, data architecture, and data modeling principles.
• Excellent communication and collaboration skills to translate business requirements into scalable technical solutions.
• Strong analytical and problem-solving abilities, with a focus on alignment with best practices and CUBI standards.
• Ability to work across multiple concurrent projects in a fast-paced environment.
• Experience creating scalable ETL solutions using tools such as ADF, DBT, SSIS, or Microsoft Fabric.
• Familiarity with Agile development methodologies and CI/CD pipelines.