About the role
The client is a global business advisory and technology consulting firm specializing in digital transformation and technology solutions across industries such as insurance, banking & financial services, healthcare, and life sciences. It helps organizations modernize operations through strategic consulting, digital engineering, cloud solutions, data & AI capabilities, automation, and enterprise platform implementations. The company partners with clients to improve customer experiences, optimize processes, reduce operational complexity, and deliver scalable technology solutions.
Rate Range: $30-$35/Hr
Job Description:
Mandatory Skills
- Experience writing, analyzing, and optimizing SQL for large-scale enterprise databases.
- Experience with Amazon Redshift and/or Amazon RDS PostgreSQL.
- Strong expertise in PostgreSQL query performance tuning, execution plan analysis, indexing strategies, statistics, partitioning, and database optimization.
- Experience writing PL/pgSQL stored procedures, functions, and database scripts.
- Experience with Database Administration activities in PostgreSQL and/or Redshift.
- Strong understanding of Data Warehouse architecture and Star/Snowflake schema design.
- Experience with Git, DevOps practices, and Agile delivery methodologies.
- Excellent troubleshooting, analytical, and documentation skills.
- Experience with BI tools such as Power BI and/or Web Intelligence (WebI).
- Hands-on experience with AWS technologies including S3, Lambda, EMR, EC2, Kubernetes, Kinesis, etc.
- Linux development experience.
- Experience building and supporting ETL/ELT pipelines.
- Python programming experience.
- Exposure to Big Data technologies such as Spark, Hadoop, Kafka, etc.
- Bachelor's degree in Computer Science, Information Technology, Mathematics, Statistics, or a related technical discipline (or equivalent practical experience).
About ApTask:
ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-owned company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer:
At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at [email protected].
Applicant Consent:
By submitting your application, you agree to ApTask's (www.aptask.com) Terms of Use and Privacy Policy, and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-355-8000 or [email protected]. Message frequency may vary. Msg & data rates may apply.