• Data Architect

    Posted Date 2 months ago(8/12/2019 11:05 AM)
    ID
    2019-3217
    # of Openings
    1
    Category
    Consulting
    Work Site - City
    Brooklyn
    Department
    Consulting Technical Services - Platform
    Work Site - State
    NY
    Security Clearance Level
    Public Trust
    Maximum Expected Travel
    None
    Type
    Any (Full-Time or Subcontract)
    Remote/Telecommute Available?
    No - Applicants Must be Local to Work Site
  • Job Overview & Responsibilities

    Mythics is looking for a Data Architect who will work onsite in Brooklyn, New York for a public service agency delivering Data Warehouse solutions. As the Data Architect, you must have experience with BI/Data Warehouse technology and be responsible for solution development, technical design and build for the DW solution and its related BI components. The candidate will have strong data warehouse design, PL/SQL, ETL experience. The candidate must be able to maintain a current production database, design and develop new ETL, and build data marts inside an Oracle Database.

     

    Responsibilities:

    • Creation of Data Model

    The data model of the design is based on multidimensional design that is intended for end­user queries and Bl process. The tasks include:

    • Definition of Information from each data sources integrating to the enterprise DW
      • Define the Dimension information
      • Define Fact information
    • Define high level business model
    • Define logical structure of the data model
    • Define physical structure of the DWH
      • Create Database objects
      • Map Business Rules
      • Build the Data Dictionary
    • Work with the business, end users, and technical information and facilities (server access and Database Administrative access, etc.) necessary to design and implement the solution
    • Perform requirements analysis, application design and develop technical design documents
    • Work with appropriate organizational personnel (stakeholders) representing the DW to meet with and engage in data modeling sessions and design the solution according to specifications
    • Participate in and conduct peer reviews as needed.

    Qualifications

    • * Must be able to obtain a Public Trust
    • * 100% onsite in Brooklyn, NY 
    • Bachelor's or Associate degree in Computer Science, Information Systems, Software Engineering or another engineering major or equivalent experience
    • 15 years of experience with IT industry using Data Modeler and Data warehouse build products (SQL Developer/Modeler, TOAD, Erwin, Oracle RDBMS, etc.).
    • 6 years of experience in modeling, data transformation tools, BI and Oracle database
    • Recent, long-term full lifecycle engagement as a data warehouse or data architect lead in a data warehouse implementation using Oracle 12c or higher.
    • ETL implementation experience including data modeling, data mart design, and advanced customization and configuration of database/data warehouse to map data elements between various data storage technologies, and defines ETL logic to move data between locations
    • Experience in performance analysis and tuning of ETL and other data transfer components
    • Develop data models
    • Install tablespaces, tables, and other associated database objects:
      • Schema management
      • Logical Data Model
      • Physical Data Model
      • Dimensional Modeling concepts
    • Implement different instances of databases into different environments: dev, test, and prod
    • Perform Data Model Definition
    • Attending technical meetings as required to discuss technical project aspects and reviewing/responding to comments on submittal documents
    • Leading technical meetings as extensions to reporting progress in program meetings
    • Leading, coaching, developing and supervising the efforts of assigned project staff.

    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
    • 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

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.