PBT Group, leading Data Specialists, is at the forefront of data innovation, and we're seeking a talented Migration Engineer to join our team. This role involves migrating our existing data infrastructure from SQL Server to Snowflake, enhancing our data capabilities, and driving business insights. In addition to migration tasks, you will be responsible for integrating new data sources and providing comprehensive reporting using Qlik.

Job Description:

As an SQL Server to Snowflake Migration Engineer, you will lead the migration of data from SQL Server to Snowflake while also integrating new data sources into existing models. Your role will involve designing and developing robust data architectures, optimizing performance, and providing insights through Qlik reporting. We are looking for an intermediate-level resource who can contribute valuable insights into data modeling and excel in reporting tasks.

Key Responsibilities:

Data Migration:
- Analyse and understand existing SQL Server databases and business logic.
- Develop a comprehensive migration plan for transitioning to Snowflake.
- Execute data migration, ensuring data integrity and performance optimization.
Data Integration:
- Integrate new data sources into existing data models, requiring potential modifications and enhancements.
- Collaborate with stakeholders to understand new data requirements and ensure seamless integration.
Data Modeling:
- Provide insights and recommendations on data modeling to enhance current data structures.
- Design and develop scalable and efficient data architectures in Snowflake.
Reporting:
- Utilize Qlik to design, develop, and maintain reports and dashboards that provide actionable insights.
- Ensure data visualization best practices are followed to enhance reporting quality.
Performance Optimization:
- Optimize Snowflake environments for cost efficiency and performance.
- Implement best practices for data governance, security, and scalability.
Collaboration and Support:
- Work with cross-functional teams to ensure a seamless transition and address any issues.
- Provide support and training to internal teams on Snowflake and reporting solutions.

Skills and Experience Required:

Technical Skills:
- Proficiency in SQL Server and Snowflake, including T-SQL and Snowflake SQL.
- Strong experience with ETL tools (Informatica, Talend, Apache NiFi).
- Experience with data integration and modeling in cloud environments.
Reporting Skills:
- Strong experience with Qlik for designing and developing reports and dashboards.
- Ability to analyse complex data sets and provide insights through visualizations.
Programming and Scripting:
- Strong programming skills in Python or JavaScript.
- Ability to write scripts for data transformation and automation tasks.
Cloud and Big Data:
- Familiarity with cloud platforms (AWS, Azure, GCP) and big data technologies.
Problem-Solving and Communication:
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration abilities, able to articulate opinions on data models.
Experience Level:
- Intermediate-level experience, with the ability to provide insights into data modeling and reporting.
- Snowflake certification is a plus.

Preferred Qualifications:

Bachelor's degree in Computer Science, Information Technology, or a related field.
Relevant certifications in Snowflake, Qlik, or cloud technologies.
Experience in a similar migration or data engineering role.

* In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent

Apply Now

Share this job with someone you think should apply!

Facebook

Data Migration Engineer - Cape Town City Centre

Related Jobs

Senior Data Engineer - Cape Town City Centre

Data Engineer - Cape Town City Centre

Data Scientist - Cape Town City Centre

Engineer - Cape Town City Centre

Engineer CPT - CBD - Cape Town City Centre

Want to do another search?