Systems Engineer, Lead - Data Modeler - 36368 in Mechanicsburg, PA at Alion Science and Technology

Date Posted: 6/11/2021

Job Snapshot

Job Description

Position Summary:

Alion 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.

Security Clearance:

  • Active Secret clearance is a mandatory requirement


  • 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 – shouldn’t this go under Knowledge
    • Requires experience with data ingestion tools

Security Clearance: Secret

Next Steps

Join the Alion Talent Network today and stay up-to-date on our openings as they continue to become available! As a member of our network, you will receive alerts with new job opportunities that match your interests and have the ability to share job opportunities through social media or email. Join now!

Whether you choose to apply or just leave your information, we look forward to staying connected with you.


Woman smiling