Solution Architect

Ioco; Gauteng; On-site; ZAR 900 000 - 1 200 000; Full time

Job summary

A data solutions company in South Africa is seeking an experienced Solution Architect to lead data projects and engage with clients. The ideal candidate will have a minimum of 7 years in data engineering, strong SQL skills, and experience with Microsoft technologies. Responsibilities include building data solutions and optimizing data pipelines. This role offers competitive pay and opportunities for technical growth.

Qualifications

• Minimum 7 years working experience in data engineering.
• Strong analytic skills related to working with unstructured datasets.
• Experience in supporting cross-functional teams.

Responsibilities

• Engage with clients to conceptualize data solutions.
• Assist sales team with Pre-Sales and POCs.
• Build the infrastructure for optimal data extraction and loading.

Skills

Data engineering

Advanced SQL knowledge

Data pipeline architecture

Analytic skills

Project management

Education

Bachelor's degree in Computer Science or related field

Master's degree in a relevant field

Tools

Microsoft SQL Server

Microsoft Power BI

SSIS

SSAS

SSRS

Data Factory

Job description

Solution Architect

Posted today

Job Description

We are looking for a strong Solution Architect to join our Data, Information and Analytics team as client-facing, permanently employed consultants. Someone who is passionate about data and implementing technology solutions and leading project teams to achieve business outcomes. There will be exposure to a wide range of industries, so the ability to quickly understand new business environments is essential.

What Will You Do?

• Engage with clients to conceptualize data solutions
• Assist our sales team with Pre-Sales and POCs
• Provide technical assistance and guidance to our junior and intermediate consultants
• Create and maintain optimal data pipeline architecture
• Assemble large, complex data sets that meet functional and non-functional business requirements
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, redesigning infrastructure for greater scalability
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Microsoft technologies
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics
• Collaborate with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs
• Work with data and analytics experts to strive for greater functionality in our data systems
• Complete technical reviews for consultants
• Assist with necessary technical training for consultants and clients
• Provide input into consultants technical growth plans
• Drive technical blogs, forums and/or workshops
• Balance team support responsibilities with billable work, depending on capacity and utilization

Who do you need to be

• Minimum 7 years working experience in data engineering
• Advanced SQL knowledge and experience with relational databases, query authoring and familiarity with a variety of databases
• Experience building and optimizing data pipelines, architectures and data structures
• Experience performing root cause analysis on internal and external data and processes
• Strong analytic skills related to working with unstructured datasets
• Experience building processes supporting data transformation, metadata, dependency and workload management
• A track record of manipulating, processing and extracting value from large datasets
• Strong project management and organizational skills
• Experience supporting and working with cross-functional teams in a dynamic environment

Qualifications

Bachelor's degree in Computer Science, Information Systems, Information Technology, or related field. A Master's degree in a relevant field is advantageous.

Microsoft Qualifications: Microsoft Certified Solutions Associate: Data & Analytics (Advantageous); SQL Server 2016 or later; SQL Database Development; SQL Database Administration; SQL BI Development; BI Reporting (Power BI, Qlik Sense, Tableau); Microsoft Certified Solutions Expert (Advantageous); Data Management & Analytics; Microsoft Azure Certifications (Advantageous).

Technology Experience: Experience with Microsoft SQL Server, SSIS, SSAS, SSRS, Data Factory, Microsoft Power BI.

Is this job a match or a miss?