BUSINESS OBJECTS DEVELOPER JOB DESCRIPTION

State Medicaid systems and municipal ERP platforms generate thousands of reports that inform appropriations, compliance audits, and service delivery decisions. When universe design breaks down, or WEBi reports return inconsistent data, agencies lose visibility into the metrics federal and state governments require by statute. The Business Objects Developer owns the full reporting architecture that prevents those failures, from IDT universe construction and SQL query optimization to the Deski-to-Webi migrations that keep legacy ERP environments current. Public-sector BI differs from commercial work in one concrete way: every deliverable answers to a named government stakeholder with a compliance deadline attached.

Business Objects Developers in Government & Public Sector are accountable for designing, building, and maintaining the Business Objects universe and report infrastructure that state agencies and municipal departments rely on to meet federal and state reporting mandates. They operate within IT or Information Warehouse teams, collaborating with data analysts, business SMEs, and end users across multiple departments to translate operational requirements into governed, auditable BI solutions.

Career Impact: Deep hands-on experience across IDT/UDT universe design and Medicaid/ERP data domains establishes a track record that transfers directly into senior BI architect roles in both public and regulated private sectors.

Business Impact: The reports this role produces directly feed compliance submissions to state and federal governments, meaning errors affect agency funding, program eligibility determinations, and audit outcomes.

Growth Opportunity: Government BI environments are actively migrating legacy Deski estates to Webi and adopting SAP BI 4.2 platforms, giving developers upgrade cycle experience that commands a measurable premium in the market.

• Design and build IDT and UDT universes supporting complex hierarchies, drill-down paths, and aggregate awareness for state and municipal reporting requirements.
• Develop advanced WEBi reports and dashboards against Oracle and SQL Server data sources to meet federal and state government specifications.
• Gather functional requirements from agency stakeholders and document technical specifications as inputs to report design and deployment.
• Migrate Deski reports, universes, and user security settings to Webi in accordance with change management and production promotion processes.
• Perform SQL query optimization and universe performance tuning to maintain SLA-compliant response times across high-volume government data environments.
• Administer Business Objects security by configuring user groups, folder-level access restrictions, and application-level permissions based on agency user profiles.
• Coordinate with data analysts and end users to execute unit, integration, and system testing and resolve defects before production deployment.
• Provide training and technical documentation to support agency power users and department report developers.

• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience.
• 5 or more years of Business Objects universe design and WEBi report development experience, with demonstrated delivery in government or regulated-data environments.
• Proven hands-on experience with both the Universe Design Tool (UDT) and Information Design Tool (IDT), including universe conversion between the two.
• Strong SQL and PL/SQL development skills, including complex query authoring, stored procedures, and performance tuning against Oracle and/or SQL Server databases.
• Demonstrated ability to gather requirements from non-technical government or agency stakeholders and translate them into governed BI solutions.
• Experience supporting Business Objects administration tasks including installation, configuration, environment migration, and production troubleshooting.
• Solid understanding of data warehousing concepts, data governance, and reporting lifecycle processes in multi-system environments.

• Experience with SAP BI 4.2 or later, including BI Launchpad, CMC, and Central Configuration Manager administration.
• Prior exposure to Medicaid/CHIP claims data, municipal ERP platforms (such as CGI Advantage), or other government-mandated data structures.
• Familiarity with Agile delivery practices including sprint planning, backlog estimation, and iterative release cycles.
• Experience with secondary reporting platforms such as Tableau or SSRS to support cross-platform reporting environments.

• Universe defect rate per release cycle, measuring design quality across IDT/UDT builds before production promotion.
• Report-to-requirement traceability coverage, tracking the percentage of documented agency requirements reflected in delivered WEBi outputs.
• Mean time to resolution for production BO support tickets, measuring responsiveness to agency user issues within SLA bounds.
• Deski-to-Webi migration completion rate, tracking the percentage of legacy reports successfully converted and validated per project phase.
• Government reporting submission accuracy rate, reflecting error-free delivery of federally required data outputs on statutory deadlines.
• Typical tools: SAP Business Objects suite (commonly BI 4.2 Web Intelligence, IDT, CMC); relational databases (commonly Oracle, SQL Server)

• Base Salary Range: $95,000 to $130,000 annually, depending on seniority and agency
• Bonus: Project completion bonuses or annual merit increases; varies by employer
• Equity: Uncommon in public sector; may apply in government contractor roles
• Health Benefits: Medical, dental, and vision; federal contractor roles often include robust coverage
• PTO: 15 to 20 days plus federal and state holidays
• Common Perks: Remote or hybrid flexibility, professional development budget, government benefits stability

Figures are estimates based on general US market benchmarks and may be outdated. Adjust based on location, company size, and seniority level.

