Intern - Enterprise Analytics

Mid American Energy Company, a Midwest utility, provides regulated electric and natural gas service to more than 1.6 million customers in Illinois, Iowa, Nebraska and South Dakota. The company owns and operates a portfolio of power-generating assets, approximately 61% of which is wind generation. Mid American Energy Company is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or religious creed, age, national origin, ancestry, citizenship status (except as required by law), gender (including gender identity and expression), sex (including pregnancy), sexual orientation, genetic information, physical or mental disability, veteran or military status, familial or parental status, marital status or any other category protected by applicable local, state or U.S. federal law.

Employees must be able to perform the essential functions of the position, with or without an accommodation. Mid American Energy Company has an exciting career opportunity available. Take the next step in your career and apply now!

Must be a college student, sophomore, or higher standing, currently enrolled in a bachelor's degree program in data analytics, computer science, management information systems, mathematics, or related field of study. Must be available May-August 2026. Working knowledge of Microsoft Office and the Windows operating environment.

Primary

Job Duties and Responsibilities

* Identify partner teams' key problems, prototype solutions, and help solve business problems using statistical analysis, cloud technology and data science tools

* Collaborate with internal business groups and domain experts to develop problems, gather requirements, and design advanced analytics solutions.

* Collaborate with team members and other Data and Analytics interns to design, develop, and deliver advanced analytics projects.

* Perform data discovery, exploratory analysis, and data profiling activities using Python, SQL, and Power

BI.

* Perform ETL, data engineering, and data wrangling in Python and SQL supporting advanced analytics projects.

* Develop advanced analytics models (machine learning, statistical, mathematical, or computational models) using Python to solve industry problems.

* Develop data visualizations and dashboards using Power

BI to display and present advanced analytical model results as well as descriptive and exploratory analytics.

* Effectively communicate and present advanced analytics model results and project outcomes.

* Respond to and improve from feedback from internal business groups and team members. Strive for continuous improvement and personal growth.

* Use Microsoft Teams, Microsoft Office, and Azure Dev Ops for team collaboration, meetings, project organization, and planning.

* Perform any additional responsibilities as requested or assigned.

Performance Expectations

* Perform responsibilities as directed within determined time frames and with a high degree of accuracy.

* Establish and maintain effective work relationships within the department and the company.

* Maintain the professional competence, knowledge and skills necessary to effectively complete responsibilities; enhance job knowledge and abilities by taking personal responsibility for professional development and training.

* Maintain sensitive and confidential information regarding company information.

* Attend work on a regular basis and support the company's employee policies and procedures, including workplace safety rules.

* Ensure all compliance aspects of position are known and followed; understand and comply with all policies, codes and regulations applicable to position and company.

Skills for Success

* Effective oral and written communication skills.

* Effective analytical and problem-solving skills.

* Effective interpersonal skills and customer relationship skills

* Ability to prioritize and handle multiple tasks and projects concurrently.

* Experience using Python to develop machine learning or statistical models.

* Experience using SQL to work with database tables and ETL processes.

* Taken coursework in data analytics, machine learning, statistics, or computational mathematics preferred.