Job Title: IT - Business Intelligence (BI) Specialist
Organization: Daimler Financial
Request Type: Contract
Work Location: Daimler Financial, Farmington Hills
City & State: Farmington Hills, Michigan
local candidates only.
need last 4 of SSN , email id and other submission details.
Prophix Technical Support Administrator
Business Intelligence (BI) Specialist
Job Overview
The Prophix Technical Support Administrator will work with the IT Finance and PC teams and take ownership of the quality and success of the Prophix application. The primary tasks are: support of daily operations for the IT Finance and PC cubes, financial planning and forecasting categories and data integrity, continuous reporting development for various teams, uploading of external files and overall system monitoring. 3 years of Prophix experience required.
Responsibilities
• Overseeing system performance, administration, and troubleshooting data and issues
• Creating a backup and safeguarding the data; ensure data accuracy for all financial cycles approved
• Performing system upgrades following new releases
• Maintaining internal documentation
• Performing account setup and update Hierarchy Structures as Required
• Update Data Imports and Processes as Required
• Update Reports & Templates as Required
• Creating Enhancements as needed
• Continues improvements and identify efficiencies within the connected external files
• Testing improvements/upgrades within the tool
• Supporting both the IT Finance team and the Project Controlling team with any ad-hoc requests
• Running and troubleshooting the daily system processes
• CISM Ticket management for all Prophix access requests
• Working with the Customer Care Center to ensure active directory administration.
• Training and supporting teams on all relevant Prophix topics and creation of reports
5+ Years of experience.
Qualifications
• This position requires a minimum of 3 years of relevant work experience with Prophix and similar Budgeting and Forecasting tools
• Bachelor degree in IT and Business administration ( combined fields); understanding of planning and reporting processes
• Proficient in Microsoft Platforms
• Ability to develop Prophix Cubes, data architecture skills.
• Worked on SAP/BPC – CPM Platform
• Accounting experience is an asset
• Proficiency with MS Office Excel – advanced database understanding and advanced formulas
• Essbase experience preferred
• Cloud technology
• Experience with SQL performance tuning and trouble shooting is expected.
• Business Intelligence certifications desirable, preferably related to Cognos.
• Programming / scripting experience and knowledge of software development life cycle is preferred.
• Problem solving and administration skills are necessary
• Flexibility
• Ability to communicate effectively
• Ability to work under time constraints, multiple priorities, and adjust quickly to changing priorities.