The American National Red Cross
Business Intelligence Data Modeler
The American National Red Cross, Ohio, Illinois, United States, 61349
Business Intelligence Data ModelerLocation:
Fully Remote - Eastern Time Zone
Time Type:
Full time
Posted On:
3 Days Ago
Job Requisition ID:
RC77138
Join us—Where your Career is a Force for Good!
Job Description:
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.
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.
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%)
Pay Information:
The salary range for this position is: $100,000 - $115,000 /annually.
Benefits for You:
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
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.
Interested in Volunteering? Visit redcross.org/volunteertoday to learn more, including our most-needed volunteer positions.
#J-18808-Ljbffr
Fully Remote - Eastern Time Zone
Time Type:
Full time
Posted On:
3 Days Ago
Job Requisition ID:
RC77138
Join us—Where your Career is a Force for Good!
Job Description:
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.
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.
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%)
Pay Information:
The salary range for this position is: $100,000 - $115,000 /annually.
Benefits for You:
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
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.
Interested in Volunteering? Visit redcross.org/volunteertoday to learn more, including our most-needed volunteer positions.
#J-18808-Ljbffr