Finance Data AnalystSeeking professionals to support our finance data initiatives. This role will support all phases of finance data related projects, including the defining of data requirements, data design, data mapping and transformation, and data validation and control. This role is part of our Finance organization and will partner closely with our Finance Capability, as well as our Digital organization.You will be supporting the design and maintenance of finance data systems and databases.
This includes troubleshooting and fixing data-related problems, mining data from primary and secondary sources (mainly SAP FI/CO), and reorganizing data in a format that can be easily read by either human or machine.Essential FunctionsSupport projects delivering business processes and data supported by technology in the areas including, but not limited to Financial Accounting, Project Systems, Fixed Assets, Accounts Receivable, Accounts Payable, Product Costing, Financial Planning, Consolidations, Treasury, Tax, and Reporting.Work closely with finance teams to understand business processes, review current systems, and define data requirements. Evaluate current system and data capabilities and identify system modifications or changes that need to be made to current data processes.Work as a team member with other Molex business analysts and technical resources to implement data changes. Communicate detailed requirements (functional specifications) and timelines to appropriate IT departments.Support the development, design, and maintenance of data systems and databases.Understand data logic; troubleshoot coding and fix data-related problems.Use automated tools to extract data from primary and secondary sources.Perform tests of new and updated functionality to verify desired results are achieved.
Evaluate results and coordinate changes to improve system performance. Create test plans as required.Understand data sources (tables, etc.); perform analysis to assess quality and meaning of data.Use statistical tools to identify, analyze, and interpret patterns and trends in complex data sets.Develop and maintain system related documentation.Perform other related duties as assigned by management.Required QualificationsMinimum of 5 years of experience as a data analystMinimum of 5 years of experience in data projects where large scale multi-national SAP system is source dataMinimum of 3 years of experience in Finance/Accounting related data areasPreferred Qualifications2-3 years of proven project management skillsBachelor’s degree in related fieldSkills And AbilitiesPrevious experience working on teams or leading project teams consisting of business and IT resourcesProven self-management skills that demonstrate the ability to complete assignments in a systematic and timely basisStrong understanding of accounting concepts, financial consolidations, and internal controlsGood verbal/written communication skills that demonstrate the ability to express ideas clearly and concisely to influence business decisions on systems and applicationsAbility to effectively work with coworkers and external contacts to achieve common goals and respond positively to situationsProblem-solving skills, accuracy, and attention to detailDemonstrates flexibility regarding change of projects, focus, priorities, and needsStrong mathematical skills to help collect, measure, organize and analyze dataKnowledge of database design, development, data models, techniques for data miningExperience in handling reporting packages like Business Objects or otherProficiency in statistics and statistical packages like Excel or AlteryxKnowledge of data visualization software like Tableau or Power BI