Business Intelligence Reporting

Description:

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),

---