• Data Warehouse Specialist

    Posted Date 6 days ago(1/11/2019 9:02 AM)
    ID
    2019-3063
    # of Openings
    1
    Category
    Consulting
    Work Site - City
    Springfield
    Department
    Consulting Technical Services - Platform
    Work Site - State
    VA
    Security Clearance Level
    None Required
    Maximum Expected Travel
    None
    Type
    Regular Full-Time
    Remote/Telecommute Available?
    No - Applicants Must be Local to Work Site
  • Job Overview & Responsibilities

    Mythics is seeking a Data Warehouse Specialist who will perform technical administration duties for data warehouse development and maintenance. The successful candidate will provide technical support and coordination during warehouse design, testing, and movement to production. As Data Warehouse Specialist, you will act as liaison between engineers, data architects, programmers, and analysts. The Consultant will implement and enforce standards and procedures to ensure data is managed consistently and properly integrated within the warehouse, as well as implement business rules via stored procedures, middleware, or other technologies.

     

    Responsibilities include:

    • Test software systems or applications for software enhancements or new products
    • Review designs, codes, test plans, or documentation to ensure quality
    • Provide or coordinate troubleshooting support for data warehouses
    • Prepare functional or technical documentation for data warehouses
    • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies
    • Verify the structure, accuracy, or quality of warehouse data
    • Select methods, techniques, or criteria for data warehousing evaluative procedures
    • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures
    • Map data between source systems, data warehouses, and data marts
    • Implement business rules via stored procedures, middleware, or other technologies
    • Develop and implement data extraction procedures from other systems, such as administration, billing, or claims
    • Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases
    • Design and implement warehouse database structures
    • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow
    • Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing
    • Create or implement metadata processes and frameworks
    • Develop data warehouse process models, including sourcing, loading, transformation, and extraction
    • Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements

    Qualifications

    Qualifications: 

    • US Citizenship is required to obtain a CBP clearance
    • 12+ years of experience and a B.S. degree and M.S degree. BS can be substituted with an additional 4 years of related experience, and MS can be substituted with an additional 2 years of related experience.
      5 years of experience with MarkLogic
    • 5 years of experience with Informatica
    • Experience with the design, development and maintenance of enterprise level data systems such as Oracle, SQL Server, Teradata or others.
    • Strong data modeling skills (normalized and multidimensional).
    • Strong technical skills with all data warehousing technologies (e.g., ETL, ODS, DBMS, BI) with experience in Informatica
    • Experience in leading successful enterprise data warehousing efforts.

    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 Account and Dependent Care 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 Fridays (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.

    Options

    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!