Senior Information Technology Architect Data Warehouse

Company: Wits Solutions Inc
Location: Baltimore
Posted on: February 25, 2021

Job Description:

View all jobs Senior Information Technology Architect Data Warehouse Baltimore, MD -- Information Technology Client: Maryland State Department
Position: Senior Information Technology Architect Data Warehouse
Location: Baltimore, MD
Salary: $140K/Year
--
Experience Level: Between 8 - 12 years of Industry Experience
Responsibilities:

• Responsible for the 24/7 support and maintenance of the EDW in the Operations & Maintenance Phase of the System Development Life Cycle (SDLC).
• Critical responsibilities include, but are not limited to:
  • Data Modeling
  • Knowledge of Federal and State Academic Accountability reporting requirements
  • Data Programming
  • Database Management
    • Supply expertise in modeling and organizing information to facilitate support of projects or information architectures utilizing the most current principles and practices of architecture data management systems.
    • Perform the role of both a designer and architect dealing with state-of-the-art technologies, databases, reporting systems, and Extract, Transform and Load (ETL) software.
    • Provide on-site and off-site technical support/troubleshooting; software upgrades, and enhancements to the applications, systems and programs--
      Skills & Knowledge:
      • At least ten (10) years of experience planning, designing, building, and implementing IT systems.
      • Five (5) years of data warehousing design and development knowledge
      • Five (5) years of Informatica 9.1 or higher ETL development and administration
      • Five (5) years of working with Oracle 11g or higher
      • Five (5) years of creating and updating data models using Erwin modeling tool
      • Five (5) years or higher of programming in SQL, PL/SQL, and HTML
      • Five (5) years of creating Entity Relationship Diagram (ERD) and dimensional data modeling
      • At least one (1) year of documented experience in each of:
        • Informatica Data Integration
        • ETLs process design, development, and performance tuning
        • Data modeling using ERD and dimensional models for highly conformed data marts, relational operational data stores, and star-schemas
        • Oracle DBA skills with and ability to define indexes, create and edit tables, monitor Oracle performance
        • Informatica 9.1 or higher system administrator skills and training
        • Data Warehousing design and development
          • Specialized experience:
            • At least 2 years of K-12 or Higher Education industry data warehousing experience.
            • At least five (5) years of the required ten (10) years of experience must be in the direct supervision and management of major projects that involve providing professional support services and/or the integration, implementation and transition of large complex system and subsystem architectures.
            • Must have led or been chief architect in major IT implementation efforts.--
            • Must demonstrate a broad understanding of client IT environmental issues and solutions and be a recognized expert within the IT industry.
            • Must demonstrate advanced abilities to team and mentor and possess demonstrated excellence in written and verbal communication skills
              • Good oral and written communication skills. This will be evaluated during the oral presentations. Candidates will be required to submit samples of past written communications for review. Examples include memos, status updates, etc. Sensitive information can be redacted. Oral communication skills can and will be validated during the oral presentation.--
                Educational Qualifications:
                • Bachelor's Degree from an accredited college or university with a major in Engineering, Computer Science, Mathematics or a related field.Master's Degree preferred. resumes@witssolutions.com
                  --

Keywords: Wits Solutions Inc, Baltimore , Senior Information Technology Architect Data Warehouse, IT / Software / Systems , Baltimore, Maryland