Product Data Analytical Engineer (Remote)

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.

We are a product data team responsible for building and maintaining high-performance data pipelines in Snowflake to support business analytics, KPIs, and product insights. We collaborate closely with Data Analysts, SQEs, and Product Managers to understand key business needs and create custom, optimized data sources for efficient reporting and decision-making. We are looking for an Analytical Engineer to bridge the gap between data engineering and analytics. You will analyze existing data, work closely with stakeholders to gather requirements and develop high-performing, reusable data sources that power dashboards and insights.

Key Responsibilities:

• Analyze existing data models to ensure efficiency.
• Collaborate with Data Analysts, SQEs, and PMs to understand business needs.
• Design and build custom, high-performance data sources in Snowflake.
• Optimize SQL queries and transformations for better performance.
• Ensure data integrity, accuracy, and governance in all models.
• Work with engineers to improve data availability and observability.
• Maintain documentation and best practices for data transformations.
• Support continuous improvements in data processing efficiency.

Required Skills & Experience:

• 1+ years of experience in Analytical Engineering, Data Engineering, or BI Development.
• Experience with AWS Cloud services
• Strong expertise in SQL, with experience optimizing queries for performance.
• Experience with Snowflake and data warehousing best practices.
• Ability to understand and translate business needs into scalable data models.
• Strong collaboration skills to work with analysts, SQEs, and PMs and translate them into data models.
• Experience with ETL/ELT processes and data transformation.

Preferred Qualifications:

• Experience with DBT for data modeling.
• Familiarity with Python for data processing and automation.
• Knowledge of Tableau or other BI tools for data validation.
• Understanding of data governance, security, and best practices.

EEO Statement

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.

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.

Read Full Description