Data Architect - Flash Group

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.

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

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