Business Intelligence Data Modeler

Job Description:

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.

WHERE YOUR CAREER IS A FORCE GOOD:

What You Will Do:

Key Responsibilities:

• Universe Design & Development: Develop, optimize, and maintain Business Objects Universes to meet the organization's reporting needs, ensuring data integrity, performance, and scalability.

• Requirements Gathering: Collaborate with business analysts and end-users to understand business requirements and translate them into technical specifications for universe design.

• Data Modeling: Design and implement data models within Business Objects that facilitate efficient and intuitive data access for end-users.

• SQL Development: Write, test, and optimize SQL queries to ensure efficient data retrieval and support complex reporting needs.

• Performance Optimization: Monitor and enhance the performance of Business Objects Universes, including query optimization, indexing strategies, and load balancing.

• Documentation: Maintain comprehensive documentation for all Universe design and development activities, including data mappings, table relationships, and query structures.

• User Support & Training: Provide support to end-users by troubleshooting issues, answering queries, and training users on Business Objects tools and Universes.

• Quality Assurance: Conduct rigorous testing to ensure accuracy, consistency, and stability of data within the Universes.

• Data Governance: Ensure compliance with data governance standards, including data privacy, security, and quality.

WHAT YOU NEED TO SUCCEED:

Qualifications:

• Education: Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field or combination of education and work experience.

• Experience:

  • 7+ years of experience in Business Objects Universe design and development.

  • Strong SQL skills with experience in complex query optimization.

  • Hands-on experience with relational databases such as SQL Server, Redshift, Teradata, or similar.

• Technical Skills:

  • Proficiency in SAP BusinessObjects Designer/Information Design Tool (IDT).

  • Familiarity with Business Objects reporting tools (e.g., Web Intelligence).

  • Knowledge of data modeling techniques and best practices.

  • Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.

• Soft Skills:

  • Strong analytical and problem-solving skills.

  • Excellent communication skills for collaborating with technical and non-technical stakeholders.

  • Ability to work independently and manage multiple priorities in a fast-paced environment.

Travel: May require some travel (approximately 10%-15%)

*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).

Pay Information: The salary range for this position is: $100,000 - $115,000 /annually.

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.

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 15 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

The American Red Cross is an Equal Opportunity/Affirmative Action 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