Technical Manager, DW/BI Reporting

Company: HealthHelp
Location: Houston
Posted on: November 23, 2021

Job Description:

Company DescriptionHealthHelp - A WNS Company (www.HealthHelp.com), is the leader in the field of healthcare utilization & care management. We have gained this position by actively working to change out-of-date practices with a collaborative, non-denial based approach. Our methodology helps payors achieve a higher return on investment, gives providers education programs that better inform physicians, and ensures quality and safety for the patients needing treatment.HealthHelp's innovative approach and strong IT capability in specialty benefits management means that staff will move healthcare forward when provided with evidence-based solutions and second opinions. HealthHelp's staff is comprised of healthcare professionals who make a difference every day. HealthHelp has a desire to fill their company with talented and innovative people who want a career path filled with success and personal growth.Our specialty benefits management services are broad and include, Cardiology, Oncology, Radiology, Radiation Therapy, Sleep Care, and Musculoskeletal Care. HealthHelp has two locations in Houston, one a corporate office and the second a state-of-the art contact center. HealthHelp is also proud to have another such contact center in Albany, New York.WNS Global Services Inc. (NYSE: WNS) is a global Business Process Management (BPM) leader. WNS offers business value to 400+global clients by combining operational excellence with deep domain expertise in key industry verticals, including Banking and Financial Services, Consulting and Professional Services, Healthcare, Insurance, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Telecommunications, Travel and Utilities. Globally, the group's over 44,000+ Professionals serve across 60 delivery centers in 16 countries worldwide.Job DescriptionMAJOR RESPONSIBILITIESOversees the HealthHelp data warehouse environment (EDW) and tools (Microsoft BI Stack, Tableau, GenReports, Power BI) to support monthly and self servicing reporting platforms. The Manager of Business Intelligence Reporting is responsible for meeting with IT, Analytics team, Operations, Clinical, Client Services & Product development managers to integrate new quantitative metrics and/or processes into the overall data warehouse platform to expand capabilities and functionality. The Manager of BI Reporting is responsible for ensuring data integrity and report consistency across all data warehouse reporting. Additionally, the position ensures frequency specific reporting is completed and distributed to our internal decision makers as well as external customers on time. Works with Product Implementation to coordinate new customer and/or product scheduled reporting.--- Manage and Provide leadership and direction for the Business Intelligence team which may include multiple functional areas including but not limited to the DW platform & reporting--- Responsible for gathering business requirements, analyzing business needs, defining the BI reporting architecture to meet & support and participate in the delivery of technical solutions to complex business and technical requirements--- Responsible for leading the design, Architect and maintenance of the Business Intelligence Reporting platform and tools.--- Communicate platform changes and deployments to other departments--- Mentor other developers and Analysts with in the team & organization--- Conduct periodic demo and training sessions with business users and Analytics team.--- Support and work with external and internal client report issues--- Implement an innovative modeling of a rapidly changing environment that allowed for accurate historical reporting for contracted and pre contract customers.--- Responsible for taking current platform into cloud (Microsoft or AWS) as is or build future state BI reporting in cloud.--- Implement tools to facilitate self-service BI reporting platform--- Manage change control processes internal to DW & Data Operations reporting--- Work with Director of DW/BI & Analytics to integrate customer data into DW for analytics and standard reporting--- Assist client services with analytics by providing a scalable and an easy to use platform to prepare for external deliverables. Schedule and lead internal meetings and training sessions to review new features and/or data analytical tools.--- Ability to create and interpret Visio process and workflow diagrams.--- Skilled in handling multiple deadline driven assignments with the ability to initiate, supervise and complete projects and assignments with minimal supervision.--- Understand the products/programs/services provided by HealthHelp and knowledge of our various utilization management programs.--- Define and implement the overall business intelligence team goals and tasks in terms of scope, quality, budget, and schedule.--- Consistent exercise of independent judgment and discretion in matters of significance. QualificationsGENERAL QUALIFICATIONS--- Master's or Bachelor's degree in business, computer science, mathematics, engineering, informatics, business intelligence, information technology, business or related field required--- Minimum 8 + years of extensive experience in Microsoft BI Stack (SSIS, SSAS, SSRS, T-SQL & MDX Programming)--- Minimum 3+ years of Microsoft SQL DW BI platform design experience is required--- Minimum 2+ years of Microsoft SQL DW BI Reporting platform management experience is required--- Position requires excellent technical and communication skills. The ability to manage multiple projects and resources simultaneously is a requirement of this position.--- Experience with relational database systems in an operational environment and particularly with Microsoft SQL Server.--- Knowledge of how the Kimball approach has been implemented in the Microsoft BI tool stack including the use of Excel PivotTables or similar reporting tools to fulfill ad hoc data requests when required.--- Experience in large scale BI Reporting systems.--- Experience in Excel & Word based reporting and Tableau & Power BI report development and maintenance--- Must be authorized to work in the United States on a full-time basis for any employer Additional InformationAll your information will be kept confidential according to EEO guidelines.

Keywords: HealthHelp, Houston , Technical Manager, DW/BI Reporting, IT / Software / Systems , Houston, Texas