Data Scientist (W2 Only)

HRU Tech is seeking a Data Scientist on a W2 basis for an onsite role in Sterling Heights, Michigan. The position centers on designing, building, and maintaining enterprise data infrastructure to support Combat Mission Systems operations, delivering scalable data models and efficient pipelines while ensuring secure, reliable access for analytics, reporting, and operations.

Responsibilities

• Create and implement conceptual, logical, and physical data models that faithfully reflect the organization's data.
• Collaborate with business analysts, architects, developers, and stakeholders to elicit requirements and align models with business and technical needs.
• Maintain centralized data dictionaries, metadata repositories, and enterprise data standards.
• Enhance data infrastructure performance through tuning, reducing redundancy, and improving scalability and reusability.
• Design and support data integration solutions across multiple systems and platforms.
• Conduct reverse engineering of existing databases and data structures as needed.
• Develop and maintain documentation, naming conventions, coding standards, and data governance practices.
• Ensure data is securely stored, efficiently managed, and accessible for analytics, reporting, and operational use.
• Implement data validation, quality control, and data integrity processes.
• Tune data pipelines for performance, scalability, and reliability.
• Support data scientists, analysts, and engineering teams by ensuring infrastructure meets operational and analytical requirements.
• Troubleshoot data infrastructure issues and perform ongoing system monitoring and maintenance.
• Assist with configuration control, change impact analysis, and enterprise data architecture management.
• Identify and manage Authoritative Sources of Truth databases and related data integrations.
• Support data replication and transformation activities within Midas and AWS cloud environments using Power BI and related technologies.

Requirements

• Bachelor's degree in Data Management, Data Science, Mathematics, Statistics, or a related field.
• Minimum of six years of relevant experience.
• Experience designing and maintaining enterprise data models and data infrastructure.
• Solid understanding of data warehousing concepts and data architecture principles.
• Experience with ERDs, dimensional modeling, normalization, and metadata repositories.
• Power BI
• SQL
• AWS and AWS Redshift
• Oracle
• SSAS
• MS Excel
• Visual Basic
• MATLAB and Simulink
• Mathcad
• MagicDraw
• Midas
• Alation
• Dataiku
• Experience with cloud-based data services such as AWS or Azure
• Familiarity with big data technologies including Hadoop or Spark
• Background in data governance and data quality methodologies
• Strong analytical and problem-solving abilities
• Excellent written and verbal communication skills
• Experience in Agile or Scrum environments
• Ability to collaborate effectively with both technical and non-technical stakeholders

Technologies

• Power BI
• SQL
• AWS Redshift
• AWS
• Oracle
• SSAS
• MS Excel
• Visual Basic
• MATLAB
• Simulink
• Mathcad
• MagicDraw
• Midas
• Alation
• Dataiku
• Azure
• Hadoop
• Spark

Position Overview

The Data Infrastructure and Data Modeling Engineer will support the design, development, and upkeep of the enterprise data infrastructure for Combat Mission Systems operations. The role is responsible for creating scalable data models, optimizing data pipelines, and ensuring data is secure, reliable, and accessible across complex systems and large datasets.

Work Environment

• Highly collaborative setting that supports engineering, analytics, and enterprise data initiatives.
• Focus on enterprise-scale data architecture, governance, and digital transformation.
• Combination of technical implementation, stakeholder collaboration, and process improvement activities.

Preferred Qualifications

• Master's degree in mathematics, statistics, engineering, business, applied sciences, management information systems, or a related field.
• More than ten years of relevant experience.
• Experience using structured problem-solving methodologies.
• Experience supporting engineering or manufacturing organizations.
• Experience collaborating directly with development teams.
• Familiarity with Agile performance metrics and reporting.
• At least one year of Scrum or Agile management experience.
• Knowledge of technical systems and requirements related to combat vehicles.