EY Consultant/Senior Consultant - SQL Server Lisboa/Porto 

Portugal, Lisbon 

449438443

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.

: 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

• Bachelor’s 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, you’ll 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

An effective communicator and you’ll be a confident team player equipped with strong people management skills; Creative, proactive, a team player, and able to work under pressure. It’s 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 you’re 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.

We offer a competitive remuneration package where you’ll be rewarded for your individual and team performance. Plus, we offer support:
•: You’ll develop the mindset and skills to navigate whatever comes next.
•: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
•: 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.

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