SQL Developer - SSRS/SSIS

We are data and evidence-based advisory business providing information and recommendations to clients, worldwide. We help clients understand people and inspire growth. The worlds leading, tech-enabled marketing data and analytics company.

Our insights, foresight, and advice are embedded within our clients processes and at the heart of their decisions. We do not just help clients understand what has happened; we explain why and how they can shape the future.

Our Data Engineering practice is at the core of our data-driven solutions, focusing on database design, development, optimization, and data integrity. By combining cutting-edge database technologies and human expertise, we empower clients with robust, reliable, and scalable data infrastructures.

Job Overview :

We are seeking an experienced and dynamic SQL Developer to join our esteemed team. The ideal candidate will design, develop, and maintain database systems, ensuring high performance and availability. This role requires strong SQL programming skills, database optimization expertise, and a collaborative approach to solve complex data challenges.

Key Responsibilities :

- Database Design & Development: Develop, implement, and optimize SQL queries, stored procedures, functions, views, and triggers.

- Data Management: Create and maintain data models, ensuring data integrity and accuracy.

- Performance Tuning: Analyze and optimize slow-running queries and database structures.

- Collaboration: Work closely with cross-functional teams, including data analysts, engineers, product managers, and business stakeholders, to understand requirements and deliver robust database solutions.

- Data Integration: Develop and maintain ETL (Extract, Transform, Load) processes to load and transform data.

- Security & Compliance: Ensure databases adhere to security and compliance standards.

- Documentation: Document database structures, processes, and best practices for future reference.

- Mentorship: Provide guidance and support to junior database developers.

Key Qualities :

- Technical Expertise: Proficiency in SQL, T-SQL, and relational database concepts (e.g., normalization, indexing).

- Attention to Detail: Precision in database design and query development to ensure accuracy and performance.

- Problem-Solving Skills: Ability to troubleshoot database issues and implement effective solutions.

- Communication Skills: Ability to convey technical concepts to non-technical stakeholders.

- Team Collaboration: Strong interpersonal skills and a collaborative approach to working in teams.

- Adaptability: Flexibility to handle changing project requirements and challenges.

- Curiosity and Innovation: Drive to explore new database technologies and performance optimization techniques.

Qualifications :

- Proven experience of 3 to 5 years in a SQL Developer or related role with hands-on experience in SQL Server or other RDBMS.

- Proficiency in SQL, T-SQL, and ETL processes.

- Experience with database performance tuning and optimization techniques.

- Familiarity with SSIS, SSRS, and SSAS is a plus.

- Bachelor's degree in a related field (e.g., Computer Science, Information Systems, Engineering).

- Strong presentation and communication skills.