Hybrid Data Modeler: AWS Redshift & Data Governance

Job Details
ITData Modeler Sterling Heights,MI Posted:5/13/2026 Job Description Job #:

16158

IT

Contractor

9/80 work schedule

Geo Logics is working with a top Aerospace and Defense client looking for a Data Modelerin Sterling Heights, MI - Hybrid.

Role: Data Modeler

Client: Top Aerospace and Defense company

Location: Sterling Heights, MI - Hybrid (Goal is to be 3 days on, 2 day remote)

Schedule/Travel: 9/80 with 10% travel

Education: Bachelors in Data Management, Data Science, Math, Statistics

Rate: $52 to $62 per hour (W2 contract non-benefitted, No PTO - ever hour worked is an hour paid)

Job Description

• Design and implement conceptual, logical, and physical data models to represent organizational data accurately.
• Collaborate with business analysts, data architects, developers, and other stakeholders to gather requirements and ensure models meet business and technical needs.
• Maintain a central data dictionary, enforce data standards, and ensure compliance with data governance policies.
• Optimize performance of data infrastructure by tuning data models for efficiency, reduce redundancy, optimize reusability at the right levels and improve database performance.
• Design solutions for integrating data across systems and perform reverse engineering of existing databases when necessary.
• Develop and maintain documentation, naming conventions, and coding standards to ensure consistency across data systems helping the business to define 'what does good look like?'
• Ensure that data is stored securely, efficiently, and in a manner that is accessible for analysis and reporting.
• Ensuring the accuracy, consistency, and reliability of data, implementing data validation and quality control processes.
• Optimize data pipelines for speed, scalability, and performance, ensuring that data is available when and where it's needed.
• Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and ensure that data infrastructure meets their needs.
• Troubleshoot issues with data infrastructure, monitor system performance, and perform regular maintenance to ensure smooth operation.
• Support configuration control, documentation and change impact analysis on the businesses data architecture model including identification of Authoritative Source of Truth (ASOT) databases, connectors to replicate data from ASOTS to Midas and/or AWS Cloud Environments through data transformation within Power BI.

Skills Required

• Excellent oral and written communications.
• Be directly involved in developing data models and process flows as well as liaising with multiple stakeholders - mainly engineering, to document and/or validate the current state or As-Is business process.
• Proven ability to work within teams in which your contributions are critical to success.
• Proficiency with tools such as Power BI, Visual Basic, MSExcel, MATLAB/Simulink, Mathcad, Magic Draw, Midas, AWS/AWS Redshift, SSAS, Alation, Dataiku, Oracle, SQL.
• Experience using entity-relationship diagrams (ERDs), dimensional modeling, normalization techniques, and metadata repositories to design and document data structures.
• Understanding of data warehousing concepts.
• Experience with big data technologies like Hadoop or Spark.
• Familiarity with cloud-based data services such as AWS or Azure.
• Background in data governance and data quality concepts.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills with both technical and non-technical stakeholders.
• Experience in Agile or Scrum environments.

Must Have Knowledge:

• Develop Data Models
• AWS Medallion architecture including AWS Redshift
• Data Cataloguing tools like Collibra
• Data Transformation tools like Dataiku
• Dashboarding tools like Power
  
  BI or Tableu
• Experience using entity-relationship diagrams (ERDs)
• Big Data tech like Hadoop or Spark

Geo Logics is an Equal Opportunity/Affirmative Action Employer that is committed to hiring a diverse and talented workforce. EOE/Disability/Veteran