Join the Ford family as we change the way the world moves.
Data Engineer – Full Stack
Location
Ohio
Posted
69 days ago
Salary
$99.6K - $198.5K / year
Seniority
Senior
Job Description
Data Engineer – Full Stack
Ford Motor Company
• Design and implement end-to-end data pipelines (ETL/ELT) that ingest, process, and curate large-scale enterprise data, including telemetry/vehicle data and other structured/unstructured sources. • Build and maintain Gen AI pipelines — including embedding generation, vector store indexing, retrieval-augmented generation (RAG), and LLM orchestration — to enable intelligent search, summarization, and conversational analytics over enterprise data. • Migrate and modernize data assets to a centralized data platform (e.g., BigQuery) using principled data lake/warehouse architectures (Bronze/Silver/Gold or Medallion architecture) to power analytics, reporting, and AI/ML workloads. • Architect scalable data models and data warehouses, optimizing for query performance, maintainability, cost efficiency, and downstream AI consumption. • Develop and operate robust orchestration pipelines using Airflow/Astronomer or Schedule Query, with secure, reproducible CI/CD workflows (Terraform + Git) for both data and AI artifacts. • Integrate LLM APIs and AI services (e.g., Vertex AI, OpenAI, LangChain) into data workflows to automate data enrichment, classification, anomaly narratives, and natural-language interfaces. • Build and maintain reliable data and model quality checks, lineage, and monitoring with observability tools (e.g., Splunk, Looker/Grafana/Tableau/Power BI dashboards) to rapidly detect and resolve data and AI pipeline issues. • Implement data governance, security, and compliance controls (data lineage, access controls, PII/PHI protection, prompt injection safeguards, responsible AI guardrails) in collaboration with security and privacy teams. • Lead the design and delivery of analytics-ready and AI-ready data assets for cross-functional teams, including dashboards, alerts, self-service analytics, and AI-powered insight tools. • Evaluate, prototype, and productionize emerging Gen AI capabilities (agents, function calling, fine-tuning, multimodal models) to solve business problems and improve platform intelligence. • Mentor and coach junior engineers on data engineering, AI/ML integration patterns, prompt engineering best practices, and documentation standards. • Collaborate with data scientists, ML engineers, product managers, and business stakeholders to translate requirements into scalable data and AI solutions and timely insights. • Monitor cost and capacity planning for cloud and AI resources; optimize storage, compute, and token usage across GCP services (BigQuery, Dataflow, Dataproc, GCS, Vertex AI). • Participate in on-call rotations and incident response to maintain high availability of data and AI services.
Job Requirements
- A bachelor's degree
- 5+ years of experience in data engineering, data platforms, or a similar role.
- 3+ years of hands-on experience with Google Cloud Platform (BigQuery, Cloud Storage, Dataflow, Dataproc; Schedule Query or equivalent scheduling/orchestration) or AWS.
- 1+ years of experience working with Generative AI technologies — including LLMs, embeddings, vector databases, RAG architectures, or AI orchestration frameworks (e.g., LangChain, Semantic Kernel, LlamaIndex).
- 1+ year experience building Semantic Data layer to serve AI agents.
- Practical experience building and operating data pipelines with orchestration tools (Airflow/Astronomer; Schedule Query).
- Experience with infrastructure-as-code and CI/CD (Terraform, Git, and related tooling).
- Demonstrated ability to design and implement analytics-ready data assets and dashboards; familiarity with BI tools (Looker, Tableau, Power BI, Grafana) for monitoring and reporting.
- Strong communication skills and ability to work effectively with cross-functional teams (engineering, analytics, product, security).
Benefits
- Immediate medical, dental, vision and prescription drug coverage
- Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up child care and more
- Family building benefits including adoption and surrogacy expense reimbursement, fertility treatments, and more
- Vehicle discount program for employees and family members and management leases
- Tuition assistance
- Established and active employee resource groups
- Paid time off for individual and team community service
- A generous schedule of paid holidays, including the week between Christmas and New Year’s Day
- Paid time off and the option to purchase additional vacation time
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Data Engineer
Pabst Brewing CompanyPabst Brewing Company is an American brewing company founded in Milwaukee, Wisconsin by Jacob Best in 1844. Today, Pabst Brewing Company is located in San Antonio, Texas and is rec
Role Description We’re looking for a Data Engineer to join our Data Systems team and help build the modern data foundation behind our business. This role is all about turning complex data into scalable, reliable solutions that power reporting, analytics, integrations, and AI-driven insights across the company. You’ll design and support cloud-native data platforms using Microsoft’s modern data ecosystem, while helping modernize legacy systems and shape the future of our data environment. We’re looking for someone who enjoys solving problems, building scalable systems, and partnering across teams to turn ideas into action. Qualifications - 3-5+ years of overall IT experience, including 3+ years focused on data engineering - Strong experience with Microsoft SQL Server, T-SQL, stored procedures, views, and SSIS - Hands-on experience with Microsoft Azure and Microsoft Fabric - Experience with Azure Data Factory, Azure Data Lake Storage Gen2, Azure SQL, and Logic Apps - Familiarity with Medallion Architecture (Bronze/Silver/Gold) data modeling approaches - Experience with Power BI reporting and dashboard development preferred - Exposure to data science workflows, machine learning, or AI deployments is a plus - Strong analytical and problem-solving skills - Ability to communicate technical concepts clearly to both technical and non-technical audiences - A collaborative mindset with the ability to work independently and cross-functionally Requirements - Design, develop, and optimize database objects including tables, views, and stored procedures within Microsoft Fabric - Build and maintain scalable ETL/ELT pipelines using Microsoft Fabric Pipelines, Azure Data Factory, SSIS, and Azure Data Lake Storage Gen2 - Modernize and migrate legacy SSIS solutions into cloud-native Azure and Fabric environments - Partner with engineers, analysts, and business teams to develop scalable data warehouse and lakehouse solutions - Integrate data from internal and third-party systems using APIs, FTP/SFTP, and cloud ingestion patterns - Monitor and support production data pipelines to ensure reliability, performance, and data quality - Contribute to data architecture best practices around governance, security, scalability, and optimization - Help support a modern analytics environment that enables enterprise reporting, advanced analytics, and AI-driven insights Benefits - Flexibility: Work that fits your life – with a remote schedule, unlimited vacation, 9 sick days, 10 company holidays, and 2 paid volunteer days. - Great Benefits: Comprehensive healthcare plans, a 401(k) with company match and immediate vesting, paid parental leave, disability coverage, life insurance, and more. - Great People: A casual, high-energy environment where authenticity is celebrated, curiosity is welcomed, and creativity is supported.
Role Description The GIS Project and Data Engineer serves as the tactical anchor for the project lifecycle, ensuring seamless communication between field operations and GIS systems. This role combines hands-on technical management of As-Built drawings and CAD files with the organizational discipline required to track deliverables and maintain company standards. The ideal candidate is a detail-oriented professional capable of navigating the bridge between engineering design and geospatial data integrity. Qualifications - Associate’s or bachelor’s degree in GIS, Geography, Project Management, or a related technical field required. - 1–3 years of experience in a GIS, engineering, or technical project support role required. - Minimum 2+ years of AutoCAD experience (Civil 3D focus) and functional proficiency in ArcGIS Pro data editing required. - Knowledge of outside plant (OSP) telecommunications engineering and construction processes preferred. - Strong technical writing skills and the ability to convey complex geospatial concepts to diverse audiences preferred. - Capable of working autonomously in a remote environment while maintaining a preferred, collaborative, customer-focused attitude. - Familiarity with office and field observer safety requirements. - Hands-on experience with ESRI geodatabases, spatial data editing, and mapping workflows. - Familiarity with telecom-specific inventory tools, industry standards, and databases. - Proficiency in AutoCAD app development and workflow automation. - Exposure to project management platforms such as Smartsheet, MS Project, or Asana. Requirements - AUDIT AutoCAD files for technical compliance and execute the precise translation of data between CAD and ESRI environments. - Apply a strong understanding of projections and coordinate systems to ensure all data aligns with Arcadian internal geodatabases. - Act as the primary intake for field vendor data, reviewing submissions for spatial integrity and attribute completeness before importing records. - Coordinate and package complex GIS deliverables for external stakeholders including Caltrans, CDT, and Hyperscalers. - Act as the point of contact for routine project status, ensuring engineering teams, inspectors, and contractors are aligned on milestones. - Facilitate internal and external project calls by documenting action items and distributing project summaries. - Make sound, timely decisions regarding data workflows and involve appropriate stakeholders to maintain high standards of quality. - Develop and maintain technical documentation, standard process guides, and reference materials for evolving GIS and CAD workflows. - Perform routine attribute edits and quality checks to proactively flag and resolve data inconsistencies. - Ensure all engineering and design activities adhere to company policies, contract requirements, and safety standards.
Logistics Management & Data Specialist
PavagoPavago specializes in connecting businesses with top-tier offshore talent in operations, sales, and marketing, offering a comprehensive recruitment solution designed to reduce cost
Role Description We’re hiring a Logistics Management & Data Specialist to manage and optimize the operational backbone of a fast-growing e-commerce business. This is a highly analytical, systems-focused role that combines logistics coordination, inventory planning, operational reporting, and AI-driven process improvement. You’ll be responsible for managing freight operations, purchase order workflows, inventory data, operational reporting, and internal systems while helping the company build smarter, more automated workflows using AI tools. This role is ideal for someone who enjoys solving operational problems, working with data, improving systems, and creating structure inside a fast-moving e-commerce environment. What You’ll Be Doing - Logistics & Ecommerce Operations - Manage freight and logistics operations end-to-end, including shipment tracking, delivery coordination, warehouse communication, and purchase order uploads. - Coordinate with warehouse teams to ensure inventory accuracy and smooth fulfillment operations. - Create and manage monthly purchase orders based on sell-through rates, inventory forecasting, and revenue projections. - Monitor inventory movement and identify potential stock risks before they impact operations. - Maintain accurate product information and variants within Shopify. - Support operational planning by ensuring clean and reliable logistics data across systems. - Data Analysis & Reporting - Build and maintain operational spreadsheets and reporting systems. - Analyze large datasets related to inventory, returns, customer service trends, and product quality. - Generate actionable business reports that support operational and inventory decisions. - Create dashboards and reports that improve visibility across logistics and operational performance. - Use data insights to identify inefficiencies and recommend improvements. - AI & Systems Development - Build centralized reporting systems using Claude or similar AI tools. - Connect operational data across Shopify, Meta Ads, Google Ads, Klaviyo, and internal reporting systems. - Develop AI-supported workflows and automations to improve operational efficiency. - Explore and test emerging AI tools that can improve logistics, reporting, customer service, and internal operations. - Identify repetitive workflows and create scalable systems to reduce manual work. - Process Improvement & Operational Efficiency - Improve operational workflows and create scalable systems that support business growth. - Organize and maintain structured documentation, trackers, and operational processes. - Continuously identify opportunities to improve reporting accuracy, operational visibility, and execution speed. - Collaborate cross-functionally with operations, warehouse, customer support, and leadership teams. Qualifications - You are highly analytical and naturally organized. - You enjoy building systems, improving workflows, and solving operational problems. - You are comfortable working with large datasets and operational reporting. - You think proactively and identify problems before they escalate. - You are comfortable operating independently in a remote environment. - You are detail-oriented and highly reliable with operational execution. Requirements - Proven experience in logistics, supply chain, ecommerce operations, or inventory management. - Hands-on experience with Shopify and understanding of product data structures. - Strong experience managing freight, purchase orders, shipment tracking, and warehouse coordination. - Advanced spreadsheet skills with the ability to create professional, scalable operational trackers and reports. - Strong quantitative and analytical skills with experience working with large datasets. - Experience using Claude, ChatGPT, or similar AI tools within operational workflows. - Ability to build structured systems and improve operational processes. - Strong English communication skills (written and verbal). - Ability to work independently and manage priorities in a remote environment. Nice-to-Have Experience - Experience connecting data across Shopify, Meta Ads, Google Ads, and Klaviyo. - Familiarity with APIs, automations, or AI integrations. - Experience building dashboards or centralized reporting systems. - Previous experience in ecommerce or consumer product businesses. - Experience with inventory forecasting and margin analysis. Key Metrics for Success (KPIs) - Accuracy of inventory tracking and operational reporting. - Timeliness of shipment coordination and purchase order management. - Reduction in operational errors and logistics bottlenecks. - Quality and usability of operational dashboards and reports. - Successful implementation of AI-supported operational improvements. - Reliability and cleanliness of operational data across systems. Interview Process - Initial Screening Call - Recruiter Interview - Final Interview - Offer & Onboarding
Data Engineer, Azure
Bluelight ConsultingBluelight is a leading software consultancy dedicated to designing and developing innovative technology that enhances users' lives. With a steadfast commitment to delivering exceptional service to our clients, Bluelight excels in its focus on quality and customer satisfaction. Our mission is not only to create cutting-edge applications but also to foster a collaborative and enriching work environment where each team member can grow and thrive. With a presence across the United States and Central/South America, Bluelight is in an exciting phase of expansion, continually seeking exceptional talent to join its dynamic and diverse community.
Role Description We are looking for a skilled individual to join our rapidly growing team at Bluelight. This position is ideal for someone who thrives in a fast-paced, dynamic environment where everyone's opinions and efforts are valued and appreciated. You will have the opportunity to contribute to challenging and meaningful projects, developing high-quality applications that stand out in the market. We value continuous learning, personal growth, and hard work, offering a collaborative environment that promotes professional development. If you are passionate about software development and eager to be part of a growing software consultancy, we invite you to apply and join us on this exciting journey. - ETL Data Engineering: Develop and maintain ETL data engineering processes using Python (PySpark) within Azure Synapse Analytics Notebooks, and/or Azure Synapse Analytics Pipelines. - Data Warehousing: Design and build effective data storage structures in a Massively Parallel Processing (MPP) SWL Pool. - Data Source Expertise: Extract data from various sources, including REST APIs, SWL database tables, and CSV files. - Azure Synapse Analytics Expertise: Design and optimize data notebooks/pipelines for scalability and performance. - Data Fabric Concepts: Contribute to the implementation of Data Fabric concepts, such as data lakes, lakehouses, delta lakes, and data cataloging. - Data Modeling: Collaborate with data architects to create data models and schemas that align with business requirements. - Data Quality: Implement data quality checks and validation processes to maintain data accuracy and consistency. - Performance Tuning: Identify and resolve performance bottlenecks and optimize ETL data notebooks/pipelines to meet SLAs. - Monitoring and Troubleshooting: Monitor ETL jobs, diagnose issues, and implement solutions to ensure data pipeline reliability. - Documentation: Maintain comprehensive documentation of ETL data engineering processes, data flows, and data transformations. - Collaboration: Work closely with cross-functional teams to understand data requirements and provide support for data-related initiatives. - Security and Compliance: Ensure data security and compliance with data governance and privacy standards. Qualifications - Bachelor’s degree in Computer Science, Information Technology, or a related field; or equivalent work experience. - Certifications related to data engineering or data science (e.g. Azure Data Engineer) being a plus. - Proven experience in ETL data engineering with significant expertise in using Python (PySpark). - Proficiency in using Azure Synapse Analytics resources including Notebooks, Pipelines, Linked Services, and Azure Key Vault. - Demonstrated ability to write complex SQL queries and optimize query performance. - Knowledge of data integration best practices and tools. - Experience with version control systems, such as Git (Azure DevOps). - Strong problem-solving and analytical skills, with attention to detail. - Excellent communication skills, both verbal and written. - Familiarity with big data technologies, machine learning, and data analysis preferred. - Experience with data visualization tools (e.g. Power BI, Tableau) and Agile Methodologies a plus. Benefits - Competitive salary and bonuses, including performance-based salary increases. - Generous paid-time-off policy. - Flexible working hours. - Work remotely. - Continuing education, training, conferences. - Company-sponsored coursework, exams, and certifications.
