1

Data Modeling Internship Jobs in Madison, WI (NOW HIRING)

Investment Intern

Madison, WI · On-site

$15.75 - $20/hr

Investment Internship First Business Bank is a Top Workplaces USA company, learn more here . At the ... from data analysis * Assist the team in constructing model portfolios and optimizing asset ...

Investment Intern

Madison, WI

$15 - $20.25/hr

Investment Internship First Business Bank is aTop Workplaces USA company, learn more here . At the ... from data analysis * Assist the team in constructing model portfolios and optimizing asset ...

Investment Intern

Madison, WI

$15.75 - $20/hr

Investment Internship First Business Bank is a Top Workplaces USA company, learn more here . At the ... from data analysis * Assist the team in constructing model portfolios and optimizing asset ...

Investment Intern

Madison, WI · On-site

$15.75 - $20/hr

... from data analysis * Assist the team in constructing model portfolios and optimizing asset ... Previous investment internship experience and/or interest in investments, asset allocation, trading ...

next page

Showing results 1-20

Data Modeling Internship information

See Madison, WI salary details

$12

$22

$42

How much do data modeling internship jobs pay per hour?

As of Aug 6, 2026, the average hourly pay for data modeling internship in Madison, WI is $22.68, according to ZipRecruiter salary data. Most workers in this role earn between $17.45 and $24.71 per hour, depending on experience, location, and employer.

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.
What cities near Madison, WI are hiring for Data Modeling Internship jobs? Cities near Madison, WI with the most Data Modeling Internship job openings:

$80K - $131K/yr

Full-time

Medical, Dental, Vision, Retirement, PTO

Posted 5 days ago


American Family Insurance rating

7.5

Company rating: 7.5 out of 10

Based on 135 frontline employees who took The Breakroom Quiz

215th of 301 rated insurance


Job description

This position uses data, statistical and quantitative analysis, explanatory and predictive modeling, and fact-based management to develop new insights, enhance understanding of business performance and drive decision making. Responsible for developing dashboards, financial models, and advanced statistical models, as well as data scrubbing, validation, and manipulation.

Position Compensation Range:

$80,000.00 - $131,000.00

Pay Rate Type:

Salary

Compensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates.

Primary Accountabilities

  • Conducts accurate and timely business analysis and reporting to support and drive business decisions using statistical modeling and other business analysis tools.

  • Collaborates with key stakeholders to define key financial and operational metrics to continuously monitor, track, and report performance.

  • Collaborates with business partners in the development and delivery of key performance analysis and reporting.

  • Builds and maintains models used to project business results; enhances the model where there is business value in adjusting the models.

  • Ensures analysis and reporting accuracy and integrity and explains performance drivers and provides insights into performance trends.

  • Analyzes and addresses data quality issues, tests and analyzes impact of system changes to data/reporting infrastructure.

  • Develops, tests, and deploys automated reporting solutions and automated decision analytics to replace manual business processes.

  • May be requested to complete other assignments or participate in projects based upon skills, achievements, or experience.

  • Partners with Legal, Compliance, and Business stakeholders to define meaningful operational and strategic metrics to deliver actionable insights.

  • Identifies opportunities to leverage automation, analytics, and AI-enabled solutions to improve operational efficiency and decision-making across Legal and Compliance.


Specialized Knowledge & Skills Requirements

  • 3+ years experience Demonstrated experience providing customer-driven solutions, support or service.

  • Solid knowledge and understanding of forecasting techniques or statistical analysis.

  • 3+ years experience utilizing data tools to build complex formulas and create reports.

  • 3+ years experience utilizing software tools to query and report data.

  • Strong knowledge of a variety of standard reporting software packages and best practices for report deployment processes.

  • 3+ years experience developing data sets.

  • 3+ years experience working with legal, compliance, litigation, regulatory, audit, or claims data is preferred but not required.
    3+ years experience with platforms such as Google Cloud Platform (GCP), Tableau, PowerBI, & SQL.


Licenses

  • Not Applicable.


Travel Requirements

  • Up to 10%.


Physical Requirements

  • Work that primarily involves sitting/standing.


Working Conditions

  • Not Applicable.

#LI-MD2

Additional Information
  • To ensure a strong start, all employees participate in our New Employee Orientation during their first week. This experience is held in person at our Madison, WI Headquarters or one of our AmFam core locations to help you connect with our mission, meet key team members and build relationships that support your growth. At times, sessions may be delivered virtually based on scheduling and availability.
  • Offer to selected candidate will be made contingent on the results of applicable background checks
  • Offer to selected candidate is contingent on signing a non-disclosure agreement for proprietary information, trade secrets, and inventions
  • Sponsorship will not be considered for this position unless specified in the posting

We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, 9 paid holidays and a paid time off program (23 days accrued annually for full-time employees). In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Insurance Group benefits.

We are an equal opportunity employer. It is our policy to comply with all applicable federal, state and local laws pertaining to non-discrimination, non-harassment and equal opportunity. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.

American Family Insurance is committed to the full inclusion of all qualified individuals. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please email AskHR@AmFam.com to request a reasonable accommodation.

#LI-MD2

What American Family Insurance employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom