What are the responsibilities and job description for the Business Intelligence Data Modeler position at American National Red Cross?
By joining the American Red Cross you will touch millions of lives every year and experience the greatness of the human spirit at its best. Are you ready to be part of the world's largest humanitarian network? Join us-Where your Career is a Force for Good! Job Description : Why Choose Us? 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, tothe 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