Sr Business Systems Analyst

For more than 170 years, The Hanover has been committed to delivering on our promises and being there when it matters the most. We live our values every day, demonstrating we CARE through our values, ESG initiatives, and IDE journey.Our IT Department is currently seeking a Sr Business Systems Analyst to join our growing team. This position is hybrid out of our Worcester, MA location or remote. This is a full-time, exempt role.POSITION OVERVIEW:We are looking for an advanced business system analyst with the desire to join a dynamic team managing systems that support business outcomes for our Enterprise space. The position offers the opportunity to partner with business and technology. If you love working in a collaborative, innovative, and learning environment, then we want to hear from you.The Business System Analyst is responsible for the collection, development, analysis, documentation, and communication of business needs and requirements. Throughout an assignment, the Business Analyst will interface and work collaboratively with both technology and the business organization assessing the needs of the assignment by directly interacting with management, leadership, technology, the business, and the customer. The Business System Analyst looks for opportunities to develop and grow the business through effective use of technology taking a broad perspective to determine how solutions will impact existing work processes and systems, and how to manage the integration.IN THIS ROLE, YOU WILL:Support data management efforts, from source through integration, understanding data transformation over time, data mapping and/or analysis and mapping 3rd party data sources.Ensure data integrity and quality for the data within the organization.Profile data to understand data anomalies and data quality issues.Serve as a project team member for projects of medium to large scope and moderate complexity, or sub-projects within a large or highly complex project.Participate in project planning from requirements through design, testing, implementation, and maintenance.Responsible for the collection, analysis, and documentation of business and/or technical requirements, which may include leading planning sessions with business partners to improve a business process or products within the department.Provide technical expertise across the Enterprise technology business unit, understanding the relationship between the business and the data and technology that supports the business.Collaborate with all relevant parties by demonstrating knowledge of the business technical systems and providing timely and accurate information between the business partner and the information technology organization. This includes ad-hoc data requests/analysis, user support, etc.Assess needs to identify business priorities and advise business partners on options and technical limitations.WHAT YOU NEED TO APPLY:Bachelor’s degree or equivalent required.At least 5+ years of relevant work experience, internships included.Advanced understanding of data warehousing concepts, architectures, and processes.Strong experience with data mapping, data warehousing, and enterprise warehousing including understanding and using relational and dimensional database structures.Advanced understanding of mapping data attributes from existing sources to the target reporting data models; identify gaps between the target reporting data model and the required attributes identified by business users, and articulate data derivation or transformation rules in business terminology. Understanding mapping Xpaths, reading XML, and updating and governing reference data.Working knowledge of insurance data in warehouses, a plus but not required.Experience writing and executing SQL queries.Understanding of extraction, transformation, and loading (ETL) concepts.Experience using business intelligence software, including the construction of reports based on warehouse data.Adept in desktop applications and software tools.Experience being a liaison between technical and business teams (Data Steward, Data Architects, and Software Engineers).Strong experience analyzing and documenting data requirements to create specifications, utilize storyboarding and prototyping to assist with the design of integrated solutions.Analytical Thinking – Ability to apply analytical techniques (e.g., separating a complex whole into its parts or elements to resolve problems or issues).Communication – Ability to express concepts (e.g., business, technical, and other), ideas, insights, opinions, and conclusions, so that others understand.Information seeking – Thoroughly investigates and researches multiple sources to expose details and complete information about resources, issues, problems, and so forth.Self-Management – Effectively plans and organizes their work to achieve desired outcomes.Relationship building – Develops and maintains cooperative relationships.CAREER DEVELOPMENT:It’s not just a job, it’s a career, and we are here to support you every step of the way. We want you to be successful and fulfilled. Through on-the-job experiences, personalized coaching, and our robust learning and development programs, we encourage you – at every level – to grow and develop.BENEFITS:We offer comprehensive benefits to help you be healthy, build financial security, and balance work and home life. At The Hanover, you’ll enjoy what you do and have the support you need to succeed.Benefits include:Medical, dental, vision, life, and disability insurance401K with a company matchPTOCultural Awareness Day in support of IDEOn-site medical/wellness center (Worcester only)The Hanover values diversity in the workplace and among our customers. The company provides equal opportunity for employment and promotion to all qualified employees and applicants on the basis of experience, training, education, and ability to do the available work without regard to race, religion, color, age, sex/gender, sexual orientation, national origin, gender identity, disability, marital status, veteran status, genetic information, ancestry or any other status protected by law.

#J-18808-Ljbffr