At Make-A-Wish® America, we are more than a great place to work — our work is life-changing. Together, we create life-changing wishes for children with critical illnesses. Nearly 40 years ago the inspiration for Make-A-Wish began with one little boy's wish to be a police officer. Today, together with our volunteers, donors, staff and supporters, Make-A-Wish has granted more than 500,000 life-changing wishes and transformed countless lives. 

THE TEAM 

Make-A-Wish America is the national headquarters for our organization, providing resources and support for our 60 Chapters around the country. The Information Technology team is comprised of a diverse team of technologists responsible for building and operating the technologies that enable Make-A-Wish to grant the wish of every eligible child. The Information Technology team is focused on providing innovative solutions across these key areas: Operations, Security, Applications, Infrastructure. 

THE ROLE 

The Senior Business Intelligence (BI) Developer’s role is to strategically design and implement BI software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users. The Business Intelligence Specialist is also responsible for ensuring high levels of BI availability through support functions and in-depth testing. 

WHERE YOU COME IN 

As the Senior Business Intelligence Developer you will:  

•          Direct, organize, and lead projects in the implementation and use of new BI software tools and systems, such as MS Power BI.
•          Lead the integration efforts for merging BI platforms with enterprise systems and applications.
•          Design, code, test, and document all new or modified BI systems, applications, and programs.
•          Develop the semantic layer, metadata, reports, and report definitions.
•          Develop graphs and portal interfaces, including static and interactive reports and dashboards.
•          Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.
•          Analyze user requirements and based on findings, design functional specifications for BI front-end applications.
•          Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
•          Work with project managers to ensure that data entry, retrieval, change, and delete functions meet business requirements for project completion.
•          Conduct job duties and responsibilities according to the organization’s business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology.
•          Design and deliver end-user training and training materials; provide technical support as necessary.
•          Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.
•          Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.
•          Mentor and/or provide leadership to junior members of the team.

 WHAT YOU’LL NEED  

• College diploma or university degree in the field of computer science, information systems, or computer engineering preferred.
• Certifications in relation to BI development and data analytics is highly desirable.
• 5+ years of Microsoft SQL and report writing experience, including MS Power BI.
• 5+ years of experience with Microsoft ETL tools required.
• Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
• Experience with tier-one applications, databases, and data warehouses, such as MS SQL Server, Oracle DB, Enterprise ERP, Enterprise CRM, HRIS and so on.
• Experience with database design applications, including MS SQL Server/Azure/Data Factory.
• Experience with of Python/R is highly desirable.
• Position may require travel to organizational conferences and events 

WHAT WE OFFER 

BENEFITS 

• Comprehensive benefit package, effective day 1: Medical, Vision*, Dental*, Wellness
• Competitive compensation with annual incentive potential    
• Health Savings Account and Flexible Spending Account Options    
• Health Reimbursement Account fully funded by Make-A-Wish 
• Short Term Disability*, Long Term Disability* and Life Insurance 
• Additional Insurance Plans: Accident, Critical Illness, Hospital Indemnity, Pet Insurance through Figo 
• 401(k) Retirement Savings Plan with 5% match after one year of service
• Eligibility for student loan forgiveness through the Public Service Loan Forgiveness Program    

TIME OFF 

• Up to 15 PTO days 
• 10 Sick Days 
• 11 Paid Holidays 
• 2 Volunteer Days after one year of service 
• 2 Personal Days accrued annually   
• Maternity Leave      

ALSO... 

• Employee Awards and Recognition Programs    
• Individual and Leadership Development     
• Discounts and special offers for theme parks, events, hotels, concerts, and movie tickets   

*Monthly premiums paid for the employee for vision, dental, and short/long term disability. 

Diversity, Equity & Inclusion Vision 

Make-A-Wish is committed to championing diversity, equity and inclusion, fostering an organization that is accessible and welcoming. In turn, we are uniting communities to help make more wishes possible.

• Our mission is most effectively fulfilled through a commitment to diversity, equity and inclusion as core values and practice.
• It is only through our mosaic of different cultures, perspectives and experiences that we can grant life-changing wishes to every eligible child.
• As the world’s largest wish-granting organization we stand against racism and intolerance and are committed to representation and acceptance, creating a sense of belonging, and practicing fairness in creating opportunities for our wish families, volunteers and staff. 
• Diversity: Diversity at Make-A-Wish is about recognizing and valuing our differences as well as focusing on our shared meaning and humanity.​ Diversity is the collection of unique attributes both visible and invisible, traits, and characteristics that make up individuals. They include race, gender, abilities, values, beliefs, experiences, backgrounds, preferences, behaviors, socioeconomic status, physical appearance, age, sexual orientation/identity, and more.
• Equity: Equity at Make-A-Wish is ensuring all Wish Kids, families, and volunteers and our stakeholders, regardless of background, receive the resources and support to ensure highly impactful outcomes.
• Inclusion: Inclusion at Make-A-Wish is creating an environment where Make-A-Wish Kids and families, colleagues, volunteers, and stakeholders feel they are welcomed, respected, and valued, and those feelings are both real & perceived.
• Belonging: Belonging at Make-A-Wish describes the experience of being accepted, included, and respected by those around you.  You have a sense of community and connection with others and feel that your full potential is engaged in the Make-A-Wish mission.

We respect and ensure equal opportunity, regardless of race, religion, ethnicity, national origin, age, gender identity, sexual orientation, disability, perceived disability and other legally protected characteristics. Make-A-Wish America utilizes E-Verify in its hiring practices to achieve a lawful workforce.