Data Engineer
Job Title: Cloud Data Warehouse Engineer
Location: Hybrid – 1 day per fortnight in the Wilmslow offices
The Role
Following recent investment, The Citation Group are looking to build out their data capabilities to be Best in Class. As such, a fantastic opportunity has arisen for a strong data warehouse engineer to work in the data engineering team. Work with the Lead Data Engineer to build and maintain the data warehouse foundations which support all business units.
We’re looking for an individual who has experience with scaling Data Modelling/Engineering processes with robust pragmatic solutions. You’ll work alongside the BI/Reporting, Data Science and Data Quality & Governance Manager to implement the group wide data warehousing strategy.
Responsibilities
- Defining the roadmap for the data warehouse
- Building and maintain ETL pipelines
- Manage and maintain the Group Data Warehouse
- Data platforms administration
- Ensure relevant technical documentation is in place
The Person
We are looking for someone who can roll their sleeves up and ‘dig in’ with the rest of the team. In addition, the successful candidate should have:
- Excellent writing and communication skills with an attention to detail
- Experience writing, troubleshooting, and debugging advanced SQL queries
- Outstanding analytical and problem-solving skills
- Experience working with ETL/ELT, and reporting and analytic tools
- Experience designing data warehouse technical architectures and infrastructure components
- Programming experience in Python
Desirable
- Understanding of cloud computing security concepts
- Experience in relational cloud based database technologies like Snowflake, BigQuery, Redshift
- Experience in open source technologies like Spark, Kafka, Beam
- Good understanding of Cloud providers – AWS, Microsoft Azure, Google Cloud
- Familiarity with DBT, Delta Lake, Databricks
- Experience with Snowflake
- Experience working in an agile environment
About Us
We are Citation. We are far from your average service provider. Our colleagues bring their brilliant selves to work every day and we create an environment where they can shine. We are a nice bunch. We don’t do office politics or “that’s not my job”. We listen, support and take ownership.
We have been proudly delivering valuable HR and Health and Safety services to SME’s across the UK for over 20 years. Passionate about service, we’re on a mission to revolutionise our colleague’s and client’s experience by employing brilliant people who are experts at what they do and smile whilst they are doing it.
Working for Citation you will have access to 25 days holiday, plus your birthday off work, gym membership discount, healthcare, childcare vouchers, the opportunity to purchase extra leave, pension contributions and more.
It’s a great place to work because of the people we employ. Fun and professional, we want likeminded individuals who love to love their job (no ‘mood hoovers’ here thanks!) and want the Company to succeed.
So, if our culture sounds like a good fit for you and you want to be part of our success story, then send us your details.
