Intern - Data Modeling Analyst

JSM & ASSOC LLC

6h•Onsite

About The Position

JSM Airport Services, LLC is seeking an Intern Data Modeling Analyst. The Data Modeling Analyst is responsible for designing, developing, and maintaining data models that support maintenance operations, inventory control, financial reporting, and performance analytics across passenger boarding bridges (PBBs) and baggage handling systems (BHS). This role ensures that data from CMMS, inventory systems, financial platforms, and site-level operations is structured, accurate, and actionable. The analyst plays a key role in enabling data-driven decisions that improve on-time maintenance performance, equipment reliability, optimize spare parts inventory, and enhance operational and financial performance across all service locations. The analyst works closely with IT, operations, CMMS, and leadership teams to ensure accurate data modeling and its integrity and usability.

Requirements

Bachelor’s degree in Data Science, Computer Science, Information Systems, Finance, or related field
Equivalent experience may be considered
2+ years of experience in data modeling, data analysis, or database design
Experience working with relational databases (SQL Server, Oracle, PostgreSQL, etc.)
Experience with data warehousing concepts (star schema, snowflake schema)
Strong SQL skills (querying, joins, performance tuning)
Experience with data modeling tools (e.g., ER/Studio, ERwin, or similar)
Familiarity with BI tools (Power BI, Tableau, or similar)
Understanding of ETL/ELT processes and tools
Knowledge of data governance and data quality best practices
Strong analytical and problem-solving skills
Attention to detail and data accuracy
Ability to translate business needs into technical solutions
Effective communication with both technical and non-technical stakeholders
Project management and organizational skills
Accuracy and reliability of data models
Performance and efficiency of data systems
Stakeholder satisfaction with reporting and analytics
Reduction in data inconsistencies and manual reporting efforts
Ability to work across multiple sites and functional teams

Nice To Haves

Experience with airport systems, PBBs, or BHS environments
Knowledge of maintenance KPIs and reliability analytics
Familiarity with inventory management and supply chain data
Experience with cloud platforms (Azure, AWS, or similar)
Basic knowledge of Python or similar tools for data analysis

Responsibilities

Design and maintain conceptual, logical, and physical data models
Develop data schemas for data warehouses and operational systems
Ensure alignment of data models with business processes and reporting needs
Standardize data definitions, naming conventions, and structures
Collaborate with CMMS and IT professionals to support ETL/ELT processes
Map data from multiple source systems into unified models
Ensure data model quality, consistency, and integrity across sites
Partner with business stakeholders to understand reporting and analytics needs
Optimize data structures for dashboards and reporting tools (e.g., Power BI, Tableau)
Support KPI development and metric standardization
Enable self-service model usage through well-defined data formatting and sourcing
Maintain comprehensive documentation of data models and data flows
Support data governance initiatives including data standards and policies
Establish and enforce best practices for data modeling and management
Analyze existing data systems and recommend improvements
Identify opportunities to improve performance, scalability, and usability of data models
Support advanced analytics initiatives, including predictive modeling and forecasting