SQL/ETL Developer
NOCO Energy Corp
On-site
Buffalo, New York, United States
$85,000 - $95,000 USD yearly
Development
Position: SQL/ETL Developer
Location: Buffalo, NY
Compensation: $85,000 - $95,000
What We Are Looking For
We’re seeking a dynamic and forward-thinking Data Solutions Developer to join our lean, agile enterprise. This role is pivotal in delivering high-quality, modern data solutions by collaborating closely with our analysis, application development, and project management teams. Leveraging Microsoft Fabric and other cutting-edge technologies, this person will help redefine application data workflows that share data across numerous applications. This position is ideal for someone who thrives on solving a wide range of business challenges, enjoys interfacing with stakeholders, and brings an innovative mindset to data strategy and execution. A deep expertise in at least one modern programming language and a passion for continuous learning as new tools and technologies emerge.
What Will You Do
- 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
What You Will Need
- 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
- Well versed with web services, utilizing public API of utility companies and government agencies preferred.
- Familiarity with public APIs from utility companies and government agencies preferred
- 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
What We Offer
- Competitive compensation package
- 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