Intern Python Data Analyst Jobs in Illinois (NOW HIRING)

Job Description

DATA ANALYST 2

Job Summary:

This position, reporting to the Analytics Manager, is responsible for creating, maintaining, and improving analysis tools for traffic safety data that provide actionable insights that support decision-making and strategic planning. This role involves working closely with different departments of the Center for Analytics and Research in Transportation Safety (CARTS) and its stakeholders to understand analysis needs, develop reports and dashboards, and use data analysis techniques to inform stakeholder decision making.

The key responsibilities of this position include, but are not limited to: coding, data collection and analysis, data integration, reporting and dashboards, data visualization, business performance tracking, trend analysis and forecasting, and data documentation and reporting.

Job Responsibilities:

50% - Data Analysis:

Create, update, and improve complex programs and scripts relevant to multiple objectives using Python, R, or other appropriate language.

Design, build, and implement statistical and machine learning models to solve specific business problems. Visualize data using charts, graphs, and dashboards to communicate insights clearly. Use data visualization tools (e.g., Tableau, Power BI) to create interactive and dynamic reports that connect to and rely on multiple data sources.

25% - Data Extraction and Preparation:

Work with Information Technology Manager and Analytics Manager to design and build the data infrastructure necessary to achieve data driven analytic solutions. Prepare and analyze data for studies and analytical tools using appropriate methods. Extract and analyze data to support the efforts of CARTS stakeholders.

15% - Project Management:

Manage projects, graduate assistants, and student workers as assigned by Analytics Manager.

10% - Other Duties as Assigned

Perform miscellaneous tasks as directed by the Analytics Manager.

Minimum Qualifications:

Education Level: Bachelor's degree in Business Analytics, Data Science, Economics, Statistics, Mathematics, or related field

Degree Substitute: LSU is dedicated to fostering an environment where our employees feel appreciated for their skills and individuality. If a candidate does not meet the minimum qualifications as listed but has substantial experience in the key job responsibilities, we encourage them to apply.

Years of Experience: 1

Specific Experience: Experience in data analysis, business intelligence or related role.

Knowledge of statistical analysis software (e.g., R, Python). Familiarity of Excel, SQL, and data visualization tools (e.g., Tableau, Power BI)

Preferred Qualifications:

Education Level: Master's degree in Business Analytics, Data Science, Economics, Statistics, Mathematics, or related field

Years of Experience: 2-3

Specific Experience: Familiarity with statistical methods and predictive modeling. Experience doing analysis, programming, or data visualization with traffic safety data. Strong Experience building complex applications using Python, R, SQL or any combination thereof.

Competencies:

Knowledge of statistical analysis software (e.g., R, Python). - Advanced

Experience with business intelligence tools such as Microsoft Excel, including Solver and PowerPivot - Proficient

Experience preparing data for analysis using SQL. - Proficient

Experience with data visualization software such as Tableau or Microsoft PowerBI. - Proficient

Analyzing large datasets, identifying trends, and extracting actionable insights to guide business decisions. - Proficient

Problem solving - Advanced

Attention to Detail - Proficient

Effective verbal and written communication skills - Proficient

Able to work effectively in a team environment and collaborate with colleagues from different departments. - Proficient

DATA ANALYST 3

Job Summary:

This position, reporting to the Analytics Manager, will be responsible for coordinating and serving as primary contributor for projects focused on the development, implementation, and maintenance of advanced highway safety data applications and processes at the Center for Analytics and Research in Transportation Safety (CARTS). This position will be responsible for creating, maintaining, and improving analysis tools for traffic safety data that provide actionable insights that support decision-making and strategic planning. This role involves working closely with different departments of CARTS and its stakeholders to understand analysis needs, develop reports and dashboards, and use data analysis techniques to inform stakeholder decision making. This role will also closely manage the graduate assistants in the analytics department, at the direction of the Analytics Manager.

