Data Consultant

SDG Group UK; Milton Keynes; On-site; GBP 45,000 - 65,000; Full time

Job summary

SDG Group UK is seeking a Data Consultant to join the Milton Keynes team. You will deliver data consulting, build ETL/ELT pipelines, and support data architecture on cloud platforms (Azure, AWS, Snowflake). You will analyze and design data solutions in BI and Big Data, with a focus on quality and client satisfaction.

Ideal candidates have 3+ years of data experience, strong SQL/Python/Spark skills, data modelling knowledge, and excellent communication and teamwork abilities.

Qualifications

• Experience designing data warehouses, data lakes or data lakehouses.
• Proven ability with SQL, Python or Spark to process and model data.
• 3+ years of data engineering/analytics work delivering data solutions.
• Strong data integration and performance optimization knowledge.
• Excellent verbal and written communication and teamwork.

Responsibilities

• Deliver first-class data consulting services to clients.
• Design and implement ETL/ELT processes for data projects.
• Support data architecture design and cloud platform guidance (Azure, AWS, Snowflake).
• Develop data engineering solutions within BI/Big Data domains.
• Communicate clearly with clients and colleagues, and maintain quality outputs.

Skills

Data warehousing

Data lakes

Data lakehouses

SQL

Python

Spark

ETL/ELT

Data modeling

Communication

Teamwork

Tools

Git/JIRA

Power BI

Tableau

Qlik

Looker

Matillion

Talend

Pentaho

SSIS

Databricks

DBT

Fivetran

Snowflake

SQL Server

Oracle DB

Redshift

Job description

SDG Group is a global Consulting firm specialising in Data & Analytics. We are committed to unlocking an organisations' potential and hidden value by offering in-depth analytics expertise that empowers our clients' business models to become successful data-driven enterprises. Innovation is in our DNA. We constantly innovate our value proposition with cutting-edge laboratories and transformational models to provide the ultimate analytics practices and solutions.

SDG Group has partnerships with the leading technology vendors: AWS, Microsoft, Snowflake, Matillion, ThoughtSpot & Dataiku.

We are currently looking for a Data Consultant to join our Data practice based out of our Milton Keynes.

As a Data Consultant, you will work on projects, executing data driven tasks, while offering recommendations to the client, that will enhance project scalability.

Duties and Responsibilities:

Consultation:

Delivering first-class data consulting services to SDG's clients

ETL/ELT Implementation:

Data processing and development of ETL/ELT processes

Architecture Support:

Support the design of data models and architecture under the guidance of architects on Cloud Platforms (Azure, AWS, Snowflake or similar).

Technical Delivery:

Analysis, design and development of solutions and projects in the field of data engineering in Business Intelligence and Big Data.

Quality Driven Approach:

A strong foundation in soft skills e.g. clear communication both verbally and in writing, passion for developing high quality and accurate outputs, ability to adapt to different clients and businesses, ability to be proactive and navigate uncertainty.

Ideally you will be able to offer

• A strong understanding of designing and implementing data warehouses, data lakes, or data lakehouses.
• Demonstratable experience of implementing Slowly Changing Dimensions types 0,1 and 2
• 3+ years' experience working with Data
• A strong understanding of data integration techniques and solution /performance optimisation
• Excellent understanding and knowledge of SQL, Python or Spark
• Apply relevant data modelling techniques (e.g. STAR, Snowflake)
• Excellent Communication and Teamwork Skills
• Coaching and mentoring experience

Technologies & Experience Desired:

• Git and JIRA software and backlog management tools
• Power BI, Tableau, Qlik or Looker
• Matillion, Talend, Pentaho, SSIS
• Databricks, DBT, Fivetran
• Snowflake, Microsoft SQL Server, Oracle DB or Redshift
• Building CI/CD pipelines and IaC
• Analytical skills including the ability to apply a range of analytics, visualisation and data science techniques
• Strong understanding of Matillion architecture and access control