Working under the general direction of the BI Manager of the MGPOPhysician Analytics & Business Intelligence department; primaryresponsibilities include development of reporting and dashboard solutions thatmeet the needs of the organization. The developer must work well in a teamsetting and have excellent organizational, prioritization, communication, andtime management skills. The successful candidate will demonstrateaccountability, flexibility and adaptability to handle multiple and changingpriorities and can successfully collaborate with development teams, technologygroups, and key stakeholders.
PRINCIPAL DUTIES AND RESPONSIBILITIES: Indicate key areas ofresponsibility, major job duties, special projects and key objectives for thisposition. These items should beevaluated throughout the year and included in the written annual evaluation.
Develop and maintain Cognos Reports lists, crosstabs, graphs,scorecards, standard reports and dashboards using the IBM Cognos 10.2 toolset(Report Studio, Active Reports, Workspace Advanced).
Develop and maintain Tableau dashboard with visualization,action and user filters, advanced navigation, Level-of-detail expressions and table calculations.
Solve real-world business problems by designing and building queriessourced from OLAP (online analytical processing) cubes, applying data miningalgorithms, writing queries, and designing reports using the IBM Cognos toolsetand a SQL Server data warehouse. Create and/or enhance report objects, metrics,filters and prompts. Debug, monitor, and troubleshoot BI solutions
Support senior-level developers,analysts with reporting, analysis, and Adhoc reporting. Participatein requirements gatheringexercises with the business and conduct Unit Testing to validate report results againstrequirement deliverables for accuracy.
Troubleshoot and analyze data issues within reports. Document and communicateissues, level of effort and solution options.
Assume rotatingresponsibility of being the BI teams point person for the PBO month end closeactivities by coordinating close activities with the business, DB team andmanagement. Complete all BI reconciliation of month end data and the IPORTreports and cubes. On a day to day basis the BI developer will also beresponsible for daily reconciliation of IPORT data against Epic ProfessionalBilling Cube. S/he will escalate any data issues discovered with the businessthat requires workflow fix such that it is resolved on time ahead of the monthend. Month end close activities occur every month on the 1st and 2ndcalendar day and completing this on time and budget is highly importantirrespective of company holidays.
Meet deliverable deadlines and escalate when there is risk to meetingdeliverables.
Follow BI standards and best practices across the team
Write relational and multidimensionaldatabase queries
3-5 years of Information Technology experience with a strong focuson Data Warehousing and Enterprise Reporting solutions.
3+ years experience with developing applications, reports, and dashboards usingIBM Cognos Business Intelligence suite is required.
3+ years experience with developing reports against an OLAP data source isrequired.
At least 3 years hands on experience with technical support. Strong ability totroubleshoot required
IBM Cognos certification or familiarity with version 10.2 is a strong plus.
3+ years experience working with data warehouses is preferred. Strong SQLskills and experience with performance tuning are required.
3-5years of Cognos BI development, testing and change management experience withCognos BI products
Documentationand working with fast paced cross functional teams is required.
Experience with BI end users production support
SKILLS/ ABILITIES/ COMPETENCIESREQUIRED:
Supports and demonstrates the values of the Massachusetts General Hospital and the MassachusettsPhysicians Organization by conducting activities in an ethical manner withintegrity, honesty, and confidentiality. Demonstrate a positive, open-minded,can-do attitude. Represents a team perspective and shows a willingness andenthusiasm to collaborate with others. Follows through on commitments and achieves desired results. Exhibits sound judgment, obtains the facts,examines options, gains support, and achieves positive outcomes
$140K - $160K