Background checks, including criminal history review, are a condition of employment, and roles supporting government contracts may require additional screening or clearance verification. All applicants are considered without regard to race, color, religion, sex, national origin, disability, veteran status, or any other characteristic protected under applicable federal, state, or local law. Reasonable accommodations for qualified individuals with disabilities are available upon request throughout the application and employment process. Candidates must be authorized to work in the United States.

The Business Objects Developer delivers end-to-end BI reporting solutions, designing complex SQL queries, building data marts, and creating reports for state and federal government clients using claims and subsystem data. Working within cross-functional project teams and reporting to technical leadership, this role strengthens organizational data infrastructure and ensures reporting systems operate with accuracy and efficiency.

Key Responsibilities

• Design, develop, implement, and maintain Business Intelligence reports using claims and other subsystem data.
• Develop and administer Business Intelligence development and production servers.
• Perform SQL script execution and build or modify existing programs to meet system and design specifications.
• Design, develop, and implement complex SQL queries to create data marts.
• Manage backups of all Business Intelligence Windows servers.
• Create Metadata Business Intelligence Universes.
• Create Business Intelligence reports for state and federal governments.
• Design and develop database systems to efficiently store and report data.
• Participate in project discussions to document and recommend alternative technical solutions or requirements.
• Participate in unit, integration, and system testing.
• Meet with customers on a regular basis to communicate project status.
• Maintain effective communication and relationships with all persons involved in the project.
• Provide technical assistance, training, and mentoring to others.
• Learn new technologies as needed to perform job duties effectively.
• Research and consult with resources and industry experts to ensure the effectiveness and efficiency of systems and applications.

Required Qualifications

• Bachelor's or advanced degree in a related field such as Information Technology, Computer Science, Mathematics, Statistics, Analytics, or Business Technology.
• 5+ years of Business Objects development and reporting experience.
• 5+ years of SQL development, including 4+ years of SQL performance tuning.
• 2+ years of data warehouse project experience.
• 2+ years of Teradata Version 14+ experience, including SQL Assistant.
• 2+ years of Tableau Server administrative experience.
• Experience with State Medicaid, Medicare, or healthcare applications.
• Experience in SAP Business Objects and SAS is an advantage.
• Prior experience in Tableau or Business Objects version upgrades is an advantage.
• Experience in Agile.
• Excellent verbal and written communication, client-facing, team collaboration, and mentoring skills.
• Strong organisational skills with the ability to set priorities and schedule work to meet deadlines.
• Ability to adapt to and collaborate within a team and organisational culture.

Embedded within the BI and analytics team, the Business Objects Developer builds end-to-end analytical and reporting solutions by translating business stakeholder needs into SAP BI and Business Objects implementations aligned with platform design guidelines and industry best practices. Working closely with developers, super users, and business stakeholders, this role advances the organization's data capabilities and supports business digitization through well-governed, high-quality reporting systems.

Core Functions

• Support production systems and proactively analyse and resolve production problems promptly, including identification of issue severity, root cause, and path to resolution.
• Identify opportunities to leverage information and analysis to improve business processes and support business digitisation efforts.
• Research and represent industry best practices.
• Plan and manage small projects leveraging appropriate project management methodology.
• Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, and participating in professional societies.
• Contribute to team efforts by accomplishing related results and participating in projects as needed.

Qualifications & Experience

• 7+ years of experience in Information Technology, preferably in BI or BW development.
• At least 5 years of hands-on experience with SAP BI and Business Objects, including hands-on development.
• At least one full lifecycle implementation of SAP Design Studio or equivalent interactive dashboard with business performance metrics.
• Experience with SAP BPC, APO, and IBP.
• Experience with SAP SAC and Microsoft Power BI.

Reporting to technical leadership, the Business Objects Developer shapes the organization's reporting capability by designing and managing UDT and IDT universes, building advanced Web Intelligence reports, and establishing documentation standards for report development. Partnering with business teams to gather requirements and oversee end-to-end build, test, and deployment activities, this role delivers reliable, scalable BI solutions that support data-driven decision-making.

Primary Duties

• Design, develop, and manage both UDT and IDT universes, web intelligence reports, publications, and dashboards.
• Develop complex reports using advanced Business Objects techniques and build ad hoc capabilities into universes for use at the report level.
• Gather functional requirements and create technical specifications as inputs to report design.
• Perform and supervise report build, test, and deployment activities.
• Create and document report development standards and processes.

Skills & Qualifications

• 5+ years of experience with Business Objects Universe Design, Scheduler, and report development.
• 5+ years of SQL development, with strong Oracle SQL and PL/SQL skills.
• Experience with Business Objects version 4.2.
• Strong Business Objects Web Intelligence report development skills, including troubleshooting complex reports with multiple queries, prompts, filters, crosstabs, charts, and merge queries.
• Experience working with universe design, reporting tools, dashboard tools, and 360eyes.
• Experience working directly with the business to analyse, define, and develop solutions.
• Ability to work well with people of varying levels of technical experience.

