ERP Data Architect

April 19

Marcus & Millichap

WebsiteLinkedInAll Job Openings

A History of Success. Built for the Future.

Commercial real estate investment sales • Financing • Research • Advisory Services

1001 - 5000

Description

• Design, development, and implementation of company's data architecture strategy for acquiring, analyzing, modeling, and storing data. • Creating new reports, modifying existing reports, and performing ad-hoc reporting/ query writing in support of business processes and data-driven decision-making using reporting/ data visualization tools like PowerBI, XLCubed, etc. • Collaborating with key business users to develop standardized analytical & KPI framework with understanding of implications to the P&L, Balance Sheet, and Cash Flow. • Assisting business heads to enable them to drive strategic and tactical business decisions based on the results of this analysis.

Requirements

• Bachelor’s degree in data Analytics, Finance, Accounting or similar discipline with experience in analytics or financial support roles. • Minimum of 10 years of experience as a Data Engineer, Developer, or similar role. • Excellent understanding of SAP ECC6 database and tables, specifically within FICO/ Financial Accounting module. (Must have) • Knowledge of several functional business areas including General Ledger, Accounts Payable, Asset Accounting, Cost Center Accounting, Profit Center Accounting, and Internal Orders. • Good understanding of various business processes including month-end process, year-end process, payment process, corporate allocations process, electronic payments process, bank statement reconciliation process, etc. • Strong aptitude to be an individual contributor. • Mastery of both legacy and modern tools/platforms, such as SSIS, SSAS tabular including DAX, and MS SQL Server. • Advanced SQL knowledge and experience working with relational databases and data warehouses such as MS SQL Server. • Expertise in reporting tools including PowerBI, Power Query, DAX, XLCubed (Fluence), etc. • Scripting knowledge in Python, JavaScript, PowerShell, or other languages. • Strong expertise in data modeling, database design, and data integration techniques including SSIS. • Experience with cloud platforms (Azure or AWS) a plus. • Strong analytical skills with acute attention to detail. • Experience in monitoring and optimization of database performance, ensuring efficient query execution and data processing. • Demonstrated ability & experience working with highly integrated system landscape. • Demonstrated ability of learning and applying new skills during the career. • Ability to take user requirements, design appropriate solutions and carry them through implementation including integration testing and end-user training. • Excellent verbal and written communication skills with the ability to sell concepts and ideas to a wide range of audiences. • Ability to work effectively in a collaborative, team-oriented environment.

Benefits

• N/A