Senior Associate, Data Analytics Engineering

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: 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 following qualifications are required and/or preferred: Ability to collaborate with multiple partners to craft solutions that align business goals with internal processes, security, and delivery standards Ability to communicate technical concepts to audiences with varying levels of technical background and synthesize non‑technical requests into technical output Comfortable supporting business analysts on high‑priority projects High attention to detail, tradeoffs, and an ability to think structurally about a solution Technical Skills: Ability to write and optimize complex analytical (SELECT) SQL queries Ability to write and optimize Python for custom data pipeline code Strong experience with data viz/prep tools (preferably Tableau and Alteryx) 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 (AWS, Azure, Databricks, Snowflake) Preferred: Familiarity with data modeling design concepts such as 3rd‑normal form or denormalization (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: 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 3+ years of experience as a data analyst, data engineer, software engineer, data scientist, financial risk analyst, or business intelligence analyst Certificates or Licenses: BI tool certification (preferred) Financial Analyst certification (preferred) Benefits: A hybrid work environment, up to 2 days per week of remote work Tuition Reimbursement to support continued education Student Loan Repayment Assistance Technology Stipend allowing use of device of choice while working remotely Generous PTO and Parental leave 401(k) Employer Match Competitive health benefits including medical, dental and vision Compensation: The salary range listed is exclusive of fringe benefits and potential bonuses. Final base salary will be determined by skills, experience, and/or education. We typically do not hire at the maximum of the range in order to allow for future and continued salary growth. All employees may be eligible for a discretionary bonus based on company and individual performance. Salary Range: $84,700.00 - $145,600.00 Incentive Range: 6% to 10% This position is eligible for an annual discretionary incentive compensation award with a target range listed above. The amount of such award, if any, will be based on various factors, including but not limited to both individual and company performance. OCC is an Equal Opportunity Employer. #J-18808-Ljbffr