Orion Innovation
Data Engineer
Montvale, New Jersey, United States · Contract
Sponsorship not specifiedDetected 20 days ago
PythonSQLDatabricksAzureLinuxData AnalysisData EngineeringData VisualizationAccountingExcelSAPERPCustomer SupportLeadershipCommunication
About the role
- Orion Innovation is a premier, award-winning, global business and technology services firm.
- This is not an operations manager role; it is a hands-on technical leadership role focused on complex incident resolution, data-intensive troubleshooting, and performance / scalability in large datasets and pipelines.
Responsibilities
- 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 seek an experienced Applications Lead (Technical Lead) to own technical support leadership for Data Analytics solution-supporting a global users across multiple Azure-based production environments.
- You will serve as the escalation support technical lead for the most challenging cases (e.g., large datasets, heavy transformations, performance bottlenecks, configuration issues across data platforms), guiding support analysts and partnering with engineering/product to drive root cause closure and durable fixes.
Requirements
- 8+ years of experience in application support / technical lead / data platform troubleshooting roles, with demonstrated ownership of complex incident/problem resolution in production-like environments.
- Hands-on Azure Data Engineering and Python experience.
- Experience with large-scale data wrangling, including scenarios with very large row counts (e.g., 100M+), and ability to reason about data complexity and performance bottlenecks.
- ability to map concepts between SSIS and ADF.
- Databricks + PySpark familiarity, including:
- Building/navigating workspaces and notebooks
- PySpark read/write operations and basic transformation logic
- Strong T SQL / DWH background, including:
- SQL database design and development
- Stored procedures, table & scalar functions, performance tuning via execution plans and indexing
- Advanced querying (CTEs, temp tables, correlated subqueries
- cursors where appropriate)
- Hands-on ETL and reporting experience, including troubleshooting of pipelines and data flows end-to-end.
- Strong communication skills: ability to explain complex data/platform issues clearly to engineers, support teams, and stakeholders.
Nice to have
- How we handle that information
- Strong understanding of RDBMS concepts and (preferred) MSBI stack fundamentals.
Skills
- Preferred Experience
- ADLS file-format expertise: Parquet/Delta vs CSV/Excel tradeoffs for volume, performance, and operational supportability.
- Power BI workspace concepts (nice to have), plus data management/data analysis tools like Alteryx (nice to have).
- Basic accounting concepts to better interpret audit/financial datasets.
- Advanced Excel (Pivot, formulas, lookups, VBA macros) as a nice to have.
- SAP/Oracle ERP technical profile:
- Understanding ERP architecture
- Support implementation/customization/performance tuning of extraction code
- Basic ABAP/UNIX familiarity as a nice to have
- 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.
Visa & Work Authorization
- 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 ch
Apply directly at Orion Innovation →Create a free account for alerts like thisView Orion Innovation immigration profile
This listing is sourced directly from Orion Innovation's careers page and normalized into a canonical job model.