Full-Time

Senior Data Modeler

Posted on 9/5/2024

Benevity

Benevity

501-1,000 employees

Software for corporate social responsibility initiatives

Enterprise Software
Social Impact

Senior

Toronto, ON, Canada

Requires at least 50% in-office presence.

Category
Data Engineering
Data & Analytics
Required Skills
Microsoft Azure
Redshift
Python
Airflow
NoSQL
Data Science
Apache Beam
BigQuery
Apache Spark
SQL
Apache Kafka
Java
AWS
Jenkins
Hadoop
Snowflake
Google Cloud Platform
Requirements
  • Degree in Computer Science or equivalent professional experience
  • 10 years of experience in data modeling, database design, and data management
  • 10 years of experience in data engineering, with a focus on data architecture, ETL processes, and big data technologies
  • 10 years of hands on experience with designing and deploying enterprise data warehouse models
  • 5+ years’ experience with proficiency in programming languages such as Python, Java, SQL
  • Hands on experienced working with data warehousing technologies (BigQuery, Redshift, Snowflake)
  • Strong understanding of database management systems (SQL and NoSQL)
  • Expertise in big data technologies like Hadoop, Spark, DBT, Airflow, Apache Beam, Kafka, etc.
  • Experience with cloud-based platforms and building data engineering solutions (AWS, Azure or GCP)
  • Provide architectural guidance and big data engineering expertise for use cases that require capabilities in Federated Queries, Data Ingestion and Distributed Computing
  • Excellent problem-solving skills and attention to detail
  • Hands on experience with writing and optimizing SQL based code
  • Experience with database performance optimization and tuning
  • Familiarity with Continuous Integration/Continuous Deployment (CI/CD) Pipelines (e.g., Jenkins, GitLab CI/CD, AWS CodePipeline, GCP Cloud Build)
  • A strength in pragmatically designing, building and deploying scalable, highly-available systems
  • An ability to think abstractly and are comfortable with ambiguous/undefined problems
  • Excellent communication skills: you understand user needs and have the ability to translate them into actionable pieces of work
  • GCP Professional Data Engineering certification
  • AWS Data Engineer certification
  • Azure Data Engineer certification
Responsibilities
  • Design and develop logical and physical data models to meet the needs of various business applications
  • Ensure data models are aligned with business requirements and best practices
  • Create and maintain data dictionaries and metadata repositories
  • Design and optimize database structures to support high-performance and scalability
  • Collaborate with database administrators to ensure optimal performance of data models
  • Implement indexing, partitioning, and other database optimization techniques
  • Work closely with data architects, data engineers, and business analysts to integrate data from various sources
  • Define data integration standards and practices. Ensure data consistency, quality, and integrity across different systems
  • Collaborate with cross-functional teams to understand business requirements and translate them into effective data models
  • Document data models, data flows, and business rules
  • Ensure compliance with data governance policies and industry regulations
  • Conduct regular audits and reviews of data models and databases to ensure compliance and optimal performance
  • Identify opportunities for process improvements and implement solutions to enhance data modeling practices

Benevity provides software solutions that help businesses incorporate social impact and corporate responsibility into their operations. Their platform includes tools for employee and customer engagement, as well as community investment, allowing companies to create, manage, and measure their social initiatives. Benevity operates on a subscription-based model, offering features like a giving API and branded giving portals, which enable businesses to enhance their interactions with customers and encourage employee participation in social impact activities. Unlike many competitors, Benevity focuses specifically on the Environmental, Social, and Governance (ESG) sector, serving a wide range of clients from mid-market companies to large enterprises. The goal of Benevity is to help organizations attract and retain talent while making a positive contribution to society through purpose-driven initiatives.

Company Stage

Acquired

Total Funding

$66M

Headquarters

Calgary, Canada

Founded

2008

Growth & Insights
Headcount

6 month growth

0%

1 year growth

0%

2 year growth

-5%
Simplify Jobs

Simplify's Take

What believers are saying

  • Benevity's focus on digital security strengthens trust with clients and partners.
  • The rise in corporate volunteerism boosts demand for Benevity's engagement solutions.
  • Christopher Maloof's leadership may drive strategic acquisitions and potential IPO opportunities.

What critics are saying

  • Leadership transition with new CEO may lead to strategic shifts or instability.
  • Layoffs in early 2023 could impact employee morale and company culture.
  • Increased competition in the social impact software market may affect market share.

What makes Benevity unique

  • Benevity offers an all-in-one software solution for corporate social responsibility initiatives.
  • The platform supports nearly 2 million nonprofits worldwide, enhancing its global reach.
  • Benevity's integration of Impact Genome sets a new standard for social impact reporting.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Flexible Work Hours

Remote Work Options

Professional Development Budget

Hybrid Work Options

INACTIVE