Financial Systems Analyst

Aston Carter•Kansas City, MO

1d•$55 - $65•Remote

About The Position

Our client, a large manufacturing organization, is seeking a Manufacturing Accounting Systems Analyst for a fully remote, open-ended contract opportunity. This role requires strong expertise in SQL, Power BI, and manufacturing accounting, with cost accounting experience strongly preferred. The analyst will partner directly with finance stakeholders to gather requirements, develop and maintain financial reports and dashboards, validate data accuracy, and ensure compliance with SOX and audit requirements. Experience working in a large corporate manufacturing environment and familiarity with Infor M3 are highly desirable. The ideal candidate is a highly independent professional who can translate business needs into reporting solutions while managing projects from requirements gathering through delivery. Key responsibilities include developing Power BI reports, writing and optimizing SQL queries, troubleshooting data issues, and creating clear user and technical documentation that explains report functionality and data flow. Strong communication skills and the ability to work directly with stakeholders are essential. This is a fast-paced environment where report requests are expected to move quickly, often with a two-week turnaround from start to finish. Candidates must be able to work 8:00 AM to 5:00 PM Central Time and have a proven track record supporting finance and accounting teams through reporting, analytics, and documentation initiatives. The Financial Systems Analyst, Reporting develops, tests, and delivers accounting and finance reports using SQL and Power BI, serving as the primary liaison between business stakeholders and the reporting function. This role translates business reporting requirements into clear technical specifications, builds reliable and auditable reports sourced from an enterprise Data Warehouse, and ensures all deliverables meet accuracy, completeness, and SOX compliance standards. The position suits a highly independent professional who combines strong technical reporting skills with solid manufacturing accounting and finance knowledge in a fully remote environment.

Requirements

At least 10 years of experience in report or business intelligence development, or a related analytical role.
At least 10 years of manufacturing accounting experience.
Strong working knowledge of accounting and finance concepts and terminology to accurately interpret business requirements.
Advanced proficiency in SQL, including query writing, joins, and performance tuning.
Advanced proficiency in Power BI, including data modeling and report development.
Proficiency with DAX and Power Query.
Advanced proficiency in Microsoft Excel.
Familiarity with SOX compliance requirements and audit-ready documentation practices.
Strong attention to detail and a high level of commitment to data accuracy.
Strong time management skills with the ability to manage multiple concurrent projects and deadlines.
Ability to work effectively in a fast-paced environment with shifting priorities and short deadlines.
Strong verbal and written communication skills, including the ability to translate technical concepts for non-technical audiences.
Collaborative, team-oriented approach with the ability to work effectively across business and IT teams.
Ability to quickly learn and adapt to new systems, tools, and data sources.

Nice To Haves

Bachelor's degree in Accounting, Finance, Information Systems, Computer Science, or a related field, or equivalent professional experience.
Experience with M3 (ERP) and/or RentalMan.
Experience working with enterprise Data Warehouse architectures and ETL concepts.
Experience creating technical and functional documentation for audit or compliance purposes.
Finance or accounting reporting within a manufacturing environment.
Experience building organized, well-structured reports and dashboards using Power BI and Excel.

Responsibilities

Partner with business stakeholders to gather and document complete, clear, and unambiguous reporting requirements that inform report design and development.
Create and manage Azure DevOps (ADO) tasks to plan, scope, and track report development work, ensuring requirements, acceptance criteria, and timelines are clearly documented.
Design, build, and maintain financial and accounting reports using SQL and Power BI, leveraging data from the enterprise Data Warehouse.
Write and optimize SQL queries, including stored procedures and views, to support report development and data validation.
Test all assigned reports for completeness and accuracy prior to delivery, including performing SOX-compliant audit tracebacks to source systems.
Document and maintain evidence of testing and validation to support internal and external audit requirements.
Develop clear, user-friendly end-user guides that describe report contents, functionality, and intended use for report reviewers.
Create detailed technical guides for developers that document report logic, data lineage, and validation procedures.
Partner with report requestors to review and validate finalized reports against original requirements and business needs prior to sign-off.
Maintain version control and change documentation for existing reports, including performing impact analysis for source system or data model changes.
Execute report implementations and changes in accordance with the SOX Change Management Process.
Troubleshoot and resolve data discrepancies, performance issues, or defects in existing reports.
Provide ongoing support and minor enhancements for reports in production, prioritizing work based on business impact and deadlines.
Ensure all reports and underlying data handling comply with data governance, security, and access control policies.
Mentor junior analysts and developers on reporting standards, tools, and best practices as needed.
Stay current on Power BI, SQL, and Data Warehouse platform capabilities and recommend process, tooling, and reporting improvements.