Senior Data Engineer / Architect

The department is undertaking a significant modernization of its enterprise data environment, including the migration of critical data processing workflows to Snowflake and Informatica, and the expansion of business intelligence capabilities through Tableau.

The technical leadership provided by this position will strengthen the organizations ability to leverage data as a strategic asset while ensuring scalability and long-term sustainability of its data infrastructure.

Guide the migration of enterprise data processing and ETL workflows to Snowflake and Informatica platforms.
Design, implement, and maintain scalable data warehouse workflows.
Develop and optimize ETL/ELT processes to improve data integration, performance, and reliability.
Perform data validation, reconciliation, and quality assurance to ensure the accuracy, completeness, and integrity of enterprise data.
Establish, implement, and monitor data governance standards, data quality controls, and compliance with organizational policies and regulatory requirements.
Develop automation solutions and reusable data processing tools using Python, R, and VBA to improve operational efficiency and reduce manual effort.
Design, develop, and maintain complex scripts, stored procedures, and workflows supporting enterprise reporting and analytics.
Analyze, troubleshoot, and resolve complex data integration, transformation, and performance issues across multiple systems.
Collaborate with business and technology teams to translate business requirements into technical solutions, and to understand cloud data architecture, data integration strategies, and best practices.
Develop and maintain technical documentation, including data flow diagrams, process documentation, data dictionaries, and system specifications.
Evaluate emerging technologies and recommend enhancements that improve the organizations data management capabilities, security, scalability, and operational efficiency.
Creates and maintains interactive Tableau dashboards for scalability, manageability, extensibility, performance, and re-use;
Works with team members to create useful reports and dashboards that provide insight, improve/automate processes, or otherwise add value to the team;
Supports the R&I Data Steward in administering the data stewardship program and coordination with various data users and data owners.