SAP Business Warehouse (Sap Bw)/Business Objects Senior Developer

The Office of the State Controller

This job is 100% Remote. 

• SIGN-ON BONUS OFFERED*

A Sign-on bonus of $3000 is being offered to the selected candidate of this posting.

See eligibility for Sign-on Bonus below in the Supplemental and Contact Information section.

Successful candidate will be subject to a criminal background check.

Please Note: OSC does not use 3rd parties to conduct job interviews.

OSC is interested in every qualified candidate who is eligible to work in the United States.  However, we are not able to sponsor visas at this time.

The mission of the Office of the State Controller (OSC) is to protect the financial integrity of the State and promote accountability in an objective and efficient manner.

The foundational principles of the office are Integrity/Ethics, Objectivity and Accountability.  OSC's overall goals are to optimize operational execution, manage risk effectively and efficiently and foster a high-performance culture.  OSC will provide excellent customer service while achieving those goals. The State Controller is the State's Chief Fiscal Officer.  The Controller serves as an independent resource to protect the financial integrity of the State and to promote accountability in an objective and efficient manner through accounting, disbursing, payroll, internal control, eCommerce and financial reporting systems.  The basis for the Controller's authority is statutory.

Description of Work:

The primary purpose of the ERP HR/Payroll Production Support division is to maintain and support the SAP HR/Payroll system, which is an enterprise system utilized by 38 state agencies/entities across North Carolina and pays greater than 81,000 employees on both bi-weekly and monthly cycles.

The primary purpose of the Business Intelligence Specialist position is to develop data models, analytic applications, reports and dashboard/visualizations to support the HR/Payroll Business Intelligence.  This position will function as a technical expert in all areas of development and support of the Business Intelligence platform including but not limited to planning, developing, maintaining and monitoring of Datawarehouse, the ETL processes and all related reports.

This position is responsible for all aspects of the system development life cycle including gathering statewide user requirements, data extraction, data warehouse system design/modeling, job scheduling, report creation, technical and customer-oriented documentation and overall system maintenance.  The ability to process information analytically and methodically and the flexibility to perform well in a constantly changing environment is critical.  This position works in a collaborative and consultative role with analyst, programmers, other technical peers, business specialists and other stakeholders to ensure that the final designs meet all business requirements while maintaining consistency with the structural parameters of the database and application environment.

This position completes complex projects using a diverse set of skills involving an integrated group of enterprise/statewide database and application systems.  This position researches problems and prioritizes work independently, with minimal supervision and completes high impact projects. This position develops guidelines and procedures that are used by other BI developers to assure that the quality goals of the unit are met.  This position provides input on architectural and design options and assists management with long term strategic planning for the Business Intelligence platform.

Key responsibilities include:

•    Gathering Business Requirements

•    Designing, developing and testing solutions, including reports and security

     role mapping

•    Configuring the system to meet the requirements

•    Testing (Unit, Integration, Security, User Acceptance)

•    Review and approval of training course materials

•    Implementation & support

•    System patching and upgrades

NOTE:  The knowledge, Skills, and Abilities (KSA'S) and the Minimum Education and Experience are REQUIRED in order to be considered qualified for this vacancy.  Therefore, you MUST provide supporting information within the body of your application that clearly demonstrates your possession of the KSA's and the minimum education and experience requirements.

• Thorough knowledge of ERP Application systems and the integration of customer business needs

• Skill in SAP analytics, including interface with various other technologies or skill in similar technology

• Ability to manage highly complex projects that have significant impact on the enterprise

• Ability to plan and organize day to day work, complete highly complex requests, evaluate and resolve emergent issues, and assists other analysts, specialists, and IT managers as needed

• Ability to consult with upper management on a regular basis to develop long-range strategic goals and alternatives

• Ability to lead others, providing technical guidance and direction; and to manage and direct meetings and discussions with customers and team members to develop custom solutions based on business needs

• Thorough knowledge of specialized Business Intelligence computer applications and related development software and languages, which may include: SAP ERP, AS-ABAP, AS-JAVA, Business Objects, SAP Business Warehouse Modeling, Business Explorer Query, Crystal Reports, WEBI Reports, BI Integrated Planning, and/or SAP SAC, SAP Lumira or other similar Business Intelligence tools (SAC, etc.).

• Thorough knowledge of activating and enhancing SAP BI content including data sources in source system, data target and data flow objects in BW or other similar ETL software development activities

• Working knowledge of the SAP Analytics Roadmap and new technologies such as SAP HANA, SAP SAC.

• Considerable knowledge of specialized/custom development methodologies, systems and applications, specifically ITIL compliant change management, Agile, Scrum, or other rapid deployment methodologies

• Ability to review and analyze applications and programs, and guide managers/specialists/engineers on identifying and resolving issues to make solution recommendations

• Thorough knowledge of specific agency functions and business needs, and changes in laws, rules and regulations affecting the business needs of the organization

• Skill in performing web application programming using HTML5, JavaScript, jQuery, or other similar language

• Considerable knowledge of tasks related to a Business Warehouse Administrator role such as monitoring nightly loads, deleting PSA and DSO change load data, BW performance management using aggregates, compression, roll up, and partitioning of Info Cubes or other related technology

• Ability to train and mentor others

Some state job postings state that you can qualify by an "equivalent combination of education and experience." If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See oshr.nc.gov/experience-guide for details.

Bachelor's degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and three years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system; or

Associate degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and four years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system; 

or High School or General Educational Development (GED) diploma and seven years of relevant experience in programming and applications analysis including the design and maintenance of an integrated database system; or an equivalent combination of education and experience.

NOTE:  Transcripts must be uploaded to NEOGOV and attached to your application to receive credit for any training and educational requirements, in order to qualify for the position.  

All degrees must be received from appropriately accredited institutions.   NEOGOV Technical Assistance

If you are having technical issues logging into your account or applying for a position, please review the Get Help/FAQ's information on the website. If you are still experiencing technical issues with your application, please call the NEOGOV Help Line at 855-524-5627.

All work history, training, and education must be listed on the official application, along with attached transcripts, to receive credit.  Applications must be completed in full.  "See Resume" or "See Attached" will not be accepted.

Eligibility for Sign-on Bonus

Qualified applicants must be selected from the candidate pool of this posting and meet the State policy following requirements:

A newly hired permanent full time or permanent part-time employee who works 30 to 40 hours per week is eligible for a sign-on bonus (this will be prorated for employees working less than 40 hours per week). The sign on bonus will be paid in three installments.

An employee is not eligible for a sign-on bonus if:

(1) the employee has held a position in North Carolina State government, including the judicial system, or the University of North Carolina system within the last 12 months (the employee shall remain ineligible for 12 months from the separation date);

(2) the employee has previously received a sign-on bonus from any State agency;

This Sign-on Bonus is contingent upon budget and final eligibility determination as of the effective date of hire.

Before receiving this sign-on bonus, the hired applicant must agree to repay the bonus on a pro-rated basis should he/she not have a performance rating of at least Meets Expectations or separates employment with OSC within 18 months of the hire date.

All work history, training, and education must be listed on the official application, along with attached transcripts, to receive credit.   Applications must be completed in full.   "See Resume" or "See Attached" will not be accepted.

The Office of the State Controller

3514 Bush Street

Raleigh, NC 27609

 http://www.osc.nc.gov/

Once the position has been filled, all on-line applicants will be notified via the e-mail provided at the time of application.

APPLICATIONS MUST BE COMPLETED IN FULL.  "SEE RESUME" OR "SEE ATTACHED" WILL NOT BE ACCEPTED.