Sr. Data Engineer
Job Description
Patelco Credit Union is hiring a Senior Data Engineer to strengthen its data platform in Dublin, CA. In this onsite role, you will design and build core data warehouse capabilities, streamline ETL flows, and help improve analytics performance through SQL Server Analysis Services.
You will work on database structures and data movement processes that support new and evolving data sources, while also serving as a trusted technical point of contact for teammates and leaders.
What you’ll do
- Design and support database and table schemas for new and changing data sources feeding the data warehouse
- Create and support ETL processes to load data into 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 person for team members and leaders inside and outside the team
- Share best practices to help develop others
- Monitor and troubleshoot data warehouse server performance issues
- Follow established design principles and best practices 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
- Perform other duties as assigned
What you bring
- Bachelor’s degree in computer science or a related field
- Expert-level SQL coding and querying skills in SQL Server and/or MySQL
- 7+ years of database design experience, with most focused on data warehousing, using enterprise relational database systems such as MS SQL Server, Oracle, or other RDBMS
- 5+ years of ETL development experience using tools such as Altreyx or Cloud Data Services
- Experience with Business Intelligence tools including Crystal, Business Objects, Microsoft SSRS, or Informatica Data Hub, Dell Boomi, or Oracle OBIEE
- Experience with relational database design and modeling using tools such as ERstudio or ERwin
- Prior Data or Core migration experience
- Financial service industry knowledge is a plus
Technologies
- 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
- Target base pay: USD 120,170 - 150,212 per year
- Compensation at Patelco: salary information is a general guideline only; Patelco Credit Union considers scope and responsibilities, candidate work experience, education/training, key skills, internal peer equity, and market/business considerations when extending an offer
Benefits
- Competitive total rewards package including a Short-Term Incentive (STI) program for all regular positions
- Wide range of medical, dental, vision, financial, and other benefits
Location: Dublin, CA (onsite)