Lead Manager, Business Intelligence Developer

Who We Are: 

Our vision is to grant the wish of every eligible child. Through our mission, we are uniting communities to grant life-changing wishes. As the world’s largest wish-granting organization, we strive to create a sense of community and an environment where we warmly embrace our wish families, volunteers, and colleagues.

Joining Make-A-Wish means becoming part of a mission that believes in the power of a wish.  

Location:

Remote positions are open to applicants based anywhere in the continental U.S. Hybrid positions are open to applicants based in the Phoenix, Arizona area. 

Applicants must be authorized to work for ANY employer in the U.S. We do not sponsor employment visas or other immigration processes to attain or maintain employment eligibility.

Position Summary:  

Design, develop, and maintain data pipelines for multiple systems in support of Business Intelligence solutions. Design, build, implement, and monitor solutions for data storage and processing. Troubleshoot and resolve technical and data issues to deliver accurate, timely, consistent, and insightful information for business analysis.

Knowledge and Abilities:

• Experience with ETL data integration.
• Experience with data warehouse and reporting solutions.
• Experience with DevOps and CI/CD.
• Experience with Report Development.
• Demonstrated successful problem-solving abilities.
• Proficiency in research and data analysis.
• Possess strong written and verbal communication skills.
• Engage effectively with professionals at all levels of the organization.
• Organize work, prioritize, and meet deadlines, and make timely decisions with sound judgment.

Duties and Responsibilities:

• 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.

Qualifications:

• 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.

Working Conditions:

• Ability to thrive in a remote environment.
• Some travel required.
• May on occasion require work outside a traditional Monday – Friday work week, and outside of normal business hours.

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 America
• 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   
• Parental 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.