Data Analyst 2 / 3
Louisiana State University
Baton Rouge, Louisiana
Full-Time
Competitive
OfficeAssociate
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.
For questions or concerns related to updating your application with attachments (e.g., resumes, RS:17 documents), date of birth, or reactivating applications, please contact the LSU Human Resources Management Office at 225-578-8200 or email HR@lsu.edu. For questions or concerns regarding the status of your application or salary ranges, please contact the department using the information provided in the Special Instructions section of this job posting.