About Patelco Credit Union
Patelco Credit Union is a not-for-profit credit union with a purpose to build financial health and wellbeing for our members. Since 1936, Patelco has grown from $500 in assets to over $9 billion in assets and is the 7th largest credit union in California with branches throughout Northern California.
We are here for our members throughout all their stages of life. Meeting them with the products and services to help them plan purposefully for their futures and to secure our life-long partnership as their trusted financial advocate. As one team, we are all committed to delivering service, empowering financial literacy, creating products, and providing new technology for our members.
We believe that work should be rewarding, challenging, and enjoyable. We’re dedicated to creating a positive and supportive culture where our team members can thrive. If you’re looking to use your skills and knowledge to make a difference in our members’ lives, Patelco could be the perfect fit for you.
Overview
In this role, responsibilities will include participating in design and development of Data Warehouse and ETL process. In this role the person must possess previous DW and ETL development experience and several related skills - Database design and translation, the ability to identify and troubleshoot any issues that arise in the database, designing queries and reports, and writing scripts within the database. In addition, this position will provide database support to other members in Analytics team and lead how to use the database efficiently and effectively.
Responsibilities
- Design and support the database and table schemas for new and evolving sources of data brought into the data warehouse
- Create and support the ETL to facilitate bringing data into the data warehouse using SQL Server Integration Services
- Create and support the SQL Server Analysis Services cubes to help with query performance
- Act as the go-to person for team members and leaders both inside and outside of the team
- Share best practices to help develop others
- Monitor and troubleshoot performance issues on the data warehouse servers
- Follow the design principles and best practices defined by the team for data warehousing techniques and architecture.
- Generate new ideas and execute on solutions that make a difference
- Participate in production code pushes after regular business hours.
- Participate in an on-call rotation as required.
- Performs other duties as assigned
Qualifications
- Bachelor’s degree in computer science or related field
- Expert-level SQL coding/querying skills in SQL Server and/or MySQL.
- 7+ years in database design, most of it towards data warehouse, using enterprise relationship database systems (MS SQL Server, Oracle or other relational database).
- 5+ Yrs experience with ETL development using tools such as Altreyx or Cloud Data Services
- Experience with Business Intelligence tools such as Crystal, Business Objects, Microsoft SSRS, or Informatica Data Hub, Dell Boomi or Oracle OBIEE.
- Experience with relational database design/modeling using tools such as ERstudio or ERwin.
- Prior Data or Core migration experience
- Financial Service Industry knowledge is a plus.
Target Base Pay
$120,170 - $150, 212
Compensation at Patelco
Please note that the salary information is a general guideline only. Patelco Credit Union considers factors such as (but not limited to) scope and responsibilities of the position, candidate's work experience, education/training, key skills, internal peer equity, as well as market and business considerations when extending an offer. We offer a competitive total rewards package including a Short-Term Incentive (STI) program for all regular positions and a wide range of medical, dental, vision, financial, and other benefits.