Position Summary

The Data Operations Analyst is a technical role responsible for ensuring the stability, accuracy, and efficiency of our core data pipelines and operational processes. This individual uses technical skills to manage data flows, troubleshoot issues, perform analysis, and support continuous improvement. This role serves as a critical link between our Data and Delivery

teams, translating data into actionable insights and robust processes that support program delivery and other operations.

The focus of this position is on the execution and maintenance of existing data processes and workflows.

Key Responsibilities

• Core Responsibilities:
• • Run predefined Python scripts and notebooks in Databricks for routine tasks.
  • Perform regular data uploads to Salesforce using tools like Data Loader, ensuring accuracy.
  • Write basic SQL queries to extract data and answer routine business questions.
  • Handle first-tier data-related inquiries and support tickets from the Delivery team.
  • Assist in the documentation of operational processes.
• Lead Generation Management & Support: Perform weekly manual reviews of sites to ensure pipeline replenishment. Provide ad-hoc lead generation support as requested.
• Technical Pipeline Management: Oversee and troubleshoot core operational processes, including Salesforce data uploads, data quality checks in Databricks, and the execution of automated flows.
• Data Quality Assurance: Proactively monitor and resolve data quality issues by running data checks, investigating anomalies, and managing data integrity across platforms.
• Reporting & Support: Build and maintain reports and dashboards in Salesforce and/or BI tools (e.g., AWS Quicksight). Provide direct support to the Delivery team by handling ad-hoc analysis, data pulls, and custom reports.
• Process Improvement: Document existing data processes and collaborate with technical teams to test, troubleshoot, and support the automation and enhancement of operational workflows.

Key Qualifications

• Bachelor's degree in a technical field or equivalent practical experience.
• Strong organizational skills and high attention to detail.
• Excellent communication skills with the ability to explain technical concepts.
• Familiarity with Salesforce, particularly data management and reporting.
• Basic understanding of SQL and data manipulation concepts.
• Ability to work in a remote team environment.

Location and Travel

Power TakeOff is a 100% virtual company with no physical office location. However, many employees are based in two hubs in the areas around Denver, CO and Kitchener-Waterloo, Ontario. Residence in one of these two hubs is desired but not required, and relocation assistance will not be provided for the position. This position is eligible for employment in both the United States and Canada.

Travel is not expected for this position. Power TakeOff will cover the associated accommodation and travel expenses for any company travel.

Compensation and Benefits

The total expected base salary range for employees residing in the U.S. is between $65,000 - $80,000 USD and CAD 76,200 - CAD 93,800 per year, depending on experience. Power TakeOff maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, and market conditions.

• Medical insurance, including vision and dental
• Health Savings Account contributions
• Retirement plans with company matching
• Student Loan Incentive Repayment Program (eligible 12 months after employment)
• Generous time off, including: 
• • 15 paid vacation days, increasing to 20 after the first year
  • 7 flexible well-being days
  • At least 9 paid holidays
  • All company winter break between Dec. 25th and Jan. 1st
  • Summer "Friyays", from June through August we get each 2nd and 4th Friday off!

Join our team and play a key role in driving positive impacts for our business, our customers, our utility clients, the environment, and all of society!