• Responsible for leading and performing data warehouse design, data analysis, design and developing ETL (Extract, Transform and Load) and reporting solutions using Microsoft Business Intelligence (BI) tools. • Performs design and code reviews while leading and mentoring BI developers to ensure best practices and the review process are being followed. • Participates in establishing the data management framework that improves the data quality and standards for both database structures and the warehouse repository. • Designs, leads and develops requirements for data mapping and ETL processes. • Designs, leads and participates in the development of the data model(s) for the data warehouse. • Provides recommendations for all data strategies and innovative reporting solutions. • Performs analysis and design, and maps data between source systems and the Enterprise Data Warehouse; analyzes data in source systems to assess data quality and makes recommendations for addressing within the source systems or as part of the ETL process. • Develops SSAS Tabular Models, Power BI Dashboards and other appropriate data access objects for end user reporting depending on business need. • Performs design and code reviews to ensure best practices and standards are being followed by all team members. • Other duties as assigned.

• Collaborate cross-functionality with business owners, teams, and colleagues to identify documents, address project requirements, issues and risks, ensuring timely delivery of project deliverables, system enhancements, resolution for customer requests. • Conduct analysis that identifies current business process, system inadequacies, departmental or user issues, business performance measures, revenue and marketplace analytics, or competitor analysis. • Present ideas for process and systems improvement recommendations that assist the business in achieving its goals and objectives, while leveraging best practices and professional experiences. • Acquire and maintain a deep understanding of CMS applications, customer needs, and various business units within Vitu. • Communicate with leadership on impacts to changes in project scope while communicating impact to management and team. • Ensure appropriate project or user documentation is produced/used. • Manage individual workload and assist with defining and prioritizing tasks. • Ability to work effectively on multiple assignments, activities, or projects. • Ensures all analytical processes adhere to established business/department standards and protocols. • Perform other duties as assigned or needed. • Travel may be required.

• Collaborate cross-functionality with business owners, teams, and colleagues to identify documents, address project requirements, issues and risks, ensuring timely delivery of project deliverables, system enhancements, resolution for customer requests. • Conduct analysis that identifies current business process, system inadequacies, departmental or user issues, business performance measures, revenue and marketplace analytics, or competitor analysis. • Present ideas for process and systems improvement recommendations that assist the business in achieving its goals and objectives, while leveraging best practices and professional experiences. • Acquire and maintain a deep understanding of CMS applications, customer needs, and various business units within Vitu. • Communicate with leadership on impacts to changes in project scope while communicating impact to management and team. • Ensure appropriate project or user documentation is produced/used. • Manage individual workload and assist with defining and prioritizing tasks. • Ability to work effectively on multiple assignments, activities, or projects. • Ensures all analytical processes adhere to established business/department standards and protocols. • Perform other duties as assigned or needed. Travel may be required.

• Analyze data reports and system outputs to identify performance trends and potential issues. • Collaborate with internal stakeholders, clients, and third-party vendors to resolve interface and workflow challenges. • Maintain and enhance existing EDI client configurations as needed. • Provide quality assurance for internal and external reporting outputs. • Manage the commissioning and decommissioning of data sets. • Support the development of new reports and data analyses. • Recommend and implement process improvements to optimize workflow efficiency. • Monitor updates to source data systems and assess their impact on existing workflows and reports. • Deliver training to end users on new reports and data processes. • Develop and maintain Standard Operating Procedures (SOPs). • Act as an escalation point for complex issues, working closely with departmental leadership.