[Hiring] Lead Manager, Business Intelligence Developer @Make-A-Wish America

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.