DataJobs.io
← Back to all jobs

Job Description

Patelco Credit Union is seeking a Sr. Data Engineer to strengthen its data platform in Dublin, CA. In this onsite role, you will help design and deliver core data warehouse components, build ETL workflows, and improve query performance through SQL Server Analysis Services.

What you will do

  • Design and support database and table schemas for new and evolving data sources feeding the data warehouse
  • Build and maintain 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 resource for team members and leaders inside and outside of the team
  • Share best practices to support the development of others
  • 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 difference
  • Participate in production code pushes after regular business hours
  • Join 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 skills for SQL Server and/or MySQL
  • 7+ years of database design experience, with most focused on data warehousing, using enterprise relational database systems (including MS SQL Server, Oracle, or similar)
  • 5+ years of 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, plus 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
  • Knowledge of the Financial Services Industry is a plus

Tools and 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 and benefits

Target base pay: USD 120,170 - 150,212 per year.

Compensation at Patelco: salary information is a general guideline only. Patelco Credit Union considers factors such as scope and responsibilities, candidate work experience, education and training, key skills, internal peer equity, and market and business considerations when extending an offer.

  • 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)

Similar Jobs