Data Analyst Full Time

Apex Systems

NA

23rd Feb

Newport Beach, California

Primary Skills : Analyst, Consultant, IT, Analysis, Oracle, Excel, SQL.

Secondary Skills : Analytical, Risk Management, Business Analyst, Systems, Scripts.

No. of Positions : 1

Job Description

All interested candidates, please send your resume and availability to connect to Caitlyn Opulencia at

Data Analyst

This team is adding a data analyst to assist with delivering the vision of their Integrated Risk Platform. The vision calls for a single source of truth for risk data, for consistent risk reporting across divisional, risk pillar and aggregate views. And importantly to identify trends, analyze data connections across controls, risks, issues and organizational dimensions.

Responsibilities

  • Ensures consistent, complete, high quality risk data, is analyzed and available to stakeholders
  • Creates and maintains data dictionary
  • Consults on data architecture and data mart design
  • Coordination of data owners to ensure data completeness
  • Alignment with production support for data integrity
  • Consultant for development on data usage, interpretation and import templates
  • Coordination with IT on technology and Corporate Finance on best practices


Tasks

  • Preparation of periodic risk committee reports and dashboards
  • Provide useful interpretation of data/reports
  • Analysis of historical and current risk data
  • Data transformation from transactional system (archer) to data warehouse (ETL)
  • Using Oracle Analytics create custom queries, calculated fields, views and other techniques to enable presentation of data to range of stakeholders
  • Build and maintain views to enable end user reporting from single source of truth
  • Trending of behaviors shown through patterns in historical data
  • Presentation of findings through visualization and other reporting techniques
  • Mine/analyze database to identify actionable and business impacting insights
  • Analyze data with the intention of identifying insights that will assist in the company's long term growth and strategy


What it's not

  • Not predictive modelling or "full data science"
  • Not machine learning


Requirements

  • Bachelor's degree, ideally with Statistics major/minor
  • 2-5 years data analysis
  • Very strong report presentation skills
  • Oracle Analytics and Advanced Excel essential
  • SQL experience
  • GRC experience - ideally RSA Archer
  • Strong technically and strong communications
  • Analytical and problem-solving skills


Nice to have

  • 1-3 years' experience in Risk Management, Compliance, or Internal Audit reporting
  • Previous experience as a Business Analyst (as they will be translating requirements from areas they might be typically unfamiliar with, having those conversational skills, deciphering current reporting and translating to OAC, Excel, etc.)



EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or

Job Description

All interested candidates, please send your resume and availability to connect to Caitlyn Opulencia at

Data Analyst

This team is adding a data analyst to assist with delivering the vision of their Integrated Risk Platform. The vision calls for a single source of truth for risk data, for consistent risk reporting across divisional, risk pillar and aggregate views. And importantly to identify trends, analyze data connections across controls, risks, issues and organizational dimensions.

Responsibilities

  • Ensures consistent, complete, high quality risk data, is analyzed and available to stakeholders
  • Creates and maintains data dictionary
  • Consults on data architecture and data mart design
  • Coordination of data owners to ensure data completeness
  • Alignment with production support for data integrity
  • Consultant for development on data usage, interpretation and import templates
  • Coordination with IT on technology and Corporate Finance on best practices


Tasks

  • Preparation of periodic risk committee reports and dashboards
  • Provide useful interpretation of data/reports
  • Analysis of historical and current risk data
  • Data transformation from transactional system (archer) to data warehouse (ETL)
  • Using Oracle Analytics create custom queries, calculated fields, views and other techniques to enable presentation of data to range of stakeholders
  • Build and maintain views to enable end user reporting from single source of truth
  • Trending of behaviors shown through patterns in historical data
  • Presentation of findings through visualization and other reporting techniques
  • Mine/analyze database to identify actionable and business impacting insights
  • Analyze data with the intention of identifying insights that will assist in the company's long term growth and strategy


What it's not

  • Not predictive modelling or "full data science"
  • Not machine learning


Requirements

  • Bachelor's degree, ideally with Statistics major/minor
  • 2-5 years data analysis
  • Very strong report presentation skills
  • Oracle Analytics and Advanced Excel essential
  • SQL experience
  • GRC experience - ideally RSA Archer
  • Strong technically and strong communications
  • Analytical and problem-solving skills


Nice to have

  • 1-3 years' experience in Risk Management, Compliance, or Internal Audit reporting
  • Previous experience as a Business Analyst (as they will be translating requirements from areas they might be typically unfamiliar with, having those conversational skills, deciphering current reporting and translating to OAC, Excel, etc.)



EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or

Relevant Skill Jobs

Patelco Credit Union

Dublin

San Jose

Rockville

MD

Philadelphia

Tek Mahindra

Philadelphia

Latest Data Analyst Jobs