Business Intelligence Developer III

Robert Half is seeking a Business Intelligence Developer III to be part of the Financial Data and Analytics (FD&A) Team.  FD&A team has a centralized ownership of our Finance & Accounting reporting infrastructure including Data Governance, Operational Analytics, Finance & Accounting Reporting, Analytics and Tools & Technology. Our team works with all sub-teams in Corporate Accounting globally to ensure our data definitions and accounting and finance glossaries are accurate and up to date.  We participate in the Business Analytics Council and collaborate with D&A teams throughout the organization.  We also produce batch reporting for Finance & Accounting and maintain the reporting tools and technology SAP Business Objects, Domo, Workday. We provide Data Analytics support by bringing data and dashboard solutions to key decision-makers.

Specific responsibilities include:

Manage BI Tools/Systems

• Develop architecture/implementation plans for Business Intelligence projects.
• Create/Manage/maintain business security model, ensuring that access to data systems is granted to authorized individuals only. Create/modify user roles. Provide Security changes as needed.
• Provide system-level support and expertise.
• Validate Installation, patching, & configuration of BI environment, ensuring that customer base can effectively use the tool
• Install and configure Business Object software on multiple servers.
• Experience with Business Objects upgrades, including UNV/UNX conversion and troubleshooting performance degradation.
• Develop standards and guidelines for the effective and efficient delivery of enterprise BI, including operational reporting, dashboarding, and business analytics across the spectrum of descriptive to prescriptive
• Monitor BI application, ensuring that services are running and performing optimally, and that production certified content is running as planned
• Perform technical and advisory functions in the development of BI system architecture and the creation of semantic models for reporting, dashboards, delivery and scheduling.
• Migrate developed content to various environments and maintain order in production environment (organization, scheduling, etc.) with a documented process and attention to detail.
• Experience creating report schedules and CMC calendar maintenance.
• Ensure by working with IT that BI systems are kept current with patches and updates, and inform the analyst community accordingly
• Maintain data source connectivity through ODBC/JDBC configurations
• Publication/Distribution Configuration Updates
• Review universe and report designs and recommend solutions for performance optimization
• Understanding of AWS Security group console and security vulnerability software.

Strategy / Business Development/Consulting / Support

• Partner with field/business/IT teams to understand data/reporting needs.
• Test designs and coordinate content migration to production following thorough testing and UAT; Influence the schedule and timing accordingly.
• Develop the strategy for working effectively with other business units to build and iterate on semantic model designs.
• Troubleshoot existing universes/reports/dashboards and optimize performance through analyzing the design, generated SQL, and assessing database performance.
• Use experience and expertise in data sources to recommend database level enhancements, for consideration in Data Strategy discussions.
• Institute processes for effectively managing change for BI Analysts and promoting content to various environments.
• Effectively anticipate how business users will interact with semantic model and build accordingly for maximum user adoption.
• Communicate updates to customers and managers regularly, informing of progress and/or resetting expectations accordingly.
• Develop the strategy for effectively managing the BI environment for multiple customers across field, business and IT verticals.
• Envision new ways to utilize and promote BI technology across the company.
• Develop automated reporting and dashboard solutions for customers using BI intermediate/advanced tools.
• Play a central role in Robert Half’s Analyst Community to guide standards, best practices, and strong data governance within our cloud BI platforms.

Business Intelligence Configuration, Support and Data Modelling

• Analyze new/existing data sources and determine most efficient table relationships (evaluating primary keys and indexes) and model in semantic modeling tool (Universe Designer) for ease of use by business users
• Integrate data structure and business rules into common semantic model, allowing business users to pull data from a common definition
• Partner with business data