Data Consultant - Data Engineer at Intuit

Liverpool, England, United Kingdom

Intuit Logo
Not SpecifiedCompensation
Mid-level (3 to 4 years), Senior (5 to 8 years)Experience Level
Full TimeJob Type
NoVisa
Telecoms, Insurance, Finance, MortgagesIndustries

Requirements

  • Solid experience in Azure, specifically Azure Databricks and Azure SQL/SQL Server
  • Proficiency in SQL and Python languages
  • Hands-on experience in designing and building data pipelines using Azure Data Factory (ADF)
  • Familiarity with building metadata driven pipelines
  • Knowledge of Azure Storage, Medallion Architecture, and working with data formats such as JSON, CSV, and Parquet
  • Strong understanding of IT concepts, including security, IAM, Key Vault, and networking
  • Familiarity with agile principles and practices
  • Experience with Azure DevOps pipelines
  • Exposure to Apache Airflow and DBT (bonus)
  • Certification in Azure or related technologies (nice to have)
  • Experience with other cloud platforms (e.g., AWS, Google Cloud) (nice to have)
  • Knowledge of big data technologies (nice to have)
  • Familiarity with data governance and compliance (nice to have)
  • Experience in BigQuery (GCP), data modelling in DBT, and mobile/telecoms industry (beneficial for Analytics Engineering lean)

Responsibilities

  • Develop and maintain data pipelines using Azure Data Factory (ADF), ensuring efficient and reliable data movement and transformation
  • Perform data modelling using Kimball, 3NF or Dimensional methodologies
  • Utilize SQL and Python to extract, transform, and load data from various sources into Azure Databricks and Azure SQL/SQL Server
  • Design and implement metadata driven pipelines to automate data processing tasks
  • Collaborate with cross-functional teams to understand data requirements and implement appropriate solutions
  • Ensure data quality, integrity, and security throughout the data pipeline
  • Troubleshoot and resolve any issues or errors in the data pipelines
  • Stay updated with the latest Azure technologies and industry best practices to continuously enhance data engineering capabilities
  • Ingest large data sets for clients, involving data pipeline design, integration, and transformation into models for downstream consumption

Skills

Key technologies and capabilities for this role

Azure Data FactoryData PipelinesData IngestionData IntegrationData TransformationData Modeling

Questions & Answers

Common questions about this position

What is the salary for this Data Consultant - Data Engineer position?

This information is not specified in the job description.

Is this role remote or hybrid, and where are the office locations?

The role is hybrid, with all office locations considered including Newbury & Liverpool (UK) and Šibenik, Croatia.

What key skills are required for this Data Engineer role?

Key skills include developing data pipelines with Azure Data Factory, data modelling using Kimball, 3NF or Dimensional methodologies, SQL and Python for ETL into Azure Databricks and Azure SQL/SQL Server, and designing metadata-driven pipelines.

What is the team and company culture like at Intuit?

Intuita is a fast-growing consultancy making waves in consultancy and technology, with a dynamic team of experts where you can act as an expert in data and technology, working on ambitious goals to exceed client expectations across various sectors.

What makes a strong candidate for this position?

Strong candidates have immediate or quick availability, permanent rights to work, and skills in data engineering with Azure technologies; experience in Analytics Engineering with BigQuery, DBT, and mobile/telecoms is also beneficial.

Intuit

Financial software for tax and accounting

About Intuit

Intuit provides financial technology solutions designed to assist consumers and small businesses with their financial needs. Its main products include TurboTax for tax preparation, QuickBooks for accounting, and Mint for personal finance management. These tools help users manage their finances effectively by simplifying complex tasks like filing taxes, tracking expenses, and budgeting. Intuit stands out from its competitors by offering a subscription-based model along with transaction fees, which allows for continuous updates and support for its users. The company's goal is to empower individuals and small businesses to achieve financial success through education and user-friendly experiences, while ensuring the security of their financial data.

Mountain View, CaliforniaHeadquarters
1983Year Founded
$11.7MTotal Funding
IPOCompany Stage
Fintech, Cybersecurity, Financial ServicesIndustries
10,001+Employees

Risks

Emerging fintech companies like CoinTracker pose competition in the tax preparation market.
Acquisition of SeedFi may lead to increased regulatory scrutiny in financial services.
Integration challenges from Zendrive acquisition could cause operational disruptions if not managed well.

Differentiation

Intuit offers a comprehensive suite of financial tools including TurboTax, QuickBooks, and Mint.
The company focuses on data security with multi-factor authentication and anti-fraud technology.
Intuit fosters innovation and diversity, enhancing user experience and financial education.

Upsides

Acquisition of SeedFi expands Intuit's reach to low-credit consumers in underserved markets.
Integration of Zendrive enhances data analytics for personalized and secure financial solutions.
Growing institutional investments indicate strong market confidence and potential stock value appreciation.

Land your dream remote job 3x faster with AI