Data Engineer transforming legacy on - premises systems to cloud - native architectures for advanced data analytics. Collaborating with teams to build efficient data solutions using Python and AWS.
About the role
- Senior Data Engineer crafting and developing data products for analytical insights at Zendesk. Collaborating in an Agile environment with a focus on data warehousing and process optimization.
Responsibilities
- Collaborate with team members and business partners to collect business requirements, define successful analytics outcomes and design data models
- Serve as Data Model subject matter expert and data model spokesperson, demonstrated by the ability to address questions quickly and accurately
- Implement Enterprise Data Warehouse by transforming raw data into schemas and data models for various business domains using SQL & dbt
- Design, build, and maintain ELT pipelines in Enterprise Data Warehouse to ensure reliable business reporting using Airflow, Fivetran & dbt
- Optimize data warehousing processes by refining naming conventions, enhancing data modeling, and implementing best practices for data quality testing
- Build analytics solutions that provide practical insights into customer 360, finance, product, sales and other key business domains
- Build and Promote best engineering practices in areas of version control system, CI/CD, code review, pair programming
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery
- Work with data and analytics experts to strive for greater functionality in our data systems
Requirements
- 5+ years of data engineering experience building, working & maintaining data pipelines & ETL processes on big data environments
- 5+ years of experience in Data Modeling and Data Architecture in a production environment
- 5+ years in writing complex SQL queries
- 5+ years of experience with Cloud columnar databases (We use Snowflake)
- 2+ years of production experience working with dbt and designing and implementing Data Warehouse solutions
- Ability to work closely with data scientists, analysts, and other stakeholders to translate business requirements into technical solutions.
- Strong documentation skills for pipeline design and data flow diagrams.
- Intermediate experience with any of the programming language: Python, Go, Java, Scala, we primarily use Python
- Integration with 3rd party API SaaS applications like Salesforce, Zuora, etc
- Ensure data integrity and accuracy by conducting regular data audits, identifying and resolving data quality issues, and implementing data governance best practices.
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Benefits
- Bonus
- Flexible work arrangements
- Professional development opportunities
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Data Engineering Academy focused on Snowflake and Databricks for professionals interested in expanding their technical capabilities. Fully remote with future office work in Monterrey or Saltillo after completion.
Senior Data Engineer at Intent HQ designing and scaling data platforms. Building high - impact intelligence from millions of customer insights with a focus on performance and reliability.
SAP Data Engineer supporting MERKUR GROUP's evolution into a data - driven company. Responsible for data integration, modeling, and collaboration with various departments in Group Finance.
Data Engineer at Booz Allen Hamilton organizing data and developing advanced technology solutions. Leading data engineering activities for mission - driven projects and mentoring multidisciplinary teams.
Senior Data Engineer at Bristol Myers Squibb developing scalable data pipelines for foundational products. Collaborating with data scientists and IT professionals to ensure data quality and accessibility.
Sr. Data Engineer building and maintaining data infrastructure for Purpose Financial. Collaborating with teams to improve data services and analytics.
Data Engineer II role focusing on developing and maintaining data pipelines for analytics. Collaborating with Data Science and Analytics teams to ensure data quality and reliability.
Senior Data Architecture Specialist designing and maintaining data integration solutions for Morgan Stanley. Involved in building data architecture and optimizing data storage using various technologies.
Lead Data Engineer responsible for building and maintaining the central HR data lake. Collaborating with analysts and business stakeholders for data - driven decision making.