Systems Engineer, Lead - Data Modeler - 37672

Job Description

Position Summary:

HII-TSD is looking for a talented Data Modeler to support activities related to enterprise-wide, mission critical and mission support data sets. The preferred candidate will have a background in supporting various types of systems and database structures and network-related missions within the Department of Defense environments, as either a developer, analyst or engineer.

The data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.

The successful candidate will:

• Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
• Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.

Responsibilities:

• Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
• Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
• Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
• Focus on data warehousing work using Oracle, SQL Server, MySQL, NoSQL.

Education and Experience:

Bachelor's or Masters degree in Computer/Data Science or equivalent fields. Educational requirements may be adjusted for applicable work experience. Work experience may be adjusted for highly specialized knowledge or uniquely applicable experience.

• 5+ years of hands on experience as a data modeler
• Experience in the following key areas:
  • Relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
  • Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
  • Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.
  • Experience in team management, communication, and presentation. Experience with Teradata and/or Big Data technologies (Such as Hadoop, Spark, and Apache).
  • Experience with building data marts, data pipelines, and data warehouses from scratch
  • AWS experience – Redshift, Kinesis, ELK
  • Requires Knowledge of Spark, Python, Java, Scala—shouldn't this go under Knowledge
  • Requires In-depth understanding of Hadoop Echo System & HDFS File System
  • Requires experience with data ingestion tools

Security Clearance: Secret
Telework - Limited

Diversity Statement

We are an EOE that values our employee's talent – regardless of gender, race, ethnicity, national origin, sexual orientation, religion or other protected characteristics – Your Talent Is Our Strength .

Women, minorities, individuals with disabilities and Veterans are encouraged to apply. Alion will provide a reasonable accommodation to individuals with disabilities and disabled veterans who need assistance to apply. Please visit the Alion Careers site for more information. U.S. Citizenship Required for the majority of our positions.

Covid Notice

A new Federal Executive Order requires that employees of Federal contractors and subcontractors be fully vaccinated for COVID-19 by December 8, 2021. Accordingly, as a condition of employment with Technical Solutions, a division of Huntington Ingalls Industries, employees will be required to provide proof of full vaccination against COVID-19 or have an approved exemption prior to starting employment.