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 Business Intelligence Developer designs, develops, and maintains data pipelines for multiple systems in support of Business Intelligence solutions.

WHERE YOU COME IN

As the Business Intelligence Developer you will:

• Provides data consolidation and information collation services across all Enterprise Systems into a central repository for accurate reporting.
• Develops, implements, and executes data pipelines for integration between external sources of data and the Enterprise Data Warehouse.
• Uses various other ETL and reporting tools, writes code, and creates jobs for automation of tasks.
• Reviews business requirements to build or modify database queries to meet the organization's needs.
• Partners with stakeholders to ensure accurate, high-quality design and delivery of data in support of the Foundation’s analytics needs.
• Partners with Application and Technology peers to ensure accurate and efficient design of data integration and related reports and recommend new reporting strategies and application data improvements.
• Performs test cases to ensure routines meet stated business objectives before moving into a production environment.
• Performs analysis of data, maintains data-integration maps, and creates and performs data transformations on data, both in-place and in motion.
• Performs other job-related duties, as assigned.

WHAT YOU’LL NEED

• Bachelor’s degree in Computer Information Systems or related field required or equivalent work experience.
• Minimum of 3 years of SQL development experience required, Azure SQL/Data Warehouse preferred.
• Proficiency in programming languages (Python, Scala)
• Proven experience with ETL tools required, Azure Data Factory/Data Pipelines preferred.
• Experience in Azure DevOps.
• Experience with Reporting solutions, Power BI/Fabric preferred.
• Experience with CRM products such as Salesforce, NetSuite preferred.
• Advanced knowledge of Microsoft Office applications required.
• 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
• The organization will send a laptop, 24” monitor, and a docking station/adaptor to new hires

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.

Trouble submitting an application?

We’re thrilled that you’re interested in joining our mission! If you’re experiencing any hiccups while submitting your application, don’t worry – technology can be tricky sometimes. Here are a couple of quick tips to help you out:

• Clear Your Cache and Cookies: Sometimes, a fresh start is all you need. Clearing your browser’s cache and cookies can often resolve submission issues.
• Try a Different Browser: If clearing your cache doesn’t do the trick, switching to another browser might help. Browsers like Chrome, Firefox, Safari, or Edge are all great options.

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.

Required Skills

Required Experience