Data and Reporting Analyst
Core
Collect, transform, and store data from diverse sources to create meaningful reports and dashboards for stakeholders, enabling data-driven decision-making within the insurance function.
Role type
Senior Data and Reporting Analyst (ETL & Visualization)
Builds
Production reporting tools, dashboards, and automated data pipelines for business units
Domain
Insurance / Financial Services
Deliverable
dashboards & analysis
Required skills
SQL, data modeling, ETL processes, database administration, data warehousing, reporting tool development, automation scripting
Preferred skills
Python, Java, or Scala; SAS Base/EG; Snowflake, Redshift, or BigQuery; Tableau, Power BI, or QlikView; Agile methodologies; insurance domain knowledge
Technologies
SQL Server, Oracle, PostgreSQL, SAS Base, SAS EG, Apache NiFi, Apache Spark, Talend, Snowflake, Redshift, BigQuery, Tableau, Power BI, QlikView
Responsibilities
Design and maintain ETL processes; create interactive dashboards and reports; administer and optimize databases; implement data quality checks and governance policies; develop automated solutions for data processing; lead onshore reporting projects; perform root cause analysis on data queries
Seniority
Senior, hands-on IC