Returning Candidate?

Data Engineer

Data Engineer

Job ID 
Posted Date 
ADCI - Karnataka
Recruiting Team 

Job Description was recently voted #5 most admired company in the US, #1 most innovative, and # 1 in Customer Service. We are investing heavily in building an excellent advertising business, and are responsible for defining, and delivering a collection of self-service performance advertising products – “always-on analytics” that is fully scalable and reliable. Our products are strategically important to our leadership, finance, economists, analysts, and BI partners to drive long-term growth. We mine billions of ad impressions and millions of clicks daily and are breaking fresh ground to create world-class products. We are highly motivated, collaborative, and fun loving with an entrepreneurial spirit and bias for action. With a broad mandate to experiment and innovate, we are growing at an unprecedented rate with a seemingly endless range of new opportunities.
The Advertising Analytics and Data Management team is looking for an exceptional Data Engineer who is passionate about data and the insights that large amounts of data can provide, who thinks/acts globally, and who has the ability to contribute to major novel innovations in the industry. The role will focus on working with a team of data engineers, business and tech savvy professionals to lay down scalable data architecture to ingest the large amounts of structured and unstructured datasets and work with stakeholders to drive business decisions based on these datasets.

The ideal candidate will possess both a data engineering background and a strong business acumen that enables him/her to think strategically and add value to the customer experience. He/She will experience a wide range of problem solving situations, requiring extensive use of data collection and analysis techniques such as data mining and machine learning.

The successful candidate will work with multiple global site leaders, Business Analysts, Software Developers, Database Engineers, Product Management in addition to stakeholders in sales, finance, marketing and service teams to create a coherent customer view. They will:

· Develop and improve the current data architecture using AWS Redshift, AWS S3, Oracle and Hadoop/Hbase Cluster.
· Improve upon the data ingestion models, ETL jobs, and alarming to maintain data integrity and data availability.
· Keep up to date with advances in data persistence and big data technologies and run pilots to design the data architecture to scale with the increased data sets of advertiser experience.
· Partner with analysts across teams such as product management, operations, sales, finance, marketing and engineering to build and verify hypothesis to improve the business performance.
· Manage weekly business reports via dashboards and papers the analyses of daily, weekly, and monthly reporting of performance via Key Performance Indicators.

Basic Qualifications

  • Bachelor’s degree in Computer Science Engineering or related technical field
  • 3+ years of relevant experience with ETL, data modeling, and business intelligence architectures
  • 3+ years’ experience in relational database concepts with a solid knowledge of star schema, Oracle, SQL, PL/SQL, SQL Tuning, OLAP, Big Data technologies
  • Experience building self-service reporting solutions using business intelligence software (e.g., OBIEE, Tableau Server, Micro Strategy etc.).
  • Experience with Big Data solutions: Hadoop, Pig/Hive or other frameworks
  • Exceptional troubleshooting and problem-solving abilities.
  • Excellent written and verbal communications skills.
  • Demonstrated ability to work effectively across various internal organizations.

Preferred Qualifications

- AWS Experience
- Experience working with Apache Spark