Programmer Analyst Prin

Job Title

Programmer Analyst Principal

Remote

Contract

1st Shift, 9/80B

Hours:

8:00 AM–5:00 PM EST

Pay Rate: $72.49/Hr.

Benefits: medical, dental, vision, 401k

• US Citizenship or Green Card
• 8 years of experience in data engineering, with a focus on designing and implementing large‑scale data systems
• 5 years of hands‑on experience in writing complex, highly optimized queries across large data sets using Oracle, SQL Server, and Redshift
• 5 years of hands‑on experience using AWS Glue, Python/PySpark to build ETL pipelines in a production setting, including writing test cases
• Bachelor’s or master’s degree in computer science or a related field, with at least 6 years of experience in IT
• Proficiency in one or more programming languages (Python, Java, Scala)
• Strong understanding of database design principles, data modeling, and data governance; proficiency in SQL, including query optimization, indexing, and performance tuning
• Experience with data warehousing concepts, including star and snowflake schemas
• Strong analytical and problem‑solving skills, with the ability to break down complex problems into manageable components
• Experience with data storage solutions such as relational databases (Oracle, SQL Server), No
  
  SQL databases, or cloud‑based data warehouses (Redshift)
• Experience with data processing frameworks such as Apache Kafka, Fivetran, or building ETL pipelines using AWS Glue, Apache Airflow, and programming languages including Python and Py Spark
• Understanding of data quality and governance principles and best practices
• Experience with agile development methodologies such as Scrum or Kanban

• Design and implement data pipelines to ingest, extract, transform, and load (ETL) data and store large datasets from various sources
• Build and maintain data warehouses, including data modeling, data governance, and data quality
• Ensure data quality, integrity, and security by implementing data validation, cleansing, and governance policies; optimize data systems for performance, scalability, and reliability
• Collaborate with customers to understand their technical requirements and provide guidance on best practices for using Amazon Redshift
• Work with cross‑functional teams, including data scientists, analysts, and business stakeholders, to understand data requirements and deliver data solutions
• Provide technical support for Amazon Redshift, including troubleshooting, performance optimization, and data modeling
• Identify and resolve data‑related issues, including pipeline failures, data quality issues, and performance bottlenecks
• Develop technical documentation and knowledge‑base articles to help customers and AWS engineers troubleshoot common issues

• Bachelor’s or master’s degree in computer science or a related field, with at least 8 years of experience in IT
• Experience with Dataiku, building reports with Power
  
  BI and Tableau
• Experience with Alteryx
• Relevant cloud certifications (e.g., AWS Certified Data Analytics – Specialty)
• Experience with AWS services and best practices

Apollo Professional Solutions, Inc. is an equal opportunity employer. We provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, marital status, age, national origin, ancestry, disability status, medical condition, pregnancy, genetic information, protected veteran status, gender, sexual orientation, gender identity or expression, or any other status or characteristic protected under federal, state, or local law.