ZipRecruiter

Log In

1

Data Modeling Internship Jobs in Connecticut (NOW HIRING)

Synchrony

BLP Intern - Data Analytics

Stamford, CT

Business Leadership Program Internship Overview: Synchrony's Business Leadership Program Summer ... models to predict customer behavior. You will work with large and complex datasets to: * Develop ...

Town of Fairfield

GIS Analyst

Fairfield, CT

$97K/yr

May lead or oversee the work of interns, consultants, and technical staff on assigned projects. GIS ... Knowledge of cartography, spatial analysis, map design, data modeling, and geospatial database ...

Citadel

$4.5K - $5.8K/wk

Our signature internship program takes place June through August. Occasionally, we can be flexible ... models and signals in a live trading environment * Use unconventional data sources to drive ...

next page

Showing results 1-20

All JobsData Modeling JobsData Modeling Internship JobsData Modeling Internship Jobs in Connecticut

Data Modeling Internship information

What is a data modeling internship?

A Data Modeling Internship is a temporary position for students or recent graduates to gain practical experience in designing and structuring data for use in databases and information systems. Interns typically work with data architects and analysts to create data models, which help organize and manage data efficiently for businesses. This role often involves learning about different data modeling techniques, using specialized software tools, and supporting projects that improve data quality and accessibility. The internship provides valuable exposure to real-world data challenges and prepares individuals for future roles in data management and analytics.

What is the difference between Data Modeling Internship vs Data Analyst Internship?

AspectData Modeling InternshipData Analyst Internship
Required SkillsData modeling, database design, SQL, data warehousingData analysis, Excel, SQL, visualization tools
Work EnvironmentData teams, IT departments, database environmentsBusiness units, analytics teams, reporting environments
Industry UsageTech, finance, healthcare, where data structure design is keyMarketing, finance, retail, focusing on data insights

While both internships involve working with data, a Data Modeling Internship focuses on designing and structuring data systems, whereas a Data Analyst Internship emphasizes analyzing data to generate insights. The choice depends on whether you prefer working on database architecture or data interpretation.

What are the key skills and qualifications needed to thrive as a data modeling intern, and why are they important?

To thrive as a Data Modeling Intern, you need a solid understanding of database concepts, data structures, and proficiency in SQL, often supported by coursework in computer science or data analytics. Familiarity with data modeling tools like ERwin, Microsoft Visio, or Lucidchart, and experience with relational database management systems (RDBMS) are typically required. Strong analytical thinking, attention to detail, and effective communication skills help interns collaborate with teams and translate business requirements into data models. These skills are essential for creating accurate, scalable data models that support efficient data storage, retrieval, and analysis in organizational projects.

What types of projects and responsibilities can I expect during a data modeling internship?

As a Data Modeling Intern, you can expect to work closely with data engineers and analysts to design, build, and refine data models that support business intelligence and analytics initiatives. Typical responsibilities include gathering requirements, creating entity-relationship diagrams, normalizing databases, and assisting in the documentation of data flows. You'll also have opportunities to participate in meetings with cross-functional teams, learn best practices for database design, and contribute to ongoing data quality improvement efforts. This hands-on experience provides valuable exposure to real-world data challenges and helps build a strong foundation for a career in data management.
Data Modeling Internship jobs near you

Data Engineering Internship (Summer 2027)

Castleton Commodities International, LLC

Stamford, CT • On-site

$122K - $146K/yr

Full-time

Posted 20 days ago

Job description

Application Deadline: September 1, 11:59 pm EST
Program Summary - Data Science & Technology Internship
Company Overview:
Castleton Commodities International is a leading global energy commodities merchant and infrastructure asset investor. As a trader, CCI deploys capital on a proprietary basis in the physical and financial commodity markets, providing the Company with market insights and access. As a strategic investor and developer, CCI leverages its market expertise, operations capabilities, and industry knowledge to invest in, and develop, select commodity infrastructure assets. Our strategically integrated platform has generated strong risk-adjusted returns for our investors since our formation.
Position Overview:
CCI is developing a leading-edge Data Science platform, as staying at the forefront of data management and analytics is essential to our investment strategy. We are looking for motivated and detail-oriented Data Engineering Interns to join our Global Data Science & Technology team in Houston, TX, Stamford, CT, & New York City offices. The Data Engineering Intern will work closely with our Data Science, Data Engineering and Commercial teams to build and optimize data pipelines that power our analytics, forecasting, and investment decision-making processes. This is a hands-on technical internship ideal for someone who enjoys solving real-world data challenges, especially around ingesting, scraping, and managing large datasets across the commodity markets.
Responsibilities:
  • Develop and maintain robust data ingestion pipelines from various internal and external sources, including APIs, FTP endpoints, and cloud data providers.
  • Develop data ingestion and transformation pipelines using Python and SQL, publishing Snowflake for downstream use in analytics and forecasting tools.
  • Work on data architecture and data management projects for both new and existing data sources.
  • Design and implement ETL processes to clean, normalize, and store structured and semi-structured data in Snowflake, our core relational data warehouse.
  • Analyze data pipeline performance and implement optimizations to improve efficiency and reliability.
  • Conduct data quality checks and build validation logic to identify anomalies and ensure data integrity for use by commercial trading and analytics teams.
  • Automate data workflows using Python, SQL, and orchestration tools (e.g., Airflow or similar).
  • Assist in transitioning legacy datasets and codebases into scalable, cloud-native workflows aligned with our modern data architecture.
  • Document data sources, pipeline logic, and data models to ensure maintainability and knowledge transfer.

Qualifications:
  • Currently pursuing a Bachelor's or higher degree in Computer Science, Engineering, Management Information Systems, or related technical field.
  • Expected graduation date of Winter 2027 or Spring/Summer 2028.
  • Strong programming experience in Python (preferred libraries: pandas, NumPy, SQL alchemy, etc.).
  • Strong understanding of SQL and experience querying relational databases (Snowflake a plus).
  • Exposure to or interest in cloud platforms (e.g., AWS, Azure), particularly with cloud data storage and compute.
  • Familiarity with web scraping frameworks and handling large-scale structured and unstructured data sources.

Apply