• Lead Data Warehouse Architect

    Posted Date 1 month ago(2/26/2019 11:24 AM)
    # of Openings
    Work Site - City
    Consulting Technical Services - Platform
    Work Site - State
    Security Clearance Level
    None Required
    Maximum Expected Travel
    Regular Full-Time
    Remote/Telecommute Available?
    No - Applicants Must be Local to Work Site
  • Job Overview & Responsibilities

    Mythics is looking for a Lead Data Warehouse Architect who will work at our client site in Brooklyn, NY. The Lead Data Warehouse Architect is responsible for the design, delivery, implementation of the data models, and physical data warehouse structures. This includes working with the business users, other team Architects and Developers to implement and design the OBIEE RPD physical, business and presentation layers. You will mentor the entire team on various aspects of Data Warehouse development and implementation from the database design to testing. In conjunction with the BI developers, you will create metadata layers, reports and dashboards. You will perform project management related duties, including creating and managing schedules. Additionally, you will work with the Sr. PL/SQL and ETL developers to provide guidance on loading the data into the physical data structures of the data warehouse. Finally, for any data related security, you will implement and test any security configuration and requirements to include user/group setup, permissions setup and validation.


    • Minimum of a Bachelor’s Degree and/or equivalent work experience

    • Must be a US Citizen to obtain necessary clearance

    • PMP strongly desired

    • CSM strongly desired

    • 2+ years of Oracle PL/SQL experience
    • 2+ years of OBIEE experience including building the RPD layers
    • 1+ year of ODI
    • 7+ years of Data Architecture
    • 2+ Oracle DBA experience
    • 1+ years of Oracle MDM
    • 1+ years of Big Data Experience (Oracle stack)
    • A strong Oracle background including Data Architecture, and Oracle BI stack (PL/SQL, OBIEE, ODI, BI Publisher) is a must
    • Experience in Big Data specifically Cloudera and the Oracle Bid Data Appliance stack
    • Master Data Management implementation, both technically and functionally
    • Strong Oracle DBA skills in a Data Warehouse environment
    • Excellent Data Warehouse tuning skills, including configuration, implementations and understanding of specific Oracle database techniques
    • Good understanding of Dimensional Data Modeling
    • Understanding of the underlying technology including setup, tuning and administration
    • Knowledge and experience implementing Big Data as part of a larger Data Warehouse solution
    • Golden Gate experience is a plus
    • Experience with OBIEE migration through the full life cycle
    • Experience configuring and developing in a MUD environment
    • Work with users to design and develop OBIEE reports and dashboards
    • Ability to test the entire solution
    • Experience collecting, analyzing and documenting user requirements
    • Project Management experience in an agile environment
    • Excellent communications skills to interact with client and other developers, including training and mentoring of team members
    • Project Leadership skills including understanding, designing, and implementing the technical solution as well as leading the entire technical team to ensure that they follow the approach and meet deadlines.
    • Ability to work as a collaborative team, mentoring and training the client and other Mythics staff on the various tools and techniques to build a complete Analytics solution

    Company Overview

    Why work at Mythics?

    Because at Mythics, YOU count!  
    At Mythics, we have an environment that fosters creative thinking, respects your contributions, and accepts nothing less than excellence in serving our customers.  We demonstrate these core principles daily through our corporate Values of Respect – Empathy – Excellence – Fun (REEF). Our REEF values are the foundation of everything we do.

    • Comprehensive Health, Dental, and Vision plans available for you and your family
    • Premier 401k retirement plan with corporate matching and a 529 college saving plan
    • Tax-advantaged Health Savings Accounts and Flexible Spending Account options
    • Generous PTO bank and paid holidays
    • Tuition reimbursement for continuing education
    • Engaging company events such as quarterly awards, annual kick off parties, and FUN Friday’s (early release once a month)
    • Free gourmet coffee, tea, fresh fruits and healthy snacking alternatives
    • Community Service activities and charitable giving programs
    • Our 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, Inc. 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, Inc. 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, Inc. 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.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us!

    Don't see any positions that match your skillset? Not ready to apply? You can still Connect with us for future consideration!