Finance Data & Automation Analyst

Job Overview

The Finance Data & Automation Analyst supports the improvement and automation of recurring finance and accounting processes. This position works with FP&A, Accounting, IT, and other business teams to understand existing workflows and develop practical solutions that improve accuracy, efficiency, and access to financial information.

Microsoft Fabric will be the primary platform used in this role, along with Power BI and other automation and data tools. The analyst will also use AI and AI-assisted development tools to help build solutions, analyze data, troubleshoot issues, and improve finance and accounting workflows. This position will help develop and maintain data workflows, reporting solutions, and process automations while ensuring outputs are accurate, documented, and appropriately controlled.

The ideal candidate has a foundation in finance, accounting, data analytics, or business systems, combined with strong technical aptitude and an interest in developing deeper automation capabilities.

Process Improvement

• Work with finance and accounting teams to document current processes, identify manual work, and understand reporting or data issues.
• Evaluate automation opportunities based on business value, complexity, risk, and available resources.
• Simplify and standardize processes before automating them.
• Measure the results of completed projects, including time savings, reduced errors, and faster reporting.

Automation Data and Reporting

• Build and maintain data workflows, reporting solutions, and process automations primarily within Microsoft Fabric and Power BI.
• Work with Fabric lakehouses, data warehouses, pipelines, dataflows, notebooks, and semantic models based on the needs of each solution.
• Connect and transform data from financial systems, planning platforms, operational systems, spreadsheets, APIs, and other sources.
• Develop and maintain Power BI reports and the underlying datasets and models.
• Use SQL, Python, Power Query, APIs, AI-assisted coding tools, and other technologies as needed to support Fabric-based solutions.
• Test automated processes and validate results against source systems, existing reports, and expected outcomes.
• Investigate data discrepancies, process failures, and performance issues.
• Monitor recurring solutions for data-quality problems or changes in upstream systems.
• Maintain clear documentation of data sources, definitions, transformation logic, testing results, and support procedures.
• Update existing solutions as reporting needs, processes, and source systems change.

Controls and Governance

• Follow company standards for system access, data security, documentation, testing, and change management.
• Build appropriate reconciliations, reviews, approvals, audit trails, and exception reporting into automated processes.
• Partner with Accounting and IT to ensure solutions meet financial-control and data-governance requirements.
• Identify and escalate risks involving financial reporting, sensitive information, system access, or data integrity.
• Ensure solutions remain understandable, supportable, and auditable after implementation.

Required Qualifications

• Must be at least 21 years old.
• Bachelor’s degree in Finance, Accounting, Information Systems, Data Analytics, Business, or a related field.
• Two or more years of experience in finance, accounting, data analytics, financial systems, business intelligence, or a related field.
• Experience working with financial or operational data.
• Working knowledge of common finance or accounting activities such as reporting, budgeting, forecasting, reconciliations, monthly close, accounts payable, or accounts receivable.
• Hands-on experience with Microsoft Fabric, Power BI, or a comparable Microsoft data platform.
• Strong Microsoft Excel skills, including formulas, pivot tables, data validation, and data analysis.
• Ability to investigate data discrepancies and validate results against source information.
• Strong analytical, problem-solving, documentation, and communication skills.
• Ability to learn new tools and complete assigned work independently with guidance from a manager.

Preferred Qualifications

• Experience with Microsoft Fabric lakehouses, data warehouses, pipelines, dataflows, notebooks, or semantic models.
• Experience developing or maintaining Power BI reports and datasets.
• Working knowledge of SQL, Python, Power Query, APIs, or Power Automate.
• Experience using AI tools for data analysis, workflow automation, documentation, or coding support.
• Experience with Microsoft Dynamics 365 Business Central, Workday Adaptive Planning, or another ERP or financial-planning system.
• Experience improving or automating a recurring finance or accounting process.
• Experience in gaming, entertainment, manufacturing, or another multi-entity business.

Note: All offers are contingent upon successful completion of a background check

*Posted positions are not open to third party recruiters and unsolicited resume submissions will be considered free referrals.

AGS is an equal opportunity employer