Belong to something bigger.

At ESL, it’s more than a job. It’s your unique journey.

Your Journey Begins Here

ESL Federal Credit Union is seeking an experienced Data Systems Architect who is interested in influencing the architectural direction and data design of our enterprise data warehouse. This person will be responsible for the creation of a data warehouse design that can be leveraged by the business to effectively answer data related questions. This role also ensures use of best practices with respect to data usage and develops the strategy for how the data will be documented, handled, stored, and processed to support the requirements from across all business units.

Are you someone who would like to:

• Influence the growth of a newly created warehouse into a strategically used repository
• Help define organization wide data standards and coordinate all aspects of source data transformation
• Act as a key player in ensuring ESL meets its strategic data goals
• Continue to strengthen and grow ESL’s Data Management Initiative
• Spread awareness of the benefits and capabilities of data management
• Participate in the strategy and communication with all levels of the organization
• Identify and drive solutions
• Guide and mentor others

Why ESL?

We offer experienced Data professionals:

• A full data warehouse suite including modeling, ETL, and business intelligence tools
• An expanding warehouse with three full environments on the latest infrastructure 
• The ability to guide the entire date warehouse lifecycle using Kimball methodology
• Ability to work in a collaborative environment utilizing Waterfall techniques

Pay: 

Work Hours:

40

Schedule:

This position is hybrid and remote eligible for up to 40% of the time. The office location for this position is at ESL Corporate Headquarters in Rochester, NY. Hours are Monday - Friday 8:00 a.m. - 5:00p.m. Must be flexible to meet current and future business needs.

Who is the Ideal Candidate?

• Bachelor's degree in a technical field or 4 years of equivalent strong technical experience with leadership, analytical skills and data warehousing
• Minimum 10 years of experience in supporting the business aspects of application systems
• Minimum 10 years of experience in supporting business data, analytical concepts, and techniques
• Minimum 5 years of experience in data warehousing
• Advanced experience with database concepts and query analysis in MS SQL and/or Oracle database applications
• Highly experienced in all aspects of the Data Warehouse Lifecycle methodology including requirements gathering, design, implementation, testing, and support
• Experience with Data Management concepts, focusing on data transformation, reporting, and analytics
• Demonstrated highly effective communications, interpersonal, and team building skills
• Proven experience working with business users to understand requirements and translate them to systems/data specifications
• Proven ability to multitask and independently engage in highly complex, strategic activities
• Proven leadership skills
• Proven ability to develop standards and process flows
• Demonstrated ability to work directly with the highest levels of management
• Demonstrates alignment with ESL’s Core Values, mission, vision, and Purpose to help our community thrive and prosper

Additional Preferred Qualifications:

• Minimum 10 years of experience in supporting banking application systems. Thorough understanding of banking products, services, and supporting business data, processes and technologies preferred.

Accountabilities:

Leads data mapping and definition efforts across the organization

• Ensures use of best practices with respect to data usage. Develops the strategy for how the data will be documented, handled, stored, and processed to support the requirements from across all business units.
• Coordinates all aspects of source data transformation (source-to-target mapping) in support of ESL’s Data Management Program.
• Leads and mentors others on data governance aspects related to ESL’s Data Management Program.
• Ensures use of best practices with respect to data usage. Develops the strategy for how the data will be documented, handled, stored, and processed to support the requirements from across all business units.
• Coordinates all aspects of source data transformation (source-to-target mapping) in support of ESL’s Data Management Program.
• Leads and mentors others on data governance aspects related to ESL’s Data Management Program.
• Utilizes advanced understanding of data behind the portfolio of applications as well as how the business uses the data to make informed decisions to ensure that data is handled appropriately and consistently across the organization.
• Provides support for the Data Management Program Manager and Principal Data Systems Architect in the areas of data architecture, design, and transformation.
• Provides support for the ETL and BI developers for all data related analysis, questions, and issues.
• Performs Data Steward duties for various Dataset Subgroup Teams.

Implement and drive solutions to allow technology to improve business results and leverage data

• Provides support for the Data Warehouse Architect in the areas of data design (including modeling), data transformation, and data architecture standards and ensures that they do not compromise business processes.
• Provides industry leadership and expertise to the Systems and Technology organization on data source mapping and the effect that changes to sources and their data will have on downstream systems.
• Identifies and drives business solutions where data can improve business results and/or leverage existing data.
• Collaborates with business users to understand/clarify needs and develop/document clear, specific requirements.
• Works with the business to identify opportunities for future initiatives and releases.
• Works with the project manager to ensure that all necessary tasks are accurately represented in the project plan.
• Defines and gains agreement on the size of the effort during the design phase. Identifies changes that could impact scope and necessitate adjustments to resources or timeline.
• Researches approach for handling data integration.
• Researches data related issues and performs detailed data analysis.
• Designs and leads the testing of data transformation aspects of the solution. Assists technical staff with unit testing plans to ensure that all business requirements are tested.

Ensures that the Data Warehouse and other data environments are stable, secure, and available to support business units and customers at all times.

• Ensures accurate tracking of the uptime of the data management databases (including the warehouse) relative to the uptime goals.
• Plays a role with vendors to address ESL business needs.
• Leads knowledge transfer activities on systems data that require business support.
• Provides assistance/mentoring to S&T project leads on how to integrate Data Management and its governance into enhancement requests, requirements, statements of work, project plans, and implementation plans.
• Collaborates with ETL Development team on triage and analysis of data issues found.
• Works with Data Management Program Manager and Principal Data Systems Architect in the creation of standards that effect how ESL uses technology to satisfy business needs.
• Involved in creating material for and delivering the methodology, data, and field definition training for the business community.
• Provides 24X7 production support as needed. This includes tracking statistics about bugs and backlog items.

Interested? Apply today.

We’re committed to diversity, equity, and inclusion. ESL recognizes the importance of a culture that embraces diversity and values individual differences. We are committed to cultivating a diverse workforce at all levels that mirrors the communities we serve. We welcome applications from people with diverse perspectives and backgrounds. We strive to create an inclusive, respectful and equitable environment, which makes ESL a great place to work!

#LI-KS1

#LI-Hybrid