Data Modeler/Data Analyst - West End Solutions Group Inc.

Data Modeler / Data Analyst

Are you ready to embark on a transformative journey in data analysis? We seek a seasoned Data Modeler / Data Analyst with expertise in understanding the methodologies and approaches around data modelling and data analysis.

Work Environment

• Be willing and able to work in the Sacramento, CA office 2-3 days per week.
• Be willing and able to work 8 a.m. - 5 p.m. PT.

Key Responsibilities

• Performs business and systems analysis and documentation
• Develops conceptual and dimensional data models for the enterprise data warehouse
• Performs data modelling in relational and dimensional models
• Develop physical data model and/or work with the architect to develop a 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 modelling.
• Mentors and educates team members on best practices and industry standard

Mandatory

• 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 and dimensional data modelling, statistical analysis, and machine learning supportive of key duties/responsibilities identified above.

• Expert-level Kimball Dimensional Data Modeling experience
• Expert-level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle.

Why Join Us:

• Be at the forefront of innovation in data, contributing to developing state-of-the-art solutions.
• Work in a dynamic and collaborative environment where your expertise will be valued and recognized.
• Enjoy flexibility and diversity while contributing to long-term strategic initiatives.

If you are passionate about shaping the future of data analysis and possess the skills, expertise, and desired certifications to drive transformative change, apply now to be a key player in our journey toward data excellence. Together, let's redefine what's possible in the world of data.