Data Warehouse Engineer

Overview:

For two decades, Millennium Corporation has been operating on the leading edge of cybersecurity. Our elite team of more than 400 experts has an unparalleled record of performance supporting Red Team Operations, Defensive Cyber Operations, Software Engineering, and Technical Engineering. With the largest contingent of contracted Red Team operators in the DoD, we provide an unmatched level of threat intelligence and battle-tested experience for customers in both the DoD and federal civilian markets.

We believe that diversity is a fact, inclusion is a choice.  At Millennium Corporation, we are inclusive. We celebrate multiple approaches and different points of view. We strongly believe that diversity drives innovation, and we are building a culture where differences are valued. We are always growing our programs and we offer tools to help our employees grow and manage their careers.

Millennium is an equal opportunity employer and does not discriminate or allow discrimination on the basis of race, color, religion, gender, age, national origin, citizenship, disability, veteran status or any other classification protected by federal, state, or local law. Millennium promotes affirmative action for women, minorities, disabled persons, LGBTQ+ and veterans.

Millennium Corporation is hiring a Data Warehouse Engineer to work 100% REMOTE. The candidate must have an active secret clearance.

As a Data Warehouse Engineer on the Data Warehouse (Migration) Team with Logistical Data Services (LDS), you will be expected to:

• Ability to communicate effectively with non-technical and technical client POCs to establish clear requirements for data warehousing and data marts, then design and implement in PL/SQL and PostgreSQL to deliver the intended business outcomes
• Designing and implementing complex ETL solutions within Oracle PL/SQL AND PostgreSQL databases
• Experience pulling/loading files, transforming/cleansing data, loading it into complex schemas
• Designing and building additional schemas and data structures (generic data model) to expose data to external systems and users via API, including RBAC related access role design and implementation
• Building database jobs and code packages in PostgreSQL to move data in/out, as well as integrating data from multiple sources within the database
• Analytics data warehouse design and implementation - In depth understanding of OLAP databases (Amazon Redshift preferred), including how to design columnar centric databases, moving raw semi-structured data through various layers of transformation and semantic layer logic for optimal data refresh efficiency, as well as query performance
• Responsible for meeting Program Increment (~12week) deadlines to create and enhance Data Ingestion Team capabilities.
• Attend and Participate in Periodic Large Scale Agile Planning events.
• Support standard Agile ritual meetings (Sprint Planning, Daily Stand-ups, Backlog Grooming, Sprint Reviews and Retrospectives) as necessary and assist Scrum teams in execution of Sprints.

• Candidate must have an active secret clearance.
• BS degree in Engineering, Physics, Network Security, Computer Science, Information Systems preferred
• 6-8 years IT experience and 2 to 5 years of direct Data Warehouse Engineering
• DoD 8570 IAT Level II / minimum requirement - Security + , COMPITA Linux + , AWS Certified Cloud Practitioner / Solutions Architect preferred

• Developed and/or Implemented Databases

• Experience with Oracle and knows PL/SQL

• Can write SQL Code and Queries

• Can write ETL (Extract, Transform, Load) in SQL

• Experience working with Postgress SQL

• Experience with Amazon Web Services Redshift and Glue and has written Glue Jobs

• Must be comfortable with prolonged periods of sitting at a desk and working on a computer.
• Must be able to lift up to 10-15 pounds at a time.

Less than 5%