Financial Data Analyst - Senior Consultant
简介：贝克泰利是一家领先的咨询，税务和保证公司，在美国主要地区以及世界上许多领先金融中心 （纽约，伦敦，旧金山，洛杉矶，芝加哥和波士顿）提供给客户真正的海岸到海岸和全球优势.Baker Tilly Advisory Group,LP 和 Baker Telly US,LLP 通过根据 AICPA 职业行为法典和适用的法律，规定和专业标准提供的替代实践结构提供专业服务.BakerTilly US, LLP 是一个获得许可的独立 CPA 公司，为其客户提供认证服务。贝克蒂利咨询集团，LP 及其子公司为客户提供税务和商业咨询服务。贝克蒂莉咨询集团和子公司并非获得许可的 CPA 公司。贝克提利咨询集團，LP 和贝克蒂丽美国，LLP 作为 Baker Tilly 交易，是全球独立账户和商业顾问事务所在141个地区的百科蒂利国际的独立成员，拥有43,000名专业人士和总收入5.2亿美元。访问 bakertilly.com 或加入 LinkedIn,Facebook 和 Instagram 上的对话。请与你的贝克泰利人才收购专业人员讨论工作地点状况，以了解你正在探索的机会的要求。贝克泰里是一个平等机会/肯定行动雇主。所有合格申请者将根据适用的联邦，州或地方法律获得就业报酬，不论种族，颜色，宗教，性别，国籍，残疾或受保护退伍军人的身份，性别认同，性取向或其他受到法律保护的基础。任何通过我们的网站或 Baker Tilly Advisory Group,LP 提交的未请求简历，员工电子邮件帐户被认为是 Baker Tiley Advisory group,LP 的所有权，并不受代理费支付。为了成为 Baker Telly Advisory Groupe,LP 的授权招聘机构 （"搜索公司"）,必须有一个正式的书面协议，并且该机构必须由 Baker TILLY's Talent Attraction 团队邀请，通过我们的申请人跟踪系统提交候选人进行审查。职位描述：职务总结 我们正在寻找一个具有高度分析和技术技能的金融数据分析师/Excel 自动化专家，在微软 Excel,Power Query 和 VBA 方面拥有先进的专业知识。
查看英文原文
Overview
Baker Tilly is a leading advisory, tax and assurance firm, providing clients with a genuine coast-to-coast and global advantage in major regions of the U.S. and in many of the world’s leading financial centers – New York, London, San Francisco, Los Angeles, Chicago and Boston. Baker Tilly Advisory Group, LP and Baker Tilly US, LLP (Baker Tilly) provide professional services through an alternative practice structure in accordance with the AICPA Code of Professional Conduct and applicable laws, regulations and professional standards. Baker Tilly US, LLP is a licensed independent CPA firm that provides attest services to its clients. Baker Tilly Advisory Group, LP and its subsidiary entities provide tax and business advisory services to their clients. Baker Tilly Advisory Group, LP and its subsidiary entities are not licensed CPA firms.
Baker Tilly Advisory Group, LP and Baker Tilly US, LLP, trading as Baker Tilly, are independent members of Baker Tilly International, a worldwide network of independent accounting and business advisory firms in 141 territories, with 43,000 professionals and a combined worldwide revenue of $5.2 billion. Visit bakertilly.com or join the conversation on LinkedIn, Facebook and Instagram.
Please discuss the work location status with your Baker Tilly talent acquisition professional to understand the requirements for an opportunity you are exploring.
Baker Tilly is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status, gender identity, sexual orientation, or any other legally protected basis, in accordance with applicable federal, state or local law.
Any unsolicited resumes submitted through our website or to Baker Tilly Advisory Group, LP, employee e-mail accounts are considered property of Baker Tilly Advisory Group, LP, and are not subject to payment of agency fees. In order to be an authorized recruitment agency ("search firm") for Baker Tilly Advisory Group, LP, there must be a formal written agreement in place and the agency must be invited, by Baker Tilly's Talent Attraction team, to submit candidates for review via our applicant tracking system.
Job Description:
Position Summary
We are seeking a highly analytical and technically skilled Financial Data Analyst / Excel Automation Specialist with advanced expertise in Microsoft Excel, Power Query, and VBA. This role will work with complex financial and operational datasets, combining information from multiple sources, identifying discrepancies and trends, transforming data, and developing reliable analytical and reporting solutions.
The ideal candidate combines strong data-analysis and technical capabilities with financial acumen and an understanding of how data flows through financial models, reporting processes, and business decision-making.
Key Responsibilities
- Analyze large and complex financial and operational datasets to identify trends, discrepancies, relationships, and data-quality issues.
- Compare datasets from multiple systems and identify differences, missing records, duplicates, and reconciliation issues.
- Perform complex joins, merges, lookups, aggregations, and data transformations across multiple data sources.
- Develop and maintain sophisticated Power Query solutions for data ingestion, cleansing, transformation, reconciliation, and reporting.
- Build and maintain VBA macros and Excel automation to streamline repetitive processes and improve the accuracy and efficiency of existing workflows.
- Design analytical processes that are repeatable, auditable, and scalable.
- Work with complex Excel workbooks and financial models, understanding formulas, dependencies, assumptions, calculations, and data flows.
- Validate data used in financial models and reporting and investigate unexpected results or variances.
- Translate business and financial requirements into practical data-analysis and automation solutions.
- Partner with business teams to understand reporting requirements, troubleshoot data issues, and improve existing processes.
- Document data transformations, business rules, assumptions, and automated processes.
Required Qualifications
- Advanced expertise in Microsoft Excel, including complex formulas, pivot tables, lookups, dynamic data analysis, and large datasets.
- Advanced hands-on experience with Power Query (M), including merging and appending queries, conditional transformations, grouping, data cleansing, and combining data from multiple sources.
- Strong VBA development and Excel automation skills.
- Strong understanding of relational data concepts, including joins, keys, relationships, aggregations, and data transformation.
- Demonstrated ability to compare and reconcile large datasets and systematically investigate differences.
- Strong analytical and problem-solving skills with exceptional attention to detail.
- Experience working with financial or accounting data.
- Working knowledge of financial models, including the ability to understand model inputs, assumptions, calculations, outputs, and dependencies.
- Ability to independently take an ambiguous data problem, determine the appropriate analytical approach, and produce accurate and understandable results.
Preferred Qualifications
- Experience with SQL and relational databases.
- Experience with Power BI, Power Pivot, DAX, or similar business-intelligence tools.
- Familiarity with government-contract financial concepts such as contract funding and indirect rates.
- Experience automating manual Finance or operational reporting processes.
- Experience integrating Excel with databases, flat files, APIs, SharePoint, or other enterprise data sources.
- Experience with cost-plus accounting, including an understanding of direct and indirect costs, cost allocation, indirect rates, and related financial analysis.
·
- Familiarity with Deltek Costpoint, particularly financial, project accounting, billing, or reporting functionality.
- Familiarity with financial statements, forecasting, budgeting, variance analysis, or management reporting.
Core Skills
Technical: Excel • Power Query / M • VBA • Data Transformation • Data Joins & Merges • Data Reconciliation • Data Cleansing • Financial Modeling • Data Analysis
Analytical: Dataset Comparison • Variance Analysis • Root-Cause Analysis • Data Validation • Pattern Recognition • Problem Solving
Business: Financial Acumen • Requirements Gathering • Process Improvement • Documentation • Communication • Attention to Detail
Originally posted on Himalayas