Simon Property Group - Indianapolis, IN

posted about 2 months ago

Full-time
Indianapolis, IN
Real Estate

About the position

The Database Architect is responsible for the overall design and development of databases that support business applications, with a primary focus on business intelligence applications. This role involves collaborating with the DBA team, application developers, business analysts, and end users to understand their needs and to recommend appropriate database solutions. The Database Architect will be tasked with building, designing, and implementing databases, which includes creating tables, views, stored procedures, and other database objects. Additionally, the role requires troubleshooting issues related to data and performance, and recommending solutions to enhance database efficiency. The Database Architect will serve as a liaison between the application team and the DBA support team, ensuring that all database designs comply with corporate change management processes. The position also involves assisting with data integration work and, at times, contributing to ETL (Extract, Transform, Load) and report development. This multifaceted role is crucial for maintaining the integrity and performance of the databases that underpin critical business operations. Candidates for this position should have a strong background in relational database development and experience in designing and modeling both relational and analytical databases. The role demands effective communication skills, as the Database Architect will need to convey complex technical information to non-technical stakeholders and collaborate effectively with various teams.

Responsibilities

  • Works with the DBA team, application developers, business analysts, and end users to understand needs and recommend appropriate solutions.
  • Designs and implements databases including tables, views, stored procedures, and other database objects.
  • Troubleshoots issues with data and/or performance and recommends solutions.
  • Serves as liaison between the application team and the DBA support team.
  • Complies with corporate change management processes.
  • Assists with data integration work.
  • At times, assists with ETL and/or report development.

Requirements

  • 7-10 years demonstrated relational database development experience (i.e., tables, views, stored procedures, queries, etc.).
  • 5-7 years demonstrated experience designing/modeling relational and analytical databases.
  • 5-7 years demonstrated experience designing and developing databases in a Business Intelligence/Data Warehouse environment.
  • 5-7 years designing and developing MS SQL Server databases.
  • Effective written, oral, and interpersonal communications.
  • Working knowledge of Software Development Lifecycles (waterfall, iterative, agile, etc.).
  • Experience with Erwin Data Modeling software.

Nice-to-haves

  • Experience with modern database/storage technologies (Azure, Data Lake, NoSQL, etc.) is a plus.
  • Experience modeling and/or writing reports in PowerBI is a plus.
  • Experience with ETL technologies is a plus.
  • Experience with IBM DB2 is a plus.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service