Milwaukee Succeeds
What You Will Do
This hybrid on-site position is located at our headquarters in Oak Creek, WI. You will report directly to the Manager, Business Intelligence & Data Science.
How You Will Do It
Create and maintain conceptual, logical, and physical data models for various data initiatives, including transactional systems, data warehouses, data lakes, and data marts.
Translate complex business requirements and rules into clear, concise, and accurate data structures.
Determine appropriate data modeling techniques (e.g., relational, dimensional, NoSQL) based on business needs and technical constraints.
Work closely with business stakeholders, data architects, data engineers, ETL developers, and data analysts to gather requirements, validate designs, and ensure alignment across data initiatives.
Facilitate discussions and workshops to define data entities, attributes, relationships, and business rules.
Data Governance & Standards
Define and enforce data modeling standards, naming conventions, and best practices to ensure consistency and maintainability across the enterprise.
Contribute to the development and management of data dictionaries, glossaries, and metadata repositories.
Optimization & Performance
Collaborate with database administrators and data engineers to optimize data models for performance, scalability, and cost‑efficiency.
Advise on indexing strategies, partitioning, and other physical design considerations.
Data Quality & Integrity
Ensure data models support data quality initiatives by incorporating appropriate constraints, validation rules, and integrity checks.
Understand and document data lineage to track data flow from source to consumption.
Evaluation & Improvement
Review existing data models and databases for variances, discrepancies, and opportunities for optimization.
Stay current with industry trends and emerging data modeling tools and methodologies.
What We Look For Required
Minimum of a Bachelor's Degree in Computer Science, Information Systems, Data Science, or another related quantitative field from an accredited institution.
Minimum three years of professional experience as a Data Modeler, Data Architect, or a similar role with a strong focus on data modeling.
Expertise in designing and implementing conceptual, logical, and physical data models.
Strong proficiency in SQL for data definition, manipulation, and querying.
Proven experience with industry‑standard data modeling tools (e.g., ERwin Data Modeler, SAP PowerDesigner, ER/Studio, Lucidchart).
Solid understanding of data warehousing concepts and experience with dimensional modeling (Star Schema, Snowflake Schema).
Familiarity with various database technologies (e.g., relational databases like PostgreSQL, MySQL, SQL Server; NoSQL databases; cloud data warehouses like BigQuery).
Experience with data modeling in cloud environments (e.g., Google Cloud Platform, AWS, Azure).
Preferred
Master's degree in a relevant field.
Knowledge of data governance frameworks and metadata management platforms.
Experience working with ERP systems (SAP, MS Dynamics, Oracle, etc.); IFS ERP systems experience is preferred.
Familiarity with ETL/ELT processes and how data models support data pipelines.
Experience in an Agile/Scrum development environment.
Certifications in data modeling or related data management field.
Who We Are We are a team that designs computers, displays, and electronic systems for aircraft of the future! At Astronautics, you will be part of a creative group of professionals who work on the cutting‑edge of technology. We offer competitive pay, excellent benefits and the opportunity for professional growth in a collaborative environment.
Astronautics, headquartered in Oak Creek, Wisconsin, is a global leader in the design, development and manufacture of secure avionics equipment and systems for the commercial and military aerospace industry. Key product areas include electronic primary flight and engine displays, connected aircraft and cyber solutions, electronic flight bags, and certified servers for airborne applications. Services include avionics system integration and custom software for critical applications. Since its founding in 1959, Astronautics has been providing trusted, reliable, and tailored solutions to help customers achieve mission success. Astronautics is the parent company of Kearfott Corporation, headquartered in Pine Brook, New Jersey.
Equal Opportunity Employer We are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment, including protected veterans and individuals with disabilities. Employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color or any other protected class.
#J-18808-Ljbffr
How You Will Do It
Create and maintain conceptual, logical, and physical data models for various data initiatives, including transactional systems, data warehouses, data lakes, and data marts.
Translate complex business requirements and rules into clear, concise, and accurate data structures.
Determine appropriate data modeling techniques (e.g., relational, dimensional, NoSQL) based on business needs and technical constraints.
Work closely with business stakeholders, data architects, data engineers, ETL developers, and data analysts to gather requirements, validate designs, and ensure alignment across data initiatives.
Facilitate discussions and workshops to define data entities, attributes, relationships, and business rules.
Data Governance & Standards
Define and enforce data modeling standards, naming conventions, and best practices to ensure consistency and maintainability across the enterprise.
Contribute to the development and management of data dictionaries, glossaries, and metadata repositories.
Optimization & Performance
Collaborate with database administrators and data engineers to optimize data models for performance, scalability, and cost‑efficiency.
Advise on indexing strategies, partitioning, and other physical design considerations.
Data Quality & Integrity
Ensure data models support data quality initiatives by incorporating appropriate constraints, validation rules, and integrity checks.
Understand and document data lineage to track data flow from source to consumption.
Evaluation & Improvement
Review existing data models and databases for variances, discrepancies, and opportunities for optimization.
Stay current with industry trends and emerging data modeling tools and methodologies.
What We Look For Required
Minimum of a Bachelor's Degree in Computer Science, Information Systems, Data Science, or another related quantitative field from an accredited institution.
Minimum three years of professional experience as a Data Modeler, Data Architect, or a similar role with a strong focus on data modeling.
Expertise in designing and implementing conceptual, logical, and physical data models.
Strong proficiency in SQL for data definition, manipulation, and querying.
Proven experience with industry‑standard data modeling tools (e.g., ERwin Data Modeler, SAP PowerDesigner, ER/Studio, Lucidchart).
Solid understanding of data warehousing concepts and experience with dimensional modeling (Star Schema, Snowflake Schema).
Familiarity with various database technologies (e.g., relational databases like PostgreSQL, MySQL, SQL Server; NoSQL databases; cloud data warehouses like BigQuery).
Experience with data modeling in cloud environments (e.g., Google Cloud Platform, AWS, Azure).
Preferred
Master's degree in a relevant field.
Knowledge of data governance frameworks and metadata management platforms.
Experience working with ERP systems (SAP, MS Dynamics, Oracle, etc.); IFS ERP systems experience is preferred.
Familiarity with ETL/ELT processes and how data models support data pipelines.
Experience in an Agile/Scrum development environment.
Certifications in data modeling or related data management field.
Who We Are We are a team that designs computers, displays, and electronic systems for aircraft of the future! At Astronautics, you will be part of a creative group of professionals who work on the cutting‑edge of technology. We offer competitive pay, excellent benefits and the opportunity for professional growth in a collaborative environment.
Astronautics, headquartered in Oak Creek, Wisconsin, is a global leader in the design, development and manufacture of secure avionics equipment and systems for the commercial and military aerospace industry. Key product areas include electronic primary flight and engine displays, connected aircraft and cyber solutions, electronic flight bags, and certified servers for airborne applications. Services include avionics system integration and custom software for critical applications. Since its founding in 1959, Astronautics has been providing trusted, reliable, and tailored solutions to help customers achieve mission success. Astronautics is the parent company of Kearfott Corporation, headquartered in Pine Brook, New Jersey.
Equal Opportunity Employer We are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment, including protected veterans and individuals with disabilities. Employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color or any other protected class.
#J-18808-Ljbffr