Data Warehouse Engineer

Vista Innovative Services, LLC is seeking a Data Warehouse Manager to add to our Enterprise Analytics and Systems Support Services (EASSS) team in support of Human Resources Command (HRC) Enterprise Modernization Directorate (EMoD).

Responsibilities Include:

• This role will partner cross-functionally with all areas of the business to create a single source from where teams can pull data and insights.
• Defines an overarching data strategy to ensure the right people have the right data at the right time while overseeing data design and the creation of database architecture and data repositories.
• Responsible for the design, implementation, maintenance, and support of the data warehouse systems and projects.
• Ensures that reporting, modeling, and ETL projects and initiatives are supported fully and run smoothly.
• Installs processes for auditing data warehouses and ensuring data quality.
• Establishes connections between data warehouse/data models and BI visualization tools.
• Ensures stability of data warehouses including security, uptime, and troubleshooting of database errors.
• Maintains data warehouses including rollout of upgrades and constant evaluation of emergent technologies.
• Work in a multi-protocol, multi-platform environment.
• Providing a managerial role while providing day-to-day support of the data warehouse and troubleshooting existing procedures and processes.
• Guides the project in identifying any new data needs and deliver mechanisms for acquiring and reporting such information as well as addressing the actual needs.
• Designs and develops systems for maintenance of the data warehouse, ETL processes, and business intelligence.
• Highly collaborative with other team members and data consumers within the business to gather and populate data warehouse table structure.
• Establishes the documentation of reports, develops, and maintains technical specification documentation for all reports and processes.

Qualifications:

• Bachelor’s degree in management information systems, Computer Science, or a related field.  Education may be substituted for years of experience.
• 5-9 years of experience in database administration, database architecture, or a related field.
• Mastery of SQL and experience standing up cloud data warehouses.
• Extensive knowledge of Data Warehouse design concepts and tools.
• Secret Clearance