Flash Group IT / Telecom Jobs in Western Cape
1. Patiently scroll down and read the job description below.
2. Scroll down and find how to apply or mode of application for this job after the job description.
3. Carefully follow the instructions on how to apply.
4. Always apply for a job by attaching CV with a Cover Letter / Application Letter.
Description
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.
- Determine the requirements for new Data Warehouse databases.
- Continuous improvement of current Data Warehouse data structures.
- Team collaboration to meet project phases and deadlines.
- Regular database audits to ensure data quality.
ADVERTISEMENT - CONTINUE READING BELOW
Business Architecture (Vision, Strategy and Architecture)
- No data is better than bad data.
- Ensure that our data quality is beyond reproach by satisfying the following attributes for data quality, accurate, consistent, complete, and valid.
- Provide information when needed, that is easily accessible, understandable, and usable for its intended purpose.
- Be able to understand the big picture, by knowing the organizational IT specific strategy and vision.
- Learn and develop our chosen data warehouse architecture.
- Embrace creativity and innovation.
Data Warehouse Development
- Provide data warehouse solutions to the business.
- Adhere to prescribed standards, coding best practices, development, and management methodologies.
- Be consistent in providing quality code, and technical detail.
- Continuously strive to improve efficiencies of data warehouse solutions, by optimizing code, removing redundancy, and eliminating errors.
- Take pride in delivering the expertise and experience as required by this position.
Team (Mentoring, Coaching and Leadership)
- Be a responsible and accountable active participant of the team.
- Set a good work ethic, and constantly strive to improve the quality of the team.
- Ensure the team meets sprint goals.
- Garner respect through quality of work.
Demonstrate the courage for honest and open communication
Requirements
- 5-8 years SQL coding and Database development using the relevant technologies.
- Computer science/IT qualifications advantageous
- SQL programming
- Data Management discipline and techniques
- Excellent verbal and written communication skillset
- Leadership abilities
- Exceptional attentional to detail
- Database design/ Data modeling
- SSRS development
- SSIS development
- Enterprise Information Management using
- Master Data Service DQS
- Microsoft SQL Server table partitioning
- Microsoft SQL Server temporal tables
- Microsoft SQL Server Indexing
- Microsoft SQL Server Statistics
- Designing Indexes
- SQL code performance tuning
ADVERTISEMENT - CONTINUE READING BELOW
Familiar (advantageous)
- SQL Server
- Oracle DB
- .Net
- Java
- Knowledge of Power BI advantageous
Distinguishing Traits
- Good at articulating to facilitate effectively.
- Attention to detail.
- Embrace and adapt to change.
- Accountable and responsible
- Active participant in the team
- Passionate about data
- Self -management
- Dependable
ADVERTISEMENT - CONTINUE BELOW TO APPLY