[Hiring] Consulting Operations Specialist @Vizient

Role Description

When you’re the best, we’re the best. We instill an environment where employees feel engaged, satisfied and able to contribute their unique skills and talents while living and working as their authentic selves. We provide extensive opportunities for personal and professional development, building both employee competence and organizational capability to fuel exceptional performance through an inclusive environment both now and in the future.

• Interact with business stakeholders to understand their requirements for BI analysis, dashboards and data extracts/ETL for third party integrations.
• Meet with team members and/or leaders who have requested reporting from the database.
• Gather information such as time period, project and people demographics, metrics and limitations required for the report.
• Share limitation of reporting and suggest alternatives to achieve desired results.
• Discuss data aggregation and visualization required.
• Design, develop and maintain data models, reporting systems, data automation systems, dashboards and performance metrics support that support key business decisions.
• Develop and maintain project health and profitability reporting in the BI tool insights.
• Maintain all system integrations, including the integration between Workday (ERP tool) and Kantata (PSA tool).
• Manage integration error logs and work with the domain support team to resolve these errors to ensure accurate reporting on project profitability.
• Create and maintain reports using BI tools (Tableau, PowerBI, GoodData).
• Develop reporting in PowerBI and excel using data exported from company’s professional services automation (PSA) tool.
• Work on transitioning excel-based data quality reporting into PowerBI.
• Develop and maintain metrics and reporting housed in Insights, a GoodData BI tool.
• Accurately maintain a report of active project leads (PLs) used by the Knowledge Management team.
• Ensure production data quality and availability of delivered reports and ETL extracts; proactively respond to monitoring alerts and triage and fix issues to meet business SLAs.
• Manage and report all data quality within our PSA tool.
• Create and maintain all reporting (in PowerBI and excel) related to data quality management and tracking.
• Proactively identify data quality issues and work directly with the domain support teams to resolve these issues.
• Maintain the integrity of metrics, reporting, and customer invoicing.
• Build and maintain project data quality reporting in PowerBI to identify data quality issues within PSA project custom fields.
• Manage and develop all documentation and training for new and existing interfaces.
• Update single point lessons on business processes related to PSA tool.
• Document business processes related to system administrator use of interfaces, which will be included in an administrator playbook.
• Create a job aid outlining the business process for staffing positions within PSA tool.
• Provide ad hoc data pulls and analyses as requested by the business.
• Provide ad hoc data exports and analyses from our PSA tool.
• Utilize an active user download (.xls) to map in 2023 cost rates and compare the year-over-year change in fully loaded resource costs.
• Perform bulk uploads into Kantata using the SUM Data Loader, maintaining a 99% accuracy rate.
• Improve efficiency of the bulk upload process by automating task and project custom field templates using Power Query.

Qualifications

• Master's degree in Business Analytics or directly related field of study.
• 3 years of experience developing and maintaining reports and dashboards in Power BI/Tableau, including proficiency in DAX, Power Query (M), and data modeling best practices.
• 3 years experience in Microsoft Excel, including pivot tables, advanced formulas, and data analysis features.
• 3 years experience writing and optimizing SQL queries for data extraction and transformation.
• 3 years experience translating business requirements into effective data models and reporting solutions, with familiarity with ETL processes and enterprise data environments.
• 3 years experience demonstrating application of data integrity and governance standards.
• 3 years experience diagnosing and resolving data or reporting issues independently.
• 3 years experience clearly and effectively communicating with technical and non-technical stakeholders.
• 3 years experience administering or supporting Professional Services Automation (PSA) platforms.

Requirements

• Full-time, telecommute position.
• Must reside within the U.S.
• Domestic travel up to one time per year to company location.
• Visa sponsorship not available for this position.

Benefits

• Work-life blend (25 days PTO, 10 paid holidays + 1 floating, 4 weeks work-from-anywhere).
• Medical and insurance (High-deductible health plans, Dental and vision, Life and AD&D, Short and long-term disability).
• Financial (401(k) with 6% match, HSA with company contribution, FSAs, Commuter accounts, Corporate discounts, Tuition assistance up to $5,250/year).
• Wellbeing and family (Up to 24 weeks parental leave (birthing), 16 weeks (non-birthing, adoption, surrogacy, foster), Up to 6 weeks family care, 5 days bereavement).
• This position is also incentive eligible.

Company Description

Kaufman Hall is a Vizient company; Vizient has a comprehensive benefits plan. Equal Opportunity Employer: Females/Minorities/Veterans/Individuals with Disabilities. The Company is committed to equal employment opportunity to all employees and applicants without regard to race, religion, color, gender identity, ethnicity, age, national origin, sexual orientation, disability status, veteran status or any other category protected by applicable law.