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