Job DescriptionThis High Level Data Engineer role focuses on designing, building, and supporting scalable, secure data solutions for enterprise Wealth and Asset Management applications. You will maintain and enhance existing ETL processes, migrate data pipelines into a new environment, and develop new ETL and data transformation workflows. The position centers on data ingestion, transformation, storage, integration, quality, governance, and processing across structured, semi-structured, and unstructured data sources, supporting analytics, search, and AI-enabled use cases.Responsibilities
- Design and develop scalable data ingestion and ETL/ELT pipelines to support enterprise Wealth and Asset Management applications.
- Maintain existing ETL processes and migrate them into a new environment, ensuring stability, accuracy, and performance.
- Build solutions that handle structured, semi-structured, and unstructured data from multiple sources.
- Develop reusable data-processing and transformation components using Python and SQL to standardize and streamline data workflows.
- Design, implement, and support data models using PostgreSQL, Amazon RDS, DynamoDB, and Amazon S3.
- Support document ingestion and extraction using relevant tools and frameworks where applicable.
- Prepare, cleanse, and transform data for application consumption, search capabilities, analytics, and AI-enabled use cases.
- Support vector-based retrieval workflows using PostgreSQL and pgvector where required.
- Implement data quality, validation, reconciliation, metadata management, lineage tracking, retention policies, and governance controls.
- Implement secure data access mechanisms and encryption to protect sensitive information and comply with security standards.
- Optimize data pipelines and databases for performance, reliability, scalability, and cost efficiency.
- Implement monitoring solutions for data pipelines and integrations, and proactively troubleshoot issues to maintain reliable operations.
- Collaborate closely with application development, AI, DevOps, architecture, cybersecurity, and business teams to align data solutions with organizational needs.
Essential Skills
- 8+ years of experience in data engineering, data integration, or closely related roles.
- Strong hands-on experience with Python for building data-processing and transformation solutions.
- Strong hands-on experience with SQL for querying, transformation, and data modeling.
- Proven experience with PostgreSQL, including designing and supporting relational data models.
- Strong experience working with Amazon RDS for managed relational databases.
- Hands-on experience with DynamoDB for NoSQL data storage and retrieval.
- Experience working with Amazon S3 for data storage, staging, and archival.
- Demonstrated experience developing and supporting ETL/ELT pipelines and end-to-end data-processing workflows.
- Experience with data modeling techniques for structured, semi-structured, and unstructured data.
- Experience working with APIs and JSON for data integration and exchange.
- Experience with pgvector or similar vector-based retrieval solutions.
- Strong understanding of data quality practices, including validation, reconciliation, and standardized controls.
- Strong understanding of metadata management, data lineage, retention, and governance frameworks.
- Strong understanding of data security concepts, including secure access, encryption, and protection of sensitive data.
- Experience implementing operational monitoring for data pipelines and integrations.
- Experience working within large enterprise or regulated environments.
- Experience supporting document-processing and AI-enabled data solutions.
Additional Skills and Qualifications
- Experience collaborating across AI, software engineering, testing, architecture, and security teams.
- Experience in Wealth and Asset Management or similar financial services environments.
- Exposure to search and analytics platforms that leverage transformed and curated data.
- Familiarity with best practices for building reusable data components and frameworks.
- Experience contributing to cross-functional projects that involve application, AI, DevOps, architecture, cybersecurity, and business stakeholders.
Work EnvironmentThis is an on-site role based in Farmington Hills, Michigan, within a United States enterprise environment. You will work in a professional office setting that supports close collaboration with application, AI, DevOps, architecture, cybersecurity, and business teams. The technology stack centers on Python, SQL, PostgreSQL, Amazon RDS, DynamoDB, Amazon S3, APIs, JSON, and pgvector, with a strong emphasis on secure, governed data solutions. You can expect a structured environment typical of large, regulated organizations, with established processes for data quality, security, and operational monitoring. Job Type & LocationThis is a Contract position based out of Farmington Hills, MI. Pay and BenefitsThe pay range for this position is $75.00 - $82.00/hr. Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits
available for this temporary role may include the following:
Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave) Job Type & LocationThis is a Contract position based out of Farmington Hills, MI. Application DeadlineThis position is anticipated to close on Nov 13, 2026. Workplace TypeThis is a fully onsite position in Farmington Hills,MI.
About TEKsystems
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
About TEKsystems and TEKsystems Global Services
Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.
Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.
