Finance Data & Automation Analyst

AGS - American Gaming Systems; Las Vegas (NV); On-site; USD 90,000 - 120,000; Full time

Job summary

AGS - American Gaming Systems in Las Vegas seeks a Finance Data & Automation Analyst to streamline finance and accounting workflows using Microsoft Fabric and Power BI.

You will build data pipelines, dashboards, and automated reports, collaborate with FP&A, Accounting, IT, and other teams, and ensure data quality and governance. 2+ years in finance analytics and strong Excel skills required. Experience with AI-assisted tools is a plus.

Qualifications

• Bachelor’s degree in Finance, Accounting, Information Systems, Data Analytics, or related field.
• Two or more years of experience in finance, accounting, data analytics, financial systems, business intelligence, or related field.
• Experience with financial or operational data.
• Familiarity with finance activities: reporting, budgeting, forecasting, reconciliations, close.
• Hands-on with Microsoft Fabric, Power BI, or comparable MS data platform.
• Strong Excel skills: formulas, pivot tables, data validation, analysis.
• Able to investigate data discrepancies and validate results against source information.
• Strong analytical, problem-solving, documentation, and communication skills.
• Able to learn new tools and work independently with guidance from a manager.

Responsibilities

• Document current processes and identify manual work with finance and accounting teams.
• Evaluate automation opportunities based on value, complexity, risk, resources.
• Simplify and standardize processes before automating.
• Build and maintain data workflows and reporting solutions in Fabric and Power BI.
• Connect and transform data from financial systems, planning platforms, operational systems, spreadsheets, APIs.
• Develop and maintain Power BI reports and datasets.
• Test automated processes against source systems and expected outcomes.
• Monitor data quality and upstream system changes.
• Maintain documentation of data sources, transformation logic, testing results, and support procedures.
• Ensure solutions are auditable and governed; collaborate with Accounting and IT.

Skills

Power BI

SQL

Python

Excel

Data analysis

Analytical thinking

Documentation

Communication

Automation

Microsoft Fabric

Education

Bachelor's degree in Finance, Accounting, Information Systems, Data Analytics, Business, or related field

Tools

Microsoft Fabric

Job 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.

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 escale 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.