Data Analyst

The mission of the Data Analyst at Waltz Health is to use leading data analytics tools to identify and demonstrate value creation opportunities for consumers and clients looking to save on prescriptions.  You’ll do this by developing robust reporting packages for internal teams and external clients. You will work with the Waltz team to create a list of requirements, select the right technology stack, and execute to create a full reporting package from start to finish. This reporting structure will create foundation for our future growth, and establish a standard across the whole company.

The Data Analyst will work with variety of tech systems spanning across the whole organization (Microsoft DevOps, Amazon S3/Redshift, Atlassian, Tableau, PostrgeSQL and etc.)   

As a data analyst, your activities will be centered around intake of files (Microsoft Pipeline/Python), manipulation of files (SQL/Python), visualization (Tableau, Python, Excel) and presentation internally or externally (Tableau, PowerPoint, Excel) + any additional ad-hoc analysis through Tableau/Excel.  Metrics guiding your output will include: on-time delivery, accuracy, client satisfaction, and value opportunities identified.

• Create processes around intake of raw files; dealing with storage, processing, cleaning and manipulating data through different tools (ETL)
• Work with internal and external teams to understand project requirements, and propose analytical solutions
• Develop and present your findings to the rest of the colleagues, using visual tools such as Excel, PowerPoint, Tableau
• Provide data support for ad hoc projects covering our whole organization (IT, operations, finance and supply chain)

• Are enthusiastic, positive, and hardworking.
• Are flexible with job roles and responsibilities – i.e. be willing to jump into new projects and have a scrappy start-up mentality.
• Are a clear communicator who is comfortable working with all levels of the organization.
• Thrive working independently, autonomously, and can adapt to changing needs of a growing company.
• Are able to think effectively, critically and creatively.
• Have 2+ years of previous experience in data analytics work, ideally for technology and/or healthcare companies.
• Worked and manipulated large datasets using SQL or other languages.
• Created dashboards using visual tools such as Tableau, PowerBI or QlikView.
• Have strong communication skills in combination with experience in creating external facing PowerPoint decks.

It would be preferable if you:

• Lived in Chicago.
• Have experience with Python or other programming languages.
• Have used product development stacks like Atlassian (i.e. Jira/Confluence) or Microsoft DevOps
• Have familiarity with Postegre SQL, either directly or through other solutions such as Amazon Redshift.

• Develop external client reporting, and set up key structure and processes that will allow us to apply it to future more complex clients
• Work with product team to create KPIs, and track how we are doing on a regular basis.
• Meet and collaborate with our external teams to improve our current data flow and work with them on future expansions.
• Provide feedback on current internal reporting infrastructure, and work with internal and external team to improve existing processes.

• Bachelor's degree