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
Requirements
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 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 analy
Additional Information
*****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.
Theocc · Chicago - 125 S Franklin