Data Warehouse Developer

EngineeringRemote, San Francisco, California Portland, Oregon Portland, Maine New York, New York


Description

Every day, we work together for what matters – bold, swift, and equitable climate action.
ABOUT THE ROLE
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.



WHAT YOU’LL DO
As a Data Warehouse Developer, you will be responsible for designing, developing, and maintaining data warehousing solutions on the Azure stack. You will implement the architectural strategies developed by the Enterprise Architect by building efficient data pipelines and ETL processes using tools like Azure Data Factory and Logic Apps. You will ensure data quality, security, and performance within the Azure environment while working closely with business users, analysts, and other stakeholders.
  • Design and Develop Data Warehouses: Architect, create, and implement scalable, high-performing data warehouse solutions using Azure services. This includes working with the Enterprise Architect to translate high-level strategies into practical, functional solutions
  • Build & Maintain ETL Processes: Develop and maintain robust ETL pipelines using tools like Azure Data Factory, Azure Functions, and Logic Apps to integrate data from diverse internal and external sources into the data warehouse
  • Data Modeling and Schema Design: Design logical and physical data models, as well as schemas, that align with business requirements and optimize for efficient data storage, retrieval, and analysis
  • Ensure Data Quality and Security: Implement comprehensive security measures to protect sensitive information and enforce data governance policies. You will be responsible for ensuring data accuracy, completeness, and consistency through validation and monitoring
  • Performance Optimization: Continuously monitor and optimize database performance, query execution, and data loading processes within the Azure environment to ensure reliability and scalability
  • Troubleshoot and Maintain: Proactively identify and resolve performance bottlenecks, data discrepancies, and other issues to ensure the overall health and stability of the data warehouse system
  • Collaborate and Document: Work closely with business users, data analysts, and other stakeholders to translate data needs into technical specifications. You will also maintain comprehensive documentation of the data warehouse architecture, ETL processes, and data models to ensure clarity and supportability
  • Implement Architectural Strategies: Act as the hands-on developer, coder, and implementer of architectural strategies developed by the Enterprise Architect, turning vision into reality through code and configuration

 

ABOUT YOU
You are an experienced and driven professional with a strong track record of designing and developing data warehousing solutions. You have a natural curiosity for technology and a passion for contributing to a more sustainable future. In addition, we believe that an individual with the following experience will have the best opportunity for success in this role:
Professional Experience & Skills:
  • 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 and translate them into technical specifications
Education:
  • 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

 

HOW WE DEFINE SUCCESS
Within 30 days:
  • Establish a foundational understanding of the existing data warehouse architecture, ETL processes, and data models
  • Develop strong working relationships with key stakeholders, including business users, analysts, and the Enterprise Architect
  • Gain familiarity with the current data quality, security, and performance monitoring practices
Within 90 days:
  • Successfully take ownership of maintaining and troubleshooting a specific ETL pipeline
  • Contribute to the design and implementation of a new data model or schema as part of an architectural strategy
  • Begin to independently optimize query execution and data loading processes for a designated data set
Within 6 months:
  • Lead the development and successful deployment of a new, scalable data warehousing solution or major ETL pipeline
  • Proactively identify and resolve at least one significant performance bottleneck in an existing system
  • Create and maintain comprehensive documentation for a key data warehouse component
Within 1 year:
  • Demonstrate a comprehensive understanding of the business's data needs and proactively propose new solutions
  • Lead the implementation of architectural strategies for a major data initiative from inception to completion
  • Show measurable improvements in data quality or system performance that have a clear impact on operational efficiency
COMPENSATION & BENEFITS
  • Compensation: The starting base salary for this position is $134,000 to $181,000 in the US. Base pay is dependent upon many factors such as location, transferable or job-related skills, work experience, relevant training, business needs, and market demands
  • Benefits: This position is eligible for a benefits package that includes medical, dental, vision, 401k, flexible paid time off, and more. Additional information regarding the benefits available for this position can be found here        
  • Supplemental Pay: This position may be eligible to participate in discretionary bonus programs based on personal, department and company goals

*This compensation and benefits information is based on 3Degree's good faith estimate as of the date of publication and may be modified in the future
OUR COMMITMENT TO DIVERSITY, INCLUSION AND EQUITY  
3Degrees is an equal opportunity employer. We are committed to creating an inclusive environment where different perspectives contribute to better solutions. 3Degrees welcomes people regardless of race, color, religion, national origin, gender, gender identity or gender expression, age, sex, pregnancy, marital status, ancestry, disability, military or veteran status, sexual orientation, genetic information, or any other category protected by law.
#LI-Hybrid
#LI-GK1