Finance Data & Automation Analyst

AGS; Las Vegas (NV); On-site; USD 85,000 - 110,000; Full time

Job summary

AGS is seeking a Finance Data & Automation Analyst to improve and automate finance and accounting processes. You will work with FP&A, Accounting, IT, and other teams to build scalable data workflows using Microsoft Fabric and Power BI.

Ideal candidates have a finance or data analytics foundation, strong technical aptitude, and interest in expanding automation capabilities. This role emphasizes governance, accuracy, and efficient reporting.

Qualifications

• Bachelor's degree in Finance, Accounting, Information Systems, Data Analytics, Business, or related field.
• Two or more years of experience in finance, accounting, data analytics, financial systems, BI, or related field.
• Hands-on experience with financial data and reporting processes.
• Experience with Microsoft Fabric, Power BI, SQL, or Python preferred.

Responsibilities

• Document current processes, identify manual work, and understand reporting or data issues.
• Evaluate automation opportunities based on business value, complexity, risk, and resources.
• Build and maintain data workflows and reports in Fabric and Power BI.
• Connect and transform data from financial and operational sources.
• Develop, test, and maintain Power BI reports and datasets.
• Investigate data discrepancies and validate results against source information.
• Maintain documentation of data sources, transformations, and controls.
• Update solutions as reporting needs and source systems change.

Skills

Analytical thinking

Problem-solving

Documentation

Communication skills

Education

Bachelor's degree

Tools

Microsoft Fabric

Power BI

SQL

Python

Power Query

APIs

Power Automate

Excel

Job description

Description

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.

Responsibilities

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 elevate risks involving financial reporting, sensitive information, system access, or data integrity.


• Ensure solutions remain understandable, supportable, and auditable after implementation.

Requirements

• 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

AGS is an equal opportunity employer