ERP Data Architect

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.

Our mission is to help our clients create and preserve wealth by providing the best real estate investment sales, financing, research, and advisory services available.

Founded in 1971, Marcus & Millichap (NYSE: MMI) is a leading commercial real estate brokerage firm focusing exclusively on investment sales, financing, research, and advisory services, with nearly 1,700 investment sales and financing professionals in 80+ offices throughout the United States and Canada.

Marcus & Millichap closes more transactions than any other real estate investment brokerage firm in the nation. In 2023, the firm closed 8,297 transactions with a sales volume of approximately $48 billion.

The firm has perfected a powerful property marketing system that integrates broker specialization by property type and market area; the industry’s most comprehensive investment research; a long-standing culture of information sharing; relationships with the largest pool of qualified investors; and state-of-the-art technology that matches buyers and sellers.

Marcus & Millichap provides equal employment opportunities to all employees and applicants for employment without discrimination with regard to race, religious belief (including dress or grooming practices), color, sex, sex stereotype, pregnancy, childbirth or related medical conditions (including breast feeding), age, national origin, ancestry, sexual orientation, gender identification and expression, transgender status, physical or mental disability, medical condition, genetic characteristics, genetic information, family care, marital status, enrollment in any public assistance program, status as military, a veteran or qualified disabled veteran, status as an unpaid intern or volunteer, or any other classification protected by law. We also prohibit discrimination based on the perception that anyone has any of those characteristics, or is associated with a person who has or is perceived as having any of those characteristics. In addition to federal law requirements, Marcus & Millichap complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.