Data Analyst I - Consumer Loan Analytics at Nelnet in Madison, WI

Summary: Nelnet is a diversified and innovative company committed to enriching lives through the power of service. As a Data Analyst, you will work with a team to leverage data and create reports and dashboards that inform decision-making across the company. Responsibilities: - Query, clean, and analyze complex datasets using SQL, Python, or similar tools - Identify trends, correlations, and insights to support decision-making - Assemble forecasts to drive recommended actions within the business - Build clear reports and dashboards in tools like Excel and Power BI - Package insights in a clear, compelling narrative for business partners - Monitor data quality and recommend process improvements - Seek opportunities to automate repetitive tasks - Partner closely with business leaders to anticipate and address their data needs Required Qualifications: - Query, clean, and analyze complex datasets using SQL, Python, or similar tools - Identify trends, correlations, and insights to support decision-making - Assemble forecasts to drive recommended actions within the business - Build clear reports and dashboards in tools like Excel and Power BI - Package insights in a clear, compelling narrative for business partners - Monitor data quality and recommend process improvements - Seek opportunities to automate repetitive tasks - Partner closely with business leaders to anticipate and address their data needs - Is detail-oriented, motivated, and curious about data analytics - Has foundational experience with data (coursework, projects, or work experience) and working knowledge of SQL and/or Python - Is comfortable with Excel and reporting tools, with a desire to expand into tools like Power BI - Communicates clearly with both technical and non-technical users, translating data into meaningful stories and solutions - Thrives in a collaborative, customer-focused environment - Enjoys problem solving, approaching challenges with creativity and persistence - Manages multiple priorities while contributing to a culture of learning and improvement - Ability to extract, manipulate, and query data in database systems (T-SQL, SnowSQL, or similar) - Familiarity with reporting and dashboarding tools (e.g., Power BI, DAX) - Exposure to scripting languages such as Python for data manipulation or process automation - Understanding of data cleansing, mapping, and transformation concepts (ETL) - Strong critical thinking skills and the ability to break down complex problems into manageable parts - Enjoys puzzle-solving and approaching challenges with curiosity and persistence - Ability to conceptualize business processes and identify data-driven opportunities for improvement - Clear oral and written communication skills, including the ability to explain technical concepts to non-technical audiences - Strong interpersonal skills; able to collaborate effectively across teams - Customer-focused mindset with a desire to create practical, high-value solutions - Ability to balance multiple priorities and consistently meet deadlines Preferred Qualifications: - Experience in financial services, student loans, or other regulated industries Required Skills: SQL, Python, Power BI Important Skills: Excel, Data analysis Nice-to-Have Skills: Communication skills, Problem-solving, Collaboration Benefits: Medical, Dental, Vision, HSA and FSA, Generous earned time off, 401K/student loan repayment, Life insurance & AD&D insurance, Employee assistance program, Employee stock purchase program, Tuition reimbursement, Performance-based incentive pay, Short- and long-term disability, Robust wellness program