Sr Business Systems Analyst

nt, 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 3 rd party data sources.

• Ensure data integrity and quality for the data within the organization.

• Profile data to understand data anomalies and data quality issues.

• Serves 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.

• Providing technical expertise across the Enterprise technology business unit, understanding the relationship between the business and the data and technology that supports the business.

• Collaborates 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.

• Assessing 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.

• Recommended 3-5 years of relevant work experience, internships included.

• Quantitative background required.

• 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. Create an environment that encourages and values the opinions of others and promotes sharing of information and ideas.

• Information seeking - Thoroughly investigates and researches multiple sources to expose details and complete information about resources, issues, problems, and so forth. Conducts in-depth research, asks probing questions, and transcends surface issues.

• Self-Management - Effectively plans and organizes their work to achieve desired outcomes. Demonstrates flexibility in applying different approaches to changing work demands. Shows confidence in own abilities to meet challenges.

• 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 insurance
• 401K with a company match
• Tuition reimbursement
• PTO
• Company paid holidays
• Flexible work arrangements
• Cultural Awareness Day in support of IDE
• On-site medical/wellness center (Worcester only)
• Click here for the full list of Benefits

EEO statement:

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.

Furthermore, The Hanover Insurance Group is committed to providing an equal opportunity workplace that is free of discrimination and harassment based on national origin, race, color, religion, gender, ancestry, age, sexual orientation, gender identity, disability, marital status, veteran status, genetic information or any other status protected by law."

As an equal opportunity employer, Hanover does not discriminate against qualified individuals with disabilities. Individuals with disabilities who wish to request a reasonable accommodation to participate in the job application or interview process, or to perform essential job functions, should contact us at: [email protected] and include the link of the job posting in which you are interested.

Privacy Policy:

To view our privacy policy and online privacy statement, click here .

Applicants who are California residents: To see the types of information we may collect from applicants and employees and how we use it, please click here **.
**

Other details

• Pay Type Salary