3Degrees-posted 4 months ago
$134,000 - $181,000/Yr
Full-time • Mid Level
1-10 employees

This is an exciting opportunity to join 3Degrees as a Data Warehouse Developer, a role that is crucial in driving climate action and supporting a decarbonized future. As a Data Warehouse Developer, sometimes referred to as a 'Data Architect,' you will be responsible for designing, developing, and maintaining robust data warehousing solutions on the Azure stack. You will be leveraging Azure services such as Azure Data Factory, Logic Apps, and Synapse Analytics to build efficient data pipelines and implement complex ETL (Extract, Transform, Load) processes. This role is essential for transforming raw data into actionable insights, and you will be responsible for implementing the architectural strategies developed by the Enterprise Architect. This is a full-time role reporting to the Senior Director of Engineering. We value camaraderie, team collaboration, and the benefits of in-person connection, while offering flexibility. For this role, we prefer candidates to join us in a voluntary, flexible hybrid work style in our San Francisco Bay Area office. We may also consider candidates who are able to join us at one of our office hubs in Portland, OR; Portland, ME; or New York, NY. For exceptional remote candidates, we strongly prefer those located in states where we are currently eligible to hire: CA, OR, NY, WA, ME, TX, CO, MI, FL, MA, MN, VA, DC, GA, UT, and IL. While we prioritize candidates in, or open to relocating to, these states, we may consider outstanding remote candidates from other US states. Please note that hiring in a new state would involve evaluating the implications of establishing a new hiring presence there. Additionally, 3Degrees does not provide relocation assistance for this position. Please Note: 3Degrees does not provide sponsorship or work authorization assistance; therefore, pre-existing right-to-work status is a prerequisite to be considered for this position.

  • Design and Develop Data Warehouses: Architect, create, and implement scalable, high-performing data warehouse solutions using Azure services.
  • Build & Maintain ETL Processes: Develop and maintain robust ETL pipelines using tools like Azure Data Factory, Azure Functions, and Logic Apps.
  • Data Modeling and Schema Design: Design logical and physical data models, as well as schemas, that align with business requirements.
  • Ensure Data Quality and Security: Implement comprehensive security measures to protect sensitive information and enforce data governance policies.
  • Performance Optimization: Continuously monitor and optimize database performance, query execution, and data loading processes.
  • Troubleshoot and Maintain: Proactively identify and resolve performance bottlenecks, data discrepancies, and other issues.
  • Collaborate and Document: Work closely with business users, data analysts, and other stakeholders to translate data needs into technical specifications.
  • Implement Architectural Strategies: Act as the hands-on developer, coder, and implementer of architectural strategies.
  • Proven experience in designing, developing, and maintaining data warehousing solutions on the Azure stack.
  • Demonstrated ability to build and optimize efficient ETL/ELT pipelines using tools like Azure Data Factory.
  • Experience with data modeling and schema design to optimize data storage and retrieval for reporting and analytics.
  • Familiarity with ensuring data quality, implementing data governance policies, and establishing security measures.
  • A solid understanding of performance optimization within the Azure environment, including Azure Synapse Analytics and SQL Data Warehouse.
  • Proven ability to collaborate with business users, analysts, and other stakeholders to understand data needs.
  • A degree in a relevant field such as Computer Science, Data Science, or a related technical discipline is preferred.
  • Equivalent professional experience in data warehousing will also be considered.
  • Medical insurance
  • Dental insurance
  • Vision insurance
  • 401k
  • Flexible paid time off
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service