Senior Data Engineer

Why join OCLC? 

OCLC is consistently recognized as a best place to work by several independent programs. We recognize and reward people and results with a comprehensive Total Rewards package. This means competitive compensation that reflects your unique contributions—performance, experience, and skills—along with exceptional benefits, including best-in-class health coverage, retirement plans with generous company contributions, and a commitment to your overall well-being.

• We know the best ideas don’t always happen at a desk. Take a walking meeting around our 100-acre campus or enjoy lunch on the patio. We’re committed to your success—both personally and professionally. Hybrid work environment: For many roles, three days a week on-site, with occasional additional days based on business needs. 

• Free use of our on-site fitness center, gym sports, group exercise classes, and game room 

• Onsite catering and cafeteria subsidized by OCLC 

• Health and wellness events 

• Work environments with individual and team spaces and the latest technology tools 

• Paid parental leave and adoption assistance 

• Tuition reimbursement and Public Service Loan Forgiveness eligibility 

• Company-subsidized pricing on local tickets and memberships 

Join us in transforming how people everywhere access information and be part of a mission-driven team that makes a global impact. 

The job details are as follows:

We’re seeking a seasoned Senior Data Engineer to join our Analytics team and drive the design, development, and optimization of high scale data solutions. In this role, you’ll architect and support end to end ETL pipelines—leveraging Informatica PowerCenter—to ingest, transform, and curate data from internal systems and SaaS platforms into our enterprise data warehouse, data lake, data marts, and other downstream analytics platforms. You’ll serve as both the data modeling expert and a key contributor to our DataOps and Data Quality programs, partnering with stakeholders to translate business requirements into reliable, performant analytics assets. We need engineers that that embrace AI as a tool to move us with speed and execution in our ETL space. If you thrive in a collaborative, fast paced environment and are passionate about building scalable, best in class data architectures, we’d love to hear from you.

Responsibilities

• Collaborate with team members to collect business requirements, define successful analytics outcomes, and design data models
• Design, develop, and maintain ETL workflows using Informatica PowerCenter, ensuring reliable, performant pipelines from internal databases and SaaS applications
• Write performant code that meets our internal standards for style, maintainability, and best practices for a high-scale data environment. Maintain and advocate for these standards through code review.
• Serve as the Data Model subject matter expert and data model spokesperson, demonstrated by the ability to address questions quickly and accurately
• Provide data modeling expertise to other OCLC teams and departments through code reviews, pairing, and training to help deliver optimal, DRY, and scalable database designs and queries
• Ship medium to large features independently
• Subject Matter Expert for sections of the Enterprise Metadata Platform, a scalable resource to support Self-Service and Single-source-of-truth analytics
• Advocate for the Data Quality Program and Trusted Data Development process to help ensure all data is profiled, reviewed, and accurate to support critical decisions
• Implement the DataOps philosophy in everything you do
• Understand and implement data engineering best practices
• Improve, manage, and teach standards for code maintainability and performance in code submitted and reviewed
• Create smaller merge requests and issues by collaborating with stakeholders to reduce scope and focus on iteration
• Generate architecture recommendations and the ability to implement them
• Perform technical interviews
• Organize and plan development initiatives
• Implement new data engineering and analytics methodologies with minimal guidance and support from other team members
• Regularly participate in the Data Community/Industry outside of OCLC through writing, speaking, and/or networking

Qualifications

• Bachelor’s degree in a Computer Science related discipline required and skills usually represented by 4-6 years of software development or project management experience
• 4+ years in the Data space as an analyst, engineer, or equivalent
• 4+ years working with a large-scale (1B+ Rows) Data Warehouse, preferably in a cloud environment
• 2+ years managing the same data model system over time, evolving the model to meet new business requirements
• Extensive experience in 2 or more major data subject areas (finance, product, etc.)
• Professional experience using Python, Java, or Scala for data processing (Python preferred)
• Demonstrated experience leading 4 or more analytics projects from beginning to operationalization
• Demonstrated experience designing and socializing Entity Relationship Diagrams and reference SQL scripts to scale data acumen and adoption
• Experience working with multiple commercial data warehouses, ETL tools, and data visualization tools
• Familiarity with unit testing, integration testing and performance/stress testing
• Excellent oral and written communication skills: regularly achieve consensus amongst technical and business teams

Working Conditions: Normal office environment. Hybrid position requires three days in office.

ADA/EAA: The above statements cover what are generally believed to be the principal and essential functions of this job. Specific circumstances may allow or require some people assigned to the job to perform a somewhat different combination of duties.