Job title: SQL Business Intelligence Developer
Education: Bachelor’s degree in computer science
• Qualifications:
• 5 or more years of hands-on experience with MS SQL of various versions, including SQL 2005 and 2008
• 2. Prior work experience implementing large scale relational data warehouse on SQL Server platform with DTS and SSIS processes pulling from multiple source system databases is a plus.
• Responsible for activities involved in the analysis, design, development, troubleshooting, debugging and maintenance of enterprise, high-volume, transactional systems
• Responsible for formulating and implementing the team’s technical vision, providing hands-on insight into system architecture, data software development and architecture design.
• Database designing, database performance, management and tuning experience.
• Experience in database development field.
• Experience leading large multi-resource teams with interdependent initiatives to successful completion.
• Capable of working proficiently at both strategic and tactical aspects of a project.
• Experience with SSIS and SSRS
• Data Modeling experience (Logical/Physical)
• Able to design, code, debug and maintain database schemas and store procedures
• Strong communication skills and interpersonal skills
• Strong problem solving and creative thinking skills
• Able to multi-task and manage multiple project/task assignments simultaneously
Main Responsibilities:
- Manage and mentor a team of software Data Base developers
- Lead consistency in terms of coding standards, development methodology, source control, build, and deployment processes
- Provides the coding and process construction for the development and maintenance of the enterprise data warehouse (DW) and supporting business intelligence (BI) structures
- Develop complex analytic queries and data transformations in SQL and other DW / BI tools
- Assist in the development of production reports, cubes and analytical applications
- Maintain skill proficiency with the tools and software used by the DW and analytic reporting applications and systems
- Actively interface with other teams to gather requirements, design, code, debug, document, implement and maintain various DB projects
- Consult with the business to determine logical design for new business solutions according to existing data architecture
- Perform code reviews, analyze execution plans, and refactor inefficient code
- Collaborate with business analysts, source system experts, and other team members to determine data extraction and transformation requirements
- Provides on-call assistance as needed
Gender: any
If you think you are qualified kindly send your CV + A RECENT PHOTO to cv@strategicvision-eg.com or else the mail will be ignored