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 focused on data warehousing with enterprise relational database systems
5+ years of ETL development experience using tools like Alteryx or Cloud Data Services
Familiarity with Business Intelligence tools such as Crystal Reports, Microsoft SSRS, or Informatica Data Hub
Experience in relational database design/modeling with tools like ERstudio or ERwin
Knowledge of the Financial Services industry is a plus
Responsibilities
Design and support database and table schemas for new data sources
Create and maintain ETL processes using SQL Server Integration Services
Develop and support SQL Server Analysis Services cubes for improved query performance
Serve as the primary resource for team members and leaders
Share best practices to enhance team development
Monitor and troubleshoot performance issues on data warehouse servers
Adhere to design principles and best practices for data warehousing
Generate innovative ideas and implement effective solutions
Participate in production code pushes after hours
Engage in on-call rotation as needed
Benefits
Comprehensive medical, dental, and vision coverage
Short-Term Incentive (STI) program for regular positions
Financial benefits including retirement plans
Wide range of additional benefits
Full Job Description
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.
About Patelco Credit Union
Patelco Credit Union is a credit union that serves the San Francisco Bay Area. It was founded in 1936 and is headquartered in Pleasanton, California. The credit union offers a wide range of financial products and services including checking accounts, savings accounts, loans, and credit cards. Patelco Credit Union has over 300,000 members and over $7 billion in assets.