SQL Data Engineer at Realm Digital

Purpose

• We have a client that is looking for a SQL Data Engineer to join their team.

Tasks include:

• Data engineer will be part of a team that conducts regular and adhoc data projects.
• Data engineer required to implement and maintain solutions including data sourcing, data transformation using SQL.
• Data engineer will be communicating with client and end-user to determine purpose and end solution requirements.
• The role will also cover data extraction and data manipulation to fulfil client requirements, including adhoc requests, documentation, effective communication with external clients and internal stakeholders.
• Investigation, design, and implementation of improvements to existing processes
• Ad-hoc queries relating to broad spectrum data and products
• Documenting and general maintenance of processes
• Combine raw data from multiple sources and explore ways to enhance data quality and reliability
• Prepare data for prescriptive and predictive modelling and collaborate with data scientists and architects on projects
• Identify and interpret trends and patterns
• Build data systems (ETLs) and pipelines with proper data governance in
• line with the overall organizational strategy

Essential Skills, Attributes & Qualifications 

• Solid experience in all Microsoft products (TSQL, SSMS, Visual Studio,
• SSIS, VS code, Azure)
• Knowledge and experience in R and Python
• Ability to adapt to different programming tools based on project at hand
• Proficient in automation of processes and troubleshooting
• MCSE Certificate-Data Management and Analytics or Business
• Intelligence
• Experienced in SQL database design
• Understand the concepts, principles, and implementation of data modelling, design, governance, and data management
• Skilled at gathering, cleaning, enriching, and transforming data into the desired format to incorporate better decision-making in less time
• Understand the processes, roles, policies, standards, and metrics that ensure the effective and efficient use of data/information