ERP Data Architect
Portland, OR
Marcus & Millichap
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.
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture AWS Azure Classification Data Analytics Data visualization Finance JavaScript MS SQL Power BI Python RDBMS Research SQL SSIS Testing
Perks/benefits: Career development
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open Data Manager jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs