Position: Data Engineer (BI)
Company: SD Solutions
Category: SQL
Experience required: 3y
English level: upper

**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.
 - **Be available working hours: 4 pm - 11 pm**.

**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)
5 years of proven experience in building complex BI solutions end to end, using ETL processing, data visualization tools, and reporting systems
Proven ability to write complex SQL queries
Strong analytical and problem-solving skills with attention to details
2+ years in working with big data tools, processing and transferring large amount of data between systems
Solid knowledge in Python and Linux operating systems

**Good to have:
**
Experience with Amazon Redshift, Pentaho, Tableau
Experience/training in Spark

**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.