Data Engineer

Data Engineer Arctiq - 3.0 Irvine, CA Job Details Contract 21 hours ago Qualifications Data model design Databricks Data Integration (Data management) Requirements design Presentations for conferences or internal meetings Schema design SQL Technical solutions implementation Data Architecture Design (Architecture design skills) Requirements analysis Query execution time improvement CRM system proficiency Business requirements Query management Project stakeholder communication Dimensional modeling Stakeholder management Full Job Description Arctiq is a global, intelligence-driven technology services company delivering professional and managed services across Hybrid Cloud Infrastructure, Networking & Connected Experiences, Cybersecurity, Data & AI, Autonomous Operations & Intelligence, and Enterprise Service Management. We help organizations operate, secure, and modernize complex environments by unifying infrastructure, networking, data, security, automation, and observability under a single, integrated operating model. Our work focuses on helping customers reduce operational friction, improve resilience, and make better, faster decisions as their environments evolve. Arctiq builds on decades of industry expertise and a customer-centric ethos to deliver exceptional value to clients across diverse industries. We are looking for a Data Engineer (Data Analyst) to join Arctiq dedicated entirely to a high-priority internal data implementation. This is primarily a data engineering role, the successful candidate will be a strong builder who is equally comfortable designing pipelines and data models as they are engaging with business stakeholders to understand requirements. This is a 3 months contract opportunity (with potential extension). You will be embedded in our Data and AI practice, working at pace to deliver a unified data platform across five tightly scoped use cases. Databricks is our exclusive platform, and deep hands-on experience with it is essential including Declarative Pipelines (Delta Live Tables) for pipeline development. The right candidate will hit the ground running, drive the work forward independently, and keep stakeholders aligned throughout. The candidate will work across the following systems and is expected to have direct experience with several of them: NetSuite — ERP, financial data, and deal object target for cash-to-cash integration QuickBooks — accounting and financial records HubSpot — CRM, target state for pipeline and contact data Salesforce — CRM, legacy source being transitioned to HubSpot Smartsheet & Resource Manager — resource planning and operational delivery data Responsibilities Design, build, and maintain scalable data pipelines in Databricks using Declarative Pipelines (Delta Live Tables), applying medallion architecture principles across bronze, silver, and gold layers Build robust data models on Delta Lake that unify data across ERP, CRM, and resource management systems Write clean, efficient, and well-documented SQL for transformation, aggregation, and business logic Implement data quality frameworks, expectations, and lineage tracking within the Databricks ecosystem Configure and manage Databricks workflows, jobs, and cluster resources to support reliable pipeline execution Map and load resource and delivery data into ERP deal objects to support the cash-to-cash use case Execute the CRM-to-CRM data migration, ensuring complete and accurate translation of historical records Analytics & Insight Delivery Develop dashboards and reports that surface actionable insights across all five use cases Define and instrument key business metrics in partnership with Finance, Sales, and Operations teams Conduct exploratory analysis to surface trends, anomalies, and data quality issues Stakeholder Engagement & Leadership Lead discovery and requirements conversations with internal business teams across Finance, Sales, and Operations Translate business needs into well-scoped pipeline designs, data models, and reporting deliverables Communicate progress, findings, and blockers clearly to both technical and non-technical stakeholders Work closely with a Business Analyst to align data outputs with business processes and reporting workflows Proactively manage scope and timeline to keep the implementation on track within the 3-month window Required Qualifications 3+ years of hands-on experience in a data engineering or analytics engineering role Deep, production-level experience with Databricks, this is a non-negotiable requirement. Must be comfortable with Delta Lake, Declarative Pipelines (DLT), notebooks, SQL warehouses, jobs/workflows, and cluster configuration Hands-on experience with Databricks Declarative Pipelines (Delta Live Tables) for building and managing transformation pipelines Expert-level SQL proficiency, complex transformations, query optimization, and building reusable modular logic Proven experience building and maintaining pipelines that integrate data from ERP and CRM systems Solid understanding of data modeling principles, including dimensional modeling and medallion/layered architecture Experience with data migration or system transition projects Ability to independently lead stakeholder discovery sessions and translate business requirements into engineering solutions Strong communication skills; comfortable presenting technical work to non-technical audiences Demonstrated ability to deliver at pace in a time-boxed engagement with a high degree of autonomy Nice to Have Databricks certifications (Data Engineer Associate or Professional) Experience with Databricks Asset Bundles or CI/CD workflows within the Databricks ecosystem Familiarity with professional services business models (utilization, billable hours, project margins, cash flow cycles) Experience with commission modeling or sales compensation data Experience writing back to ERP systems (e.g., populating deal or transaction objects from external data sources) Python skills for pipeline development, data manipulation, or scripting within Databricks notebooks Experience with Apache Spark for large-scale data processing Arctiq is an equal opportunity employer. If you need any accommodations or adjustments throughout the interview process and beyond, please let us know. We celebrate our inclusive work environment and welcome members of all backgrounds and perspectives to apply. We thank you for your interest in joining the Arctiq team! While we welcome all applicants, only those who are selected for an interview will be contacted.