SQL Developer at Flash Group

RESPONSIBILITIES

• Be compelled to analyze data to ensure data integrity, obtain meaning, and provide derived knowledge that will be used to make informed decisions.
• Provide expertise and guidance in the design, development, optimisation, implementation and maintenance of data warehouse solutions.
• Bring a passion for database development, data modelling and data base design to a cross functional agile team.
• Exhibit self-management by being proactive, accountable and responsible for work deliverables.
• Consistently strive to improve technology and career aspirations.
• Exhibit a high level of proficiency when writing SQL code.
• Collaborate with the Business Intelligence team, and business when determining requirements.
• Develop technically sound data warehouse solutions based on requirements.
• Manage, support and maintain existing data warehouse solutions.
• Perform problem resolution and root cause analysis along with recommending and implementing preventative techniques.
• Ensure operational database and integration systems are functioning within specification and provide optimization where necessary.
• Perform tests and produce results to ensure accurate compliance with project requirements.
• Manage priorities across design and development activities as well as defect resolution.
• Interact with technical and business stakeholders to create solutions and solve problems collaboratively.
• Assist in data analysis and data modelling where required.
• Use the Scrum Framework to deliver data warehouse solutions.
• Participate in code reviews, design discussions, development issues feedback and provide possible solutions.

MINIMUM REQUIREMENTS:

• 5+ years SQL coding and Database Development using the relevant technologies
• Computer science / IT qualification advantageous
• SQL programming
• Database design / Data modelling
• SSRS development
• SSIS development
• Enterprise Information Management using:
• Master Data Services MDS.
• Data Quality Services DQS.
• Microsoft SQL Server table partitioning.
• Microsoft SQL Server temporal tables.
• Microsoft SQL Server indexing.
• Microsoft SQL Server Statistics.
• Designing of indexes.
• SQL code performance tuning