Data Tech Lead at Orioninnovation

Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity. We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education. Main Purpose of Job This is a senior hands-on data engineering role supporting the delivery, maintenance, and improvement of our client's data platform and data warehouse services. The role combines hands on development with technical oversight of distributed delivery teams. It is responsible for designing and maintaining reliable data pipelines, ETL processes, data models, APIs, and supporting AWS based services, while ensuring delivery aligns with development standards, architecture principles, and operational expectations. The role will work across technologies including AWS S3, AWS Lambda, AWS Fargate, AWS Glue, Amazon Redshift, SQL, and Python. It will also provide day to day technical guidance and review for offshore development teams, helping ensure that work is correctly understood, appropriately designed, well implemented, tested, and suitable for long term support. Knowledge, Skills and Experience Essential Knowledge • Proven experience as a Senior Data Engineer, Data Warehouse Developer, Data Engineer, or similar technical data role. • Experience developing and maintaining data warehouse solutions and ETL processes. • Strong understanding of data modelling, data transformation, and data quality principles. • Experience working with cloud based data engineering services. • Strong understanding of software engineering good practice, including maintainability, version control, testing, review, and documentation. • Experience working in Agile delivery environments. • Experience working with distributed, offshore, near shore, or third party development teams. • Ability to provide technical guidance and challenge implementation decisions constructively. • Ability to challenge proposed designs and implementations where they create risk around maintainability, performance, data quality, security, or supportability. • Effective communication skills, with the ability to work with both technical and non technical stakeholders. • Familiarity with Jira and Confluence for project and delivery management. Essential Functional / Technical Skills • Strong SQL skills, including query optimization, data transformation, modelling, reconciliation, and validation. • Strong Python skills for data engineering, automation, ETL, or API development. • Experience with AWS S3 for data storage and data exchange. • Experience with AWS Glue or similar ETL tooling. • Experience with Amazon Redshift or similar cloud data warehouse technology. • Experience with AWS Lambda, AWS Fargate, or similar serverless/container-based services. • Experience developing, supporting, or integrating APIs used by data platforms or downstream systems. • Experience with data quality checks, validation, reconciliation, and production support of data pipelines. • Familiarity with GitHub or similar version control tools. • Understanding of CI/CD, environment management, deployment safety, and operational support. Desirable • Experience providing technical oversight to offshore or near shore delivery teams. • Experience with infrastructure as code tools such as Terraform. • Experience with Java or other backend development languages. • Familiarity with AWS IAM, secrets management, access control, and cloud security fundamentals. • Experience with data governance, data lineage, and data catalogue tooling. • Experience with reporting, BI, or analytics platforms. • Experience working in high traffic, consumer, ecommerce, media, sport, or membership-based organizations. What we offer: • Dynamic and supporting international teams. • Regular assessments and performance reviews. You will have the opportunity for promotion, bonuses and a raise in accordance with the pace at which you develop and your performances. • Hybrid or office work. • 20-25 vacation days per year. • 4 days of sick leave (100% paid) • Equipment for work, laptop and all necessary additions. • Access to trainings and courses. • Private health insurance. • FIT Pass card for many sports’ facilities Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law. Candidate Privacy Policy Orion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, “Orion,” “we” or “us”) are committed to protecting your privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) explains: • What information we collect during our application and recruitment process and why we collect it; • How we handle that information; and • How to access and update that information. Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.