Associate Principal, Data Analytics Engineering

What You’ll Do:

This role will drive a team responsible for expanding OCC’s analytics capabilities by making internal corporate data accessible and usable to analysts throughout the organization. This role will drive the design and build of our internal analytics data warehouse and the maintenance of the supporting extract, load, and transform processes. This role will also demonstrate expertise in OCC’s corporate data sets and support teams across the organization in successfully harnessing this data. This role will drive a team to collaborate with business users and technical teams across the organization to facilitate data-driven decision making by enabling exploration and analysis of historical and near real-time data access using on premise and cloud-based tools and technologies. This role will drive the team responsible for gathering requirements and designing solutions that address the problem at hand while also anticipating yet-to-be-asked analytical questions, as well as collaborating with, and mentoring, team members in defining and owning processes for developing and maintaining our analytics platform to meet the company’s security and IT standards.

Primary Duties and Responsibilities:

To perform this job successfully, an individual must be able to perform each primary duty satisfactorily.

•     Develop a batch process data ingestion framework for extraction from SaaS systems and loading to target location(s)

•     Build data models to ensure information is available in our analytics warehouse for downstream uses, such as analysis and dashboard development

•     Maintain performance requirements of our analytics warehouse by tuning warehouse optimizations and storage processes

•     Collaborate with DBAs to design access controls around our analytics warehouse to meet business and internal governance needs

•     Create documentation and testing to ensure data is accurate and easily understandable

•     Promote self-service capabilities and data literacy for business users leveraging the platform through development of training presentations and resources

•     Discover and share best practices for data and analytics engineering with members of the team

•     Invest in your continued learning on data and analytics engineering best practices and evaluate them for fit in improving maintainability and reliability of analytics infrastructure

•     Assist analysts in solving their analytics questions/challenges

Supervisory Responsibilities:

None

Qualifications:

The requirements listed are representative of the knowledge, skill, and/or ability required.  Reasonable accommodations may be made to enable individuals with disabilities to perform the primary functions.

• [Required] Ability to collaborate with multiple partners (e.g., Production Operations, DBAs, Data Architecture, Security) to craft solutions that align business goals with internal security and development standards

• [Required] Ability to communicate technical concepts to audiences with varying levels of technical background and synthesize non-technical requests into technical output

• [Required] Comfortable supporting business analysts on high-priority projects.[Required] High attention to detail and ability to think structurally about a solution

• [Required] Experience working within an agile environment

Technical Skills:

• [Required] Ability to write and optimize complex analytical (SELECT) SQL queries

• [Required] Applied knowledge of Python for writing custom pipeline code (virtual environments, functional programming, and unit testing)

• [Required] Experience with data viz/prep tools (preferably Tableau and Alteryx)

• [Required] Experience with a source code repository system (preferably Git)

• [Preferred] Experience setting up environments, configuration files, and application code with Linux shell (Bash)

• [Preferred] Familiarity with at least one cloud data platform, such as AWS or GCP

• [Preferred] Experience with data integration tools, such as Stitch or Fivetran

• [Preferred] Experience with warehouse transformation tools, such as dbt

• [Preferred] Experience integrating custom code with CI/CD tools, such as Jenkins

• [Preferred] Experience with SaaS tools and their backends, such as Jira and ServiceNow

• [Preferred] Exposure to data orchestration tools, such as Airflow

• [Preferred] Understanding of applied statistics and hands-on experience applying these concepts

Education and/or Experience:

• [Required] Bachelor’s degree in quantitative discipline (e.g., Statistics, Computer Science, Mathematics, Physics, Electrical Engineering, Industrial Engineering) or equivalent professional experience

• [Preferred] Master’s degree

• [Required] 7+ years of experience as a data engineer, analytics engineer, business intelligence analyst, data analyst, data scientist, or research analyst

Certificates or Licenses:

• None

Who We Are

The Options Clearing Corporation (OCC) is the world’s largest equity derivatives clearing organization. Founded in 1973, OCC is dedicated to promoting stability and market integrity by delivering clearing and settlement services for options, futures and securities lending transactions. As a Systemically Important Financial Market Utility (SIFMU), OCC operates under the jurisdiction of the U.S. Securities and Exchange Commission (SEC), the U.S. Commodity Futures Trading Commission (CFTC), and the Board of Governors of the Federal Reserve System. OCC has more than 100 clearing members and provides central counterparty (CCP) clearing and settlement services to 19 exchanges and trading platforms. More information about OCC is available at www.theocc.com.

What We Offer

A highly collaborative and supportive environment developed to encourage work-life balance and employee wellness. Some of these components include:

A hybrid work environment, up to 2 days per week of remote work

Tuition Reimbursement to support your continued education

Student Loan Repayment Assistance

Technology Stipend allowing you to use the device of your choice to connect to our network while working remotely

Generous PTO and Parental leave

Competitive health benefits including medical, dental and vision

Step 1
When you find a position you’re interested in, click the ‘Apply’ button. Please complete the application and attach your resume.  

Step 2
You will receive an email notification to confirm that we’ve received your application.

Step 3
If you are called in for an interview, a representative from OCC will contact you to set up a date, time, and location. 

For more information about OCC, please click here.

OCC is an Equal Opportunity Employer