Jobs

Senior Data Engineer I


Job details
  • Heartland Business Systems
  • London
  • 1 month ago
Job Type
Full-time
Description

Position Summary:

This position would require a candidate to possess a strong technical background in developing and delivering BI solutions along with a strong understanding of SQL Server environments. Business intelligence (BI) is a set of technologies and practices for transforming business information into actionable reports and visualizations. The Senior Data Engineer transforms data into a useful format for analysis and is focused on the design and architecture.

A Senior Data Engineer is the data professional who prepares the data infrastructure to be leveraged by the HBS BI Data Developers. The Senior Data Engineer will design, build, integrate data from various resources and manage big data. The Senior Data Engineer ensures the operations of the data pipeline follow a consistent process of Ingestion, Processing, Storage and Access. The work involves tuning databases for fast analysis and creating table schemas.

The Senior Data Engineer is responsible for making data easily accessible, ensuring the process works smoothly and is optimized. The Senior Data Engineer is a critical firm member of the Data Team, The Senior Data Engineer will run Extract, Transform and Load (ETL) on top of datasets and create data warehouses that can be used for reporting and analysis. The Senior Data Engineer ensures the operations of the data pipeline follow a consistent process of Ingestion, Processing, Storage and Access.

Roles and Responsibilities/ Essential Functions:

  •  Meet with clients to understand their current business processes and needs to provide consulting services and direction on how to build or grow their current data strategy.
  •  Work with HBS Sales Solutions consultants to identify and grow opportunities within HBS client environments.
  •  Support and administer the underlining infrastructure and layout of a client data environment.
  •  Develop and design the process for the customer data collection process.
  •  Develop policies and procedures for the collection and analysis of data.
  •  Review customer sources to ensure integrity of the data collection process.
  •  Collaborate with the BI Data Developers to ensure the requirements are being met to build the right solution needed.
  •  Estimate development effort required to deliver data customer needs and requests.
  •  Use business analysis skillset to identify development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitability.
  •  Ability to work independently or as a team on project-based solutions for clients.
  •  Work with team mates to continue to grow and mature data services and delivery options for HBS clients.
  •  Based on experience, one may mentor other engineers in developing scalable, secure, high-performance BI and Data solutions.
  •  Billable goal expectation set on an annual basis. These charge hour requirements are prorated based on start date and will be balanced against professional development and on the job training.
Requirements

Competencies

  •  Accuracy – Ability to produce high quality work deliverables leveraging industry best practices.
  •  Analytical Skills - Strong abilities required to effectively interpret customer business needs and translate them into application and operational requirements, resolving complex technical and business problems.
  •  Communication – strong written, verbal, and non-verbal communication skills, especially conveying complex information in an understandable manner.
  •  Leadership – Ability to motivate and guide others to ensure performance is in accordance with clear expectations and goals.
  •  Learning – Ability to quickly learn new technologies to deliver solutions.
  •  Presentation Skills – Ability to effectively conduct formal and informal presentations in both small and large group settings within all levels of a company.
  •  Project Management – Ability to demonstrate an understanding of process engineering, planning, organizing, staffing, directing, and controlling work tasks.
  •  Time Management – Ability to effectively utilize available time for managing multiple tasks/projects simultaneously.

Required Experience:

  •  7 or more years in technology related role
  •  Data Model Design (Physical or Conceptual or both)
  •  Experience with needs analysis, software evaluation and selection, customization, and implementation
  •  Data Warehousing systems and architecture experience in 'real world', practical, successful implementations
  •  Understand multi-dimensional/relational database structures and schemas.
  •  Strong knowledge of system design, development, and deployment
  •  Microsoft BI Suite Experience
  • Microsoft Excel
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Reporting Services (SSRS)
  • Microsoft SQL Server Analysis Services (SSAS)
  •  Programming and Processing Experience
  • T-SQL
  • ETL
  • Python
  •  Azure Experience
  • Azure SQL Database
  • Azure SQL Manage Instance
  • Azure Architecture
  • Azure Data Factory
  •  Strong knowledge of SQL utilizing MS SQL Server
  •  Expertise in Professional Services or similar client facing roles

Preferred Experience:

  •  Experience in multiple industry (Education, Healthcare, Retail, Manufacturing) verticals
  •  PowerShell knowledge and understanding
  •  Understanding of report writing and visualization
  •  GitHub Copilot experience
  •  Microsoft BI Suite Experience
  • Microsoft Power BI
  • Microsoft Fabric
  •  Microsoft certified: Data Analyst Associate
  •  Microsoft certified: DP-200 - Implementing an Azure Data Solution
  •  Microsoft certified: DP-201 - Designing an Azure Data Solution
  •  Microsoft certified: DP-300 - Administering Relational Databases on Microsoft Azure
  •  Other SQL platform knowledge (Oracle, MySQL, PostgreSQL, etc.)

Required Skills, Education and/ or Certifications:

  •  Bachelor’s degree in business or I.T. related discipline accepted or equivalent experience.

Equal Opportunity Employer - Including Disabled and Veterans

#HBS

Sign up for our newsletter

The latest news, articles, and resources, sent to your inbox weekly.

Similar Jobs

Senior Data Engineer

Your Roleand What You'll Be DoingThe Senior Data Engineer is responsible for the design, development, and maintenance of data engineering solutions for Irwin Mitchell. They understand requirements, create technical designs, configure applications, write code, and conduct testing. They collaborate with various teams, participate in meetings, and provide technical advice to...

Irwin Mitchell Birmingham

Senior Data Engineer

JOB SUMMARYB-Stock is actively seeking a skilled Senior Data Engineering Developer to spearhead the design, development, scaling, and maintenance of our cutting-edge SaaS infrastructure. In this pivotal role, you will collaborate closely with cross-functional teams encompassing Data Science, Engineering, and Product/Business Technology. Your primary mission will be to construct robust...

B-Stock Solutions, LLC Ibstock

Senior Data Engineer

Description:Department:Data Management–Data Insights teamThe Data Management team plays a vital role in our organisation, transforming raw data into comprehensive and meaningful insights that can drive informed decision-making. Moreover the data management team is responsible for establishing and maintaining a robust and efficient data model that ensures data is consistent and...

E1 EDF Trading Ltd London

Data Engineering Technical Lead

Data Engineering Technical LeadSalary £60,000 - £65,000 Are you someone who thrives on tackling complex data challenges, designing scalable solutions and has experience within a technical team driving success? If so, we would love to hear from you.We are looking for a Data Engineering Technical Lead to join our growing...

Aviva Norwich

Senior Data Engineer - Contract

Methods AnalyticsMethods Analytics (MA) exists to improve society by helping people make better decisions with data. Combining passionate people, sector-specific insight, and technical excellence to provide our customers an end-to-end data service.We use a collaborative, creative and user centric approach to data to do good and solve difficult problems. Ensuring...

Methods Brynmawr

Senior Data Engineer

Methods AnalyticsMethods Analytics (MA) exists to improve society by helping people make better decisions with data. Combining passionate people, sector-specific insight, and technical excellence to provide our customers an end-to-end data service.We use a collaborative, creative and user centric approach to data to do good and solve difficult problems. Ensuring...

Methods Brynmawr