Senior Data Consultant

Us3 Consulting; Greater London; Hybrid; GBP 90,000 - 130,000; Full time

Job summary

Us3 Ltd in London is seeking a Senior Data Consultant to join on a permanent basis. The role involves delivering data engineering activities, designing technical specifications, and implementing robust data solutions.

You will mentor developers and participate in architecture and code reviews. The ideal candidate has strong SQL/PLSQL expertise, experience with cloud and on-premise databases, ETL tooling, data modeling and BI tooling like Power BI, plus solid testing practices and stakeholder

Qualifications

• Proven experience as a SQL/PLSQL developer.
• Extensive experience with Snowflake/Redshift/BigQuery/Azure SQL databases.
• Experience with ETL tools (Matillion, SNP Glue, Fivetran, Informatica).
• Azure DevOps experience is a plus.
• Knowledge of data modeling, data curation, and orchestration.
• Experience with Power BI is a plus.
• Strong testing and development practices (unit, TDD, functional).
• Knowledge of at least one shell scripting language.
• Excellent interpersonal and communication skills.

Responsibilities

• Assist data engineer manager with delivery of data engineering activities.
• Prepare technical design specifications based on requirements.
• Implement, test, maintain and support software per designs.
• Improve system quality by identifying issues and standardizing procedures.
• Identify opportunities for system enhancements.
• Support IT controls and business control compliance.
• Maintain and review code and architectures.
• Mentor developers and provide technical guidance.
• Collaborate with stakeholders to implement designs.

Skills

SQL and PLSQL

Cloud SQL databases

ETL tooling

Azure DevOps

Data modeling

Data curation

Orchestration

Power BI

Testing

Shell scripting

Communication

Tools

Snowflake

Redshift

BigQuery

Azure SQL

MS SQL Server

Teradata

Matillion

SNP Glue

Fivetran

Informatica

Power BI

Job description

For a leading client, we are seeking a \"Senior Data Consultant\" for a permanent position in London, UK. Must be able to work 3 days onsite.

Duties

• Assist the data engineer manager with the delivery of data engineering activities.
• Prepare technical design specifications based on functional requirements and analysis documents.
• Implement, test, maintain, and support software, as outlined in technical design specifications.
• Enhance system quality through identification of issues, common patterns, and formulation of standard operating procedures.
• Identify and implement opportunities for system enhancements.
• Working to support Business Control compliance through technology and responsible for ensuring IT Controls are incorporated into Systems.
• Maintain and improve existing codebases and conduct peer code review changes.
• Liaise with team members to implement technical designs.
• Investigate and utilize new technologies as relevant.
• Review functional requirements, analysis, and design documents to provide pertinent feedback.
• Provide technical support to customers, solving problems and answering queries.
• Mentor other development staff members and provide technical assistance as needed.
• Participate in architecture and code reviews.
• Support testing and validation activities within data related projects and initiatives.

Qualifications & Experience

• Proven experience in the market as a SQL and PLSQL developer.
• Extensive experience with any SQL cloud databases like Snowflake/Redshift/ BigQuery/Azure SQL database. Experience with any on-premise SQL database like MS SQL Server, Teradata etc.
• Clear understanding of one ETL tool (For eg: Matillion, SNP Glue, Fivetran, Informatica).
• Azure DevOps experience is a plus.
• Clear understanding of data modeling, data curation, and orchestration
• Experience with Business Intelligence tools like PowerBI is a plus.
• Sound understanding of unit testing, test-driven development, functional testing, and performance aspects.
• Knowledge of at least one shell scripting language.
• Ability to network with key contacts outside of own expertise.
• Excellent interpersonal, organizational, presentation and facilitation skills.
• Must demonstrate result-orientation and customer-focused mindset.
• Strong organizational skills are required.
• Excellent verbal and written communication skills enabling efficient interaction and collaboration with all stakeholders.
• Knowledge of reinsurance or insurance industry concepts is a plus.

Technologies

• DWH (On-premise or cloud – Snowflake preferable)

Nice to haves

• SNP Glue/Matillion/FiveTran