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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonScalaETLdata integrationdata transformationdata analysisdatabase queriesreportingdata pipelines

Soft Skills

collaborationcommunicationproblem-solvingattention to detailstakeholder engagementanalytical thinkingorganizational skillsquality assuranceadaptabilitytime management