Database Engineer

EfficiencyOne Dartmouth, NS
Share:

We transform the way people use energy.  

 

About the Organization

We’re a leading energy efficiency enterprise. We believe in the good things efficiency brings to our lives, and we come to work every day to make the world a better place – starting in our own province. We have successfully helped hundreds of thousands of families, businesses, non-profits, and institutions transform how they use energy – and we will continue to lead the way in the transition to a low-carbon future. We are deeply committed to climate change and are a multi-year winner of Canada's Greenest Employers and Atlantic Canada’s Top Employers.   

Our work has achieved more than $1 billion in energy savings and contributed over 24% of Nova Scotia’s GHG emission reductions since 2011. We’re passionate about ensuring that all Nova Scotians have equal access to our programs and understand that energy efficiency can help serve our communities and promote a socially equitable energy future. Find out more about how we are making an impact here: https://www.efficiencyone.ca/impact/.

Why you’ll love working here: 

  • A culture that understands there is life outside of work and cares about their employees
  • An engaging, fun, and inclusive work environment
  • A holistic benefits package that starts on day one
  • Wellness initiatives and fitness challenges hosted throughout the year
  • Corporate gym memberships
  • Career growth and professional development opportunities
  • Being part of a team contributing to Nova Scotia’s goal of net-zero carbon by 2050.

If you want to be part of an organization with an ambitious plan to support the transition to net zero and help build a thriving, resilient future for Nova Scotians - then you belong here!   

Want to know what it’s really like to work with us? Reach out to any one of our team members on LinkedIn to hear their firsthand experience at EfficiencyOne.

Position:

The Database Engineer is responsible for designing, configuring, testing, and maintaining energy savings and incentive calculations in EfficiencyOne’s Customer Information System (CIS). As new Efficiency Nova Scotia rebate programs are built into the Customer Information System (CIS), the Database Engineer will work with the rebate program team, the Customer Information System (CIS) development team, and others on the Portfolio Engineering team to understand technical and business requirements and lead the Customer Information System (CIS) design of energy savings and incentive calculations for that program.  They then provide ongoing training and support for updates and changes to each program.  The Database Engineer manages the Customer Information System (CIS) integrations with other applications and data products that are used for calculations.  They are responsible for all internal Customer Information System (CIS) calculations and data transformations that reference project savings or incentives.

A snapshot of what you will be involved with:

  • Acts as the database engineering representative for day-to-day Customer Information System (CIS) management tasks, including attending planning meetings and providing insight on the costs and benefits of different data configuration options.
  • Works with various internal teams to understand business requirements and translate them to Customer Information System (CIS) designs.
  • Builds and tests savings and incentive calculations and assists with deployments through database environments.
  • Manages a backlog of Customer Information System (CIS) maintenance and continuous improvement tickets assigned by the System Admin and provides live support via MS Teams for high-priority issues.
  • Balances competing for design objectives include internal user experience, customer experience, data granularity, and system maintenance complexity.
  • Acts as the subject matter expert in savings and incentive calculations and contributes to developing standard reporting metrics and dashboards.
  • Develops and delivers training on Customer Information System (CIS) savings, incentive calculations, and associated maintenance processes.
  • Executes other projects and responsibilities as assigned by the Manager.

What Will Help You Succeed?

  • A bachelor’s degree or diploma in Database Administration, Computer Science, Applied Computer Science, Business Intelligence, or an equivalent degree or diploma.
  • Applicants with a background in engineering or engineering technology will be considered, provided they have a strong background and interest in database applications.
  • The position does not require an engineering background or prior knowledge of energy savings calculations but does require a strong background in arithmetic and algebra.
  • Detail-oriented, customer focus, time management, and excellent oral and written communication
  • Self-motivated, take the initiative and handle multiple tasks, and work to a high standard in an environment with tight timelines/deadlines.
  • Strong analytical skills along with excellent oral and written communication skills, including the ability to effectively explain complex technical subjects to non-technical audiences, as well as experience in writing technical documentation
  • Proficient with all Microsoft Office software (Excel, Word, PowerPoint, Outlook, Teams)
  • Experience with data system management, ideally with backend Salesforce development.
  • Experience developing business requirements for data tracking systems.

 What to expect in your first several weeks on the job:   

In the first week, expect to:

  • Meet your new colleagues on the Portfolio Engineering team and learn about the role we play within the business
  • Meet with other employees on the Engineering Planning and Customer Information Systems (CIS) teams
  • Learn about EfficiencyOne’s role in the energy transition and the types of projects we are involved in
  • Learn about EfficiencyOne’s corporate targets and what’s important to the company’s overall success
  • Learn about the purpose of various EfficiencyOne programs and the customer experience for each
  • Learn about the types of information that we track for each project and why
  • Learn about critical internal and external reports and what data they rely on
  • Read company policies and process documents

In the first month, expect to:

  • Start attending Customer Information Systems (CIS) Operations Committee meetings with other database application specialists
  • Shadow the Portfolio Engineer in various Customer Information Systems (CIS) development and maintenance tasks
  • Learn how data is structured in our Customer Information Systems (CIS) (energy orbit, built on the Salesforce platform)
  • Learn how savings and incentive calculations are done in ESPCalcs, and how ESP interacts with Customer Information Systems (CIS)
  •  Learn about other external databases and how they interact with our Customer Information Systems (CIS)
  • Learn how data moves through the Customer Information Systems (CIS), and what information is added throughout the life of a project
  • Learn about Salesforce Flows and SOQL reporting
  • Learn how our Customer Information Systems (CIS) interacts with our Data Warehouse
  • Learn about our development, testing, and production of Customer Information Systems (CIS) and ESP environments and how we handle deployments
  • Discover what projects are currently underway and how you might contribute

In the first three months, expect to:

  • Start taking over responsibility for various Customer Information Systems (CIS) design and maintenance tasks from the Portfolio Engineer as you become comfortable executing each one
  • Make edits to savings and incentive calculations in Customer Information Systems (CIS) and ESP
  • Coordinate with the Customer Information Systems (CIS) team to move your changes through environments
  • Configure, test, and deploy new programs with the help and oversight of the Portfolio Engineer
  • Handle requests for changes that were assigned to you through a backlog management ticketing system
  • Help interpret business requirements and suggest Customer Information Systems (CIS) configuration options that meet the business objective.
  • Leverage your database experience to suggest improvements to current practices
  • Put together a plan for the rest of the year, including a timeline of when you will absorb responsibility for various critical maintenance and troubleshooting functions.

 

 EfficiencyOne is committed to fostering a culture that is supportive and values others, one that is grounded in diversity and inclusiveness. We welcome applications from all qualified candidates, including women, Indigenous peoples, persons with a disability, racially visible persons, persons of minority sexual orientations, and gender identities.

 

 

 

 

 
 
By clicking the button, I agree to the GetHired Terms of Service
GetHired.com member? Login to Apply