Fast Facts

OCLC is looking for a Senior Data Engineer to join their Analytics team, responsible for designing and optimizing data solutions and ETL pipelines in a hybrid work environment.

Responsibilities: Key responsibilities include collaborating on business requirements, developing ETL workflows with Informatica PowerCenter, and advocating for data quality and best practices.

Skills: Required skills include expertise in data modeling, proficiency in Python, Java or Scala, and experience with large-scale data warehouses and ETL tools.

Qualifications: Candidates should have a Bachelor's degree in Computer Science and 4-6 years of experience in data-related roles, with proven project leadership.

Location: This position is based at the Corporate Office in Dublin, United States, with a hybrid work model.

Compensation: Not provided by employer. Typical compensation ranges for this position are between $110,000 - $160,000.

Together we make breakthroughs possible.

At OCLC, we build technology with a purpose: to connect libraries and make knowledge accessible worldwide, because we believe that what is known must be shared. Our teams work with complex global datasets, AI and machine learning, hybrid cloud solutions, and other technologies that connect people and organizations to the information they need. We value the power of unique perspectives and experiences to unlock innovation. At OCLC, your ideas matter, whether you have two years of experience or 20. You’ll learn, create, and problem-solve with technologists, product developers, librarians, researchers, marketing pros, and support teams around the world.

Why join OCLC?

OCLC is consistently recognized as a best place to work by several independent programs Werecognize and rewardpeople and resultswith 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 informationand 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.