Business Intelligence Reporting

Marsh Canada is seeking candidates for the following position based in the Mexico office and be onsite 3 days a week:

Business Intelligence Reporting - Senior Analyst

What can you expect?

The Finance, Data Management, & Reporting Specialist Senior Business Analyst is responsible for providing business & technical analysis support in the areas of Finance, Data Management, and Reporting. 

The Senior (BA) Business Analyst is responsible for understanding business needs, facilitating business requirements, documenting business requirements into (BRD) Business Requirements Document, developing current and future state process diagrams, developing prototypes to facilitate/validate business requirements, documenting use-cases required to support business requirements for application development, and developing requirements traceability matrix as input for UAT. 

The BA will be supporting projects involving cross-offices, business practices, or functions.

What is in it for you?

• A company with a strong Brand and strong results to match
• Culture of internal mobility, collaboration and valued partnership from the business.
• Employee Resource Groups which provide access to leaders, relevant volunteer and mentoring opportunities and interactions with counterparts in industry groups and client organizations.
• Entitled to vacation, floating holidays, time off to give back to your community, sick days, and national holidays (with early dismissal).

We will count on you to:

• Conduct and facilitate business requirement workshops & process walkthrough, with the business stakeholders, and obtain sign-off. 
• Translate business strategies and objectives into business requirements; provide traceability of business requirements to IT Solutions and ensure system testing encompasses existing capabilities of solution as well as future function point requirements. 
• Identify, verify and document functional requirements using requirements management methodology and tools.  In addition clearly identify data elements and provide data mappings/dictionaries where required.
• Analyze, design/redesign, and document as is and to be business processes.
• Conduct/facilitate final acceptance tests for solutions with the user community.  This will include the development of UAT test scenarios and test scripts as required.
• Develop, deliver, and evaluate training materials; supplement materials when necessary.
• Conduct systems requirement walk-through with the development & (QA) Quality Assurance teams to ensure clear and complete understanding of the requirements. 
• Provide testing guidance to the QA team, review their quality assurance testing plan & results, and facilitate & support the UAT (User Acceptance Testing) with the business users.
• Responsible for conducting and analyzing feasibility studies/impact assessments regarding implementation of IT solutions against current state parameters (process, application use-cases, non-functional impact, etc.).
• Partner with Business and IT to define and manage scope with each release
• Monitors and controls the production, distribution and maintenance of Management Information and Business Intelligence
• Analyze reporting specifications and develops/delivers reporting solutions on time and with minimal defects
• Provides scheduled and special ad-hoc reports
• Prepares documentation for report specifications or Quality Assurance testing.
• Provides training to other unit employees on advanced and complex reporting concepts, as needed.
• Develops complex and customized reports, both on a proactive basis to address client needs as well as in response to user requests.
• Works in conjunction with data architect & project design team on new and innovative reporting solutions and, as requested, perform business analysis and troubleshooting tasks.

What you need to have:

• . 3+ years of experience in analyzing business problems and designing successful solutions
• Bachelorâs degree
• Strong Business Process Analysis and documentation skills
• Ability to elicit and document business requirements
• In depth technical experience in Oracle database development, Data modelling, Performance tuning , Schema Design  and data warehousing, Extract/Transform/Load (ETL) .
• Capable of initiating business process review sessions in order to optimize an overall outcome both business and technical driven
• Ability to work with databases and other BI software products to manipulate and transform data that can be used for analysis and decision making.
• Proficiencies with utilities such as  Import, Export , SQL* Loader, External tables, Advanced queuing and Materialized Views. concurrent programs using SQL, PL SQL and UNIX shell scripting.
• Operated on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Proficient in implementing projects using Agile and waterfall methodologies.
• Involvement in Offshore and Onsite model
• Tools: PL/SQL Developer, SQL Developer, TOAD, SQL advantage , Informatica power Centre Tool, Oracle Forms                               
• Programming Languages: Oracle SQL, PL/SQL, Informatica, UNIX Shell Scripting, Fame Time Series and Vector Processing
• Reporting Tools:  Proficiency in Business Object, Qlik, Tableau
• Web Applications : JAVA, CSS, XML, and HTML, Oracle APEX(front-end)
• Version Control: VSS, SVN, Clear Case
• Can effectively participate/lead requirements gathering and review sessions comprised of both IT and business representatives.
• Ability to articulate Business Requirements to both on shore and off shore development teams.
• Ability to articulate technical concepts, and design to business users
• Experience of the complete SDLC
• Ability to partner with IT and the business teams to management scope of the requirements.
• Strong track record in collaborating across the organization.
• Strong (clear and concise) communication skills
• Good interpersonal skills adequate for dealing and communicating clearly with people from all levels of the organization, and with external customers and suppliers
• Excellent oral and written skills adequate for documenting complex business requirements clearly and unambiguously

What makes you stand out

• Strong knowledge & experience in the insurance industry
• Fluency in written & spoken English, French
• Professional BA certification, either CBAP (Certified Business Analysis Professional) or CCBA (Certification of Competency in Business Analysis),

If you are interested, please send your CV in English.

Interviews will be hold in English.

Marsh McLennan (NYSE: MMC) is the worldâs leading professional services firm in the areas of risk, strategy and people. The Companyâs 85,000 colleagues advise clients in 130 countries.  With annual revenue of over $20 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. Marsh  provides data-driven risk advisory services and insurance solutions to commercial and consumer clients. Guy Carpenter  develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. Mercer  delivers advice and technology-driven solutions that help organizations redefine the world of work, reshape retirement and investment outcomes, and unlock health and well being for a changing workforce. Oliver Wyman s  serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit marshmclennan.com, or follow us on LinkedIn and Twitter.

Marsh McLennan is committed to creating a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.

Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local based teams will identify at least one âanchor dayâ per week on which their full team will be together in person. office or working onsite with clients at least three days per week. Office-based teams will identify at least one âanchor dayâ per week on which their full team will be together in person.