Senior Data Engineer
United Kingdom
Applications have closed
Doctor Care
Access appointments for health advice, treatment or prescriptions from a fully qualified GP or ANP 24/7, 365 days a year.Thanks for stopping by! We’re Doctor Care Anywhere: a leading digital platform, with a clear vision to radically transform the future of healthcare – and that all starts with our brilliant team. From doctors and designers to software developers and marketers – we’re proud of our people, who love working together to enhance patient experiences for the better.
It’s why every year, we help over 2 million people speak to a GP by video or phone, anywhere in the world.Our story started back in 2013, but as we continue to rapidly grow, we’re looking for the very best talent to help us achieve our ambitious goals.If you’re highly motivated, hard-working and ready to dream big – while having lots of fun at the same time – then we want to hear from you today!
Requirements
- Examine complex data and turn the data into information and insights
- Understand business processes and data flows
- Build and interrogate ETL processes to maintain data quality
- To be the “Data Guru” by building a deep knowledge our many and varied data sets with the ability to extract insights from their complexity
- Build and maintain optimized and highly available data pipelines that translate raw data into powerful features
- Build and maintain reliable and scalable ETL/ELT on big data platforms
- Build data processing frameworks to handle growing databases
- Build and monitor metrics and analyse data
- Develop queries for business projects
- Design , architect, implement, and support key datasets that make available structured and timely access to actionable business insights
- Works closely with Analytics team
- Retrieves and analyses data through the use of SQL, Excel, etc
- Build data loading services for the purpose of importing data from numerous, disparate data sources, inclusive of APIs, logs, relational, and non-relational databases
- Keep track of industry best practices and trends, and through acquired knowledge, take advantage of process and system improvement opportunities
Experience
- Database design, interrogation & programming skills (relational database, advance select queries, indexes and constraints).
- Writes advanced SQL including query tuning.
- Good understanding of data warehouse concepts.
- Experience designing and building complete Extract & Loading processes using ADF & Extract, Transformation & Loading processes using SSIS
- Business Intelligence & Data Analytics using multiple tools.
- Software development background married with strong data merging skills
- Previously worked with large data sets
- Excellent problem solver able to analyse data, identify issues/opportunities, design and implement pragmatic solutions.
- Proven abilities to be pro-active, take initiative and be innovative within a team environment
- Analytical mind within a problem-solving attitude with a keen eye for detail
- Able to work on several projects at the same time and prioritise effectively
- Build deployment pipelines – databases, data factory
Software experience
Essential
- SSDT 2017+
- Github
- Advanced T-SQL
- Azure Data Factory
- Logic Apps
- Azure Storage (Data Lake G2, Blob Storage)
- Microsoft Azure SQL
- Azure Data Warehouse environment (Dimensional Model Kimball / Inmon)
- Azure DevOps / Terraform
Desirable
- Understanding of Azure Security Model (Managed Identities, Service Principals, Virtual Networks)
- Azure Synapse
- Service Bus based architecture
- Data Bricks
- Azure Functions
- Azure Analysis Services
- SSRS, SSAS
- Power apps
- Python, R
- Microsoft Dynamics 365, Power BI, Tableau or similar BI tools
- SQL Server integration services
Benefits
We understand the importance of good health and happiness for our patients and our employees. You can expect to be supported and valued as a member of out team and have the freedom to make the most of your role and careers with us! As part of that, as an employee you will have access to:
- Free Private Medical Insurance
- Doctor Care Anywhere subscription for you and 5 members of your friends or family
- 25 days holiday + bank holidays
- Competitive Maternity and Paternity leave
- Bike2Work scheme
- Flexible working - remote working available with some travel to our London Office when required
Other plus's when at DCA!:
- 4 x charity ‘Care in the Community’ days per year
- Flexible working environment - It's important that you work wherever works for you. The office is a collaborative space where you will be needed for your input occasionally, but will have a mix of working in the office and working from home.
- Progressive environment with a focus on wellbeing
- An environment where the ‘sky is the limit’ offering career opportunities and development
- Open, transparent and dynamic environment, trusted to work independently but with a great team around you
- Virtual Fitness classes three times a week
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Azure Big Data Business Intelligence Data Analytics Databricks Data pipelines DevOps ELT ETL Excel GitHub Pipelines Power BI Python R RDBMS Security SQL SSIS Tableau Terraform T-SQL
Perks/benefits: Career development Flex hours Health care Medical leave Parental leave
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Engineer II jobs
- Open AI Engineer jobs
- Open Senior Data Architect jobs
- Open Power BI Developer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Analytics Engineer jobs
- Open Sr Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Engineer jobs
- Open Business Data Analyst jobs
- Open Product Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data Manager jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open ETL Developer jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Business Intelligence-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Data warehouse-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open Databricks-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open CI/CD-related jobs