Sr. Data Engineer

We are seeking a highly skilled Data Engineer with strong backend engineering expertise and solid finance/analytics domain knowledge. This role is focused on building, optimizing, and maintaining scalable data pipelines, improving data architecture, enhancing operational reliability, and driving data quality initiatives. The ideal candidate will have extensive experience with Python, PostgreSQL, AWS services, and modern data engineering practices, along with exposure to AI/RAG-based solutions. • Contract Duration: 6+ Months • Rate Range: $50-60/hr on W2 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. Required Qualifications: • 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. Required Skills • Python • PostgreSQL • SQL • AWS (EKS, Lambda) • FastAPI • ETL/ELT Development • Data Testing & Validation • Performance Optimization • Parquet • Data Architecture • Backend Engineering Technical Skills • Python Development • PostgreSQL Administration & Optimization • SQL Query Performance Tuning • AWS Cloud Services • FastAPI • Data Pipeline Development • Data Quality & Validation • Parquet Data Processing • API Development • Data Architecture & Reliability Engineering Preferred Qualifications • 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. If you meet the required qualifications and are interested in this role, please apply today. The Solomon Page Distinction Solomon Page offers a comprehensive benefit program for hourly employees. We pride ourselves on offering medical, dental, 401(k), direct deposit and commuter benefits to our employees, including freelancers - which sets us apart in the industries we serve. About Solomon Page Founded in 1990, Solomon Page is a specialty niche provider of staffing and executive search solutions across a wide array of functions and industries. The success of Solomon Page reflects an organic growth strategy supported by a highly entrepreneurial culture. Acting as a strategic partner to our clients and candidates, we focus on providing customized solutions and building long-term relationships based on trust, respect, and the consistent delivery of excellent results. For more information and additional opportunities, visit: solomonpage.com and connect with us on Facebook, and LinkedIn. Opportunity Awaits.