Sr. Data Engineer
Job Description
Patelco Credit Union is seeking a Sr. Data Engineer to support the design, build, and ongoing optimization of its data platform. This role focuses on data warehouse and ETL development, including schema support, performance troubleshooting, and SQL Server Analysis Services cube creation to improve query responsiveness. This position is based in Dublin, CA and is onsite.
What you will do
- Design and support database and table schemas for new and changing data sources entering the data warehouse
- Build and maintain ETL workflows to load the data warehouse using SQL Server Integration Services
- Create and support SQL Server Analysis Services cubes to improve query performance
- Serve as a go-to resource for team members and leaders inside and outside of the team
- Share best practices that help others develop
- Monitor and troubleshoot performance issues on data warehouse servers
- Follow team design principles and best practices for data warehousing techniques and architecture
- Generate new ideas and execute solutions that make a measurable impact
- Participate in production code pushes after regular business hours
- Participate in an on-call rotation as required
- Perform other duties as assigned
What you bring
- Bachelor’s degree in computer science or a related field
- Expert-level skills in SQL coding and querying in SQL Server and/or MySQL
- 7+ years of experience in database design, with most experience focused on data warehousing using enterprise relational database systems such as MS SQL Server and Oracle (or other relational databases)
- 5+ years of ETL development experience 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 (including Dell Boomi or Oracle OBIEE)
- Experience with relational database design and modeling tools such as ERstudio or ERwin
- Prior data or core migration experience
- Financial Services Industry knowledge is a plus
Technologies you may work with
- SQL Server Integration Services
- SQL Server Analysis Services
- SQL, MySQL, MS SQL Server
- Oracle
- Altreyx
- Cloud Data Services
- Crystal
- Business Objects
- Microsoft SSRS
- Informatica Data Hub
- Dell Boomi
- Oracle OBIEE
- ERstudio, ERwin
Compensation and benefits
Salary: USD 120,170 - 150,212 per year.
Benefits: Patelco offers a competitive total rewards package, including a Short-Term Incentive (STI) program for all regular positions, plus a wide range of medical, dental, vision, financial, and other benefits.
Compensation at Patelco: salary information is a general guideline only. Patelco Credit Union considers factors such as scope and responsibilities of the position, candidate work experience, education/training, key skills, internal peer equity, and market and business considerations when extending an offer.