Data Analyst

American Power & Gas; Town of Florida (NY); On-site; USD 65,000 - 95,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Optical/Vision insurance

Life Insurance

Paid Time Off (PTO)

Promotions opportunities

Job summary

American Power & Gas is hiring a Data Analyst for a full-time, on-site role. You will build data-driven insights, develop measurement frameworks, and partner with marketing, sales, and operations to drive performance.

You will work with Power BI, SQL, Looker, and Tableau to deliver trends, forecasts, and actionable recommendations. A strong English communicator with Excel expertise will thrive in our fast-paced environment.

Qualifications

• University degree or college graduate in Business, Economics, Statistics, Marketing, Social Sciences, or the equivalent hands on experience in Marketing Analytics.
• 1 to 3 years of experience with data, reporting and analysis in a quantitative business environment – experience in Sales and Marketing organizations preferred.
• Experience using data visualization tools like Power BI, Looker, Tableau to report on KPIs and trends.
• Advanced Microsoft Excel skills; pivot tables, calculated metrics, conditional logic, VLOOKUP.
• Solid understanding of database structure, schema design, joins, deduplication, aggregation, and SQL queries.
• Excellent English written and verbal communication; ability to adapt language for stakeholders.

Responsibilities

• Familiar with Power BI and data analytics.
• Develop measurement frameworks that outline definitions of success and test prioritization.
• Represent Analytics in cross-functional status and reporting meetings.
• Provide performance trends reporting, forecasts, and insights for marketing and sales leaders and senior management.
• Partner with cross-functional teams to identify analytics opportunities and develop tools for performance improvements.
• Design and implement a lead distribution framework for lead quality scoring and pipeline management.
• Develop predictive models and proformas to anticipate issues and identify growth opportunities.
• Collaborate with Operations to optimize data workflows from sourcing to reporting.
• Develop, enhance, and manage analytical solutions supporting business objectives.
• Determine data needs and how to consume and store data to support reporting and ad hoc analysis.
• Analyze data across marketing channels and customer journey including website analytics, call center activity, and CRM.
• Meet analytics deliverable timelines and adapt deliverables to stakeholder audiences.
• Troubleshoot and QA data, reporting, and tracking with proactive communication.
• Mentor new/junior team members and promote cross-functional collaboration.
• Relentlessly challenge status quo to improve efficiency.
• Provide ongoing client service to internal customers to elevate business performance.

Skills

Data analytics

Excel advanced

English communication

Critical thinking

Problem solving

Project management

Entrepreneurial mindset

Education

University degree in Business or related field

Tools

Power BI

Looker

Tableau

SQL

Excel (Pivot, VLOOKUP)

Job description

Because of expansive growth American Power & Gas is seeking a Data Analyst to add to our technical team. This is a fulltime permanent on-site role.

We have been offering Green Energy solutions to both residential and small commercial customers for over 25 years and have won the award for fastest growing company in the Tampa Bay Business Journal as well as being featured in Forbes and the Huffington Post.

Key Responsibilities

• Familiar with Power BI and data analytics.
• Understand core business challenges and develop relevant measurement frameworks that outline definitions of success, mid-campaign optimization levers and test idea prioritization.
• Routinely represent the Analytics department in cross-functional status and reporting meetings.
• Provide regular performance trends reporting, forecasts, and insights for marketing and sales team leaders as well as senior executive management to maintain a tight finger on the pulse of emerging performance trends and opportunities.
• Partner with internal cross functional teams to identify business needs and analytics opportunities, developing tools and techniques to analyze and provide performance-improving recommendations.
• Establish a data driven framework for designing and implementing a lead distribution strategy to be utilized as the blueprint for executing processes in lead quality scoring and sales rep pipeline management to maximize sales results.
• Develop predictive models and proformas for leadership to proactively manage the business – anticipating lead and sales issues before they occur, capitalize on opportunities to improve performance, drive growth, create what-if scenarios to predict future results, ultimately providing senior management with recommendations for the next course of business decisions.
• Partner with the Operations team to optimize data workflows from sourcing to storage to reporting to deliverables to maximize for value-added and time-efficiency.
• Develop, enhance, and manage various analytical solutions in support of business objectives.
• Determine what data is needed and how to consume and store this data to support reporting needs and ad hoc performance-improving analysis for internal stakeholders.
• Regularly work with and analyze data across marketing channels and the customer journey through website analytics, call center activity, and CRM systems.
• Play an active role in ensuring all Analytics deliverable timelines are met, working collaboratively as needed.
• Ensure deliverables are adapted properly to stakeholder audience; adapting terminology and visuals as needed to “speak the stakeholder’s language", thus communicating with maximum effectiveness.
• Troubleshoot and QA data, reporting, and tracking anomalies as needed, with proactive communication to stakeholders.
• Mentor new/junior team members and providing a “hands-on, roll-up-your-sleeves” mentality toward partnering cross-functionally with teammates at various levels within the organization.
• Relentlessly challenge the status quo. Always be critical of how we can be more effective or more efficient as an individual, as a team, and as a business.
• Provide ongoing and proactive client service to your internal customers as required to continue elevating the performance of the business.

Requirements

• University degree or college graduate in Business, Economics, Statistics, Marketing, Social Sciences, or the equivalent hands on experience in Marketing Analytics.
• 1 to 3 years of experience working with data, reporting and analysis in a quantitative business environment – experience in Sales and Marketing organizations strongly preferred.
• Experience using data visualization tools like Power BI, Looker, Tableau, etc. to report on KPIs and facilitate communication of trends and insights.
• Advanced Microsoft Excel skills; very comfortable with pivot tables, calculated metrics, conditional logic, and VLOOKUP functions.
• Solid understanding of database structure and functionality is required, including schema design, join keys, deduplication approaches, and aggregation techniques, with the ability to write and execute the appropriate SQL queries that retrieve accurate answers to the questions you are asking from the data.
• Excellent troubleshooting skills and attention to detail. Must be able to resolve issues tied to capturing and processing data in a timely manner and have the ‘spidey-senses’ to proactively feel when something is off in the data.
• Exceptional critical thinking and problem-solving skills; able to distill overall objectives into the actionable steps required to achieve those objectives.
• Excellent English written and verbal communication skills with the ability to adapt language as needed to suit stakeholder audience, as well as present your data driven recommendations and defend your rationale.
• Capable of effectively managing projects, priorities, timelines, and working relationships.
• Must possess the intellectual curiosity to succeed in a dynamic, entrepreneurial, fast paced, sales driven organizational culture.
• Excited by the opportunity to disrupt the status quo and uncover the eureka moment insights that will take the business to the next level – proactively searching for problems to solve, knowing there is so much to learn.

We offer Health, Dental, Optical and Life Insurance, PTO (paid time off) and the opportunity for promotions and room to advance.