Data Systems Architect

Company: ESL Federal Credit Union (CU)
Location: Rochester
Posted on: July 22, 2021

Job Description:

Work Hours:

40 

Schedule: 

Monday - Friday 8:00 a.m. - 5:00p.m. Must be flexible to meet current and future business needs.

Primary Accountability:

This position is accountable for leading the design, integration, standards, and support of data associated with releases that support ESL’s Data Management Program. Leverages knowledge of the interaction between technology, business, and critical vendors to ensure that requirements are met and that consistent business definitions are used. Works closely with the Data Warehouse Architect and business users to ensure that data to fulfill their reporting and analytics needs is accurate, available, and easy to find. Ensures that solutions meet the ESL desired information architecture.

Principle 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 Data Warehouse 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 Data Warehouse 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.

Qualifications: 

• Bachelor's degree in a technical field or 4 additional years of experience with leadership data warehousing and analytical skills
• Minimum 10 years of experience in supporting the business aspects of application systems, including reporting applications.
• Minimum 10 years of experience in supporting business data, analytical concepts, and techniques.
• Minimum 5 years of experience in data warehousing.
• Commitment to achieving an inclusive work environment.
• Proven experience with database concepts and query analysis in MS SQL and/or Oracle database applications.
• Understanding of 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 ability to integrate data with packaged software and applications.
• Proven ability to develop standards and process flows.
• Demonstrated ability to work directly with various levels personnel within the company.
• 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.

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!

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

Keywords: ESL Federal Credit Union (CU), Rochester , Data Systems Architect, Other , Rochester, New York