Senior Data Engineer

At Databricks Information Technology, we are a product led organization transforming the way we work from how easy it is to use our IT services to the applications we develop that help us scale seamlessly in face of incredible growth.

You will influence technological decision-making for business teams future data, analysis, and reporting needs. The role supports the business’s daily operations inclusive of troubleshooting of data-intelligence warehouse environment and job monitoring. You will guide the business in identifying data needs and delivering mechanisms for acquiring and reporting such information and addressing the actual needs. You will gather and maintain best practices that can be adopted in big data stacking and sharing across the business. You will provide expertise to the business regarding data analysis, reporting, data warehousing, and business intelligence. You will report to the Director, Business Systems.

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. Creates and supports the ETL in order to facilitate the accommodation of data into the warehouse. In this capacity, the Senior Data Engineer designs and develops systems for the maintenance of the business’s data warehouse, ETL processes, and business intelligence.

• Collaboration: The role that the Senior Data Engineer plays is highly collaborative and, as such,works closely 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 closely with other disciplines/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 business requirements for reporting and analysis and subsequently translating the emanating results into good technical data designs. In this capacity, the Senior Data Engineer establishes the documentation of reports, develops, and maintains technical specification documentation for all reports and processes.

What we look for:

• 5+ years of related experience with a Bachelor’s degree; or 3 years and a Master’s degree; or a PhD without experience; or equivalent work experience.

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

• Experience building and optimizing ‘big data’ data pipelines, architectures and data sets. In depth knowledge of Model and Design of DB schemas for read and write performance.

• Extensive working knowledge of API or Stream based data extraction processes like Salesforce API and Bulk API is must.

• Experience performing root cause analysis on internal and external data and processes to answer specific business 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.

• Knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.

• Experience supporting and working with cross-functional teams in a dynamic environment.

• Experience with building data pipeline from various business applications like Salesforce, Marketo, NetSuite, Workday etc. 

• Experience with big data tools: Hadoop, Spark, Kafka, Spark & Kafka Streaming, Python, Scala, Talend etc.

• Knowledge of BI Tools like Tableau, Looker etc