Responsibilities:
Data Preparation and Cleaning
- Work with large datasets from multiple sources, performing data cleaning, preparation, and transformation as needed.
- Automate data preparation processes to improve efficiency and scalability.
- Develop and maintain a business-friendly data catalog with detailed descriptions, support self-service analytics platforms, and ensure data quality and governance practices are followed to enhance data accessibility and reliability.
Data Visualization
- Develop and maintain dashboards and reports to support strategic decision-making and track key performance metrics using tools like Tableau, Metabase, or Excel.
Data Analysis and Insight Generation
- Analyze data trends and ensure accuracy and relevancy to address business questions or problems.
- Identify actionable insights and recommend solutions that align with company objectives and drive measurable impact.
- Research publicly available resources (e.g., journal articles, white papers) to enhance analysis quality and provide well-informed recommendations.
Reporting
- Prepare accurate, concise, and meaningful reports that describe and interpret analysis findings to support decision-making by upper management.
- Respond to and fulfill ad hoc data requests promptly, ensuring accuracy and relevance to support business needs.
- Collaborate with stakeholders to clarify reporting requirements and ensure deliverables align with expectations.
Your Profile
- Proficiency in SQL and working with data warehousing platforms like AWS Redshift and Databricks.
- Experience with data transformation tools like dbt.
- Experience with data visualization tools like Tableau or Metabase and a keen interest in improving user experience on self-service platforms.
- Advanced proficiency in MS Excel, including Pivot Tables and Macros.
- Optional programming skills in Python.
- Strong critical thinking and problem-solving skills with a focus on root cause analysis and effective follow-through.
- Ability to analyze information, evaluate results, and implement the best solutions to solve problems efficiently.
- Strong attention to detail and accuracy, with the ability to produce quality work under tight deadlines.
- Ability to manage and prioritize multiple projects with varying deadlines and shift efficiently between competing priorities.
- Understanding of data governance and data management principles, with an emphasis on data quality and accuracy.
- Excellent communication skills to collaborate with cross-functional teams and explain technical concepts to non-technical audiences.
- Interest in working with data within the insurance industry and learning mapping or related software.