Business Intelligence Data Modeler

$100,000 - $115,000/Yr

American Red Cross

Full-time - Mid Level

Social Assistance

About the position

The American Red Cross is seeking a Business Objects Universe Designer to develop, optimize, and maintain Business Objects Universes to meet the organization's reporting needs. This role involves collaborating with business analysts and end-users to gather requirements, designing data models, writing SQL queries, and ensuring data integrity and performance. The position also includes user support, training, and compliance with data governance standards, contributing to the mission of helping people in need.

Responsibilities

• Develop, optimize, and maintain Business Objects Universes to meet reporting needs.
• Collaborate with business analysts and end-users to gather requirements for universe design.
• Design and implement data models within Business Objects for efficient data access.
• Write, test, and optimize SQL queries for data retrieval and reporting.
• Monitor and enhance the performance of Business Objects Universes.
• Maintain comprehensive documentation for universe design and development activities.
• Provide user support by troubleshooting issues and training users on Business Objects tools.
• Conduct rigorous testing to ensure data accuracy and stability.
• Ensure compliance with data governance standards.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field or equivalent 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, or Teradata.
• 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.
• Strong analytical and problem-solving skills.
• Excellent communication skills for collaborating with stakeholders.
• Ability to work independently and manage multiple priorities.

Nice-to-haves

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

Benefits

• 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