Description: Responsible for interacting with key Finance and Controlling users to support the reporting needs within Mercedes Benz Financial Services including production, ad-hoc, and manual reporting.

Job Responsibilities:
• Work with end users to document existing end user reporting applications in MS Excel and MS Access and identify data needs
• Trace and translate SQL and MS Access queries to data warehouse source tables
• Create detailed business and technical data dictionary for Finance and Controlling areas
• Analyze data needs to identify gaps and work with data warehouse and other IT/project teams to resolve gaps
• Generate reports and information for Finance and Controlling
• Development of COGNOS repots for Finance and Controlling accurately and within estimated development times and according to the approved scope specifications.
• Utilization of Cognos Report Studio, PowerPlay, MS Access, SQL, MS Excel, or VBA to develop new reports, update existing reports, and provide ad hoc support within the BICC environment.
• Work with the assigned business analyst to identify data availability and development issues with the report project prior to scope creation.
• Gather report requirements and create report specifications; provide estimated effort estimation of effort (in hours).
• Work with IT to publish reports to the COGNOS website.
• Create daily, weekly, or monthly reports according to delivery schedule. Reports must be accurate and within scheduled due dates.
• Resolve production issues for existing reports. Utilize COGNOS 10.1.1 components, PowerPlay, Access, SQL , EXCEL, or VBA to trouble shoot, modify or enhance existing production reports. Reports must be accurate and within scheduled due dates.
• Support BICC Team as requested with special initiatives/projects.
• Provide external support/extracts when necessary (including vendors, and brand partners)
• Work with Data Warehouse team as needed to define new data warehouse tables needed for reporting, including gathering requirements, documenting requirements, and user acceptance testing
• Improving the reporting environment by: capturing new change requests and locating the needed data within the data warehouse or source system.
• Understanding the file structure of the source systems to the extent necessary to extract and load the needed information.
• Update specifications and work with IT to validate the data stage and DM changes.
• Provide formal and informal reporting training for the user community.
• Manage the structure of COGNOS web portal to provide an easy and intuitive interface to the user community.

Additional Skills:
• 8+ Years of experience.
• Bachelor's degree in Computer Science or equivalent
• Expertise in Microsoft Excel and Access
• Expertise in Structured Query Language
• Experience with Cognos 10 - Report Studio, Analyst Studio, Transformer
• Experience with Cognos BI Licensing
• Experience with Cognos 10.2 Security Object Design
• Excellent communication skills
• Knowledge of financial processes and terminology preferred