Note: The job is a remote job and is open to candidates in USA. Solomon Page is a specialty niche provider of staffing and executive search solutions. They are seeking a highly skilled Data Engineer focused on building, optimizing, and maintaining scalable data pipelines while enhancing data architecture and driving data quality initiatives.
Responsibilities
- Design, develop, optimize, and maintain scalable data pipelines and ETL/ELT workflows
- Refactor and enhance existing data processing frameworks to improve performance and reliability
- Perform extensive data validation, testing, and quality assurance across data platforms
- Optimize SQL queries, database structures, and table performance within PostgreSQL environments
- Implement and support backend services and APIs using Python and FastAPI
- Develop and maintain data solutions leveraging AWS services including EKS and Lambda
- Work with Parquet files and large-scale datasets to support analytics and reporting requirements
- Improve overall data architecture, operational stability, and system performance
- Maintain detailed task tracking, status reporting, and execution transparency through Excel-based project tracking
- Proactively identify risks, communicate project status, and manage timelines effectively
- Collaborate with business, analytics, and engineering teams to support data-driven initiatives
- Contribute to AI and Retrieval-Augmented Generation (RAG) use cases and data integrations
Skills
- 6+ years of experience in Data Engineering, Backend Engineering, or related roles
- Strong hands-on experience with Python development
- Extensive experience with PostgreSQL and advanced SQL optimization
- Experience building and maintaining ETL/ELT pipelines and data integration workflows
- Strong knowledge of data engineering concepts, data modeling, and data architecture
- Experience working with Parquet file formats and large-scale datasets
- Hands-on experience with AWS services including EKS, Lambda, and cloud-native architectures
- Experience developing APIs and microservices using FastAPI or similar frameworks
- Strong data testing, validation, troubleshooting, and performance tuning skills
- Excellent organizational skills with the ability to manage timelines, priorities, and status reporting
- Strong communication skills and ability to work independently in a remote environment
- Must be located within the EST time zone
- Experience within financial services, investment management, analytics, or related domains
- Experience with AI solutions and Retrieval-Augmented Generation (RAG) frameworks
- Familiarity with machine learning data pipelines and AI-powered applications
- Experience working in highly data-intensive environments
- Strong understanding of operational monitoring and reliability practices
Benefits
- Medical
- Dental
- 401(k)
- Direct deposit
- Commuter benefits
Company Overview
Founded in 1990, Solomon Page is a leading staffing and executive search firm headquartered in New York City with offices across the United States. It was founded in 1990, and is headquartered in New York, New York, USA, with a workforce of 1001-5000 employees. Its website is https://solomonpage.com.