Staff Data Engineer

BlackLine•New York, NY

About The Position

As a member of the Data & BI Engineering team you will primarily focus on advancing our Enterprise Data Platform to allow the organization to make data-driven decisions. The successful candidate will work closely with cross-functional teams to identify business requirements, design, and develop data models, data warehouses, and data visualization solutions that help support the organization's strategic goals. The Staff Data Engineer will work in a dynamic environment and will be required to stay current with the latest trends and technologies in the business intelligence field. The ideal candidate will be able to pick up business domain and internal process knowledge and leverage that knowledge to think strategically, communicate effectively, and manage multiple projects simultaneously. The team is also responsible for administering tools and platforms around reporting, analytics, and data visualization while promoting best practices. The role requires a strong combination of technical expertise, leadership skills, and a deep understanding of data engineering principles and best practices. We are looking for a driven, detail-oriented, and passionate engineer to come to join our team.

Requirements

10+ years as a data engineer.
10+ years of experience using RDBMS, SQL, Python languages.
10+ years of experience with ETL/ELT tools like Matillion, Cloud Data Fusion, Informatica, Talend, Airflow, SSIS.
8+ years of experience with BI Tools like Tableau, Power BI, Looker.
3+ years of experience with cloud-native architecture and data solutions such as EMR, RDS, BigQuery and RedShift.
Strong familiarity with GCP, AWS, SQL Server, BigQuery.
Proficient in writing advanced SQL procedures, tuning SQL execution plans.
Demonstrated knowledge of development processes and agile methodologies.
Strong analytical and interpersonal skills, comfortable presenting complex ideas in simple terms.
Comfortable handling large amounts of data.
Experience ensuring data and modeling accuracy, cleanliness, reliability.
Experience translating business requirements into functional, and non-functional requirements.
Bachelor's or Master's degree in Computer Science, Data Science, or a related field.

Nice To Haves

Experience with Google Cloud or similar cloud provider
Significant experience with open source platforms and technologies.
Experience with data science and machine learning tools and technologies is a plus.

Responsibilities

Design and build infrastructure for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources, including data identification, mapping, aggregation, conditioning, cleansing, and analyzing.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand data requirements and deliver valuable insights.
Effectively communicate complex technical concepts to non-technical audiences.
Desire to automate everything.
Maintain documentation and operational knowledge base.
Coach and technically train junior staff on design and development standards and best practices.
Design and implement data security and governance protocols to ensure the accuracy and reliability of data.