Position: Data Engineer
Company: SD Solutions
Category: SQL
Experience required: 2y
English level: upper

In order to be successful, this individual must be proactive and remain informed on data technologies and trends in various operating systems and languages. Engage in and improve the whole lifecycle of services—from inception and design, through deployment, operation, and refinement. The Engineer here will be working closely with other business units to gather requirements, communicate status, and proposal of the undertone Software products.

Job Responsibilities:

Support reporting services and database management systems before they go live throughout the development lifecycle activities such as system design, developing the data platforms and frameworks, capacity planning, and launch reviews.
Spend 50% in applying software and data engineering background in resolving reporting and data platform disruptions in Undertone's Ad Platform. This will involve investigation on data and integration of various services used in the data management platform - Amazon Web Services such as Redshift, Elastic Map Reduce, Data pipelines, etc.
Provide a quick temporary solution so that there is minimum downtime for the business and then work on escalation for providing a permanent fix. Need to prioritize the reporting and data refresh issues to ensure the business users are equipped with near real-time data.
Use 10% of your time to participate in System design review meetings to provide your inputs based on data engineering experience.
Another 10% of time will be spent on validating the data quality and integrity of the newly developed projects.
At the end of every Sprint cycle, participate in post-production activities such as code reviews and preparation of documentation of runbooks for ETL /data pipeline.
Spend 30% of the time learning new data technologies and implementing data solutions for providing real time insights that will enable the business users to take right decisions.
Work on 3 rd party integration projects by implementing Third Party API’s.
Apply your creative mind in addressing urgent business requirements by providing quick data solutions with minimal turnaround time to avoid any disruption to the business.
Collaborate with System Administrators and Database Administrators to fix software infrastructure problems.

Profile and Experience:

Bachelor’s degree and 3+ years of experience OR MS degree and 2+ years of experience in software engineering (Degree in Computer Science or related field preferred)
A minimum of 2 years of development experience with Python
A minimum of 2 years of experience in developing/supporting DW/BI Applications.
A minimum of 2 years’ experience in supporting/troubleshooting failed Pentaho Data Integration/Kettle ETL processes.
Strong in writing complex SQL queries and performance tuning techniques.
Experience in working on AWS S3, AWS EMR, AWS Redshift, AWS Athena.
Basic scripting skills in Bash/Perl.

Preferred Qualifications:

Database administration and development skills, especially MySQL and Postgres databases.
Experience in Hadoop, Flume, Kafka, Hive, Spark.
Experience in developing Tableau Dashboards.
Familiarity with monitoring systems like Datadog, Pingdom to catch/prevent issues.
Ability to effectively prioritize workload and work well under pressure in a fast-paced
environment.

Knowledge and passion for media, data and technology.
Quick learner, creative and ability to retain / source relevant information for references.
Great work ethic, proactive, self-motivated with excellent communication skills.
Ability to work independently and as part of a team, including remote teams.

About company:

Undertone is at the intersection of media, creative, and technology. The company has formed deep partnerships with the world’s best digital media properties, developed a suite of groundbreaking multi-screen creative formats for brands to leverage, and built technology platforms that underpin every aspect of campaign planning, delivery, optimization, and measurement.

https://www.undertone.com/