Job Description

About the Company:

Our client is an industry leader with 20+ locations and 1000 employees in the US and abroad. If you are looking for an employer that is growing and is committed to embracing state of the art technology this is the job for you!

Our client was named to Fortune's List of the Country's 100 Best Workplaces with multiple recognitions for excellence in their industry.

Our client believes in building on your strengths and creating a path for you to achieve your career goals.  No micromanagement here!

* HYBRID work schedule - (2 days in Buffalo area office)

About the Job:

As part of the BI team, the  BI Developer is a  SQL & Data Integration Specialist.  You'll play a key role in optimizing applications, ensuring data integrity, and enhancing system performance. You will manage large, complex datasets, integrations, and Microsoft Power BI  to help the business reach their reporting and analytics goals. This is an exciting opportunity to leverage your SQL expertise, collaborate with cross-functional teams, and drive meaningful improvements in business processes.

�� Master the Data – Gain in-depth knowledge of company's SQL database structure, relationships, and business applications to provide expert-level data analysis and maintain data integrity.

�� Maintain, Enhance & Customize Reports & Dashboards  – Design and implement enhancements, customizations, and integrations based on business needs, working closely with management and key stakeholders.

�� Hands-On Development & Testing – Utilize Microsoft SQL Server tools (SSRS, SSIS) to build and maintain stored procedures, triggers, ETL processes, and data models. Perform rigorous quality assurance and regression testing before deployment.

�� System Support & Optimization – Monitor integration and automation performance, troubleshoot issues, and recommend improvements to optimize system efficiency. Provide second-level support for integrations and escalate critical issues when necessary.

�� Project Management & Collaboration – Lead and contribute to internal and external projects, managing tasks, tracking progress, and ensuring accurate documentation. Partner with management and business teams to evaluate and refine system requirements.

�� Documentation & Best Practices – Maintain comprehensive records, document workflows, methodologies, and assumptions to support ongoing development and operational efficiency.

What We’re Looking For:

• Bachelor’s Degree or equivalent experience
• 5+ years of experience working and supporting SQL applications 
• 3+ years developing reports using SSRS
• 3+ years using ETL tools such as SSIS
• 3+ years using visual analytical tools such as Power BI

 

✔ SQL Expertise – Strong experience creating large, complex data sets / schemas with T-SQL development, including stored procedures, triggers, and ETL processes.

✔ Microsoft SQL Server Proficiency – Hands-on experience with SQL Server 2016+ and its suite of development tools (SSRS, SSAS, SSIS, SSIS Catalog).

✔ Integration & System Management – Knowledge of SQL Server security, performance monitoring, and management tools. Experience designing and supporting system integrations.

✔ Technical Problem-Solving – Skilled at troubleshooting system issues, performing root-cause analysis, and optimizing performance.

✔ Project Management Skills – Ability to manage projects, track progress, and collaborate effectively with internal teams and external vendors.

If you’re a proactive problem-solver who thrives in a dynamic environment and enjoys working with data, integrations, and system enhancements, we’d love to hear from you!