Search jobs > Portland, OR > Data architect

ERP Data Architect

Marcus & Millichap
Portland, OR
Full-time

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.
  • 30+ days ago
Related jobs
Marcus & Millichap
Portland, Oregon

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

Promoted
Equiliem
Beaverton, Oregon

Establishes database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy. Adapts business require...

Promoted
Volt
Beaverton, Oregon

Innova Solutions is immediately hiring for a Software Developer. As a(n) Software Developer you will:. We are seeking a skilled React JS and JavaScript & TypeScript Developer to join our development team. ...

Promoted
Slalom Consulting
Portland, Oregon

Advise clients on the overall enterprise architecture landscape on various solution architecture areas including technology, information, data, security, and integration. Support growing and scaling the Technology Strategy and Enterprise Architecture practice across Slalom, including client discussi...

Promoted
Accenture
Beaverton, Oregon

Develop technical solution design and work with assigned technical architects and cost architects to create corresponding cost estimates. This role will support our BPS Sales and Solutioning Team as the responsible Technical Solution Architect in pre-sales/RFP processes involving Finance & Accou...

Promoted
Northwest Permanente
Portland, Oregon

Our Northwest Permanente Business System Analyst II in support of our Human Resources Information Systems (HRIS) team leads and manages large and complex human resources system projects to ensure that information applications are implemented, upgraded, and meet business requirements. Apply HR busine...

Promoted
Tephra Inc.
Portland, Oregon

As a Data Engineer focusing on Data Quality for Asia Pacific and Latin America, you will use your technical expertise to validate and ensure data accuracy across a variety of systems. You are a data engineer or data quality guru with software engineering chops. You are familiar with Spark, Python, H...

Promoted
Paradigm Information Services, Inc.
Portland, Oregon

The Data Analyst develops database queries scripts tools and methods to manage data according to client requirements within defined technical standards and within time constraints. The Data Analyst is proficient with relational database concepts and practices can evaluate and write complex SQL queri...

Promoted
Columbia Sportswear
Portland, Oregon

As the Principal Data Architect, you will own the data model/schema in support of CSC's analytics. Azure Data Lake, Azure Synapse Data Warehouse, and Azure Analysis Services. Work closely with delivery teams and subject matter experts to deliver data warehousing solutions that are reliable, flexible...

Promoted
D Aceto Services LLC
Portland, Oregon

D Aceto Services LLC is seeking a motivated and detail-oriented Entry-Level Data Analyst to join our team. Help maintain data integrity and accuracy within databases. In this remote position, you will work closely with various departments to analyze data, generate insights, and support decision-maki...