Lead Manager, Business Intelligence Developer

Posted 38ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Lead Manager designing and maintaining data pipelines for Business Intelligence solutions. Developing strategies for accurate reporting and data integration at Make-A-Wish America.

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.

Requirements:

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

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