ConnectLife helps people help others. As a federally designated, not-for-profit organ procurement organization and community blood bank, we save and enhance lives through organ, eye, tissue, and blood donation. A career with ConnectLife, no matter what job you do, is an opportunity to make a difference in WNY through educating the community, inspiring donation, and connecting lives.

We are hiring for a Business Intelligence Developer

Location: ConnectLife Headquarters at 4444 Bryant and Stratton Way, Williamsville, NY 14221

Pay:

Exempt

Salary Range: $90,000.00 -$111,000.00 annually

Pay will commensurate with relevant qualifications, skills, and experience.

Status: Full Time
Schedule: Monday - Friday, Standard Office Hours; after-hours on-call requirement for 1 week, occurring every 5 weeks

Job Summary

Provide business decision reporting and analytics to advance overall operations. Primary responsibilities include working with IT team and stakeholders to support business decision needs, develop data models, data warehouse and ETL operations, write SQL queries, views, stored procedures and functions, create reports/dashboards, monitor and maintain data systems, and assist with process improvement efforts.

Education Requirements:

Bachelor’s degree in Computer Science, or related field required.
Professional certifications in a related field a plus.

Experience:

2+ years experience as Developer in Business Intelligence, Report, SQL, Power BI or Data Engineer roles
2+ years working with SQL databases
Experience in Microsoft Azure and BI services preferred
Other software development experience helpful, especially Visual Basic and Power Apps

Knowledge, Skills and Abilities:

Programming skills in T-SQL and proficiency with SQL Server DB management mandatory
Microsoft Power BI skills strongly desired
Competency with SQL Server Integration Services SSIS preferred
Proficiency with SQL Server Analysis Services SSAS desired
Experience working in a collaborative team environment strongly preferred
Ability to deliver results of analyses in a clear and effective manner to all levels of technical expertise
Required to work on multiple concurrent projects of varying scope and scale
Excellent attention to detail, quality, and follow-through; commitment to continuous improvement and the elimination of performance variability
Demonstrated ability to adapt to rapidly changing requirements with a flexible and creative approach to brainstorming, troubleshooting, and problem solving

Required Physical Demands:

Continuous sitting, over 65% of the time.
Occasional standing, walking, bending, squatting, and kneeling.
Frequent lifting, carrying, pushing, pulling up to 10lbs. Occasional lift, carry, push, pull up to 50lbs.
Frequent reaching forward. Occasional reaching lateral and overhead.
Continuous receiving detailed information through written, electronic, and oral communication.
Frequent clarity of vision at near and/or far distances.

Essential Job Functions:

Create and Maintain Business Intelligence data solutions while looking for opportunities for improvement.
Design and develop business data structures and processes for analyses and reporting that answers key business questions and develops a coherent story.
Working collaboratively with stakeholders to translate business needs into technical specification.
Design, code, test, document, implement, and maintain data models, SQL components like queries, views, stored procedures, functions, and triggers.
Design, code, test, document, implement, and maintain ETL (extract, transform, load) processes for data bases and data warehouses to provide aggregate business insights.
Administer, maintain, and follow best practices and standards around data governance, security, and privacy.
Produce ad-hoc queries and analysis, and related duties as assigned.
Create and maintain technical documentation and data dictionaries.
Participate in the IT department’s on-call rotation.
Responds to questions and assists stakeholders in understanding report results; files issue reports on behalf of stakeholders, as needed.

What We Offer

Health Insurance
Employer Sponsored Dental & Vision insurance
Employer Sponsored Life insurance
Paid vacation & sick time on an accrual basis beginning on day 1
401(k) after one year of service with 3% employer contribution
Employee Referral Bonuses
Mileage Reimbursement
Pet insurance
And more!

Learn more about this Employer on their Career Site