Skip to main content
Insight Global logo

Data Architect / Principal Data Engineer II - Job ID: 2512

Insight Global

Farmington Hills, MI · HybridContractSeen todayIn the employer's feed · checked in the last 2 days

See where you stand before you apply. No sign-up to start.

You apply on the posting's application page, with no Olive account needed.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
No compensation found
Location
Farmington Hills, MIHybrid
Schedule
Contract
Work Authorization
Not specified

Olive focuses on jobs in the United States, including remote roles you can work from there.

Job overview

A large financial organization is seeking a Data Engineer for an onsite contract role in Farmington Hills, Michigan. The role focuses on building scalable data pipelines and integrating enterprise data sources, including AI-powered workflows. The ideal candidate has strong proficiency in Python, SQL, ETL/ELT development, cloud technologies, and data integration, along with an understanding of modern AI technologies and data engineering architecture.

Skills & qualifications

RequiredNice to have

Skills

Python, requiredSQL, requiredETL/ELT Development, requiredAWS, requiredEC2, requiredS3, requiredAWS Bedrock, requiredAmazon Textract, requiredSQL Server, requiredMySQL, requiredPostgreSQL, requiredSnowflake, requiredAI-Powered Data Pipelines, requiredLLM Integrations, requiredIntelligent Document Processing, requiredGenerative AI, requiredLangChain, requiredRetrieval-Augmented Generation, requiredModel Context Protocol, requiredAgent-to-Agent Protocol, requiredApache Spark, requiredPySpark, requiredDatabricks, requiredApache Airflow, requiredPgvector, requiredVector Databases, requiredSemantic Search, requiredPower BI, requiredDAX, requiredPower Platform, requiredTerraform, requiredGit, requiredREST APIs, requiredCI/CD, required

Qualifications

3+ Years Data Engineering Experience, required

Full job description

Job Description

A large financial organization is seeking a Data Engineer that will sit onsite 4 days a week in Farmington Hills Michigan for a contract role. The ideal candidate should have strong proficiency in Python, SQL, ETL/ELT development, cloud technologies, and data integration, along with an understanding of modern AI technologies and data engineering architecture.

Key Responsibilities

Design, develop and maintain scalable ETL/ELT pipelines using Python, SQL, Pandas and Pyspark to extract, transform and integrate structured and unstructured data.

Build and manage AWS-based data pipelines using EC2 and S3, integrating data from SQL Server, Snowflake, FileNet and other enterprise data sources.

Develop data extraction and processing workflows using Amazon Textract, PostgreSQL, pgvector, vector embeddings, and Retrieval-Augmented Generation (RAG) for AI-powered applications.

Write and optimize complex SQL queries, data transformation logic, and data models to support efficient data processing, storage and analytics.

Implement data quality checks, validation rules, reconciliation processes, and automated monitoring to ensure data accuracy, reliability, and consistency.

Develop and maintain analytical datasets, Power BI dashboards, KPIs and KRIs to support business intelligence and operational reporting.

Collaborate with cross-functional teams to design scalable data architectures, automate workflows, and integrate data engineering solutions with enterprise applications.

Skills and Requirements

3+ years of professional experience in Data Engineering. Strong proficiency in Python, SQL and ETL/ELT pipeline development. Experience working with AWS services, particularly EC2 and S3, Bedrock and textract. Hands-on experience with relational databases and cloud data warehouses such as SQL Server, MySQL and PostgreSQL and Snowflake. Experience building AI-powered data pipelines, LLM integrations, or intelligent document processing solutions. Familiarity with Generative AI technologies, including AWS Bedrock, Lang Chain, Retrieval- Augmented Generation (RAG), Model Context Protocol (MCP), and Agent-to-Agent (A2A) communication protocol. Experience with Apache Spark, PySpark, Databricks, or Apache Airflow Familiarity with PostgreSQL pgvector, vector databases, and semantic search. Experience with Power BI, DAX, Power Platform and enterprise reporting solutions. Knowledge of Terraform, Git, REST APIs, and CI/CD practices.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].

How this job compares

Set against the 6,259 open Data Engineer jobs on Olive Jobs, counted November 21, 2026.

Pay
  • This postingNot listed
  • Michigan median$107–191K/yr90 salary ranges
  • US median$60–70/hr191 hourly ranges
Openings
Olive Jobs lists 118 open Data Engineer jobs in Michigan and 6,259 across the US. 9% of them nationwide are listed as remote or flexible.
Hiring the most in Michigan
Experience
This posting asks for at least 3 years of experience; Data Engineer postings that state a minimum ask for 5 years at the median (5,513 postings).
Education
2,366 of the 6,259 open Data Engineer jobs (38%) ask for a bachelor's degree or higher.

Counted across the open, public US postings on Olive Jobs on November 21, 2026. Figures based on too few postings are left out.

Prepare for this role

You've read the whole posting — now see how you match it.