Business Intelligence Data Modeler

$100,000 - $115,000/Yr

American Red Cross

Full-time - Mid Level

Social Assistance

About the position

The Business Intelligence Data Modeler at the American Red Cross plays a crucial role in developing and maintaining Business Objects Universes to support the organization's reporting needs. This position involves collaborating with business analysts to gather requirements, designing data models, optimizing SQL queries, and ensuring data integrity and performance. The role 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 and translate them into technical specifications.
• 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, including query optimization and load balancing.
• Maintain comprehensive documentation for Universe design and development activities.
• Provide support to end-users, troubleshoot issues, and train users on Business Objects tools.
• Conduct rigorous testing to ensure data accuracy and stability within the Universes.
• Ensure compliance with data governance standards, including data privacy and security.

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) is a plus.

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