- Location
- Burlington, MA,US, US · Frisco, TX,US, US
- Type
- Full-time
- Department
- IT
- Seniority
- Senior
- Experience
- 2+ years
- Education
- Bachelor
- Source
- Eightfold
Description
Data Engineering & Automation Design, build, and maintain Alteryx workflows that extract, cleanse, reconcile, and load tax data from SAP, Microsoft Dynamics 365, Snowflake, and tax applications. Write SQL against Snowflake and other sources to support tax data requests and recurring extracts. Write and maintain Python scripts for file parsing, log analysis, and data transformation, including XML, JSON, and large flat-file exports. Convert manual Excel-based processes into documented, repeatable workflows with built-in validation checks and control totals. Build Power Automate flows and other Power Platform solutions for task routing, notifications, and recurring data pulls. Maintain version history, change logs, and documentation for every workflow and script the team owns. Build and maintain Power BI dashboards and data models for tax metrics, reconciliations, and close status. Design reporting data sources with stable, typed schemas, and choose file formats suited to automated refresh. Perform reconciliations between systems, such as ERP fixed asset registers to the tax fixed asset ledger or tax engine results to ERP invoices, and document match logic, exceptions, and confidence levels. Analyze large transaction datasets to identify anomalies, root causes of tax calculation differences, and data quality issues. Support configuration, testing, and troubleshooting of Vertex O Series and its SAP integration, including test case design, log capture and analysis, and defect tracking through system integration testing (SIT) and user acceptance testing (UAT). Support ONESOURCE Tax Provision, CCH Tagetik, and Sage Fixed Assets with data loads, mappings, entity and hierarchy maintenance, and user access. Participate in ERP and tax system projects, including SAP S/4HANA migration, new e-commerce channel integrations, and software evaluations, by gathering requirements, mapping data, and executing tests. Work with IT, finance systems teams, and software vendors to triage tickets, document defects, and validate fixes. Build and maintain Microsoft Copilot Studio agents, prompts, and instruction sets that help tax users answer questions, diagnose system results, and produce standardized deliverables. Evaluate new tools and features through small pilots, and document results, risks, and controls before broader rollout. Apply data governance and confidentiality requirements to every automation and AI use case. Support SOX and audit requirements for tax systems and reports, including evidence of automated controls and change management. Bachelor's degree in Information Systems, Computer Science, Data Analytics, Statistics, Accounting, Finance, or a related field 2 to 4 years of experience in data analytics, data engineering, business intelligence, or systems support Experience supporting a tax, accounting, finance, or FP&A team, either in-house or in a consulting role Tax knowledge not required; interest in learning corporate tax concepts expected Hands-on experience with Alteryx Designer Working SQL skills, including joins, aggregations, window functions, and common table expressions Python for data manipulation (pandas or similar), file parsing, and scripting Power BI, including Power Query, data modeling, and DAX Advanced Excel, including lookups, pivot tables, Power Query, and building controlled, auditable workbooks Experience with Microsoft Power Platform (Power Automate, Power Apps, Dataverse) preferred Experience with cloud data platforms such as Snowflake preferred Familiarity with structured data formats (XML, JSON, Parquet) and API concepts Exposure to ERP systems such as SAP ECC, SAP S/4HANA, or Microsoft Dynamics 365 preferred Exposure to tax or finance applications such as Vertex, ONESOURCE, or CCH Tagetik or other EPM platforms a plus Experience with generative AI tools such as Microsoft 365 Copilot or Copilot Studio, including prompt and instruction design, a plus Experience with software development life cycle testing practices, including test case design, SIT, UAT, and defect logging Understanding of version control and change management practices Understanding of data governance, data quality, and internal control concepts; SOX exposure a plus Strong analytical and problem-solving skills, with a habit of testing assumptions against the data Attention to detail; able to reconcile results to the penny and explain every difference Clear written documentation and verbal communication for non-technical audiences Able to manage multiple requests and deadlines, including quarter-close timelines Self-starter who learns new tools and business processes quickly Collaborative working style across Tax, IT, Finance, and external vendors Comfortable working with global colleagues across time zones; occasional travel may be required.