SQL/ETL Developer

NOCO Energy-posted 3 months ago

$85,000 - $95,000/Yr

Buffalo, NY

251-500 employees

Wholesale Trade Agents and Brokers

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

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.

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

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

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

Track Jobs with Teal

Job Search Resources

•

AI Resume Builder

•

ETL Developer Resume Examples

•

ETL Developer Cover Letter Examples

SQL/ETL Developer

Job Search Resources

Tools

Career Hubs

Guides

Company