Analysts, Reporting & Analytics

About the role

Analysts, Reporting & Analytics is located in Overland Park, KS. This role will create data analytics tools and workflows to meet the needs of the tax department.

Responsibilities

• Participate in the design and implementation of new ERP system to ensure it meets tax department needs.
• Prepares federal and state income/franchise tax returns and supporting workpapers.
• Gathers and documents data requirements for tax function.
• Uses reporting & analytic tools, applications, queries, or other data sources to support tax forecasting process.
• Performs modifications and enhancements on existing processes based on evolving business and regulatory requirements.
• Validates and tests outputs to ensure accuracy and quality.
• Provides support and training to end-users for analytic tools & enhanced processes.
• Gathers simple to moderately complex data inputs from multiple sources.
• Runs routine data queries from reporting tools, ensuring integrity of data and reporting.
• PARTNERS WITH STAKEHOLDERS INSIDE AND OUTSIDE THE TAX DEPARTMENT ON THE DEVELOPMENT AND PRODUCTION OF A WIDE RANGE OF DATA ANALYTICS TOOLS THAT WORK TO ENHANCE EFFICIENCY.
• Ensures delivery meets agreed upon requirements.
• SUPPORTS TAX TEAM WITH REPORTING, ANALYSIS, AND AD HOC REPORTING AS NEEDED.
• PREPARES DOCUMENTATION TO SUPPORT COMPLIANCE WITH SOX 404 CONTROLS AND PROCEDURES.

Requirements

• Bachelor’s degree or foreign equivalent in Business, Finance, Information Management, Accounting, or related field, and 3 years of relevant work experience in Any Occupation In Which The Required Experience Is Gained.
• Master’s degree or foreign equivalent in Business, Finance, Information Management, Accounting, or related field, and 1 year of relevant work experience in Any Occupation In Which The Required Experience Is Gained.

Skills

• Experience with Microsoft Excel, including automation using macros for data analysis and reporting, data visualization, and advanced, high-level formulas such as INDEX/MATCH, XLOOKUP and nested IF statements.
• Experience with Microsoft Word and PowerPoint for documenting insights and presenting data-driven recommendations with clarity.
• Experience managing project timelines and communications through Microsoft Outlook to ensure timely and accurate delivery of reporting solutions.
• Experience with ONESOURCE Tax Provision (OTP), ONESOURCE Income Tax (OIT), Bloomberg Tax Research, and RIA Checkpoint to support end-to-end tax compliance and provision processes, including data preparation, tax calculations, deferred tax reconciliations, provision reporting, and technical tax research to ensure accuracy and regulatory compliance.
• Experience preparing reconciliations and running reports in SAP GUI or Oracle ERP Cloud to deliver actionable insights for tax-related decision-making.
• Experience applying filters, variants, and layout settings to generate targeted reports for business analysis.
• Experience exporting SAP or Oracle reports to Excel and integrating results into dashboards and presentations for internal departments.
• Experience leveraging Denodo’s data virtualization platform to access, integrate, and analyze data from diverse sources using SQL, optimizing queries and delivering clean, unified datasets for reporting, dashboarding, and advanced analytics.
• Experience managing and analyzing historical invoice data by connecting to multiple data sources, applying time-based filters and calculated fields, and recording insights from Tableau dashboards and vendor invoice management solutions to support financial analysis and strategic decision-making.
• Experience using Alteryx Designer to integrate and prepare data from multiple sources for tax reporting, leveraging tools like Input, Join, and Union to ensure seamless data consolidation.
• Experience applying Data Cleansing, Formula, and Select tools to standardize formats, perform tax calculations, and enhance data quality.
• Experience building automated workflows using Summarize, Filter, and Output tools to generate accurate, jurisdiction-specific tax reports and support compliance analysis.
• Experience maintaining centralized data storage using Microsoft Dataverse and SharePoint to automate workflows, improve tax data accuracy, and enhance departmental efficiency.
• Experience using Microsoft Dataverse to streamline tax processes and reduce manual entry, with working knowledge of Excel to support reporting and collaboration.
• Experience using Power Apps to visualize tax data and support decision-making.

Benefits

• Competitive base salary and compensation package.
• Multiple wealth-building opportunities through annual stock grant, employee stock purchase plan, 401(k), and access to free, year-round money coaches.
• Flexible work schedule with telecommuting permitted, but applicant must work from the worksite location at least 3-4 days per week.
• Less than 5% domestic travel required.

Pay

$72,209.50 - $93,400 per year.

Schedule

40 hours/week.

Location

Overland Park, KS.