Data Modeler / Data Analyst - Enterprise Data Warehouse

Sacramento, CA Full Time
POSTED ON 2/8/2024
Data Modeler / Data Analyst - Enterprise Data Warehouse
ID 2024-3957 # of Openings 1 Category Technical Consulting Telecommute No Work Site - State CA Security Clearance Level None Required Maximum Expected Travel None Type Any (Full-Time or Subcontract)
Job Overview & Responsibilities

Mythics is seeking an experienced Data Modeler / Data Analyst to support the design, development, testing, and implementation of a new Enterprise Data Warehouse and Enterprise Analytics Solution in the Oracle Public Cloud. Onsite 2-3 days a week required. Work hours 8am-5pm.

Key Duties/Responsibilities:

    Performs business and systems analysis and documentation
  • Develops conceptual and dimensional data models for the enterprise data warehouse
  • 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

Required:

  • Bachelor's degree in Computer Science or related field and/or equivalent work experience
  • 10 years of work experienceMinimum 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.

Desired:

  • Expert level Kimball Dimensional Data Modeling experience
  • Expert level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle.
Company Overview
Why work at Mythics?

Because at Mythics, YOU count! At Mythics, our Corporate Values are at the foundation of everything we do. Our values, Respect - Empathy - Excellence - Fun (REEF), have created an environment that fosters creative thinking, respects your contributions, and accepts nothing less than excellence in serving our customers.

At Mythics, you will experience a truly enjoyable corporate culture. But don't just take our word for it! Mythics has been named one of Virginia's Best Places to Work for 8 consecutive years!

Thanks to our flexible benefits options, you can choose the benefits you want or need. Our benefit options include:

  • Comprehensive Health, Dental, and Vision plans
  • Premier 401k retirement plan with corporate matching and a 529 college saving plan
  • Tax-advantaged Health Savings Account and Dependent Care Flexible Spending Account options
  • Legal Resources

In addition to our optional benefits, all full-time employees enjoy:

  • Generous work/life balance opportunities supported by a PTO bank, paid holidays, leave programs and additional flex time off
  • Employee referral program
  • Employee recognition, gift and reward program
  • Tuition reimbursement for continuing education
  • Remote or hybrid work options
  • Engaging company events such as team building activities, quarterly awards, annual kick-off parties
  • Employee Resource Groups such as our Values & Women's Leadership Committees - Focusing on charitable and volunteering events to give back to our community, creating an inclusive environment for all, and fun employee activities
  • Health and wellness-focused activities
  • Relaxation Spaces
  • In-office gourmet coffee, tea, fresh fruit and healthy snacks
  • Corporate GREEN approach - tracking energy consumption for reduction and purchasing only environmentally friendly products for our offices

Founded in 2000, Mythics is an award-winning Oracle systems integrator, consulting firm, managed services provider and elite Oracle platinum resale partner. Our business model is all about deep knowledge of Oracle technologies and business processes. We offer procurement and Oracle systems integration expertise across the full range of Oracle cloud, software, support, hardware, engineered systems, and appliances. It's a focus that gives us the critical business experience and the Oracle technology advantage you need to succeed.

Mythics, LLC is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity, age, marital status, medical condition, veteran status, or any other factor determined to be unlawful by federal, state, or local statutes. Mythics, LLC will treat all employees equally with respect to compensation; opportunities for advancement, including upgrading, promotion and transfer, and all other terms and conditions of employment. This company is a VEVRAA Federal Contractor, and has designed and agreed to implement an Affirmative Action Program in accordance with Executive Order 11246 and VEVRAA Final Rule. Mythics, LLC is able to provide alternative methods of application for those who are unable to complete an online form. Please contact accommodationrequests@mythics.com to arrange reasonable accommodations. To read more about your rights, please visit the Department of Labor Disability Rights Fact Sheet here. For more information about Federal laws prohibiting job discrimination, please view the "EEO is the Law" Poster here.

Need help finding the right job?
We can recommend jobs specifically for you! Click here to get started.

 

Salary.com Estimation for Data Modeler / Data Analyst - Enterprise Data Warehouse in Sacramento, CA
$112,385 to $148,916
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

Sign up to receive alerts about other jobs with skills like those required for the Data Modeler / Data Analyst - Enterprise Data Warehouse.

Click the checkbox next to the jobs that you are interested in.

  • Big Data Skill

    • Income Estimation: $88,069 - $110,597
    • Income Estimation: $114,118 - $141,342
  • Big Data Analytics Skill

    • Income Estimation: $88,069 - $110,597
    • Income Estimation: $114,118 - $141,342
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Mythics, Inc

Mythics, Inc
Hired Organization Address Virginia, VA Full Time
Presales Engineer ID 2023-3892 # of Openings 1 Category Technical Consulting Work Site - City Any Major US City Telecomm...
Mythics, Inc
Hired Organization Address Virginia, VA Full Time
Senior Project Specialist ID 2024-3988 # of Openings 1 Category Technical Consulting Work Site - City Remote Telecommute...
Mythics, Inc
Hired Organization Address Virginia, VA Full Time
Job Overview & Responsibilities The Operations Support Analyst focuses on the operational aspects of consulting projects...
Mythics, Inc
Hired Organization Address Virginia, VA Full Time
Job Overview & Responsibilities The S&L SaaS Account Manager will be responsible for generating new sales leads, qualify...

Not the job you're looking for? Here are some other Data Modeler / Data Analyst - Enterprise Data Warehouse jobs in the Sacramento, CA area that may be a better fit.

Assistant Chief Data Officer

CA Office of Data and Innovation, Sacramento, CA