Business Intelligence Data Modeler - Military Veterans
at American Red Cross
As one of the nation’s premier humanitarian organizations, the American Red Cross is dedicated to helping people in need throughout the United States and, in association with other Red Cross networks, throughout the world. When you join our team, you have a direct impact on a meaningful mission, and you can help save lives every day. If you share our passion for helping people, join us in this excellent career opportunity. Work where your career is a force for good.
We are committed to the diversity of our workforce and to delivering our programs and services in a culturally competent manner reflecting the communities we serve. Our work environment is collaborative, respectful, and inclusive with a focus on building allyship and a culture of belonging that empowers all team members. Come to learn, grow, and succeed while sharing your passion for making a difference.
The Red Cross supports a variety of cultural and community resource groups for employees and volunteers. From the Ability Network, our Asian American & Pacific Islander Resource Group, the Latino Resource Group, and Red Cross PRIDE, to the Umoja African American Resource Group, our Veterans+ Resource Group, and the Women’s Resource Group, these networks provide connections, mentoring and help give voice to important concerns and opinions.
At the American Red Cross, your uniqueness can shine!
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 /anually.
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:
We take care of you, while you take care of others. As a mission-based organization, we believe our team needs great support to do great work. Our comprehensive benefits help you in balancing home and work. With our resources and perks, you have amazing possibilities at the American Red Cross to advance the learn.
Medical, Dental Vision plans
Health Spending Accounts & Flexible Spending Accounts
PTO + Holidays
401K with 4% match
Paid Family Leave
Employee Assistance
Disability and Insurance: Short + Long Term
Service Awards and recognition]]>
OH
The American Red Cross prevents and alleviates human suffering in the face of emergencies by mobilizing the power of volunteers and the generosity of donors. Each day, thousands of people – people just like you – provide compassionate care to those in need. Our network of generous donors, volunteers and employees share a mission of preventing and relieving suffering, here at home and around the world. We roll up our sleeves and donate time, money and blood. We learn or teach life-saving skills so our communities can be better prepared when the need arises. We do this every day because the Red Cross is needed - every day.