Senior IT Data Engineer

This role focuses on building, maintaining, and modernizing data architecture to ensure reliable analytics. Responsibilities include engineering scalable data pipelines, standardizing datasets, and resolving data quality issues across both on-premise and cloud environments like Snowflake. Additionally, you will collaborate with business stakeholders to establish data governance and support reporting platforms like Power BI. Ultimately, you act as the bridge between raw data systems and the actionable reporting needed for downstream applications. Senior IT Data Engineer ESSENTIAL FUNCTIONS (RESPONSIBILITIES):

• Design, develop, and maintain scalable ETL/ELT pipelines for ingesting, transforming, and delivering enterprise data.

• Build and optimize integrations across cloud and on-premises systems.

• Optimize performance, scalability, and cost efficiency within data warehouse environments.

• Design and maintain dimensional and analytical data models that support enterprise reporting and business intelligence.

• Assess, identify, and remediate data quality, integrity, lineage, and consistency issues.

• Establish and promote data governance standards, naming conventions, metadata management, and documentation practices.

• Contribute to cloud migration, platform modernization, and enterprise data strategy initiatives.

• Partner with developers, analysts, architects, and business stakeholders to understand data requirements and deliver scalable solutions.

• Support and enhance reporting platforms including Power BI and Cognos.

• Support emerging AI, machine learning, and advanced analytics initiatives by preparing and governing data assets for consumption.

• Exercises awareness with regard to possible suspicious activity, money laundering or fraudulent behavior and reports any such incidents to the BSA department. Performs all job functions in compliance with all company policies and federal, state, and local laws and regulations as applicable to the position, including, but not limited to BSA/AML, OFAC and GLBA/privacy rules.

• Performs related responsibilities as required or assigned.

Do you have experience in System performance optimization?, Senior IT Data Engineer REQUIRED QUALIFICATIONS: Knowledge/Skills/Abilities:

• Advanced knowledge in SQL and database optimization.
• Advanced working knowledge of data modeling principals (dimensional, normalized and analytical models).
• Excellent communication and stakeholder engagement skills
• Advanced skills implementing Data Governance, Master Data Management (MDM), or Data Catalog solutions.
• Ability to independently work in ambiguous environments with minimal structure.
• Exemplifies the Gateway Values: Growth Oriented, Make a Difference, “Get it Done” Attitude, Team Player, Do the Right Thing.

Equivalent Education/Experience:

• Bachelor’s degree in Computer Science, Data Science, Information Systems, Engineering or equivalent experience.
• 5 years’ of experience in Data Engineering, Data Warehousing, Analytics Engineering, Business Intelligence, or related disciplines
• Experience with Azure, Snowflake, Databricks, or Microsoft Fabric certifications
• Experience building enterprise-scale ETL/ELT solutions and data pipelines.
• Strong experience with relational databases and advanced SQL development.

Senior IT Data Engineer SPECIAL JOB DIMENSIONS: Job involves access to highly sensitive data involving a lot of trust, flexible schedule, on-call rotation and the ability to lift a minimum of 40 lbs. Travel requirement 10%. NOTE: The essential job functions and associated qualifications contained in this document describe the general nature and level of the work performed. They are not intended to represent an exhaustive listing or be inclusive of all aspects of the job. The tasks and procedures involved in the performance of the essential job functions may vary from day-to-day. Major changes in areas of responsibility may occur, as directed by management, and will require revision of this job description.