Certified Cloud Engineer

Job Description

Candidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI).

AWS Engineer

The Universities of Wisconsin Enterprise Analytics Platform (EAP) team supports the development and support of the data lake for the UW System Office and member universities. We are seeking an experienced AWS Redshift Data Engineer to assist our team in designing developing and optimizing data pipelines for our AWS Redshiftbased data lake house. Priority needs are cloud formation and eventbased data processing utilizing SQS to support ingestion and movement of data from Workday to AWS Redshift for consumer and analytic use.

Key Responsibilities:

• Collaborate with data engineering business analysts and development teams to design develop test and maintain robust and scalable data pipelines from Workday to AWS Redshift.
• Architect implement and manage endtoend data pipelines ensuring data accuracy reliability data quality performance and timeliness.
• Provide expertise in Redshift database optimization performance tuning and query optimization.
• Assist with design and implementation of workflows using Airflow.
• Perform data profiling and analysis to troubleshoot datarelated challenges / issues and build solutions to address those concerns.
• Proactively identify opportunities to automate tasks and develop reusable frameworks.
• Work closely with version control team to maintain a wellorganized and documented repository of codes scripts and configurations using Git/Bitbucket.
• Provide technical guidance and mentorship to fellow developers sharing insights into best practices tips and techniques for optimizing Redshiftbased data solutions.

Required Qualifications and Skills:

• Advanced handson experience designing AWS data lake solutions.
• Experience integrating Redshift with other AWS services such as DMS Glue Lambda S3 Athena Airflow.
• Proficiency in Python programming with a focus on developing efficient Airflow DAGs and operators.
• Experience with Pyspark and Glue ETL scripting including functions like relationalize performing joins and transforming dataframes with pyspark code.
• Competency developing CloudFormation templates to deploy AWS infrastructure including YAML defined IAM policies and roles.
• Experience with Airflow DAG creation.
• Familiarity with debugging serverless applications using AWS tooling like Cloudwatch Logs & Log Insights Cloudtrail IAM.
• Ability to work in a highly complex python object oriented platform.
• Strong understanding of ETL best practices data integration data modeling and data transformation.
• Proficiency in identifying and resolving performance bottleneck and finetuning Redshift queries.
• Familiarity with version control systems particularly Git for maintaining a structured code repository.
• Strong coding and problemsolving skills and attention to detail in data quality and accuracy.
• Ability to work collaboratively in a fastpaced agile environment and effectively communicate technical concepts to nontechnical stakeholders.

Additional Useful Experience:

• Docker
• Airflow Server Administration
• Parquet file formats
• AWS Security
• Jupyter Notebooks
• API Best Practices API Gateway Route Structuring and standard API authentication protocols including tokens
• Git Git flow best practices
• Release management and DevOps
• Shell scripting
• AWS certifications related to data engineering or databases are a plus.
• Experience with DevOps technologies and processes.
• Experience with complex ETL scenarios such as CDC and SCD logics and integrating data from multiple source systems.
• Experience in converting Oracle scripts and Stored Procedures to Redshift equivalents.
• Experience working with largescale highvolume data environments.
• Exposure to higher education finance and/or human resources data is a plus.
• Proficiency in SQL programming and Redshift stored procedures for efficient data manipulation and transformation.