Business Intelligence Data Modeler
| Company | American Red Cross |
|---|---|
| Location | North Carolina, USA, Ohio, USA |
| Salary | $100000 – $115000 |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Senior, Expert or higher |
Requirements
- Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field or combination of education and work 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.
- 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 technical and non-technical stakeholders.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
Responsibilities
- Develop, optimize, and maintain Business Objects Universes to meet the organization’s reporting needs, ensuring data integrity, performance, and scalability.
- Collaborate with business analysts and end-users to understand business requirements and translate them into technical specifications for universe design.
- Design and implement data models within Business Objects that facilitate efficient and intuitive data access for end-users.
- Write, test, and optimize SQL queries to ensure efficient data retrieval and support complex reporting needs.
- Monitor and enhance the performance of Business Objects Universes, including query optimization, indexing strategies, and load balancing.
- Maintain comprehensive documentation for all Universe design and development activities, including data mappings, table relationships, and query structures.
- Provide support to end-users by troubleshooting issues, answering queries, and training users on Business Objects tools and Universes.
- Conduct rigorous testing to ensure accuracy, consistency, and stability of data within the Universes.
- Ensure compliance with data governance standards, including data privacy, security, and quality.
Preferred Qualifications
- Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.