Database Architect - Assistant Director
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. Join us and build an exceptional experience for yourself, and a better working world for all.
The exceptional EY experience. It's yours to build.
EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities.
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-related issues and errors. This may involve analyzing log files, diagnosing performance problems, and troubleshooting data integration issues.
• Research and Learning: stay updated on the latest trends and technologies in database management and business intelligence.
Additional skills/qualities needed to be successful in this role:
• Bachelor's degree or equivalent experience in Computer Science, Engineering, Mathematics, or related field preferred
• 8+ years of relevant experience
• Ability to translate opportunity analytics across various lines of business, offerings, sales campaigns, etc. into the SQL Databases.
• Ability to implement translation matrix to align DB Hoover Data, internal account name, 3rd party data sources, etc. to facilitate rapid ingestion of additional source data
• Build Quality Assurance/Quality Control checkpoints within the database foundation.
What We Offer
We offer a comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business. The base salary range for this job in all geographic locations in the US is $120,700 to $225,800. The salary range for New York City Metro Area, Washington State and California (excluding Sacramento) is $144,900 to $256,600. Individual salaries within those ranges are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and geography. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options. Join us in our team-led and leader-enabled hybrid model. Our expectation is for most people in external, client serving roles to work together in person 40-60% of the time over the course of an engagement, project or year. Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll also be granted time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.
EY accepts applications for this position on an on-going basis. If you can demonstrate that you meet the criteria above, please contact us as soon as possible.
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.
For those living in California, please click here for additional information.
EY is an equal opportunity, affirmative action employer providing equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law.
EY is committed to providing reasonable accommodation to qualified individuals with disabilities including veterans with disabilities. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process, please call 1-800-EY-HELP3, select Option 2 for candidate related inquiries, then select Option 1 for candidate queries and finally select Option 2 for candidates with an inquiry which will route you to EY’s Talent Shared Services Team (TSS) or email the TSS at ssc.customersupport@ey.com
IT Services and IT Consulting
Information Technology
Full-time