Database Architect - Assistant Director

Ernst & Young - Trenton, NJ

Full-time - Mid Level

Trenton, NJ

Professional, Scientific, and Technical Services

About the position

The Database Architect - Assistant Director at EY is responsible for designing and implementing databases that support opportunity identification and targeting applications. This role involves creating data models, optimizing database performance, and ensuring scalability and availability of the database infrastructure. The position requires collaboration with Power BI developers and entails documentation of database architecture and processes.

Responsibilities

• Design and implement databases for opportunity identification and targeting applications.
• Create data models that define data organization and relationships.
• Design and implement ETL processes for data extraction, transformation, and loading.
• Optimize database performance through query tuning and indexing.
• Ensure database scalability and availability through clustering and replication.
• Collaborate with Power BI developers to meet their data requirements.
• Document database design, data models, and ETL processes.

Requirements

• Experience in database design and implementation.
• Proficiency in data modeling and ETL processes.
• Strong understanding of performance optimization techniques.
• Ability to collaborate with developers and stakeholders.
• Experience with documentation of database architecture.

Nice-to-haves

• Familiarity with Power BI and SQL query optimization.
• Experience in high-availability database solutions.

Benefits

• Inclusive culture and support for career development.
• Opportunities for professional growth and learning.