Enterprise Data Warehouse Jobs

1 job found

Today

Data Scientist (W2 Only)

HRU Tech Sterling Heights, MI

Sterling Heights, MI

Today

$60 - $60/hr Full time Analytics Big Data Business Analytics

Apply Now

Job Description

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.

View full job page →

Get Enterprise Data Warehouse Jobs alerts

New Enterprise Data Warehouse Jobs, daily.