The key responsibilities of this position include, but are not limited to: coding, data collection and analysis, data integration, reporting and dashboards, data visualization, business performance tracking, trend analysis and forecasting, and data documentation and reporting.

Job Responsibilities:

50% - Data Analysis and BI Development:

Create, update, and improve complex programs and scripts relevant to multiple objectives using Python, R, or other appropriate language.

Design, build, and implement statistical and machine learning models to solve specific business problems. Visualize data using charts, graphs, and dashboards to communicate insights clearly.

Use data visualization tools (e.g., Tableau, Power BI) to create interactive and dynamic reports that connect to and rely on multiple data sources.

20% - Stakeholder Collaboration and Needs Assessment:

Work closely with business stakeholders to understand and define their needs. Translate these requirements into actionable BI solutions, ensuring alignment with CARTS' objectives and stakeholder expectations.

10% - Data Extraction and Preparation:

Work with Information Technology Manager and Analytics Manager to design and build the data infrastructure necessary to achieve data driven analytic solutions. Prepare and analyze data for studies and analytical tools using appropriate methods. Extract and analyze data to support the efforts of CARTS stakeholders.

10% - Project Management:

Manage projects, graduate assistants, and student workers as assigned by Analytics Manager.

10% - Other Duties as Assigned:

Perform miscellaneous tasks as directed by the Analytics Manager.

Minimum Qualifications:

Education Level: Bachelor's degree in Business Analytics, Data Science, Economics, Statistics, Mathematics, or related field

Degree Substitute: LSU is dedicated to fostering an environment where our employees feel appreciated for their skills and individuality. If a candidate does not meet the minimum qualifications as listed but has substantial experience in the key job responsibilities, we encourage them to apply.

Years of Experience: 2 years of related experience or Master's degree

Specific Experience: Experience in data analysis, business intelligence or related role.

Knowledge of statistical analysis software (e.g., R, Python).

Familiarity with Excel, SQL, and data visualization tools (e.g., Tableau, Power BI). Familiarity with statistical methods and predictive modeling.

Preferred Qualifications:

Education Level: PhD degree in Business Analytics, Data Science, Economics, Statistics, Mathematics, or related field

Years of Experience: 2-3

Specific Experience: Expertise with statistical methods and predictive modeling.

Experience doing analysis, programming, or data visualization with traffic safety data.

Strong Experience building complex applications using Python, R, SQL or any combination thereof.

Demonstrated experience handling multiple long term projects, milestones, and stakeholders.

Competencies:

Knowledge of statistical analysis software (e.g., R, Python). - Advanced

Experience with business intelligence tools such as Microsoft Excel, including Solver and PowerPivot - Advanced

Experience preparing data for analysis using SQL. - Advanced

Experience with data visualization software such as Tableau or Microsoft PowerBI. - Proficient

Analyzing large datasets, identifying trends, and extracting actionable insights to guide business decisions. - Proficient

Problem solving - Advanced

Attention to Detail - Proficient

Effective verbal and written communication skills - Advanced

Able to work effectively in a team environment and collaborate with colleagues from different departments. - Proficient

_________________________

Background Check - An offer of employment is contingent on a satisfactory pre-employment background check.

Benefits - LSU offers outstanding benefits to eligible employees and their dependents including health, life, dental, and vision insurance; flexible spending accounts; retirement options; various leave options; paid holidays; wellness benefits; tuition exemption for qualified positions; training and development opportunities; employee discounts; and more!

Positions approved to work outside the State of Louisiana shall be employed through Louisiana State University's partner, nextSource Workforce Solutions, for Employer of Record Services including but not limited to employment, benefits, payroll, and tax compliance. Positions employed through Employer of Record Services will be offered benefits and retirement as applicable through their provider and will not be eligible for State of Louisiana benefits and retirement.

All candidates must have valid U.S. work authorization at the time of hire and maintain that valid work authorization throughout employment. Changes in laws, regulations, or government policies may impact the university's ability to employ individuals in certain positions.