Datawarehouse Developer

Job Description

Responsibilities This role is responsible for the development and enhancement of Data Warehouse and Reporting applications and interfaces owned by the department.The responsibilities of the role include:
• Deliver smart, appropriate solutions that meet or exceed business expectations
• Deliver assigned activities and tasks to budget and schedule, and to agreed criteria for success
• Ensure that the project methodology is applied in all tasks undertaken
• Provide regular and timely updates to management regarding status of work activities
• Identify and raise to management any risks or issues, and contribute to the development of plans to either avoid or overcome these risks and issues
• Develop and contribute to the development of the team s skills and capabilities
• Enthusiastically participate in the development and improvement of in-the department s Excel standards and methodologies
• Adherence to security and other global and local standards
Understand requirements and design solutions
• Work directly with business analysts and/or the business end-users to ensure that requirements are understood
• Work with technical peers to identify and design appropriate and effective solutions to meet requirements
• Where applicable, document designs and solutions for changes required using the appropriate document repository (depending on the complexity of the application)
• Work with business analysts, developers and project managers to provide realistic and accurate estimates for tasks and projects
• Ensure that operational monitoring, housekeeping/maintenance and DR solutions are considered as part of all changes
Coding and testing of solutions
• Coding of required changes, respecting development standards and the project methodology
• Conducting and participating in peer code reviews
• Thorough system, unit and integration testing
• Support User Acceptance Testing
Deployment and handover
• Ensure that solutions designed and delivered can be operated and maintained
• Prepare solutions for deployment and document the deployment and change process
• Make sure that all UAT and production deployments are correctly stored in the source code repository
• Work with the Environment management team to ensure that solutions are deployed to test environments for systems testing and UAT
• Ensure that appropriate signoffs have been obtained prior to applying to have the solution approved for promotion to Production as well as adherence to defined promote procedures
• Ensure that solutions are handed over effectively to the support teams (Service Delivery)
Technical & Behavioral Competencies Required:
• At least 5 years software development experience
• Extensive experience in MS SQL development
• Proven experience using a design methodology
• Excellent communication and self-management skills
• Strong delivery focus, skills and experience
• The ability to own and solve technical problems
• A proactive self-starter
• Enthusiastic team player
• Experience and desire to work in a collaborative team environment
• Experience using the Waterfall methodology
Preferable:
• Degree qualification in IT or related discipline
• Software development experience in the Financial services industry
• Exposure to the Financial and/or Funds Management industry
• Exposure to the Agile methodology
Behavioral
• • Accountable : Want someone who is accountable for their actions. The Business analyst must be accountable for their estimates and for tracking their actions against the relevant plans as well as outlining issues as they arise
  • Attention to detail : Ensures accuracy and implements processes to ensure quality of output. Ensures high personal standards in all areas of work.
  • Problem solving: gathers and analyses information and uses it to develop effective solutions to difficult problems or situations
  • Client Focus: Complete commitment to provide professional, intelligent and timely responses to internal and external clients needs and to changes in the market.
  • Communication: Write, speak and present information effectively, relevantly and in a timely fashion
  • Negotiation & conflict resolution: Negotiates or mediates sound agreements in situations where there is disagreement or differences in interests
  • Innovation: Develop and implement original ideas, approaches and solutions to typical, unusual or difficult situations or problems
  • Collaboration and teamwork: Develops and maintains a good working relationship with others. Provide support to other team members and seeks the same from others.
  • Strategic thinking: Understands the business, and anticipates business needs, reflecting this in the approach to current solutions
  • Pro Active : Must be someone who can see a need and be willing to assist in meeting that need even if it falls outside the word specific area of their job description. Want a team player who realizes the importance of delivering the business solution and is willing to assist with this
Specific Qualifications (if required)Required:
• Strong understanding of MS SQL Server 2000 2017 database design and development (including Stored Procs, Functions Triggers etc.)
• Experience with DTS and SSIS.
• Experience with Agile methodology
• Experience with SSRS
• Experience in Database Migration
• Knowledge in SQL server replication
• Exposure to C#, ASP.NET, XML, XSLT, . NET Framework and Web development
• Exposure to database unit testing with tSQLt framework
• Hands-on experience in documenting Analysis and Design documents
Desirable:
• Knowledge of BIZ talk, SWIFT, , Web services and Service Oriented Architecture (SOA)
• Exposure to SWIFT, HiPortfolio and/or pControl
• Exposure Team Foundation Server (TFS)
Skills Referential Behavioural Skills : (Please select up to 4 skills)Communication skills - oral & written Client focusedAbility to share / pass on knowledgeAbility to deliver / Results driven Transversal Skills: (Please select up to 5 skills)Ability to develop and adapt a process Ability to understand, explain and support change Ability to develop and leverage networks Ability to anticipate business / strategic evolution Ability to set up relevant performance indicators Education Level: Bachelor Degree or equivalent Experience Level At least 5 years Other/Specific Qualifications (if required)NA, *NA

Keyskills :
ms sql serverteam foundation serverms sqlsql servervisual basicweb servicesunit testingdr solutionsretail bankingbiztalk serverglobal delivery