Apply on Employer Site

Astronautics Corporation of America · 3 months ago

Data Modeler

Oak Creek, WI

Full-time

Onsite

Mid Level

3+ years exp

Astronautics Corporation of America is a global leader in the design and development of secure avionics equipment and systems for the aerospace industry. They are seeking a highly skilled Data Modeler to design, develop, and maintain data models, ensuring data assets are structured and optimized for operational efficiency and advanced analytics.

Manufacturing

Responsibilities

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

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

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

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

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

Qualification

Data ModelingSQLData WarehousingData Modeling ToolsCloud Data ModelingData GovernanceETL/ELT ProcessesAgile/ScrumData Quality

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 E.R.P. 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

Benefits

Competitive pay

Excellent benefits

Company

Astronautics Corporation of America

Astronautics Corporation of America is a trusted leader in the design, development, and manufacture of secure and reliable avionics equipment and systems.

Founded in 1959

Milwaukee, Wisconsin, USA

501-1000 employees