Data Warehouse Architect

2 months ago
# of Openings
Work Site - City
Consulting Technical Services - Analytics
Work Site - State
Security Clearance Level
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 Data Warehouse Architect who will be based out of Vienna, VA but willing to travel to clients up to 50%.


The ideal developer will have a range of experience in architecting solutions including a strong Oracle background in Data Architecture, Data Modeling, Data Governance in addition to strong implementation skills in areas such as Oracle DB , PL/SQL, OBIEE, ODI, Informatica and other considerations. The candidate must also have a background in strong technical team leadership and knowledge of Microsoft Project to create and manage schedules.  The ideal candidate will have knowledge of Exadata and Exalytics, as well.  The qualified candidate must be willing to travel as needed for various projects.



Job Description


The Data Warehouse Architect will be responsible for the successful delivery of  data warehouse solutions and related components.  The candidate will have strong PL/SQL, OBIEE, Fusion Middleware and database design experience.  The candidate must also have familiarity with JAVA and various ETL tools. Design data ingestion components and ETL to collect data from various sources.

  • Dimensional Data Modeling
  • Data Architecture
  • Understanding of the underlying technology including setup, tuning and administration
  • Strong knowledge of Implementing and Design the OBIEE RPD physical, business and presentation layers
  • Work with user to design and develop OBIEE reports and dashboards
  • Experience with ODI and Informatica ETL tools
  • Test the entire solution
  • Strong Project Leadership skills including MS Project
  • Ability to work as a collaborative team, mentoring and training the client on the various tools and techniques to build a complete Analytics solution



  • Must be a US Citizen and have an active clearance
  • Bachelor’s degree and/or equivalent work experience 
  • 3+ years of Oracle PL/SQL experience
  • 1+ years of OBIEE experience including building the RPD layers
  • 1+ year of Informatica
  • 4+ years of Data Architecture
  • 2+ year of strong Oracle DBA experience especially in a Data Warehousing Environment
  • Strong data modeling experience in a data warehousing environment
  • Ability to test the entire solution  
  • Experience collecting, analyzing and documenting user requirements
  • Excellent communications skills to interact with client and other developers, including training and mentoring of team members
  • Must have strong writing and documentation skills
  • Support Presales activities as needed
  • PMP and/or CSM would be nice to have

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
  • Fitness/gym membership reimbursement and other wellness activities
  • 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 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!