Job Category

Modernize is seeking to hire a Python Developer to use their intellect and experience to design, build and maintain data integrations and scale systems to support our digital marketing platform. You will communicate with both business and technical stakeholders to drive timely data into crucial reporting and analytics applications that move our business forward. This is a hands-on role where you will be creating written designs, writing plenty of code and directly managing infrastructure components.

Responsibilities

• Communicate with and collect requirements from Business stakeholders
• Be a major contributor on our Data Pipeline team, wrangling data, building data pipelines, and working closely with our technical leads to improve our data pipeline architecture.
• Maintaining legacy applications as well as creating new ETL’s in our code bases that span Python, PHP and UNIX scripting languages, preparing data for key reporting, analytics, and other applications.
• Monitor and maintain our ETL/pipeline job scheduler (Airflow), notifications, and worker infrastructure components on AWS. Respond to system error notifications, and communicate outages in a timely fashion.
• Analyze data from different sources to identify possible issues and keep our pipeline working properly.
• Perform peer code reviews
• Loves to learn, assess, and apply new technology (particularly AWS) to improve solutions for our batch processing and data streaming requirements. 
• Work within an Agile development process. 
• Develop, document, and enforce standards, naming conventions, data integrity checks, and overall best practices for all company-wide
• Contribute ideas for continually improving the team's productivity, release quality, and job enjoyment.
• Perform Adhoc data analysis for trouble shooting and validation
• Collaborate with Algo and Data Analytics teams

Experience 

• 3-5 years of data engineering experience, consuming, transforming and loading data into production databases/data warehouses
• Enjoys working remotely via webcam with teammates
• Sense of humor, team player, good interpersonal skills
• Proficient in SQL and RDBMSs, preferably MySQL, Oracle, Hive and Amazon Redshift
• Strong understanding of relational modeling
• Excellent verbal and written communication skills
• Relentless and tenacious when it comes to figuring out solutions to problems

Nice to have:

• AWS experience (S3, RDS, Redshift, CloudWatch)
• Experience working with Apache Airflow or other pipeline orchestration tools
• Data streaming / near-real-time data warehousing experience
• Experience in cleaning inconsistent data and transforming it into standard forms
• Familiarity working with Big Data technologies, Hive and HDFS in particular
• Experience using dimensional modeling
• Experience using Kafka
• Interest in Performance Marketing
• Experience with PHP and Laravel
• Experience with Java
• Experience using Docker

#LI-REMOTE