Senior Data Analyst / Data Modeler

Requirements:
Senior, hands-on data modeler with strong communication skills.
Strong ability to articulate data modeling principles and gather requirements from non-
technical business stakeholders
Excellent presentation skills to different (business and technical) audiences ranging from
senior level leadership to operational staff with no supervision
Ability to translate business and functional requirements into technical requirements for
technical team members.
Candidate needs to be able to demonstrate, direct hands-on recent practical experience
in the areas identified with specific examples.
Key Duties/Responsibilities:
Performs business and systems analysis and documentation
Develops conceptual, logical, and dimensional data models for the enterprise data
warehouse
Experience with large data warehouse implementation projects
Performs data modeling in relational and dimensional models
Develops physical data model and/or works with architect to develop physical data
model
Develops Data Facts and Dimensions in the EDW
Provides documentation to support the Kimball Dimensional Data Modeling Framework
Visualizes and designs the enterprise data management framework: specifies processes
used to plan, acquire, maintain, use, archive, retrieve, control, and purge data
Documents data flow diagrams in existing and future reports to use as input in report
design and optimization
Develops Requirements Specifications
Develops Design Specifications
Performs data analysis/predictive data modeling
Mentors and educates team members on best practices and industry standards
Qualifications:
Mandatory:
Minimum of ten (10) years demonstrable experience in the data management space
with at least 5 years specializing in database design
Minimum of five (5) years of experience as a data analyst or in other quantitative
analysis or related disciplines, such as researcher or data engineer supportive of key
duties/responsibilities identified above.
Minimum of five (5) years of relevant experience in relational data modeling and
dimensional data modeling, statistical analysis, and machine learning supportive of key
duties/responsibilities identified above.
Excellent communication and collaboration skills to work effectively with stakeholders
and team members.
At least 2 years experience working on Star, Snowflake, and/or Hybrid schemas

Desired:
At least 2 years experience working on Oracle Autonomous Data Warehouse (ADW)
specifically installed in an OCI environment.
Expert level Kimball Dimensional Data Modeling experience
Expert level experience developing in Oracle SQL Developer or ER/Studio Data
Architect for Oracle.
Ability to develop and perform Extract, Transform and Load (ETL) activities using Oracle
tools with at least 2 years experience.Ability to perform technical leadership of a Oracle
data warehouse team including but not limited to ETL, requirements solicitation, DBA,
data warehouse administration, and data analysis on a hands-on basis.