Position: AWS Data Engineer
Company: Uuusoftware
Category: Data Engineer
Experience required: 5y
English level: upper

**POSITION HIGHLIGHTS**
AWS Data Engineer with strong cloud data warehouse experience, SQL expertise, and python development skills. Verstand data engineers are instrumental in significant initiatives to transform all aspects of data management services for commercial and public sector clients, as well as our internal software product development efforts. In both areas, the work leads to revised approaches to enterprise data warehousing, business intelligence and data wrangling/ELT/ETL and leverages the cloud to apply advanced analytics and data mining capabilities.

In this role, you will play a significant role in the implementation, maintenance and continuous improvement of enterprise data platforms and work closely with business stakeholders, software development and support teams. 


**KEY RESPONSIBILITIES**
•Experience with setting up and operating data pipelines and data wrangling procedures using Python and/or SQL
•Collaborate with engineers and business customers to understand data needs (batch and real time), capture requirements and deliver complete BI solutions
•Design and build data extraction, transformation, and loading processes by writing custom data pipelines
•Design, implement and support a platform that can provide ad-hoc access to large datasets and unstructured data
•Model data and metadata to support ad hoc and pre-built reporting
•Tune application and query performance using performance profiling tools and SQL

**JOB REQUIREMENTS**

EXPERIENCE, SKILLS AND EDUCATION:
• 7+ years using SQL and databases in a business environment along with knowledge of cloud environments, distributed systems, system automation, and real-time platforms
• 3 + years production experience with Amazon Web Services Redshift (AWS)
• 3+ years production experience with AWS Lambda, Step Functions and Boto3
• 5+ years of experience in custom ETL design, implementation, and maintenance
• 5+ years of experience with data warehouse schema design and data modeling
• Production level experience with Python, SQL, and shell scripting
• Experience with building large scale data processing systems
• Solid understanding of data design patterns and best practices
• Working knowledge of data visualization tools e.g., Looker, Tableau or Power BI
• Experience in analyzing data to identify deliverables, gaps, and inconsistencies
• Familiarity with agile software development practices and drive to ship quickly
• Experience leading change, taking initiative, and driving results
• Effective communication skills and strong problem-solving skills
• Proven ability and desire to mentor others in a team environment
• Excellent business and communication skills to work with business owners to understand data requirements, and to build ETL to ingest the data into the data lake
• Bachelor's degree from four-year College or university in Computer Science or related field

**EXPERIENCE THAT SETS YOU APART:**

• Ability to implement Terraform in a production environment and understand the principles behind Infrastructure as code (IOC)
• Experience managing AWS IAM permissions and security
•Working knowledge of how to configure and maintain CI/CD Pipelines in an AWS environment