OCLC, Inc.
Senior Software Architect, ETL (Information Technology)
At OCLC, we believe you'll do the best work of your life when you're living the best life possible.
We work hard to build the technology that connects thousands of today's libraries. But we also work hard to make a job at OCLC a meaningful part of a balanced life- not a substitute for one.
Technology with a Purpose. OCLC supports thousands of libraries in making information more accessible and more useful to people around the world. OCLC provides shared technology services, original research and community programs that help libraries meet the ever-evolving needs of their users, institutions, and communities. With office locations around the globe, OCLC employees are dedicated to offering premier services and software to help libraries.
The Job Details are as follows:
We are seeking a skilled Senior Architect to support the architecture and functioning of ETL pipelines that flow data into our big data infrastructure. You will collaborate with multiple teams to address new business requirements and look for opportunities to redesign existing flows for enhanced performance and cost-efficiency. Ideal candidates are comfortable with both hands-on technical work and high-level design. Experience with Snowflake is strongly preferred.Responsibilities:
Assumes technical leadership and is the architect for major OCLC systems or concepts.
Evaluates and recommends major changes to development practices and continually seeks improvements to development procedures in areas such as data modeling, manipulation, and transformation; system performance and design; and interpretation of all OCLC ISO-9000 procedures and the SDLC as they pertain to their work unit.
Identifies new opportunities with 3rd party solutions and technique for OCLC applications with the ability to understand the impact and analyze the risk.
Analyze and solve problems in existing systems.
Participates in and leads major architectural reviews and plans.
Prototypes systems in anticipation of new requirements and develops functional requirements from prototype systems.
Ensures that information and trends within their area of expertise are effectively communicated to relevant business units within OCLC.
Design, code, and test multiple modules of a system in a timely manner.
Uses industry standard techniques to translate requirements and designs into code.
Ensures that project teams plan and execute load, capacity, and performance analysis
Other tasks as assigned.
Qualifications:
Master's degree required plus 8 to 12 years of experience at a high technical level of knowledge and experience. (Equivalent experience without a master's degree is 10 to 14 years of experience at a high technical level of knowledge and experience.)
Demonstrated a proven ability to provide corporate wide leadership in their area of expertise.
Has technical leadership experience with one or more aspects of enterprise data: data warehousing, data modeling, data ETL, or analytics
Has hands-on experience in a technical role using some combination of PowerBI, Python, Java, Spark, and SQL
Extensive knowledge of large-scale database technology preferably Snowflake
Ability to implement industry-standard data modeling, management, and governance techniques by mastering advanced fundamental data modeling concepts, practices, and procedures, and having the ability to analyze and solve problems in existing systems.
Working Conditions: Normal office environment.
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.