Senior Associate, Data Analytics Engineering

*****THIS POSITION IS NOT ELIGIBLE FOR VISA SPONSORSHIP***** To be considered for this position, applications and resumes are accepted only through our careers site by directly applying to the posted job. We do not accept unsolicited resumes or sales solicitations from staffing agencies. Any OCC employee wishing to submit a referral must do so through their Workday account. Any resume submitted outside of an active job posting will not be considered for employment. What You'll Do: This position will join OCC's centralized data analytics team to enhance organizational data analytics capabilities through close business partnership, requirements gathering, and solution delivery. The individual will collaborate extensively with the Data Engineering team to architect and develop the internal analytics data layer and maintain supporting ETL processes. The successful candidate will develop deep expertise in OCC's data models and provide cross-organizational support to maximize data utilization. They will tackle strategic data challenges affecting multiple teams by developing solutions that address immediate needs while anticipating future analytical requirements. This role involves both promoting and enforcing analytics standards while ensuring business teams have appropriate data access for BI reporting, dashboarding, and ad-hoc analysis needs. Primary Duties and Responsibilities: To perform this job successfully, an individual must be able to perform each primary duty satisfactorily. Design and maintain OCC analytics solutions drawing from both raw and semantic data layers Partner with business units to gather requirements and develop targeted analytics solutions Create data models ensuring information availability in the analytics warehouse for analysis and dashboard development Help establish Data Analytics standards and collaborate with embedded business analysts to ensure adherence Develop comprehensive documentation and testing protocols to guarantee data accuracy and accessibility Identify and distribute data and analytics best practices across the team Continuously expand knowledge of data and analytics engineering methodologies to enhance infrastructure maintainability and reliability Champion self-service capabilities and data literacy among business users through semantic layer utilization, analytics platforms (Tableau, Python), and CI/CD tools Pursue ongoing professional development in data analytics, cloud computing, options trading, and financial risk management to improve analytics infrastructure Provide guidance to business-embedded data analysts in addressing analytical challenges and support ad-hoc development needs 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] Strong Experience with data viz/prep tools (preferably Tableau and Alteryx) [Required] Experience with a source code version control repository system, branch management, pull requests (preferably Git) [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] 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 analyst, data engineer, software engineer, data scientist, financial risk analyst, business intelligence analyst Certificates or Licenses: [Preferred] 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 $84,700.00 - $145,600.00 Incentive Range 6% to 10% 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 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. These scams often include fake job offers, interviews or requests for financial and personal information. We take these matters seriously and want to ensure you stay informed and protected throughout your job search. Please keep the following in mind: OCC will never ask for payment or request personal banking information at any stage of the recruitment or career process. All official recruitment communications will come from a verified OCC email address ending in @theocc.com or the specific e-mail address of theocc@myworkday.com. Be cautious of messages from personal or non-company email addresses. Do not engage with or respond to suspicious emails or messages. If you are unsure about the legitimacy of a communication, verify the sender's email address and contact us directly. Hover over the sender's email address and confirm it ends with @theocc.com or myworkday.com and be alert for misspellings or added words. If you receive a suspicious email, text or phone call using OCC's name, please forward it to talentacquisition@theocc.com. Interviews OCC does not utilize video chat rooms (that is, Google Hangouts) to conduct interviews. OCC will only use our approved Zoom video interview platform. Your vigilance helps protect you and supports the integrity of our hiring process. Recognizing fraudulent communications Phishing emails often: Do not address you by name. Create a sense of urgency to prompt quick action. Contain links that lead to suspicious websites or malicious attachments. Include grammatical or spelling errors. A highly collaborative and supportive environment developed to encourage work-life balance and employee wellness. OCC provides equal employment opportunities to all employees and applicants for employment without regard to race, color, national origin, citizenship status, sex, sexual orientation, gender identity or expression, disability, age, marital status, religion, veteran status, or any other characteristics protected by applicable federal, state, or local laws. Numerous studies have shown that people from certain groups are less likely than others to apply to jobs if they believe they do not meet 100% of the requirements. We encourage everyone to review our open positions and apply if you think your experience may be a match, even if you do not meet all of the qualifications. Your perspective may be an element we need to continue building innovative solutions to support the markets and market participants we serve. If you need a disability related accommodation for any part of the application process, please email talentacquisition@theocc.com. 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. 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. 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.