Lead Data Analyst
About The Position
Immediate need for a Senior/Lead Data Analyst position. This role is part of the Data Warehouse team and requires strong leadership/management experience, with a background in AI, data warehousing, AWS, and Snowflake. P&C insurance experience is highly preferred. The candidate will be responsible for implementing a brand-new policy administration system, fixing data issues, and tracking defects to completion using a defect tracking tool. This role also involves testing and assisting users with SQL queries. Knowledge of Snowflake is a plus. The ideal candidate should possess leadership skills, be energetic and confident, and demonstrate a strong sense of ownership. We are looking for someone with more technical and lead experience, including AI experience. Candidates must have strong SQL and hands-on testing experience.
Requirements
- Bachelor's degree in Computer Science (or equivalent experience), with 5-8 years of software development experience
- Experience in querying relational databases
- Experience in data mapping and transformation
- Knowledge of structured analysis
- Experience using a software development life cycle (SDLC) methodology, including project planning and estimating
- Experience with SQL with ability to create SQL queries for analysis and testing as well as assist developers in creating queries
- Effective oral and written communication skills
- Strong organizational skills
- Strong analytical skills and technical skills
- Ability to work with minimal direction
- Ability to lead, direct, and drive efforts of other team members
- Ability to work on multiple, concurrent projects
- Ability to effectively collaborate and build strong relationships with internal and external partners
- Attention to detail and quality
- Team player
- Strong motivational skills
- Strong leadership/management experience
- Strong background in AI, data warehousing, AWS, and Snowflake
- 10-15 + years experience
- P& C exp and Policy Admin exp
- Excellent communication skills
- Policy Administration knowledge
- SQL exp
- Leadership skill
- Energetic and confident
- Take ownership
- More technical and lead experience
- AI experience
- Strong SQL
- Hands on testing exp (not just oversights)
Nice To Haves
- Knowledge of the Property and Casualty Insurance industry desired
- Prior experience with statutory and compliance-related reporting a plus
- Proficiency with MS Office suite
- Prior Supervisory experience
- Exposure to DB2 and SQL Server databases
- Exposure to Cloud technologies
- Ability to think outside of the box and a strong desire to improve the status quo
- Knowledge of Snowflake ++
Responsibilities
- Analysis and clarification of business requirements both internal and external
- Provision of work effort estimates to Project Managers
- Development of detailed functional and system specifications using Software Development Life Cycle (SDLC) methodologies and software tools.
- Collaboration with the Development team in all phases of the SDLC
- Development of use cases
- Design support, testing and monitoring of all required changes needed to maintain all compliance-related reporting and discretionary projects
- Creation of data and transformation mapping specifications
- Development of test plans and test cases, and execution of accurate and thorough testing
- Involvement in unit, integration, user and performance testing.
- Management of requirement and testing accountabilities through working closely with business and IT partners
- Support of audits and market conduct exams as needed
- Implementing a brand-new policy administration system
- Fixing data issues
- Tracking defects to completion using a defect tracking tool
- Assisting users with SQL queries
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
