Manager Of Data Warehouse/Business Intelligence (Microsoft BI Stack Experience Only) (825Dwbi)

Healthhelp Houston , TX 77020

Posted 5 months ago

MAJOR RESPONSIBILITIES

Oversees the HealthHelp data warehouse environment (EDW) and tools (Microsoft BI Stack, Tableau, GenReports, Power BI) to support monthly and self servicing reporting for existing customers as well as internal data analysis. The Manager of Business Intelligence is responsible for meeting with Analytics team & 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 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/DW 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 Data Warehouse and Business Intelligence platform and tools.

  • Communicate platform changes and deployments to other departments

  • Mentor other developers and Analysts with in the team & organization

  • Architect a BI framework based on the SQL BI methodology that allows incremental and full loading of multiple sources and facilitate the rapid onboarding of additional client data & programs.

  • Implement an innovative modeling of a rapidly changing environment that allowed for accurate historical reporting for contracted and pre contract customers.

  • Architect, implement, and design an SSAS cube that facilitate near real-time reporting on several key source systems permitting the application to operate in both analytical and operational capacities

  • Implement tools to facilitate self-service BI reporting platform

  • Manage change control processes internal to DW & Data Operations

  • Work with VP of IT Data Systems & Analytics to integrate customer data into DW for analytics and standard reporting

  • Work closely with the product, clinical ops, client services and the analytics teams to support new client implementations as well as analytical processes, including New Unit, savings, scorecard, slippage, invoices, etc methodologies for new programs as well clients.

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

  • Facilitates organizational data strategies for governance, design, implementation, integration and usage.

Required Skills

GENERAL QUALIFICATIONS

  • Master's or Bachelor's degree in business, computer science, mathematics, engineering, informatics, business intelligence, information technology, business or related field required

  • Minimum 6 + years of extensive experience in Microsoft BI Stack (SSIS, SSAS, SSRS, T-SQL & MDX Programming)

  • Minimum 3+ years of DW/BI architect 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 the Kimball data warehouse lifecycle and strong dimensional data modeling experience, star schemas including an understanding of extraction, transformation, and load processes from operational source systems into the data warehouse.

  • 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 Data warehouse systems.

  • Experience in Cube development using Microsoft SQL Server Analysis Services

  • Must be authorized to work in the United States on a full-time basis for any employer

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Developer Business Intelligence

Jobvous LLC

Posted 4 days ago

VIEW JOBS 10/16/2019 12:00:00 AM 2020-01-14T00:00 <p><strong>Essential Job Functions</strong><br /></p><ul><li>Implement and support Business Intelligence solutions for the Retail Energy business.</li><li>Gather business requirements, develop logical solutions, assess implementation alternatives and formulate overall design approaches.</li><li>Work closely with key business stakeholders across all business functions to determine the best solution possible.</li><li>Work on ETL processes of large sets of data. Gather, store and model the data for analytics and reporting purposes.</li><li>Work with the PMO team using Agile methodology to deliver projects on time and on budget.</li><li>Ability to adapt quickly to new technologies and create proof of concepts for the leadership team and business.</li><li>Responsible for the design, development, and maintenance of BI and ETL processes while adhering to standards developed by the Technical Architecture team.</li><li>Coach and mentor junior developers.</li><li>Participate in user story workshops and estimation sessions.</li><li>Participate in sprint planning and sprint review sessions.</li><li>Participate in team code reviews.</li><li>Peer review other team members&rsquo; completed user stories and provide feedback.</li><li>Participate in technical architecture review sessions.</li><li>Collaboratively manage source control with team including branching and merging procedures.</li><li>Create and organize automated unit tests adhering to code coverage requirements.</li><li>Understanding of common software development design patterns and ability to incorporate into technical solution.</li><li>Ability to provide support during non-standard work hours or during an unplanned outage or emergency if needed.</li></ul><p><strong>Requirements</strong></p><ul><li><p>Ability to model data coming in from different data sources into BI technologies such as Azure SQL Data Warehouse, Data Lake and accommodate the self-service reporting by internal users.</p></li><li><p>Strong SQL and T-SQL skills with SQL Server or Oracle database as backend.</p></li><li><p>Ability to design and code stored procedures, functions, views and other DB objects.</p></li><li><p>Ability to design and implement core BI framework to drive analytics across the organization</p></li><li><p>Fluency in using Azure BI Stack and Data Integration (Data Factory, SQL Data warehouse and Azure Data Lake Storage).</p></li><li><p>Excellent knowledge in designing and delivery of Power BI Reports, Dashboards, Datasets and related applications.</p></li><li><p>Expertise in working with a team of Data Scientists to generate Advanced Analytics on structured, semi-structured and unstructured data.</p></li><li><p>Experience with Integration tools and related technologies will be a plus.</p></li><li><p>Knowledge and exposure to Cloud Integration concepts &amp; fundamentals.</p></li><li><p>Knowledge of Product Development Lifecycle and DevOps Tools like Azure DevOps, Git, Ant, JIRA, etc.</p></li><li><p>Experience with defect triage, analysis, and resolution.</p></li><li><p>Experience with Microsoft Visual Studio and Microsoft Teams.</p></li><li><p>Experience instantiating and managing resources in Microsoft Azure.</p></li></ul><p>&nbsp;</p><p><strong>Essential Physical Abilities</strong></p><ul><li><p>Ability to meet highest attendance requirements.</p></li><li><p>Ability to communicate effectively, both written and verbally.</p></li><li><p>Ability to handle multiple assignments on a timely basis with a high degree of accuracy.</p></li><li><p>Ability to use personal computer, calculator, etc.</p></li><li><p>Could involve some lifting.</p></li></ul><p>&nbsp;</p><p><strong>Education/Experience</strong></p><ul><li><p>Bachelor&rsquo;s degree in Business Administration, Computer Science, Information Systems or a related field required.</p></li><li><p>5-7 years of professional work experience as a Systems Integrator or as a senior Business Intelligence developer implementing successful enterprise BI solutions.</p></li><li><p>4+ years of experience with BI technologies.</p></li><li><p>3+ years of experience with SQL Server and ETL.</p></li><li><p>1-2 years of experience with Microsoft Azure environments will be a plus.</p></li><li><p>Retail Energy Industry Experience will be a plus.</p></li><li><p>Strong knowledge and experience in System Development Life Cycle (SDLC) project management and applicability of IT controls to development deliveries.</p></li></ul><p>&nbsp;</p> Jobvous LLC Houston TX

Manager Of Data Warehouse/Business Intelligence (Microsoft BI Stack Experience Only) (825Dwbi)

Healthhelp