Data Engineer

DescriptionBring your IT career and talents to CDW, where you can have a greater impact, be inspired by our mission and excited about your career and future. A Fortune 200 leader, we’re the driven professionals and technology experts companies turn to most to solve their IT challenges.CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers around the Globe. A Fortune 500 company and member of the S&P 500 Index, CDW was founded in 1984 and employs over 15,000 coworkers, with headquarters across the United States, United Kingdom and Canada.CDW prides itself on “making amazing happen”. Our relationships are fueled by our deep expertise and are grounded in the CDW Way. Our empowering leadership makes things happen and inspires their teams to do the same. From the teammates beside us to the leaders who guide us, we move forward together.Job SummaryCDW UK’s Business Transformation are responsible for driving and accelerating change and transformation across people, process, and systems. Its role is to:Provide portfolio management for all change initiatives ensuring they are assessed, prioritised, sequenced and governed to maximise benefit to CDW’s customers and co-workers, supported by robust Change ManagementSupport change initiatives with additional resource and skills, from Project Managers to Business Analysts and technical experts.Own some of the major 70+ business-wide initiatives including Robotic Process Automation, ServiceNow implementation, Process Re-engineering, and ERP replacement.CDW is undergoing a roll out of our Azure data platform, and we are looking for a Data Engineer to join a growing team to ingest, cleanse and model data into single source of truth Kimball datasets, used for Business Intelligence reporting and Data Science machine learning use cases.Key responsibilitiesIngest data from various sources, including on premise SQL databases, REST API’s, Apache Kafka streams, etc.Define and apply cleansing rules to the data to ensure meets quality expectations.Define and model data into single source of truth Kimball datasets, e.g. dimensions and facts.DevOps approach to software; create high quality code using traditional software practices, such as building, linting, unit and integration testing, repositories, CI/CD, peer reviews, etc.DevOps approach to support; monitor pipelines to ensure businesscritical data pipelines are processed meeting time constraint and data quality expectations (including implementing reactive changes where applicable).Drives and Integrates into the data team’s WOW, including backlog refinement, sprint planning, demonstrations, and retrospectives, including translation of user requirements into technical requirements including complexity estimation, implement into sprint cycles, collaboration into process improvement, etc.Based on requirements, perform ad-hoc analysis of structured and unstructured data across multiple data sources to inform solution design.Document datasets in data catalogue, including ownership, stewardship, dictionaries, glossaries, lineage, sensitivity, etc.Ownership of Work Items and works with data owners / stewards to ensure high quality, aligned deliveries, and compliance with legislation, such as GDPR, e.g. PII vs non-PII, data retention, etc.Document solution design in wiki.The above is not an exhaustive list of duties and you will be expected to perform different tasks as necessitated by your changing role within the organisation and the overall business objectives of the organisation.Qualifications, Skills & ExperienceMust Have:Architecture, modelling and leadership skillsStrong Azure data skills, including:Azure Data Factory V2Azure Data Lake Storage V2Azure DatabricksAzure Function Apps& Logic AppsAzure Stream Analytics o Azure Resource Manager skills (Terraform, Azure Portal, Az CLI and Az PowerShell)Strong PySpark, Delta Lake, Unity CatLog and Python skills. o Includes ability to write unit and integration tests in Python with unittest, pytest, etc.Strong understanding of software development practices, such as SOLID principals, structuring code, testing, IOC, etc.Strong repositories, CI/CD skills.Strong knowledge of Kimball data modelling, such as star schema, snowflake, etc.Strong SQL skills.Strong data analysis skills.Excellent written and verbal communication skillsA minimum of 2 years of experience as an Architect.A demonstrable track record of getting stuff done whilst managing competing pressures and deadlines and retaining an eye for detail and quality.A passion for technology and its ability to have a positive impact on business.Nice To Have:Azure DevOps (git, multistage YAML, etc.)Other languages, such as C#, PowerShellIaC, e.g. Terraform, ARM, Bicep, etc.Test driven development (TDD)Streaming technologies, such as Azure Stream Analytics, Spark Structured Streaming, etc.Power BI Engineering experienceCertified SCRUM Developer (CSD)Machine learning and Artificial intelligenceEssential AttributesBe a leader who can manage, inspire, and live by the CDW code.Highly motivated self-starter with ability to work with executives, managers, and individual contributors at all levels.Passionate about what they do and making a difference.Exceptional problem-solving skills and be able to multitask and manage multiple work streams and problems simultaneously.The ability to prioritise tasks through organisation and delegation is essential.To demonstrate a positive, proactive, results driven team approach.A highly energetic individual with a passion to lead, develop and contribute.Able to demonstrate adaptability in response to changing needs and priorities.Reliable, tolerant, and dependable under pressureAble to work to deadlines.Has a professional ‘can do’ attitude and approachMore about CDW and your career with us:At CDW, you’ll work with people who inspire you. People with positive, success-driven attitudes whom you will learn and forge strong relationships with. Bring your best true self — and your best ideas — to CDW. Because diverse perspectives bring forth better problem solving — and better solutions for our customers in a rapidly evolving technology landscape.CDW is an equal opportunity employer committed to maintaining a policy of non-discrimination towards all coworkers and applicants for employment in all aspects of employment. CDW does not discriminate against any applicant because of age, disability, gender reassignment, marriage and civil partnership status, pregnancy and maternity, race, religion/belief, sex, sexual orientation, veteran status, or any other basis that is prohibited by local employment law, including those protected by the UK Equality Act 2010.We encourage candidates from all walks of life to apply and join us in our mission of cultivating a culture of belonging, diversity and inclusion for better collaboration, innovation, and business results.Together, we strive to create a workplace where everyone feels like they belong and is empowered to bring their full energy, capabilities and authenticity for coworker and business benefits.

Will you be a part of it?What we offer:Life AssuranceCompetitive Contributory PensionPrivate Medical InsuranceEnhanced Maternity Pay25 days holiday + bank holidaysOption to buy additional holidayDental InsuranceSeason Ticket Loan + additional perksWho we are:CDW is a leading technology solutions provider to business, government, education and healthcare organizations across the globe. Our fingerprints can be found on technology in workplaces of more than 250,000 companies; from fresh-faced start-ups to international conglomerates. With the breadth of products and services we offer, there is no request too big or too small.What you can expect from us: Culture, coworkers, careers.CDW is not only the People Who Get IT but the People who get People. Our relationships are fueled by our deep expertise and grounded in the CDW Way. Our empowering leadership makes things happen and inspires their teams to do the same. From the teammates beside us to the leaders who guide us, we move forward together. At CDW, you’ll work with people who inspire you. People with positive, success-driven attitudes who you will learn from and forge strong relationships with. Bring your best true self—and your best ideas—to CDW. Because diverse perspectives bring forth better problem solving—and better solutions for our customers on a rapidly evolving technology landscape.