Job Description: Title: Senior/ Principal Data Engineer Location: Farmington Hills, Michigan (On-site) Duration: 2+ Month to start with Role Overview The selected candidate will utilize extensive expertise in designing, developing, and maintaining scalable data pipelines and enterprise data solutions. This position requires strong proficiency in Python, SQL, and cloud technologies alongside modern artificial intelligence architecture to integrate complex data systems. Responsibilities include translating architectural designs into efficient data engineering solutions that support advanced reporting and analytical workflows. 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 cloud-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 for advanced applications. - Write and optimize complex SQL queries, data transformation logic, and data models to support efficient data storage and processing. - Implement data quality checks, validation rules, reconciliation processes, and automated monitoring to ensure data accuracy and reliability. - Develop and maintain analytical datasets, business intelligence dashboards, and key metrics to support operational reporting. - Collaborate with cross-functional teams to design scalable data architectures, automate workflows, and integrate data engineering solutions with enterprise systems. - Apply software engineering standards including version control, code optimization, documentation, and workflow orchestration using Git and Apache Airflow. Required Qualifications Education: Bachelor's or Master's degree in Computer Science Engineering, Information Technology, Business Analytics, or a related technical field. Experience: Five or more years of experience in designing, developing, and maintaining scalable data pipelines, with at least three years of professional experience in data engineering, software development, or related technical roles. Technical Skills: Strong proficiency in Python, SQL, and ETL/ELT pipeline development; experience with AWS services, particularly EC2 and S3; hands-on experience with relational databases and cloud data warehouses such as SQL Server, MySQL, PostgreSQL, and Snowflake; understanding of data modeling, data quality, and pipeline orchestration; familiarity with Generative AI technologies, including AWS Bedrock, LangChain, Retrieval-Augmented Generation, Model Context Protocol, and Agent-to-Agent communication protocols. Preferred Qualifications - Experience with Apache Spark, PySpark, Databricks, or Apache Airflow. - Familiarity with Amazon Textract, PostgreSQL pgvector, vector databases, and semantic search. - Experience with Power BI, DAX, Power Platform, and enterprise reporting systems. - Knowledge of Terraform, Git, REST APIs, and continuous integration/continuous deployment practices. - Exposure to building AI-powered data pipelines, LLM integrations, or intelligent document processing solutions. - Cloud platform certifications. Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certificatio