SQL/ETL Developer

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