Data/ Application Integration Engineer

The Data / Application Integration Engineer will own and scale our data ingestion layer using Fivetran and Databricks or similar technologies and help build integrations between our systems with Microsoft PowerApps / Oracle Integration Cloud, Databricks Partner Connect, Fivetran Census, or similar technologies. This role focuses on integrating legacy enterprise applications, SaaS enterprise applications, databases, APIs, and file-based sources into a cloud-native analytics platform. You will ensure data is reliable, complete, secure, and delivered on time to support analytics, reporting, and downstream data products. This role sits at the intersection of source systems, data engineering, and platform operations. This role is integral to driving the company's data strategy and ensuring that data initiatives align with business objectives., * Data Ingestion & Integrations

• Design, implement, and maintain data and application integrations using Fivetran (and Census), Databricks Partner Connect, Microsoft Power Apps, Azure Integration Services, Oracle Integration Cloud, or similar tools
• Integrate data from ERP platforms (Financials, Supply Chain, Warehouse Management, Transportation Management) both on-prem and Cloud, SaaS platforms, operational databases, APIs, and flat files
• Build and maintain Fivetran (custom connectors, Census), Databricks Partner Connect, Azure integration services, Microsoft Power Apps, Oracle Integration Cloud, or similar tools where off-the-shelf connectors do not meet requirements
• Partner with application owners to understand source system schemas, SLAs, and change patterns

• Databricks & Landing Zone Engineering

• Land raw data into Databricks Delta Lake (Bronze layer) with appropriate partitioning and metadata
• Validate source data completeness, freshness, and schema consistency
• Support incremental loads, CDC, and historical backfills
• Build lightweight Databricks jobs for ingestion validation and reconciliation

• Data Quality, Monitoring & Reliability

• Monitor Fivetran: syncs, alerts, and failures; troubleshoot root causes
• Implement ingestion-level data quality checks and reconciliation logic
• Manage schema drift, breaking changes, and connector upgrades
• Document data sources, refresh schedules, and known limitations

• Security, Access & Compliance

• Configure secure connectivity (networking, secrets, service accounts)
• Apply least-privilege access controls to source systems and landing tables
• Support PII handling, retention, and regulatory requirements
• Partner with security and platform teams on audits and reviews

• Technical Skills

• 5+ years of experience in data integration, ETL/ELT, or data engineeringintegrating various enterprise applications including ERPs (Financials, Supply Chain, Warehouse Management, Transportation Management) both on-prem and cloud.
• Hands-on experience with Fivetran, Databricks Partner Connect or similar tools (including connector configuration and monitoring)
• Experience with Databricks and Delta Lake
• Strong SQL skills; working knowledge of PySpark or Python
• Experience integrating APIs (REST/JSON), relational databases, and SaaS tools
• Familiarity with CDC concepts (log-based replication, timestamps, soft deletes)
• Git-based development and documentation practices

• Operational & Collaboration Skills

• Strong troubleshooting and root-cause analysis skills
• Ability to work with application owners and non-data teams
• Comfortable operating production data pipelines with SLAs

• Education:

• Bachelor's degree in Computer Science, Engineering, or equivelant experience.

Nice-to-Have Skills *

• Familiarity with cloud platforms (Azure, AWS, or GCP)
• Exposure to Unity Catalog or data governance tooling
• Experience with data transformation orchestration tools
• Experience with pulling data from either Microsoft Dynamics 365 or Oracle Fusion
• Experience in enterprise or regulated environments
• Experience working with AI tools and agents

• An amazing company culture!
• Medical/Dental/Vision on the first of the month following hire.
• ESOP (Profit Sharing) and 401(k).
• Paid vacations, paid holidays.
• Pre-tax commuter benefits, and onsite parking.
• Coverage under State Sick Leave.
• 100% Prepaid College Tuition for employees and their dependents.
• Employee assistance program (EAP).

Additional Compensation Details:

• $102K- $148K annually
• Yearly review with possibility of increase based on performance and tenure, Please note that the pay range provided is a good faith estimate for the position at the time of posting. Actual compensation will be dependent on factors, including but not limited to, the individual's qualifications, experience, knowledge, skills, and abilities as well as physical work location within the state.

Charlie's Produce - Who We Are Charlie's Produce is a privately owned wholesale produce company. We are the largest privately owned produce wholesaler on the West Coast, and we are growing. The secret to our success in this industry is PEOPLE! We strive to hire the best and we reward them with a working environment that fosters loyalty, stability, innovation, and growth. Charlie's was founded in quality, and we are proud that it is still our focus. With a team of dedicated people who are passionate about food, supply chain, and their community we are looking for like-minded individuals to help further our goal to enhance our communities through quality produce.