W2 Role - Data Analyst (Hybrid) Worcester, MA

W2 Role - Data Analyst (Hybrid)
Location: Worcester, MA

Interviews mode: Virtual

Job Description:

Applies analytical skills to the development and enhancement of unique proprietary business tools that drive the optimization and consolidation of Agent partners business and are a strategic differentiator to the unique business model. Develops tools, processes and reporting analytics in support of business growth. Communicate with customers, external partners and internal departments while effectively leading complex analytics projects.

Key Responsibilities & Outcomes

• Support complex business/technical processes and tools for multiple products, requiring the use of technical solutions across multiple departments or lines of business.

• Serve as a team member on projects of large scope and moderate to high complexity providing data analytics and project management. Works independently and leverages resources when needed.

• Apply knowledge of multiple technical business systems enterprise wide.

• Apply understanding of business processes and the P&C Insurance business to translate requirements into analytical reporting and evolve models to meet new and changing business requirements. With limited supervision, define deliverable(s) and establish a plan to achieve the deliverable.

• Develop visually appealing, detailed reports to support strategic business initiatives.

• Develop data and reports for field and customers to clearly articulate value to agent partners and customers.

• Able to respond to urgent/timely requests and produce routine and ad hoc information in a rapid and dynamic turnaround climate.

• Summarize information and effectively communicate analyses in writing and verbally to internal partners. Ability to draw insights and observations from detailed and multifaceted data and reports. Comfortable presenting finding to senior leaders.

• Work in partnership with team and management to generate innovative solutions by approaching problems with curiosity and open-mindedness, using existing information to its fullest potential.

• Participate in the development of new tools and process enhancements to enable new capabilities and solutions to drive business growth. Proactively tuned into external trending and best practices.

• Lead projects or meetings as appropriate, meet deadlines, and handle multiple priorities in a fast-paced, ever-changing and evolving business environment.

• Establish relationships with one or more business partners by demonstrating knowledge of business processes/drivers and technical systems.

• Provide technical coaching and mentoring to less experienced team members; including the usage of best practices.

• Proactively research and apply Best Practices to technology solutions.

• Work with business partners to define tools to align with business priorities and assess impact on other business processes.

• Accountable for delivery of data models at the project level, consults with and collaborates with key stakeholders and peers.

• Interview business users to obtain data requirements. May perform quality review and guidance to other team members in the development of requirements documentation.

• Collect customer requirements, define application needs, determine technical issues, and design reports to meet data analysis needs.

• Lead and or participate in the development of prototypes for various reporting, system and tools.

• Identify new sources of data and methods to improve data storage, collection, analysis, and reporting.

• Analyze and develop logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements.

• Design conceptual and logical models for the operations systems, such as ODS, data warehouse or data mart. Communicate physical database designs to database administrator.

Qualifications & Requirements

Required:

• Bachelor's degree (Likely targeting someone with a business degree who is tech savvy).

• 1 to 5 years of related analytical experience (Manager does not want to interview candidates with more than ~5 years of experience).

• Solid knowledge of SQL and Excel.

• Mix of technical and business acumen; ability to build reports technically, but also use that information to identify underperformance, influence decisions, and drive business outcomes/ROI.

• Ability to work with, integrate and evaluate large and complex data sets.

• Comfortable turning raw data into meaningful information.

• Comprehends key industry financial/ operational metrics.

• Demonstrated data analysis and problem-solving skills.

• Polished, well-spoken, and a collaborative person with a high level of written and verbal communication skills (will be presenting information to team and leaders).

• Strong project management skills, ability to manage and prioritize varied priorities under aggressive timelines.

• Intellectually curious.

Preferred:

• Knowledge of Power BI and Python.

• Insurance industry experience.

• Ability to summarize complex business concepts into written & oral communications using PowerPoint and other data presentation tools.

• Exposure to AI (team uses Copilot and GitHub Copilot).

Best Regards,

Shivam Kumar

Lead Technical Recruiter

Stellent IT Phone: 201-503-2666

Linkedin

Email: shivam@stellentit.com
Gtalk: shivam@stellentit.com