NOCO Energy Corp. · 1 month ago
SQL/ETL Developer
Buffalo, NY
Full-time
Onsite
Mid, Senior Level
$85K/yr - $95K/yr
7+ years expNOCO Energy Corp. is seeking a dynamic and forward-thinking Data Solutions Developer to join their agile enterprise. This role is pivotal in delivering high-quality data solutions by collaborating with various teams and leveraging cutting-edge technologies.
Oil & Energy
Responsibilities
Design, develop, validate, debug, and support robust database and ETL solutions
Build dimensional data warehouses using SSIS and other tools
Migrate data from diverse sources into centralized repositories
Analyze data flows, define mapping criteria, and ensure data accuracy
Cleanse and transform data for seamless system integration
Validate post-migration data integrity and performance
Document strategies, processes, and fixes with precision
Maintain and optimize existing ETL and integration workflows
Research and recommend tools to address evolving data analysis challenges
Create and manage technical documentation and revision histories
Support enterprise-wide data governance and quality assurance
Audit existing systems, identify improvement areas, and implement fixes
Strategize data movement and content conversion with risk awareness
Test new systems and migrated data for errors and corruption
Perform other related duties as assigned
Qualification
Required
Minimum of seven (7) years' experience in Information Technology of which five (5) years' experience is working as a Data Developer in a large data warehouse and business intelligence environment
Minimum of five (5) years' experience writing and tuning advanced SQL
Minimum of five (5) years' experience working with data development technologies
Minimum Five years experience with ETL (Extract Transfer and Load) development which includes Microsoft Reporting Services, Microsoft Visual Studio, MS SQL Server Management Studio
Minimum 2 years' experience with Azure Data Factory and hands on experience with Azure PaaS services
Experience designing, building, and implementing PowerBi solutions
Advanced knowledge of .Net coding standards, Visual Studio, C#, DHTML, XML, SQL
Strong understanding of application dependencies and web services
Excellent critical thinking and innovative skills when developing technical solutions to meet business needs
Commitment to integrity and ethical behavior and the proven ability to maintain confidentiality
Self-starter who can work independently or part of a larger team
Ability to display a strong sense of urgency and passion for providing exceptional customer service
Customer and goal focused – needs to understand the importance of innovation to the business and be willing to apply himself / herself when required
Ability to work with minimal supervision in a fast paced, dynamic environment
Strong troubleshooting and problem-solving skills
Ability to successfully manage organizational change by the transformation of people, processes, and systems
Ability to sit for prolonged periods at a desk and work on a computer
Must be able to Lift up to 10 pounds at a time
Preferred
Well versed with web services, utilizing public API of utility companies and government agencies
Familiarity with public APIs from utility companies and government agencies
Benefits
Generous medical insurance offerings
Dental and vision plans
Company-paid life insurance
Company-paid short-term disability
401(k) with company match
Health savings accounts
Generous Paid Time Off policies
7 paid holidays
Employee and family assistance program
Company
NOCO Energy Corp.
With a rich history spanning more than 90 years, NOCO is a leading full-service energy company servicing customers across Upstate New York.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Michael A. Casciano
Chief Operating Officer
Deborah Coder
Chief Credit Officer & Dir. of Credit Services
Recent News
2024-04-25
Company data provided by crunchbase