Advanced SQL Developer

American Power & Gas LLC; Town of Florida (NY); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Paid Time Off

Dental, Health, and Vision Insurance

Weekly Pay

Job summary

American Power & Gas LLC is seeking an Advanced SQL Developer to join their technical team in the Town of Florida, New York. This full-time permanent role involves designing and implementing data-driven solutions to support operational initiatives and enhance company technology platforms.

The ideal candidate must be proficient in SQL and have a strong understanding of various programming languages and data management techniques. Competitive salary and benefits package offered.

Qualifications

• Proficiency with coding in SQL is required.
• Strong technical prowess, including understanding of algorithms and systems architecture.
• Experience with relational databases and large scale data processing solutions.

Responsibilities

• Support operational executives in solving business problems with data-driven solutions.
• Identify, design and implement internal process improvements.
• Deploy analytics programs to optimize performance through data science.

Skills

SQL

Python

R

Java

Data Warehouse Design

ETL Processes

Git

NoSQL Data Modeling

Job description

American Power & Gas is seeking an Advanced SQL Developer to add to our technical team. This is a full-time 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.

Key Responsibilities

• 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.

Requirements

• 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/NoSQL data modeling, RESTful API standards and large scale data processing solutions.
• Demonstrated skill in database development with solid understanding of schema design, stored procedure development, query optimization and ETL processes.
• Excellent troubleshooting ability. Must be able to resolve issues tied to capturing and processing data in a timely manner.
• Excellent English written and verbal communication skills, especially explaining technical concepts to non-technical business leaders.
• Exceptional critical thinking and problem-solving skills; able to distill overall objectives into the actionable steps required to achieve those objectives.
• 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.

Location: Tampa Bay Area (In-house position)

Schedule: Monday - Friday, 8:30 am - 5:00 pm

Salary: Competitive, based on experience

Benefits

• Paid Time Off
• Dental, Health, and Vision Insurance
• Weekly Pay

Ready to Take the Next Step?

Please contact the Director of Personnel: [e-mail]