Accounting Clerk

Accounting Clerk/Data Analyst

Job Posting

Greater Baltimore Area/Hybrid

MD Energy is a rapidly growing energy management company that serves some of the area’s largest businesses, including real estate owners, restaurants, and manufacturers. We provide consulting services for utilities across the United States, and we are looking for customer centric individuals to join our team.

As the Accounting Clerk, you will process accounts receivable, accounts payable, utility incentive payments and bi-weekly payroll. In addition to bookkeeping and payroll responsibilities, you will assist team members across our various business lines by collecting and analyzing data, providing reports, and doing market research. This role requires someone who can work independently, is a quick learner, and can balance multiple projects at once.

PRIMARY RESPONSIBILITIES

• Process accounts payable and accounts receivable transactions including monthly statement reconciliation
• Maintain records of financial transactions in Quickbooks Online
• Process bi-weekly payroll using ADP Workforce Now
• Generate year-end 1099s for vendors
• Calculate commissions payments
• Mining data from our CRM system, Salesforce, and other data sources to obtain client demographics and cross-sell opportunities
• Assist with energy procurement bid compilation and competitive rate analysis
• Reconcile supplier commissions payments and analyze forecast versus actual payments received
• Prepare utility incentive payments
• Develop data collection templates to facilitate reporting of key performance indicators
• Develop queries for databases such as SalesForce and Microsoft Dynamics
• Perform data transformations required to enable reporting from existing datasets
• Perform data quality checks and assist with data collection as needed
• Craft and manage data imports into data visualization tools
• Develop reports using PowerBI or other visualization tools
• Manage databases such as SalesForce and Microsoft Dynamics for optimal data collection and configuration
• Assist with other projects and assignments as needed

QUALIFICATIONS

• Bachelor's Degree is preferred but not required
• Experience with Quickbooks Online a must
• Strong understanding of accounting principles
• Handle confidential information with discretion
• Customer-centric mindset
• Advanced experience in MS Excel, including pivot tables, lookups and macros
• Intermediate experience in MS Word, PowerPoint, and Access is essential
• Salesforce.com data mining skills
• Strong attention to detail, time management, organizational and prioritization skills.
• Demonstrated ability to effectively manage deadlines and projects with competing priorities
• Excellent written and oral communication skills. Strong attention to detail. Demonstrated ability to effectively communicate to technical and non-technical audiences
• Possess solid quantitative, analytical, and problem-solving skills
• Outstanding interpersonal skills. Demonstrated ability to connect quickly with others and work effectively at all levels within and outside of the organization, including vendors and business partners
• Strong conflict resolution skills
• Ability to work well in a fast-paced environment under pressure in time-critical situations and be productive and self-motivated during slow periods

PREFERRED QUALIFICATIONS

• Data Visualization skills (PowerBI or similar)
• Experience with ADP Workforce Now payroll
• Salesforce customization – building reports and dashboards
• Some coding experience – Python, Ruby, etc.

BENEFITS:

MD Energy Advisors offers competitive salaries and benefits. We put a premium on work-life balance, offering flexibility with our remote team. We also offer:

• Medical, dental and vision health insurance
• 401k
• Paid time off and paid holidays
• Wellness Reimbursement
• Professional Development Reimbursement
• Regular team meetings and in-person gatherings

Maryland Energy Advisors is an Equal Opportunity Employer/M/F/Disability/Vet.