Database Architect, Assistant Director

EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities.  At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.  

Location: Birmingham, Phoenix, Tucson, Rogers, Palo Alto, Sacramento, San Diego, San Francisco, San Jose, Westlake Village, Irvine, Los Angeles, Denver, Stamford, Chicago, Hartford, Hoboken, Orlando, Miami, Jacksonville, Boca Raton, Tallahassee, Tampa, Alpharetta, Indianapolis, Des Moines, Kansas City, Wichita, Salt Lake City, Louisville, New Orleans, Baton Rouge, Baltimore, Boston, Grand Rapids, Detroit, Minneapolis, St Louis, Las Vegas, Iselin, Buffalo, Raleigh, Charlotte, Toledo, Akron, Cincinnati, Columbus, Tulsa, Oklahoma, Portland, Pittsburgh, Philadelphia, Providence, Greenville, Nashville, McLean, Memphis, Chattanooga, Cleveland, Atlanta, Dallas, Houston, San Antonio, Austin, New York, Fort Worth, Richmond, Seattle, Washington, Charleston, Milwaukee
 

Database Architect, Assistant Director

Our Markets function brings together business, sector, and account knowledge along with EY competencies and solutions to meet unique client needs.  The Markets function shares and drives an integrated growth strategy across the largest accounts, the industry sectors, solutions, and services, demonstrating and achieving a market leadership through a client centric culture.

 

Job Summary:

• Database Design: Design and implement the databases that store the data required for opportunity identification and targeting applications. This involves understanding the data requirements, designing appropriate database schemas, and optimizing the database structure for performance and scalability.
• Data Modeling: Create data models that define how data will be organized and represented within the database. This includes designing dimensional and defining relationships between different data entities.
• ETL (Extract, Transform, Load): Design and implement ETL processes to extract data from source systems, transform it into a format suitable for analysis, and load it into the database. This involves understanding the source systems, defining data transformation logic, and optimizing the ETL process for efficiency and reliability.
• Performance Optimization: Responsible for optimizing the performance of the database. This includes tuning database queries, designing indexes, partitioning data, and optimizing data storage and retrieval mechanisms to ensure fast query response times and efficient use of resources.
• Scalability and Availability: Design the database infrastructure to ensure scalability and availability to support the organization's growing data needs. This may involve implementing clustering, replication, and other high-availability mechanisms to minimize downtime and ensure uninterrupted access to data.
• Collaboration with Power BI Developers: Collaborate closely with Power BI developers to understand their data requirements and provide guidance on database design and optimization. May also assist developers in writing efficient SQL queries and troubleshooting database-related issues.
• Documentation: Document the database design, data models, ETL processes, and other relevant aspects of the database architecture. This documentation serves as a reference for developers, data analysts, and other stakeholders involved in using and maintaining the applications.
   (Sales Executives serving as GCSP)

Day to day responsibilities

• Database Design and Development: creating database schemas, defining data models, and implementing database objects such as tables, views, and indexes.
• ETL Development: design and develop ETL (Extract, Transform, Load) processes to extract data from source systems, transform it into a format suitable for analysis, and load it into the BI database. This includes writing scripts or using ETL tools to automate data integration tasks.
• Performance Tuning: continuously monitor and optimize the performance of the BI database. This may involve tuning database queries, optimizing indexes, partitioning data, and analyzing query execution plans to identify and resolve performance bottlenecks.
• Collaboration with BI Developers: collaborate closely with BI developers to understand their data requirements and provide guidance on database design and optimization.
• Documentation: document the database design, data models, ETL processes, and other relevant aspects of the BI database architecture.
• Problem Solving and Troubleshooting: identifying and resolving database-relat