Sitting at the intersection of enterprise resource planning and business intelligence, the Business Objects Developer leads the City of Anaheim's ERP reporting environment, developing Web Intelligence reports, migrating legacy Deski reports to Webi, managing universe design, and administering full system security and performance monitoring. Operating across development, testing, and production environments, this role enables city departments and government stakeholders to access accurate, well-governed reporting infrastructure.

Day-to-Day Responsibilities

• Gather business requirements and document specifications for report development.
• Interact with application report users to conduct report testing, report migration, and production maintenance.
• Develop and implement processes for report migration, testing, and support maintenance.
• Provide production support by assisting users in troubleshooting issues, implementing changes, and performing support maintenance.
• Follow through on all report issues and user inquiries to ensure timely resolution.
• Prioritise and assign target completion dates for report fixes and change orders in coordination with application users and team members.
• Assist in maintaining the technical reporting environment to support report migration.
• Migrate reports, universes, and users with security settings from development or testing environments to the production environment following change management processes.
• Create new data structures, universes, Web Intelligence ad hoc and canned reports, and dashboards with multiple hyperlinks.
• Design and develop universes supporting multiple levels of hierarchies for drill-down and drill-across reports.
• Create and maintain security groups, folders, and categories to ensure only authorised personnel can access universes.
• Administer security authentication for users and groups, manage user accounts, and create access levels based on project business needs.
• Design and implement security by creating user groups, granting application access, and applying security restrictions at the application, folder, and object levels based on user profiles and groups.
• Manage Business Objects services, including starting, stopping, enabling, disabling, cloning, adding, and removing services as required.
• Perform installation, migration, configuration, maintenance, technical support, and troubleshooting of Business Objects components across development, test, and production environments.
• Monitor system performance and availability to identify, resolve, and tune the reporting system for optimum efficiency.
• Provide training and support to report users across departments and to power users who develop reports for their assigned areas.

Experience & Qualifications

• Educational background in Computer Science or Computer Engineering is preferred.
• At least 5 years of experience in Business Objects report development for Desktop Intelligence and Web Intelligence reports.
• Hands-on programming experience using SQL, PL/SQL, or a comparable data manipulation language.
• Working experience with relational databases such as Oracle and MS SQL Server.
• Experience supporting business intelligence report developers and designers using Business Objects client tools and data services.
• Proven experience using the Business Objects Universe Design Tool and Information Design Tool.
• Strong understanding of Business Objects universe concepts, including contexts, aliases, aggregate awareness, navigation paths, filters, business layer views, performance tuning strategies, universe linking, and integration of data.
• Proficiency in developing and troubleshooting complex SQL queries and stored procedures, with the ability to optimise as required.
• Exposure to ERP solutions, including Advantage Financial, HRM/Payroll, Performance Budgeting, and InfoAdvantage, is an advantage.
• Experience with Business Objects administration and hands-on knowledge of the Business Objects stack, including installation, troubleshooting, upgrade, configuration, and maintenance, is an advantage.
• Excellent verbal communication, interpersonal, technical writing, and documentation skills.
• Strong communication and collaboration skills to effectively engage with leadership and key stakeholders.
• Ability to work in a team environment with strong problem-solving, organisational, and planning skills.

A key member of the Business Intelligence development team, the Business Objects Developer owns the full lifecycle of universe and report development, from Agile sprint planning and requirement estimation through testing, deployment, and performance tuning of complex BI solutions. Collaborating across technical teams, subject matter experts, and business users, this role enables accurate, high-performance reporting that supports organizational decision-making and mission-critical operations.

Scope of Work

• Participate in Sprint Planning, Daily Scrum meetings, Sprint Reviews, Sprint Retrospectives, and other Agile activities.
• Estimate level of effort for backlog items.
• Manage multiple tasks and adhere to project schedules.
• Perform data analysis and data profiling against source systems and data warehouse.
• Define and prepare solutions for maintenance changes to existing reports and universes, and deploy new reports and universes.
• Apply back-end functions, procedures, tables, and views required by Business Objects universes, including queries, slice-and-dice, drill-down, variables, breaks, sorting, alerters, filters, and formulae.
• Test solutions to validate whether requirements have been met and develop unit test plans, scripts, and conditions based on business and system requirements.
• Coordinate and demonstrate prototype reviews, validate that solutions meet requirements, and collaborate with subject matter experts to develop, implement, and deploy solutions.
• Prepare training materials and provide support to business users to promote understanding of Business Intelligence reporting tools and features.
• Conduct performance tuning for universes and reports.
• Assist the team with troubleshooting problems and developing recommendations and solutions.
• Update and maintain Business Objects universes and universe design specification documentation.
• Assist business analysts and testers during system testing as necessary.

