Advanced SQL Developer

American Power & Gas is seeking an Advanced SQL Developer 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 20 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.

• Support operational executives in solving business problems by designing, developing, troubleshooting, and implementing data driven solutions to complex technical objectives.
• Identify, design and implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
• Deploy sophisticated analytics programs, machine learning and statistical models to predict business outcomes and continually optimize performance through data science.
• Gather and summarize technical requirements associated with strategic business initiatives.
• Document, maintain, support and enhance company technology platforms and analytics applications.
• Look for opportunities to streamline and automate various reporting processes to help support internal teams.
• Assist with the research and development of internal business case studies to support onboarding new data tools.
• Extract, manipulate and cleanse raw data from various data sources – call center, web, and CRM systems.
• Work independently as well as collaboratively with other team members and key stakeholders as required to troubleshoot and resolve data issues.
• Provide comprehensive technical and consultative services to support development and maintenance of internal and third‑party platforms.
• Create functional test cases/criteria to verify all functionality adheres to specifications and create end user manuals.
• Routinely represent the Analytics department in cross‑functional status & data strategy meetings.
• Assist business analysts in provision of 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.
• 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.
• 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.
• 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.
• Regularly work with and analyze data across marketing channels and the customer journey through website analytics, call center activity, and CRM systems.

• Proficiency with coding in SQL is required. Ability to also write in Python, R, Java, or similar programming languages is preferred.
• Strong technical prowess, including an understanding of algorithms, systems architecture and end user experience.
• Experience with modern source, build, and deploy tools such as Git, Grub, Maven, Yeoman, etc. is a plus.
• Experience with data warehouse design, relational databases, SQL/No
  
  SQL data modeling, RESTful API standards and large‑scale data processing solutions.
• Demonstrated skill in database development with solid understanding of schema…