Sr. Data Engineer

The Senior Data Engineer contributes in technological decisions for business teams' future data and analysis needs. You will support the business's daily operations inclusive of troubleshooting of the business's data warehouse environment and job monitoring. You will guide the business in identifying any new data needs and provide mechanisms for acquiring and reporting such information and addressing the actual needs. The Senior Data Engineer gathers and maintains best practices that can be adopted in big data stacking and sharing across the business. The Senior Data Engineer provides expertise to the business in data analysis, reporting, data warehousing, and business intelligence. You will report to the Director of Business Systems and Data.

The impact you will have:

• Design/Strategy: The Senior Data Engineer designs and supports the business's database and table schemas for new and existing data sources for the data warehouse. Create and support the ETL to allow the accommodation of data into the warehouse. In this capacity, the Senior Data Engineer designs and develops systems for maintaining the business's data warehouse, ETL processes, and business intelligence.
• Collaboration: The role that the Senior Data Engineer plays is collaborative and, as such, works with data analysts, data scientists, and other data consumers within the business in an attempt to gather and populate data warehouse table structure, which is optimized for reporting. The Senior Data Engineer also works with other departments and teams across the business in coming up with simple, functional, and elegant solutions that balance data needs across the business
• Analytics: The Senior Data Engineer plays an analytical role in quickly and thoroughly analyzing requirements for analysis and subsequently translating the emanating results into good technical data designs. In this capacity, the Senior Data Engineer establishes the documentation of reports and develops technical specification documentation for all reports and processes

What we look for:

• We are looking for a candidate with 5+ years of experience in a Data Engineer role, who has attained a Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
• Experience with big data tools: Hadoop, Spark, Kafka, Spark & Kafka Streaming, Python, Scala, and Talend
• Advanced working SQL experience working with relational databases, query authoring (SQL) and working familiarity with a variety of databases.
• Experience building 'big data' data pipelines, architectures and data sets. In-depth knowledge of Model and Design of DB schemas for read and write performance.
• Working knowledge of API or Stream-based data extraction processes like Salesforce API and Bulk API is must.
• Experience performing root cause analysis on all data and processes to answer specific questions and identify opportunities for improvement.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• A successful history of manipulating, processing and extracting value from large disconnected datasets.
• Working knowledge of message queuing, stream processing, and scalable 'big data' data stores.
• Experience with building data pipeline from several business applications like Salesforce, Marketo, NetSuite, and Workday
• Working knowledge of BI Tools like Tableau, Looker is plus

Benefits

• Private medical insurance
• Accident coverage
• Employee's Provident Fund
• Equity awards
• Paid parental leave
• Gym reimbursement
• Annual personal development fund
• Work headphones reimbursement
• Business travel insurance