Software Guidance & Assistance
Data Workflow & Integration Contractor
Software Guidance & Assistance, San Jose, California, United States, 95199
Overview
Software Guidance & Assistance, Inc. (SGA, Inc.) is seeking a
Data Workflow & Integration Contractor
for a
CONTRACT
assignment with a premier SaaS client. This position is remote. The Digital Media Voice of Customer team seeks a versatile contractor to design, implement, and maintain robust data workflows that enable structured intake, transformation, integration, and reporting of customer feedback and related datasets. While our current environment leverages Airtable, future work may involve additional platforms. You should bring strong data operations experience, expertise with ETL pipelines, and the ability to quickly learn and deploy new tools. You will be the go-to resource for data architecture, ingestion, transformation, integration, and QA, and you will ensure data is accurate, accessible, and ready for analytics, reporting, and decision-making. Responsibilities
Data Architecture & Schema Design
Design scalable relational and/or non-relational database schemas for structured and unstructured datasets Define tables, relationships, metadata standards, and naming conventions to maximize clarity and future scalability Establish data governance rules and documentation
Data Ingestion, Transformation & Pipelines
Develop and manage ETL/ELT workflows to pull data from various sources (APIs, CSVs, SaaS platforms, cloud storage) using automated and manual methods Perform data cleaning, normalization, deduplication, and enrichment Prepare datasets for migration to new platforms, ensuring structural and semantic consistency Automate recurring data ingestion and transformation processes when possible
Platform & System Implementation
Support new software/platform rollouts by preparing data for ingestion, testing migrations, and validating results Configure platform-specific data models, permissions, and workflows Assist with vendor coordination and implementation timelines
Workflow Automation & Integration
Build and maintain automations to streamline manual processes (status updates, notifications, and custom calculations) Integrate disparate platforms (e.g., Airtable, Microsoft 365, SFDC, BI tools) via native connectors, middleware (Zapier, Power Automate, etc.), or APIs Create alerts, validation rules, and monitoring dashboards to ensure data quality
Quality Assurance & Maintenance
Conduct regular QA checks for data integrity, completeness, and compliance Troubleshoot schema, automation, and integration issues Maintain version control for workflows and pipelines
Stakeholder Collaboration
Partner with Voice of Customer, operations, and product teams to gather requirements and align workflows as needed Provide training and support to internal users on Airtable features and best practices Contribute to knowledge base and onboarding materials
Required Skills
Full lifecycle experience: from designing schemas and pipelines to QA and post-launch support Ability to handle large datasets confidently, without sacrificing accuracy or performance Experience with unstructured data and turning it into structured insights Ability to pivot quickly when platforms change, requirements shift, or new data sources emerge Ability to bridge technical systems and business needs Work well with ambiguity, thrive in zero-to-one environments, and proactively propose solutions 5-10 years of experience in data operations, workflow design, or platform integration Proven experience building and maintaining ETL/ELT pipelines across multiple data sources Proficiency with data cleaning and transformation tools (Excel, SQL, Python, or similar) Strong skills in relational database design and metadata management Excellent written and verbal communication, with a focus on clear documentation Preferred Skills
Experience with Airtable or similar platforms Experience with BI tools such as Power BI Familiarity with customer feedback, product research, or voice-of-customer workflows Background in platform implementation or data migration projects Compensation
Base pay range: $74.00/hr - $84.00/hr Note: This range is provided by Software Guidance & Assistance, Inc. Your actual pay will be based on your skills and experience talk with your recruiter to learn more. About the Company
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission is to solve big IT problems with a personal, boutique approach. Each year, we match consultants to more than 1,000 engagements. We are an Equal Opportunity Employer and do not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy. Visit https://sgainc.com/ for more information. Seniority level
Mid-Senior level Employment type
Contract Job function
Other Industries
IT Services and IT Consulting
#J-18808-Ljbffr
Software Guidance & Assistance, Inc. (SGA, Inc.) is seeking a
Data Workflow & Integration Contractor
for a
CONTRACT
assignment with a premier SaaS client. This position is remote. The Digital Media Voice of Customer team seeks a versatile contractor to design, implement, and maintain robust data workflows that enable structured intake, transformation, integration, and reporting of customer feedback and related datasets. While our current environment leverages Airtable, future work may involve additional platforms. You should bring strong data operations experience, expertise with ETL pipelines, and the ability to quickly learn and deploy new tools. You will be the go-to resource for data architecture, ingestion, transformation, integration, and QA, and you will ensure data is accurate, accessible, and ready for analytics, reporting, and decision-making. Responsibilities
Data Architecture & Schema Design
Design scalable relational and/or non-relational database schemas for structured and unstructured datasets Define tables, relationships, metadata standards, and naming conventions to maximize clarity and future scalability Establish data governance rules and documentation
Data Ingestion, Transformation & Pipelines
Develop and manage ETL/ELT workflows to pull data from various sources (APIs, CSVs, SaaS platforms, cloud storage) using automated and manual methods Perform data cleaning, normalization, deduplication, and enrichment Prepare datasets for migration to new platforms, ensuring structural and semantic consistency Automate recurring data ingestion and transformation processes when possible
Platform & System Implementation
Support new software/platform rollouts by preparing data for ingestion, testing migrations, and validating results Configure platform-specific data models, permissions, and workflows Assist with vendor coordination and implementation timelines
Workflow Automation & Integration
Build and maintain automations to streamline manual processes (status updates, notifications, and custom calculations) Integrate disparate platforms (e.g., Airtable, Microsoft 365, SFDC, BI tools) via native connectors, middleware (Zapier, Power Automate, etc.), or APIs Create alerts, validation rules, and monitoring dashboards to ensure data quality
Quality Assurance & Maintenance
Conduct regular QA checks for data integrity, completeness, and compliance Troubleshoot schema, automation, and integration issues Maintain version control for workflows and pipelines
Stakeholder Collaboration
Partner with Voice of Customer, operations, and product teams to gather requirements and align workflows as needed Provide training and support to internal users on Airtable features and best practices Contribute to knowledge base and onboarding materials
Required Skills
Full lifecycle experience: from designing schemas and pipelines to QA and post-launch support Ability to handle large datasets confidently, without sacrificing accuracy or performance Experience with unstructured data and turning it into structured insights Ability to pivot quickly when platforms change, requirements shift, or new data sources emerge Ability to bridge technical systems and business needs Work well with ambiguity, thrive in zero-to-one environments, and proactively propose solutions 5-10 years of experience in data operations, workflow design, or platform integration Proven experience building and maintaining ETL/ELT pipelines across multiple data sources Proficiency with data cleaning and transformation tools (Excel, SQL, Python, or similar) Strong skills in relational database design and metadata management Excellent written and verbal communication, with a focus on clear documentation Preferred Skills
Experience with Airtable or similar platforms Experience with BI tools such as Power BI Familiarity with customer feedback, product research, or voice-of-customer workflows Background in platform implementation or data migration projects Compensation
Base pay range: $74.00/hr - $84.00/hr Note: This range is provided by Software Guidance & Assistance, Inc. Your actual pay will be based on your skills and experience talk with your recruiter to learn more. About the Company
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission is to solve big IT problems with a personal, boutique approach. Each year, we match consultants to more than 1,000 engagements. We are an Equal Opportunity Employer and do not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy. Visit https://sgainc.com/ for more information. Seniority level
Mid-Senior level Employment type
Contract Job function
Other Industries
IT Services and IT Consulting
#J-18808-Ljbffr