Senior Associate, Data Analytics Engineering

What You'll Do

This role will be an active contributor to the design and build of the semantic layer of OCC's data platform in our analytics zone. They will become an expert on OCC's core business data sets to support teams across the organization to successfully harness the data. The role will also work on strategic data challenges, with a strong focus on business user requirements gathering, system design and implementation of shared analytics infrastructure, building proof-of-concepts, and evolving our analytics platforms to meeting the evolving needs of analytics developers while also meeting 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.

• Support the design and implementation of cloud infrastructure for internal analytics zone in collaboration with OCC's Data Platform team, data architects, DevOps, IT

• Assist in the build, test, and deploy semantic layer's virtual and physical data models that simplify complex semi-structured data, eliminate multiple definitions of similar data, create query-friendly datasets, and standardize column naming for downstream users that are developing quantitative analytics, dashboards, and internal risk applications.

• Assist in maintaining performance and accuracy SLAs for semantic layer and other data products through observability practices, ensuring proactive detection of system failures and incident response

• Learn user wants, motivations, priorities, and "the why" as part of eliciting business requirements with business users from various risk management departments

• Work with upstream data producers to understand how their systems work, how they generate data, and how that is subject to change over time to help manage schema drift

• Collaborate with Data Governance, Data Platform Team, and DBAs to design access controls to data platform that meet business and internal governance needs

• Create documentation and testing to ensure data lineage is traceable and semantic layer components are easily discoverable and useful to business users

• Support the implementation of ETL and data serving solutions for large datasets generated by our risk models that meet critical business user SLAs around latency and access patterns

• Promote self-service capabilities and data literacy for business users leveraging the semantic layer, other analytics platforms (e.g. Tableau, python), and CI/CD tools

• Invest in your continued learning of on data engineering best practices, cloud computing, options trading industry, and financial risk management, with an eye towards improving maintainability, reliability, and utility of our analytics infrastructure

• Assist risk analysts in solving their analytics questions/challenges and support ad-hoc development with them, as needed.

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. Business Users, Data and Solution Architects, Data Governance and IT teams -- Data Platform Team, Systems & Infrastructure, Security, DevOps, Networking) to craft solutions that align business goals with internal processes, security, and delivery standards in mind.

• [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, tradeoffs, and an ability to think structurally about a solution

Technical Skills:

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

• [Required] Ability to write and optimize python for custom data pipeline code (virtual environments, scripts vs. modules vs packages, functional programming, unit testing)

• [Required] Experience with a source code version control repository system, branch management, pull requests (preferably Git)

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

• [Preferred] Experience with transformation/semantic layer frameworks, such as dbt

• [Preferred] Familiarity with services on at least one cloud computing platform, such as AWS or Azure, or a cloud data platform such as Databricks or Snowflake

• [Preferred] Familiarity with data modeling design concepts such as 3rd-normal form or denormalization modeling concepts such as star-schema

• [Preferred] Exposure to batch orchestration tools such as Apache Airflow, Dagster, or Prefect

• [Preferred] Experience working with a linux shell and software containers for portable code distribution and execution, like docker

• [Preferred] Experience with privileged access management platforms, such as CyberArk or Hashi Vault

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

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

Education and/or Experience:

• [Required] Bachelor's or Master's degree in a quantitative discipline (e.g., Statistics, Computer Science, Mathematics, Physics, Data Science, Electrical Engineering, Information Systems) or equivalent professional experience

• [Required] 3+ years of experience as a data engineer, software engineer, data scientist, financial risk analyst, business intelligence analyst

Certificates or Licenses:

• [Preferred] Cloud platform certification, or

• [Preferred] Data Engineering or BI tool certification, or

• [Preferred] Financial Analyst certification

About Us

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.

Benefits

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
• 401k Employer Match
• Competitive health benefits including medical, dental and vision

Visit https://www.theocc.com/careers/thriving-together for more information.

Compensation

• The salary range listed for any given position is exclusive of fringe benefits and potential bonuses. If hired at OCC, your final base salary compensation will be determined by factors such as skills, experience and/or education.
• In addition, we believe in the importance of pay equity and consider internal equity of our current team members as part of any final offer.
• We typically do not hire at the maximum of the range in order to allow for future and continued salary growth. We also offer a substantial benefits package as noted on www.theocc.com/careers
• All employees may be eligible for a discretionary bonus. Discretionary bonuses are based on various factors, including, but not limited to, company and individual performance and are not guaranteed.

Salary Range

Incentive Range

This position is eligible for an annual discretionary incentive compensation award, for which the target range is listed above (see Incentive Range). The amount of such award, if any, will be based on various factors, including without limitation, both individual and company performance.

Step 1
When you find a position you're interested in, click the 'Apply' button. Please complete the application andattach 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