Senior Manager - Integrity & Compliance

Goosehead Insurance•Westlake, OH

About The Position

We are seeking a highly analytical and detail-oriented Integrity & Compliance Analyst with Excel, Java Script, SQL, Tableau/BI, and Snowflake skills and Salesforce reporting experience or capabilities preferred. I&C Analyst will be responsible for helping develop, implement, and maintain I&C solutions that help drive strategic decisions across the organization. The successful candidate will work closely with the Legal & Compliance team to conduct investigations, provide detailed reports, and create insightful reporting that assists in reducing risk exposure and fraud.

Requirements

Bachelor’s degree in Business, Information Systems, Data Science, Computer Science, or a related field.
Proficient in Excel data management and reporting.
Experience working with Salesforce reporting and Snowflake preferred, or willingness to invest in training resources.
Strong problem solving and critical analytical skills and ability to translate complex data into actionable insights.
Self-starter with the ability to work with minimal daily oversight.
Strong communication skills and ability to work with both technical and non-technical stakeholders.
Ability to communicate and present to C-suite.

Nice To Haves

Knowledge of the insurance industry is a plus.
Knowledge or experience in sales is a plus.
Experience with data visualization best practices and the ability to tell stories through data.
Java Script, SQL, Tableau/BI, and Snowflake skills
Salesforce reporting experience or capabilities preferred

Responsibilities

Analyze large datasets to provide insights and support decision-making processes.
Design, develop and maintain reports that help to ensure data integrity of commissions and underwriting accuracy.
Generate ad-hoc reports based on business needs using Salesforce SQL and BI platforms.
Ensure that I&C solutions meet business requirements and are aligned with the company’s strategic goals.
Assist in presenting complex data in a simple, actionable format to business stakeholders.
Acquire, upload, and maintain carrier claims data from carrier partners.
Assist in the development of API’s to be utilized in enterprise browser to identify data anomalies.
Regularly review reports and accurately identify data inaccuracies for correction.
Leverage Snowflake as the central cloud data warehouse to store, manage, and analyze data efficiently.
Write SQL queries to extract, manipulate, and aggregate data from different databases, especially Snowflake.
Optimize SQL queries for efficiency and performance, ensuring large datasets are processed smoothly.
Maintain and enhance the data pipeline, ensuring the quality and accuracy of data in Snowflake.
Leverage Snowflake as the central cloud data warehouse to store, manage, and analyze data efficiently.
Work closely with cross-functional teams to conduct investigations and ensure organizational compliance of industry standards.
Collaborate with stakeholders to define key performance indicators (KPIs) and design effective reporting solutions.
Communicate insights and recommendations to senior management and other teams.