Business Intelligence Developer III

Who We Are

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.

What You'll Do

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 owners to define metrics and maintain data definitions on-going
• Implement and maintain data governance employing Master Data Management methods
• Regularly evaluate semantic models for improvement
• Determine appropriate user cases for compatible query mode versus dynamic query mode
• Evaluate opportunities for data improvements, recommending summary tables, materialized views, cubes, or separate data marts to data services partners
• Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing, data security and privacy.

Subject Matter Expertise (SME) / Training / Mentoring

• Advanced knowledge of BI architecture and tool sets
• Provide as-needed development support and mentoring for field/business/analysts
• Prepare data from cloud data sources (Salesforce, Workday, AWS, etc.) and in-network data warehouses using cloud ETL.
• Organize an Analyst Community and hold regular forums to discuss successes and challenges, and inform of new product enhancements.

Advanced Analytics

• Understanding of new and advanced analytics including various tools SAP Business Objects Lumera, Tableau, Domo, Workday Prism Analytics, Cognos and PowerBI
• Assist in designing the dashboard solutions including KPIs, drill-down capabilities for customers using BI advanced analytic tools.
• Support customers in using new technologies and analyze data discrepancies between source systems and BI dashboards.

What You'll Need

• Bachelor’s degree in business or computer science, with focus in business analytics; or equivalent relevant experience. Master’s degree a plus
• 5-10 years’ experience working with large data sets from complex reporting platforms, including Oracle, and SQL Server
• 5-10 years using business intelligence development tools to solve complex business problems (e.g. SAP Business Objects, Cognos, OBIEE, MicroStrategy, Domo)
• 3 years Business Objects Universe/Designer experience required, including experience building complicated business semantic models, using both optimized (star schema) and non-optimized (transactional) data sources; using conformed dimensions, dimensional modeling, dynamic data functions (date/time), and embedding data definitions
• 3 years SAP Business Objects Administration (CMC proficient) experience required , including user/security management
• 5-10 years proficiency in writing and interpreting SQL
• Solid understanding of business report development process and SDLC
• Proficient in standard business applications, (e.g. Excel, Access, Visio, PowerPoint)
• Demonstrated subject matter expertise in several functional business areas
• Solid understanding of business processes, strategies, and key revenue/margin drivers
• Knowledge of financial accounting concepts and SOX controls is a plus
• Ability to interact and communicate with IT, business users of varying levels of expertise and 3rd party vendors.
• Ability to communicate complex technical information to less-technical users
• Ability to communicate in-depth business processes to technical resources
• Ability to create very complex process flow diagrams or flowcharts that demonstrate business or system process flow
• Ability to gather requirements effectively; document requirements and confirm observations with business owners. 
• Ability to perform fit/gap analysis based on requirements.
• Ability to execute on business/technical requirements and build multi-purpose interactive dashboard solutions
• Ability to create detailed and complex test plans for medium-sized initiatives.
• Ability to prioritize job responsibilities
• Demonstrated customer service abilities
• Demonstrated problem solving skills
• Knowledge of business systems software
• Ability to write very complex queries and reports
• Ability to develop and manage multiple enterprise-wide project plans, meeting established deliverables and timelines
• Ability to execute based upon directions from senior team members
• Ability to provide guidance, mentoring, and day-to-day support to junior personnel.
• Ability to conduct training to users and peers
• Ability to create thorough and complex documentation
• Ability to facilitate, conduct meetings, gather information and present status
• Ability to design business solutions for new processes and new business practices.
• Adaptable and demonstrates good judgment

The typical annual salary range for this position is shown below and is negotiable depending upon experience and location. The position is eligible for a discretionary annual bonus.

We offer exceptional earning potential and a competitive benefits package, including group health insurance benefits (medical, vision, dental), FSA and HSA healthcare accounts, life and accident insurance, adoption and fertility assistance, paid parental leave of up to 6 weeks, and short/long term disability. Robert Half provides paid time off for vacation, personal needs, and sick time. The amount of Choice Time Off (CTO) our people receive varies based on their years of service and is pro-rated based on the hours worked per week. A new hire earns up to 17 days of CTO per calendar year. Our people also receive up to 11 paid holidays per calendar year. We also offer the opportunity to contribute to our company 401(k) savings and investment plan or deferred compensation plan (if eligible), with an employer match of 100% on the first 3% of your contributions for eligible employees. Learn more at roberthalfbenefits.com/Resources.

Robert Half Inc. is an Equal Opportunity Employer. M/F/Disability/Veteran

As part of Robert Half’s Corporate Services facility employment process, any offer of employment is contingent upon successful completion of a background check.

Robert Half is committed to being an equal employment employer offering opportunities to all job seekers, including individuals with disabilities. If you believe you need a reasonable accommodation in order to search for a job opening or to apply for a position, please contact us by sending an email to HRSolutions@roberthalf.com or call 1.855.744.6947 for assistance.

In your email please include the following:

• The specific accommodation requested to complete the employment application.

• The location(s) (city, state) to which you would like to apply.

For positions located in San Francisco, CA: Robert Half will consider qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance.

For positions located in Los Angeles County, CA: Robert Half will consider for employment qualified applicants with arrest or conviction records in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.