Patelco Credit Union

  • Data Reporting Analyst

    Job Locations US-CA-Pleasanton
    Req No.
    2018-2919
    Category
    Information Technology
    Type
    Regular Full-Time
  • Overview

    Overview

    We’re here to help people in communities throughout Northern California build financially healthy livesWe do this by being attentive and partnering with our members to understand what is financially best for them. We thrive on change, and we put people first. If you’re looking to use your skills and knowledge to make a difference in the lives of others, we look forward to hearing from you.

    About Patelco Credit Union    

    Patelco is a not-for-profit credit union, serving the financial needs and aspirations of more than 300,000 members. What we earn, we return to our members in savings from lower loan rates, fewer fees, and personalized service that focuses on transparency, simplicity, and trust. Our mission remains the same as when we started in 1936, to provide products, services, education and expertise that will empower our members to rise up and achieve financial freedom. 

     

    The Opportunity: The Data Reporting Analyst is a key technical resource responsible primarily for design, development, and deployment of processes in response to requests for periodic and reoccurring reports of enterprise data to ensure Patelco Credit Union achieves project goals as prioritized by IT Management and Credit Union Leadership. Focused on normalizing and standardizing data provided to business users from the Fiserv/Spectrum core, our account and loan origination systems, financial reporting systems, and other third party or in-house systems, this position will work closely with the Data Analytics group, other groups in IT, and key representatives of other business units to accomplish Credit Union priorities.

    Responsibilities

    • Complete accurate, project tasks, on time, supporting project and business requests for data.
    • Research, design, test, and deploy solutions to respond to requests for periodic and reoccurring data from the business units and IT Teams.
    • Analyze data sourced from the Core banking system (Fiserv/Spectrum) and other systems of record in the Patelco infrastructure including account and loan origination systems, downstream SQL databases, and third party systems to recommend changes to procedures, processes and systems to identify, document, and correct non-normalized data; with explicit consideration to the value of correction, and the effects of the recommended changes to existing systems, documentation, and procedures.
    • Implement high quality processes to export, transform, and promote data downstream from source systems into Patelco’s data infrastructure using Microsoft SSIS.
    • Work with IT Management, Project management, Business Analysts, and business partners to validate the accuracy of business requirements.
    • Provide technical support and advice to all areas of IT and Credit Union end users.
    • Other duties as assigned.

    Qualifications

    • Bachelor’s degree, or equivalent from an accredited college, technical, business, and vocational school in Computer Science, Data Science, Management Information Systems or a related field; or equivalent work experience.
    • Three (3) years of experience working with MS SQL Server (2008R2/2012/2014/2017) Data Tools, SSIS/SSRS, SQL Management Studio, and/or Visual Studio
    • Three (3) years of hands-on experience in SQL, T-SQL and/or other scripting languages for data extraction and manipulation.
    • Two (2) years of experience in design and deployment of solutions for a financial institution (highly preferred) or other regulated industry (such as HealthCare, Education, or Governmental agency).
    • Two (2) years of hands-on experience with ETL/Data Warehousing methodologies, including database normalization, indexing/performance, and query optimization.
    • Two (2) years’ experience in project execution and/or management, with exposure and use of the tools, techniques, and methods employed for successful project management.
    • Intermediate skills in systems development lifecycle, scrum, agile, etc.
    • Intermediate skills in project definition, task management, and project reporting in one or more project management applications, such as Microsoft Project, Eclipse, JIRA, Microsoft Team Foundation Server, Asana, or Basecamp.
    • Intermediate skills in Microsoft Office applications including Word, Excel, Outlook, Visio (or other visualization application), and PowerPoint. Advance MS Excel skills preferred.
    • Intermediate skills in Unix shell scripting.
    • Knowledge of a Unix environment terminal emulation application, such as Putty or Reflections.
    • Strong written and oral/verbal communication abilities, including strong listening and interpersonal skills
    • Strong attention to detail and documentation skills

    Patelco Credit Union is an EO Employer - M/ F/ Veteran/ Disability

     

    IND123

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed