Data Analyst

Company Description

At Cotality, we are driven by a single mission—to make the property industry faster, smarter, and more people-centric. Cotality is the trusted source for property intelligence, with unmatched precision, depth, breadth, and insights across the entire ecosystem. Our talented team of 5,000 employees globally uses our network, scale, connectivity, and technology to drive the largest asset class in the world. Join us as we work toward our vision of fueling a thriving global property ecosystem and a more resilient society.

Cotality is committed to cultivating a diverse and inclusive work culture that inspires innovation and bold thinking; it's a place where you can collaborate, feel valued, develop skills, and directly impact the insurance marketplace. We know our people are our greatest asset. At Cotality, you can be yourself, lift people up and make an impact. By putting clients first and continuously innovating, we're working together to set the pace for unlocking new possibilities that better serve the property insurance and restoration industry

• Regular working hours will be from 12noon to 9pm IST
• It will be Hybrid work where the team will need to be in the office for the first half of the day for 3 days a week and they can leave in the afternoon around 3pm or 4pm and log back at home for the remaining hours (same as other local teams).
• Training will be provided about the product.

Description

We are seeking a highly skilled Data Analyst to join our Analytics Support team to serve customers across the property insurance and restoration industries. As a data analyst you will play a crucial role in developing methods and models to inform data-driven decision processes resulting in improved business performance for both internal and external stakeholder groups. You will be responsible for interpreting complex data sets and providing valuable insights to enhance the value of data assets. The successful candidate will have a strong understanding of data mining techniques, methods of statistical analysis, and data visualization tools. This position offers an exciting opportunity to work in a dynamic environment, collaborating with cross-functional teams to support decision processes that will guide the respective industries into the future.

Responsibilities

Collaborate with cross-functional teams to understand and document requirements for analytics products.

Serve as the primary point of contact for new data/analytics requests and support for customers.

• Act as the domain expert and voice of the customer to internal stakeholders during the analytics development process.
• Develop and maintain an inventory of data, reporting, and analytic product deliverables for assigned customers.
• Work with customer success teams to establish and maintain appropriate customer expectations for analytics deliverables.
• Create and manage change order tickets on behalf of customers within internal frameworks.
• Ensure timely delivery of assets to customers and aid in the development of internal processes for the delivery of analytics deliverables.
• Work with IT/Infrastructure teams to provide customer access to assets and support internal audit processes to ensure data security.
• Create and optimize complex SQL queries for data extraction, transformation, and aggregation.
• Develop and maintain data models, dashboards, and reports to visualize data and track key performance metrics.
• Conduct validation checks and implement error handling mechanisms to ensure data reliability.
• Collaborate closely with stakeholders to align project goals with business needs and perform ad-hoc analysis to provide actionable recommendations.
• Analyze large and complex datasets to identify trends, patterns, and insights, and present findings and recommendations to stakeholders in a clear and concise manner.

Job Qualifications

• 5+ years’ experience of building PowerBI dashboards, data modeling and analysis
• Bachelor’s degree in computer science, data science, statistics, or a related field is preferred.
• Advanced knowledge of data analysis tools such as Power Query, Excel, and Power BI
• Demonstrated expertise in Power BI creating reports and dashboards, including the ability to connect to various data sources, prepare and model data, and create visualizations.
• Excellent visual and storytelling skills with data.
• Experience with Power Query for importing, transforming, and shaping data.
• Expert knowledge of DAX for creating calculated columns and measures to meet report-specific requirements.
• Proficiency in SQL with the ability to write complex queries and optimize performance.
• Experience with ETL processes, data pipeline and automation a plus.
• Strong analytical and problem-solving skills
• Excellent attention to detail and the ability to work with large datasets.
• Effective communication skills, both written and verbal.
• Ability to work independently and collaborate in a team environment.
• Experience in property insurance industry will be a plus.