Data Engineer

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.

What you'll be doing :

• Design, build, and deploy robust ETL and data management processes specifically for ingesting, transforming, and loading high-volume digital analytics data from Google Analytics 4 (GA4) into BigQuery / Snowflake.
• Develop and optimize BigQuery / Snowflake datasets, tables, and views to support various analytical needs, ensuring efficient querying and data integrity.
• Design, build, and deploy ETL job workflows with reliable error / exception handling and rollback frameworks. This includes designing and implementing data pipelines to feed data models for subsequent consumption.
• Monitoring and optimizing data processing and storage resources, with a focus on performance and cost efficiency.
• Troubleshooting and resolving data pipeline issues and performance bottlenecks, particularly those related to large-scale digital data processing.
• Write complex, customized SQL queries to manipulate data, generate automatic periodic reports, and support ad-hoc analytical requests.
• Build applications and scripts using Python to automate data processes, integrate systems, and enhance data quality.
• Develop strategies for data ingestion (from multiple sources) into data platforms, using various extract and load techniques through scripting and / or tooling, streaming, API consumption, and replication.
• Document data engineering processes, best practices, and technical specifications, especially for GA4 data models and BigQuery / Snowflake schemas.
• Work collaboratively with Business Partner Teams and Business Stakeholders during project scoping and feasibility phases as a Subject Matter Expert (SME) for concept investigation / viability and technical impact; identify and communicate technical risks and mitigations.
• Conform to agile development practices – Evolutionary design, refactoring, continuous integration / delivery, test-driven development.
• Provide production support for data load jobs, ensuring the continuous flow of critical digital data. Actively monitor and resolve user support issues, working closely with your functional squad and other squads.
• Maintain or upgrade existing data applications and pipelines.
• Clearly communicate technical terms to non-technical people and help them understand why change might be required to achieve a specific goal or to complete a project.
• Attend key design meetings and provide support.
• Perform research of viable technical and / or non-technical solutions.
• Other ad hoc duties as required.

What you’ll need :

Engineer's Core Skills :

Tools & Technologies :

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 (“Notice”) explains :

Your use of Orion services is governed by any applicable terms in this notice and our general .