Skip to content

Solutions Data Engineer

San Jose, CALos Angeles, CASolutions ArchitectureOnsite3+ YOE
Summary

Builds and manages end-to-end data integrations for customer source systems into FloQast's platform using Data Studio, handling extraction, transformation, validation, and publishing. Requires 3+ years in data integration with strong SQL/Python/scripting skills and cross-functional collaboration.

About the role

What You'll Do

  • Use our Data Studio and Data Platform to build and manage end-to-end data flows across connection, extraction, mapping, transformation, validation, and publishing.
  • Analyze source system data to understand file structures, APIs, data relationships, and model requirements for new integrations and use cases.
  • Connect FloQast to customer source systems including ERPs, file-based sources, APIs, and other upstream systems using supported connectivity patterns such as sFTP, APIs, and data sharing.
  • Create mappings for new source systems and new FloQast data models, ensuring source data is accurately normalized for downstream application use.
  • Map and transform source data into FloQast data models so it can be consumed consistently across FloQast applications.
  • Build custom data models and transformation logic that extend FloQast's surface area to new systems and use cases, including non-ERP systems such as subledgers, banks, billing, payments, and other external platforms.
  • Partner cross-functionally with customers, partners, Implementation, Customer Success, Product, and Engineering to turn business needs into working integrations and durable data solutions.
  • Troubleshoot mapping, transformation, and publishing issues across customer implementations and internal platform workflows.
  • Resolve data variances between source systems and published outputs to ensure accuracy, consistency, and trust in the data.
  • Support successful customer launches by ensuring source data is connected, validated, and published accurately into FloQast applications.
  • Scale integration patterns, mappings, and recipes so new sources can be onboarded more efficiently and consistently over time.
  • Identify opportunities to improve Data Studio recipes, platform capabilities, and operating processes so integrations become faster, more scalable, and easier to support.

What You'll Bring

  • 3+ years of experience in data integration, technical implementation, solutions consulting, analytics engineering, data migration, or a similar hands-on role.
  • SQL, Python, and scripting skills, with hands-on experience working with data pipelines, APIs, file analysis, and file manipulation.
  • Advanced proficiency in Microsoft Excel.
  • Experience working with large CSV, TSV, and Excel-based source files.
  • Experience working with structured and semi-structured data, transformation logic, schema mapping, and data validation.
  • Experience cleansing, reshaping, and validating data for downstream consumption.
  • Comfort working with incomplete, inconsistent, or messy source data.
  • Strong communication skills and the ability to work effectively across customers, partners, Implementation, Customer Success, Product, and Engineering.
  • Comfort operating in ambiguity and moving quickly without heavy process or close oversight.
  • Strong debugging and troubleshooting ability across end-to-end data flows, including identifying root causes and driving issues to resolution.
  • A practical ownership mindset with a bias toward getting working data into production safely and reliably.

Nice to have

  • Experience working with financial data models and systems, such as hands-on experience with one or more major ERPs or accounting systems such as Oracle, SAP, Workday, or OneStream.
  • Working knowledge of accounting and financial data, with the judgment to recognize when balances, relationships, or hierarchies do not make business sense.
  • Experience working in a model-driven or metadata-driven data platform where source data is mapped, normalized, and published into reusable application-ready models.
  • Experience creating custom transformation logic or custom data models to support downstream reporting, operational workflows, analytics, or application use cases.
  • Experience troubleshooting customer-specific data issues in production environments, including source data defects, mapping gaps, schema mismatches, and transformation failures.
Skills
SQLPythonData PipelinesAPIsMicrosoft ExcelsFTPCSVTSVData TransformationSchema MappingData ValidationERPsSAPOracleWorkday