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.