Analytics Analyst

TruStage; Madison (WI); On-site; USD 90,000 - 120,000; Full time

Job summary

TruStage in Madison, Wisconsin seeks an Analytics Analyst to translate data into insights, support analytics processes, and drive data-driven decision making across business domains.

Requirements include a 5+ year track record in data analytics, a quantitative bachelor’s degree, and proficiency with Alteryx, R, Python, SQL, SAS, and BI tools like Power BI and Tableau. You will collaborate across teams to improve core metrics and data quality.

Qualifications

• 5+ years' data analytics and reporting experience.
• Ability to gain in-depth understanding of TruStage products/services and market.
• Strong understanding of business concepts, metrics, processes, and systems.
• Ability to manage multiple priorities in a time-sensitive environment.

Responsibilities

• Support, optimize, and develop new analytics processes.
• Provide data driven insights through reports and visualizations.
• Help shape analytic solutions for specific business domains to meet objectives and key results.
• Support core metrics, KPIs, forecasts, and historical performance for domains.
• Collaborate with analytics engineering teams to set up data pipelines and deploy analytics solutions.
• Explain difficult information and tailor insights to audiences.

Skills

Alteryx

R

Python

SQL

SAS

Power BI

Tableau

Education

Bachelor’s degree in mathematics, economics, computer science, information management, statistics, or related field

Job description

At TruStage, we’re on a mission to make a brighter financial future accessible to everyone. We put people first, and work hand in hand with employees and customers to create a diverse and inclusive environment. Passionate about building insurance and financial services solutions, we push the boundaries of what’s possible. We need you to help us shape what’s next. You’ll be encouraged to share your experiences, ideas and skills to help others take control of their financial future.
Join a team that has received numerous awards for being a top place to work: TruStage awards and recognition

Job Responsibilities

The Analytics Analyst will utilize subject matter expertise in the following areas:

Business Domain Analysis

• Support, optimize, and develop new analytics processes.
• Provide data driven insights impacting the specific business domains through coherent reports and visualizations.
• Help shape the analytic solutions for specific business domains to help the business achieve its objectives and key results.
• Support the core metrics and key performance indicators for specific business domains, leading and lagging indicators, forecasts, and related historical performance.
• Solve complex business domain problems; takes a new perspective using existing solutions. and approaches changes with flexibility.
• Act as a resource for colleagues with less experience; participates in and may lead small cross-departmental projects with manageable risks and resource requirements.
  

Data Modeling, Reporting, and Business Intelligence

• Understand the relationships in specific business domain data sets, how it changes and trends over time, the key business drivers and use this understanding to accomplish the work.
• Collect, manipulate, and analyze complex datasets pertaining to specific business domains; utilizes standard formulas, methods, and BI tools common in the industry and relevant to the current data in all phases (collection, analysis, reporting).
• Helps set direction, update, and modify reporting on core metrics and key performance indicators for specific business domains.
• Utilize BI/Reporting tools to explore data and produce outputs.
• Solve problems that impact complex situations; analyze possible solutions using technical experience, judgment, and precedents within level of authority.
• Impact a range of customer, operational, project or service activities within own team and other related teams; works within broad guidelines, best practices, and policies to meet deadlines.
• Collaborate with analytics engineering teams to set up data pipelines and deploy analytics solutions.
  

Business Data Communications

• Explain difficult or sensitive information. Work to build consensus and influence.
• Contribute to change initiatives by suggesting ways to clarify ambiguity.
• Prepare presentations, reports or visualizations and present the information to various cross-departmental teams while tailoring the presentation and insights to a level appropriate for the audience.
• Adapt to new situations such as teams, projects, or work processes.
• Champion relevant data to appropriate users in an organization and monitor the published data sources for usage/relevance/quality feedback.
• Work as part of a team dedicated to maintaining and enhancing the overall usefulness, integrity, and security of data across the enterprise.
  

The above statement of duties is not intended to be all inclusive and other duties will be assigned from time to time.
Job Requirements

• Bachelor’s degree in mathematics, economics, computer science, information management, statistics, or related field or equivalent combination of education and/or related professional work experience.
• 5+ years\' data analytics and reporting experience.
• Ability to gain in-depth understanding of company products and services, awareness of the competition, and knowledge of factors that differentiate TruStage in the market.
• Strong understanding of applicable business concepts, metrics, processes, and systems for business domains.
• Ability to independently manage multiple priorities in a time sensitive production environment.
• Awareness of leading practices and how own area integrates with others.
• Skilled in data mining technologies such as: Alteryx, R, Python, SQL, SAS.
• Ability to interpret data models in conjunction with exploratory analysis of a database.
• In-depth knowledge of key data within a specific data domain and or business unit, SME knowledge on one or more source systems.
• Ability to start connecting multiple lines of business and/or data domains across the enterprise.
• Ability to tutor individuals within the department on specific data domains / businesses.
• Knowledge of the logical and physical data model currently leveraged by a specific business unit and data storage tools such as Snowflake and SQL Server.
• Ability to translate complex business requirements into model relationships.
• Skilled in BI applications such as Power BI and Tableau.
• Ability to construct dynamic reports / scorecards vs static reports.
• Ability to represent relevant data within comprehensive visuals.
• Ability to incorporate aesthetic principles into report / scorecard development.
• Ability to communicate analytics in layperson’s terms
• Capable of leading development of presentation logic
• Strong presentation skills
• Ability to communicate (verbally and in writing) with internal and external teams regarding tasks and assignments