Power BI Developer

Job Description:

WHY CHOOSE US?
Joining The American Red Cross is like nothing else - it's as much something you feel as something you do. You become a vital part of the world's largest humanitarian network. Joining a team of welcoming individuals who are exceptional, yet unassuming. Diverse, yet uncompromising in unity. You grow your career within a movement that matters, where success is measured in people helped, communities made whole, and individuals equipped to never stop changing lives and situations for the better.

When you choose to be a force for good, you'll have mentors who empower your growth along a purposeful career path. You align your life's work with an ongoing mission that's bigger than all of us. As you care for others, you're cared for with competitive compensation and benefits. You join a community that respects who you are away from work as much as what you do while at work.

WHAT YOU NEED TO KNOW ABOUT THE JOB:
The Business Intelligence (BI) Developer plays a pivotal role in delivering data-driven insights that inform strategic decisions and enhance operational efficiency across all lines of business. This position supports key initiatives in areas such as Hospital Sales, Blood Collections, and Consumer Fundraising.

Working collaboratively with internal teams and external partners, the BI Developer designs and refines interactive dashboards and reports, translating complex data into meaningful visualizations. The role also involves conducting in-depth analyses to uncover trends and opportunities that support both strategic planning and marketing efforts.

Ideal candidates will bring substantial experience in Power BI model development, writing queries, building semantic models, data modeling, etc. Successful candidates will also demonstrate the ability to work cross-functionally with staff, volunteers, and IT professionals to implement impactful analytics solutions.

The work location for this position is 100% virtual/work from home. While the position can be worked from anywhere in the United States, the preferred work hours are on an East Coast schedule. Standard work hours are: 8am - 6pm Monday - Friday.

WHERE YOUR CAREER IS A FORCE FOR GOOD (Key Responsibilities):

Principal Responsibilities:
* Collaborates with stakeholders and subject matter experts to create new and enhance existing business intelligence assets, principally through Power BI.
o Contributes clarity of business needs and evaluates feasibility of technical solutions by delivering functioning BI prototypes and enterprise-grade Power BI semantic models, dashboards and reports.
o Analyzes and sources data from business applications, enterprise data warehouse (Amazon Redshift) and alternate business intelligence platforms (e.g., SAP Business Objects Webi).
o Develops and delivers end user dashboards with effective visualizations that quickly convey actionable information tailored to stakeholder needs.

* Conducts deeper analyses to identify areas for improving decision support and operational effectiveness and evaluates data to deliver research findings & recommendations for increasing revenue, reducing costs and enhancing customer satisfaction.
* Maintains existing BI assets as business needs and/or technical infrastructure evolve, often in coordination with IT staff who support data integration and enterprise data warehouse assets.
* Serves as a key data resource for insights & visualizations related to hospital sales and product management, fulfilling ad hoc information requests.
* Assists with data integration efforts related to the modernization and automation of run-and-maintain reporting, with the goal of increasing self-service utilization, decreasing data latency / time to market, and maximizing data-driven insights.

Secondary Responsibilities:
* Provides analytic support to program managers and vendors as requested to identify opportunities to improve available source system data for reporting & analyses.
* Collaborates with marketing colleagues and product managers to research & identify market trends and conduct competitive analysis.
* Collaborates with IT staff on the enhancement of analytics platforms and data assets, including design, development and testing activities.
* Support Power BI solutions, including advocacy & end user adoption as well as conversion of legacy reports to current BI standards.
* Collaborate with data science colleagues, leveraging knowledge of performance measures to help evaluate opportunities to incorporate machine learning into analytics and data visualization products.
* Performs related duties as assigned.

Scope Responsibilities:
* Internal organizational contacts include Fundraising, Corporate Marketing, Biomedical Services, Volunteer Services, Finance, and field teams.
* External contacts include vendors and hospital customer personnel.
* Works with confidential and proprietary information.

