Consultant/Senior Consultant - SQL Server | Lisboa/Porto

At EY youll 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 were 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.

The opportunity

EY is looking for a Senior SQL Server Consultant to join our dynamic team that focuses on implementing solutions and working in client engagement teams to deliver tech consulting this role you will leverage your extensive experience in SQL Server to design and implement robust database solutions that drive business success. You will play a crucial role in optimizing our data management processes and ensuring the integrity and security of our data assets.

Your key responsibilities

Business Analysis: Collaborate with stakeholders to gather and analyze business requirements translating them into technical specifications for database solutions.

Database Development: Design develop test implement and maintain stored procedures functions and triggers in SQL Server to meet business needs and enhance operational efficiency.

Performance Optimization: Conduct performance tuning and optimization of SQL queries and stored procedures to improve database performance and responsiveness.

Cross-Functional Collaboration: Work closely with cross-functional teams including application developers data analysts and project managers to ensure seamless integration of database solutions.

Monitoring and Troubleshooting: Monitor database performance and troubleshoot issues implementing solutions to prevent future occurrences and ensure optimal performance.

Data Security and Integrity: Implement best practices for data management to ensure the security integrity and availability of data within the SQL Server environment.

Documentation: Maintain comprehensive documentation of database designs processes and procedures to facilitate knowledge sharing and compliance with organizational standards.

Technical Support and Training: Provide technical support and training to end-users and development teams fostering a culture of continuous improvement and knowledge sharing.

Skills and attributes for success

Communication is essential must be able to listen and understand the question and develop and deliver clear insights in both verbal and written with the ability to convey complex technical concepts to non-technical stakeholders.

Independent and able to manage and prioritize workload.

Ability to adapt quickly and positively to change.

This position will require strong analytical and problem-solving skills with a keen attention to detail.

You will also be a part of larger team (incl. client-side stakeholders) so communication and collaboration skills will also help you to succeed.

A proactive approach to identifying and resolving issues

To qualify for the role you must have

Bachelors degree in information systems Computer Science Engineering or other related;

Minimum of 6 years of experience in SQL Server database development and administration;

Strong proficiency in SQL programming including the creation and maintenance of stored procedures functions and triggers;

Proven experience in database performance optimization and troubleshooting techniques;

Familiarity with ETL tools and data integration processes;

Excellent English communication skills (written & spoken). A good level of another foreign language would be an asset.

Ideally youll also have

Relevant certifications in SQL Server (e.g. MCSA MCSE) are a plus;

Experience with master / reference data are a plus;

Experience in SSIS SSAS Power BI

What we look for
An effective communicator and youll be a confident team player equipped with strong people management skills; Creative proactive a team player and able to work under pressure. Its important to have a strategically focused mindset and the ability to deliver multiple projects and present information in a clear and concise manner. Business mindset and some commercial acumen. We value a strong work ethic forward-thinking and being a self-starter.
If youre ready to take on a wide range of responsibilities and are committed to seeking out new ways to make a difference this role is for you.

What we offer
We offer a competitive remuneration package where youll be rewarded for your individual and team performance. Plus we offer support:
Continuous learning: Youll develop the mindset and skills to navigate whatever comes next.
Success as defined by you: Well provide the tools and flexibility so you can make a meaningful impact your way.
Transformative leadership: Well give you the insights coaching and confidence to be the leader the world needs.
Diverse and inclusive culture: Youll be embraced for who you are and empowered to use your voice to help others find theirs.

If you can demonstrate that you meet the criteria above please contact us as soon as possible.

The exceptional EY experience. Its yours to build.

EY Building a better working world

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.

At EY were committed to providing recruitment and career opportunities to all regardless of gender sexual orientation social background or disability. We believe that equality and diversity are central to our recruitment process as they enhance creativity and efficiency leading to improved performance and line with this commitment EY Portugal recently became a member of the Inclusive Community Forum. This initiative led by Nova SBE focuses on the recruitment of individuals with disabilities advocating for a more inclusive community. Moreover EY Portugal has also endorsed the Diversity Charter of APPDI (the Portuguese Association for Diversity and Inclusion) pledging to establish and develop internal policies and practices which support diversity. Through these initiatives EY seeks to actively contribute to the inclusion process and promote a more inclusive community for people with disabilities by actively participating in creating solutions.

#Hybrid