Programmer Analyst Principal (Hybrid)

For our client, we are seeking an experienced Programmer Analyst Principal to design, develop, and maintain large-scale data systems in a cloud-based environment. The successful candidate will have strong expertise in data engineering, ETL development, and Amazon Redshift, as well as experience collaborating with technical and business teams to deliver reliable data solutions. Design and implement data pipelines to ingest, extract, transform, and load (ETL) large datasets from multiple sources Build and maintain data warehouses, including data modeling, governance, and quality control Ensure data integrity, accuracy, and security through validation and cleansing processes Optimize data systems for scalability, performance, and reliability Collaborate with customers to understand technical requirements and provide best practice guidance on Amazon Redshift usage Partner with cross-functional teams, including analysts, data scientists, and business stakeholders, to define and deliver data solutions Provide technical support for Amazon Redshift, including troubleshooting and performance tuning Identify and resolve data-related issues, such as pipeline failures and quality concerns Develop technical documentation and knowledge articles to support internal teams and clients Skills Required Bachelor’s or Master’s degree in Computer Science or a related field, with at least 6 years of experience in Information Technology 8+ years of experience in data engineering and large-scale data system design 5+ years of hands-on experience writing optimized SQL queries for Oracle, SQL Server, and Redshift 5+ years of experience using AWS Glue and Python / PySpark to build production ETL pipelines Proficiency in one or more programming languages (Python, Java, Scala) Strong understanding of database design, data modeling, and governance principles Expertise in SQL query optimization, indexing, and performance tuning Familiarity with data warehousing concepts (star and snowflake schemas) Strong analytical and problem-solving skills Experience with data frameworks such as Apache Kafka and Fivetran Hands-on experience building ETL pipelines using AWS Glue, Apache Airflow, Python, and PySpark Experience with agile development methodologies (Scrum or Kanban) Skills Preferred Experience with Dataiku, Power BI, Tableau, or Alteryx Relevant AWS certifications (e.g., AWS Certified Data Analytics – Specialty) Experience implementing AWS best practices for data management Experience Required 8+ years of data engineering experience focused on large-scale system design 5+ years of experience with Oracle, SQL Server, and Redshift query optimization 5+ years of experience using AWS Glue and Python / PySpark for ETL pipeline development Benefits : Health Insurance 401k Pay Range : $70.00 - $75.00 per hour (Depending on experience and qualifications) By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from HEPCO, Inc and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at https : / / www.hepcoinc.com / privacy / All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, marital status, national origin, age, veteran status, disability, or any other protected class.