Programmer Analyst Principal

Programmer Analyst Prin

Location: Remote, United States

Contract - 1st Shift, 9/80B

Hours: 8am - 5pm EST

Pay Rate: $72.49/Hr.

Benefits: medical, dental, vision, 401k

REQUIREMENTS: Programmer Analyst Prin

• 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 Information Technology
• Proficiency in one or more programming languages (e.g., Python, Java, Scala)
• Strong understanding of database design principles, data modeling, and data governance o 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), NoSQL databases, or cloud-based data warehouses (Redshift)
• Experience with data processing frameworks such as Apache Kafka, Fivetran o Experience in building ETL pipelines using AWS Glue, Apache Airflow, and programming languages including Python and PySpark
• Understanding of data quality and governance principles and best practices
• Experience with agile development methodologies such as Scrum or Kanban,

JOB DESCRIPTION: Programmer Analyst Prin

• Design and implement data pipelines to ingest, extract, transform, 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, data cleansing, and data governance policies o 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 data pipeline failures, data quality issues, and performance bottlenecks
• Develop technical documentation and knowledge base articles to help customers and AWS engineers troubleshoot common issues

PREFERRED EDUCATION & SKILLS: Programmer Analyst Prin

• Bachelor's or master's degree in computer science or a related field, with at least 8 years of experience in Information Technology
• Experience with Dataiku o Experience with building reports using PowerBI and Tableau
• Experience with Alteryx
• Relevant cloud certifications (e.g., AWS Certified Data Analytics - Specialty)
• Experience with AWS services and best practices

75458

EEO Statement Apollo Professional Solutions, Inc. is an equal opportunity employer. We provide equal employment opportunities to all employees and applicants for employment and prohibits 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.