Scope: Individual contributor that works under limited supervision. Apply subject matter knowledge. Capacity to understand specific needs or requirements to apply skills/knowledge.

Note: Qualified candidates must be authorized to work in the United States. The American Red Cross does not sponsor employment visas.

WHAT YOU NEED TO SUCCEED (required/minimum qualifications):
* Bachelor's degree (or equivalent experience / certification) in Computer Science, Mathematics, Data Analytics, Marketing, Finance, or a relevant field.
* A minimum of five years of analytics experience, including at least three years of semantic model development.
* Familiarity of the marketing process: project management, market segmentation, targeting, and pricing.
* Demonstrated knowledge of relational database and statistical analysis, dimensional modelling and data warehouse concepts.
* Strong background with analytic & visualization tools, including Microsoft Power BI or equivalent, and Microsoft Excel.
* Strong database and analytic skills, with an emphasis on PostgreSQL, DAX and M/ Power Query.
* Strong background in development of semantic models built against an enterprise data warehouse.
* Familiarity with data visualization and dashboard design concepts & best practices.
* Aptitude for & familiarity with basic statistical analysis (frequency distribution, variance analysis).
* Knowledge of relational data warehouse environments & SQL is required (PostgreSQL preferred).
* Excellent written and oral communication skills.
* A high degree of organization and coordination.
* Ability to work under pressure.
* Ability to work collaboratively with a variety of stakeholders.

WHAT WILL GIVE YOU A COMPETITIVE EDGE (preferred qualifications):
* Knowledge of enterprise data warehouses, particularly Amazon Redshift.
* Knowledge of SAP Business Objects (Webi) desirable but not required.
* Familiarity with additional programming languages (Python, R) is desirable.
* Exposure to any of the following is a plus: process improvement (e.g., Lean Six Sigma), user experience, customer journey methods.

* Combination of candidate's education and general experience satisfies requirements so long as the total years equate to description's minimum education and general experience years combined (Management experience cannot be substituted).

PHYSICAL REQUIREMENTS
Physical requirements are those present in normal office environment conditions. Operational flexibility to meet sudden and unpredictable business needs and willingness to work outside standard established business hours are necessary. A minimal amount (0-10%) of business travel may be required.

+++++++++++++++++++++++++++++
PAY INFORMATION:
The annual salary range for this position is $82K - $90K. We do not offer an annual bonus for this role.

Note that American Red Cross salaries are aligned to the specific geographic location in which the work is primarily performed. Other factors that may be used to determine your actual salary may include your specific skills, how many years of experience you have and comparison to other employees already in this role. **We will review specific salary information at the time of phone screening based upon your location & experience.**

This job will be posted for a minimum of five business days and extended if the applicant pool needs to be expanded.

BENEFITS FOR YOU:
As a mission-based organization, we believe our team needs great support to do great work. Our comprehensive package includes:
* Medical, Dental Vision plans
* Health Spending Accounts & Flexible Spending Accounts
* PTO: Starting at 19 days a year; based on type of job and tenure
* Holidays: 11 paid holidays comprised of six core holidays and five floating holidays
* 401K with up to 6% match
* Paid Family Leave
* Employee Assistance
* Disability and Insurance: Short + Long Term
* Service Awards and recognition

*LI-EH1

The American Red Cross is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law.

Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers, San Diego Fair Chance Ordinance, the California Fair Chance Act and any other applicable state and local laws.

AmeriCorps, the federal agency that brings people together through service, and its partners - the Peace Corps, AmeriCorps Alums, National Peace Corps Association, and the Service Year Alliance - launched Employers of National Service to connect national service alumni with opportunities in the workforce.American Red Cross is proud to be an EONS partner and share our employment opportunities with the network of organizations.

Interested in Volunteering? Visit redcross.org/volunteertoday to learn more, including our most-needed volunteer positions.

To view the EEOC Summary of Rights, click here: Summary of Rights