Education & Experience

• Bachelor's degree, with preferred majors including Computer Science, Computer Engineering, Electrical Engineering, and Information Management and Technology.
• 8+ years of experience designing complex Business Intelligence universes.
• 8+ years of experience creating advanced complex reports in Business Intelligence.
• Proven experience with Business Objects Universe Design Tool and Information Design Tool, including converting universes from UDT to IDT.
• Strong SQL data analysis skills.
• Strong understanding of the software development life cycle.
• Strong analytical, problem-solving, and organisational skills.
• Excellent written and oral communication skills.
• Ability to apply strong technical knowledge of features and functions of Business Intelligence tools.

Accurate, timely data reporting for Health Net Federal Service depends on the Business Objects Developer, who develops BI reports and universe enhancements within the Information Warehouse team, resolving complex issues and implementing solutions aligned to client specifications. Serving as a technical resource within the IW team, this role delivers analytical solutions that support healthcare data analysis and strengthen reporting capabilities across the organization.

Accountabilities

• Develop Business Objects reports in accordance with client needs and requirements.
• Understand business requirements by interacting with data analysts and end users.
• Facilitate design and develop processes utilising best standards.
• Develop solutions in accordance with client specifications.
• Communicate project status to team members.
• Resolve complex issues arising in project execution.
• Implement Business Objects development and testing.
• Perform realistic assessments of development time.
• Conduct research and analysis to create innovative solutions.
• Train, direct, and mentor technical and process teams.

Background & Experience

• 7+ years of Business Objects or data access tool experience, with Business Objects upgrade to version 4.x being an advantage.
• 2+ years of experience with Teradata data warehouse architecture.
• Knowledge of data warehousing, data governance processes, data quality processes, testing methodologies, reporting tools, and application development.
• Multi-platform and multi-system integration experience.
• Working knowledge of Information Management, Business Intelligence, and healthcare analytics is an advantage.
• Demonstrated problem-solving skills, creativity, and ability to manage multiple priorities.
• Ability to analyse business cases, extract requirements, and understand business needs.

As the Business Objects Developer, this role builds and maintains SAP BW process chains, designs financial and operational analytical reports and dashboards, and establishes best-practice standards for report development, code versioning, and deployment workflows. The BI and technical team relies on this work to ensure reporting platforms operate within SLA bounds, data discrepancies are resolved, and stakeholders receive accurate, well-documented intelligence across transactional systems.

Job Functions

• Coordinate with business intelligence analysts and subject matter experts to determine data analysis and reporting requirements.
• Capture and translate business requirements into effective technical solutions.
• Maintain SAP BW process chains to automate data loads.
• Design and create operational and financial analytical reports and dashboards to support business needs.
• Design and develop Business Objects universes and Web Intelligence reports.
• Develop, execute, and maintain SQL queries to validate report data.
• Validate reports against data in transactional systems.
• Create, enhance, debug, and rectify complex Web Intelligence reports.
• Investigate problems and reporting data discrepancies.
• Respond to ad hoc Web Intelligence report and data requests from users.
• Develop reports in alternate platforms as required.
• Establish standards and best practices for report development, code versioning, approval workflows, and deployments.
• Develop documentation templates and generate business and technical documentation to augment best practices.
• Collaborate with technical staff and end users to troubleshoot platform issues and develop appropriate solutions.
• Ensure that support requests are logged in the ticketing system, remediated within SLA bounds, and subject to root cause analysis to mitigate future incidents.
• Execute unit, integration, and functional testing, as well as adjustments from user acceptance testing.

Minimum Qualifications

• Bachelor's degree in Computer Science, Engineering, Sciences, or Management.
• Minimum 3+ years of hands-on experience in SAP BW and Business Objects universe and Web Intelligence report development.
• Intensive hands-on experience with SAP Business Warehouse 7.x and SAP BI 4.x.
• Experience in SAP BW extraction, BW data loading, building BW cubes, DSO, multi-providers, and BEx queries.
• Basic ABAP skills for debugging routines.
• Finance reporting domain experience is an advantage.
• Experience with alternate reporting platforms such as Tableau and SSRS is an advantage.
• SAP BW HANA experience is an advantage.
• Strong analytical, quantitative, problem-solving, and organisational skills.
• Strong oral and written communication skills.
• Ability to multitask on multiple projects, set priorities, and meet deadlines.
• Ability to interact with stakeholders, ask pertinent questions, and propose best-practice solutions.
• Ability to take initiative and find creative and effective ways to deliver results.
• Strong attention to detail with a mindset toward quality to avoid rework.
• Ability to quickly learn and develop support for reporting solutions using alternate reporting platforms.