Application Engineer
Apex Clean Energy

Posted January 04, 2021

Employment Type Full-time, Exempt

Compensation Base and Bonus Commensurate with Experience

Company Apex Clean Energy

Location 310 4th Street NE, Suite 300
Charlottesville, VA 22902
US


DESCRIPTORS

WELCOME

We recognize and respect the amount of time you are about to invest by applying to this open position. If you complete this job application, you will be kept informed via email status updates (and text messages, if you opt in) throughout the evaluation process.

By continuing with this job application, you will be asked to answer job-specific questions. Please note that the questions contained in this job posting are our sole intellectual property.

Upon receipt of your responses, we will evaluate your submission. If selected for a personal interview, you will receive an email/text with scheduling instructions.

Thank You,
The Apex Team

SPECIAL NOTE: If you do not receive a confirmation e-mail within minutes of your job application submission, please check your email bulk or spam folders.
COMPANY DESCRIPTION

Founded in 2009, Apex Clean Energy is an independent renewable energy company focused on bringing utility-scale generation facilities to market, from site origination and financing to turnkey construction and long-term asset management. With a team of over 200 professionals and the nation’s largest renewable energy project portfolio, Apex is a leader in the transition to a clean energy future. For more information, visit www.apexcleanenergy.com.

 

Apex strives to excel in every phase of project realization, from origination and financing to construction and asset management. Our mission-driven team seeks determined, resolute individuals who strive to innovate and go above the call of duty, and who will relentlessly do their part to help accelerate the shift to America’s clean energy future.

Apex Clean Energy, Inc. is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.

We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to sponsor visas at this time.

JOB DESCRIPTION

Apex Clean Energy seeks an Application Engineer to join a technologically advanced team, focusing on innovation and delivery of critical applications and dashboards to foster business solutions and solve specific business challenges.

Reporting to the Manager of Analytics and Systems Engineering within our Technology and Energy Team, you will be the main developer responsible for designing, developing, and implementing applications and programs that interface with the data warehouse. You will work closely with project teams and stakeholders across Apex in support of development and implementations activities including requirements gathering, system design and architecture, and deployment of applications. You will be responsible for then providing applications and dashboards using a combination of tools and programming languages that perform data extraction and data modeling. Ongoing operational support of ETL and data integration jobs are also an important task of this position comprised of scheduling, monitoring and troubleshooting to maintain optimal health of the environments.

The Application Engineer serves as diagnostician and solution provider for data, information and business process-related analysis. We look to this role for technical expertise in specific data domains and incorporating data governance into daily activities. This role is responsible for providing expertise in the integration of data, insights, trends and solution recommendations. You will enable data driven decisions for your respective domain and partner with other analysts to extract, interpret, and perform advanced analytics.

 

We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to sponsor visas at this time.

RESPONSIBILITIES

  • Design and develop applications interfacing with the data warehouse (e.g., Power Apps and Power BI dashboards) that effectively accomplish objectives and needs
  • Collaborate with stakeholders to define business logic for source-to-target mappings and integration workflows.
  • Design and develop data extraction SQL queries that are highly optimized for very large data sets
  • Analyze and edit existing applications to improve functionality
  • Remodel and adapt applications as needed to optimize performance
  • Assisting in production support by resolving source data issues and refining transformation rules when needed
  • Test applications extensively to ensure they are error and bug free
  • Maintain application database
  • Support the maintenance of the existing data warehouses and facilitate aggregation, slicing and dicing of data using dbt
  • Creating and maintaining the company data dictionary as well as technical documentation for source-to-target mapping
  • Support the management and maintenance of ETL processes
  • Follow current trends, their impact on business strategies, and their implications for creating sustainable data warehouse architecture
  • Analyze the needs and the environment to make sure the solution you're developing considers the current architecture and operating environment as well as future functionality and enhancements
  • Work closely and collaborate with various cross functional teams to identify, troubleshoot and fix data issues, and resolve data gaps that impact the fulfillment of the business’s functional requirements
  • Work collaboratively with team members and customers to gather and validate requirements as well as deliver features/enhancements
  • Collaborate with architects, team leads and team members to architect and design solutions to meet functional and technical requirements
  • Troubleshoot issues, identify resolutions
QUALIFICATIONS

  • At least two years of related experience with complex/large data management
  • At least two years of relevant application engineering or development experience
  • At least two years of working collaboratively across interdisciplinary teams with an end goal of solving business challenges
  • Extensive knowledge of Python and SQL
  • Demonstrable project management skills; highly organized and detail-oriented
  • Strong quantitative skills
  • Critical, analytical, and driven
  • Thrives in a fast-paced rapidly evolving work environment, adapting quickly to new information and re-prioritizing as needed
  • Enjoys complex problem-solving and collaboration
  • Familiar with ETL tools for database / warehouse development. Experience with Azure, preferred
  • Experience in all aspects of project development life cycle such as identifying requirements, design, feasibility analysis, allocating timelines, task prioritization, development, performance, best practices and testing
  • Experience supporting a data warehouse environment, reporting, data integration jobs and job schedules
  • Experience performing analysis and reporting from the data warehouse, ideally using PowerBI
  • Experience setting up data access and visualization tools and systems for non-technical users
  • Prior experience with renewable energy and/or SCADA a plus
  • Interest/passion for renewable energy required
BENEFITS

  • Health Insurance
  • Dental Insurance
  • Vision Insurance
  • 401(k) Employer Match
  • 401(k) Pre-tax or Roth Deferrals
  • Health Savings Accounts
  • Flexible Spending Arrangements
  • Short-term Disability Insurance
  • Long-term Disability Insurance
  • Group Term Life Insurance
  • Voluntary Additional Term Life Insurance
  • Paid Time Off (PTO)
  • Holidays
  • Volunteer Time Off
  • Progressive Parental Leave Plan
  • Milk Stork Travel Solution
  • Professional Development Opportunities
  • Employee Referral Program
  • ACAC Fitness and Wellness Center - Corporate Discount
  • Company Paid Cell Phone
  • Company Paid Parking
  • United Van Lines - Relocation Discounts