Data Engineer

The Data Engineer reports directly to the Director, Head of Technology Solutions, and plays a pivotal role in driving innovation and efficiency within our technical and data teams. This role requires someone who can think proactively, solve complex problems, and maintain the highest standards of professionalism and discretion. As a key player on our application development team, the Data Engineer will be responsible for steering the technical and data strategy. You'll work closely with the Director, Head of Technology Solutions, and the data & analytics team to establish and uphold data architecture standards that align with the needs of our stakeholders.

This role is ideal for a dynamic individual seeking the opportunity to make a lasting impact on the organization’s growth. We're an organization committed to fostering an inclusive, forward-thinking environment that encourages open dialogue, supports our members, and strikes a balance between technology, process, and people.

Key Responsibilities:

• Develop and oversee the organization’s data architecture, ensuring adherence to data management, metadata, and naming standards, while prioritizing security, scalability, and data integrity.
  
• Design and manage conceptual, logical, and physical data models, ensuring their alignment with business needs.
  
• Implement physical data models, configuring databases (e.g., indexes, partitions, constraints) for optimal performance.
  
• Design and build data pipelines within AWS, integrating diverse data sources with varying formats, frequencies, and latencies.
  
• Own data mapping processes, ensuring business logic, transformations, and data quality are maintained at all stages.
  
• Support and enhance existing platforms while advancing toward cutting-edge technology architectures.
  
• Leverage AWS features to unlock faster business insights, enhancing analytics and data science capabilities.
  
• Collaborate closely with Data Science and Analytics teams to extract insights and create business value from data assets.
  
• Engage with a wide range of stakeholders, including internal teams, external vendors, and insurance members, to deliver results in a highly cooperative setting.
  
• Take on additional projects and tasks that support the overall success of the organization and its partners.
  

Qualifications:

• 5+ years of experience as a Data or Software Engineer, ideally within not-for-profit or NGO sectors.
  
• Bachelor’s degree required, with a Master’s in Computer Science preferred.
  
• Hands-on expertise in database management systems (DBMS), specifically SQL Server, Hive, and Spark.
  
• Experience in data modeling and adopting a Data Model Driven Approach.
  
• Proficiency in AWS or Azure cloud environments.
  
• Advanced skills in Python programming.
  
• A passion for developing and maintaining data systems that support analytics and machine learning.
  
• Exceptional organizational, communication, and collaboration skills, with an eye for detail.
  
• Strong results-oriented mindset with a commitment to high-quality work.
  
• Ability to thrive in a fast-paced and dynamic environment.
  
• Demonstrated integrity and ability to handle confidential information discreetly.
  
• A problem-solving mindset with a scientific approach to challenges.
  
• Experience in the Property & Casualty (P&C) insurance industry is a plus.
  
• Comfortable working in and excelling within a remote work setup.