Database Architect - Assistant Director

Ernst & Young - Woodbridge Township, NJ

Full-time - Mid Level

Woodbridge Township, 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 includes responsibilities for ETL processes, performance tuning, and comprehensive documentation of database architecture.

Responsibilities

• Design and implement databases for opportunity identification and targeting applications.
• Create data models that define data organization and representation within the database.
• Design and implement ETL processes to extract, transform, and load data into the database.
• Optimize database performance through query tuning, indexing, and data partitioning.
• Ensure scalability and availability of the database infrastructure to support growing data needs.
• Collaborate with Power BI developers to understand data requirements and provide guidance on database design.
• Document database design, data models, ETL processes, and other relevant aspects of the database architecture.

Requirements

• Experience in database design and development.
• Proficiency in ETL processes and tools.
• Strong understanding of performance optimization techniques for databases.
• Ability to create and maintain documentation for database architecture.

Nice-to-haves

• Familiarity with Power BI and data visualization tools.
• Experience with cloud-based database solutions.
• Knowledge of data governance and security best practices.

Benefits

• Comprehensive health insurance coverage.
• 401(k) retirement savings plan with company matching.
• Paid time off and holidays.
• Professional development opportunities.
• Flexible work arrangements.