Marcus & Millichap, Inc, the nation’s largest commercial real estate investment brokerage company (80+ offices in North America), is looking to hire a highly motivated ERP Data Architect.

ERP data architect will have two-fold responsibilities, (a) design, development, and implementation of company's data architecture strategy for acquiring, analyzing, modeling, and storing data, (b) 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.

ERP data architect will also be responsible for collaborating with the key business users to develop standardized analytical & KPI framework with understanding of implications to the P&L, Balance Sheet, and Cash Flow.

A person in this role will assist business heads to enable them to drive strategic and tactical business decisions based on the results of this analysis.

Education and Experience Required:

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