Senior Data/Reporting Analyst :: Austin, TX(Hybrid) at Austin, Texas, USA |
Email: [email protected] |
Please share resume at [email protected] Senior Data/Reporting Analyst Fort Worth, Texas (local, Someone within a driveable distance) Job Type: Contract Visa Status: GC, US Citizen 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. Bachelors 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 Thanks and Regards!! Akashika Pandey Technical Resource Specialist Ace Technologies Inc 2375 Zanker Road, Suite 250, San Jose, CA 95131 Phone: 408-442-3665 | Extn 4286 | Email ID/Hangout : [email protected] ------------------------------------------------------------------------------------------------------- Reporting Manager: Gaurav Kumar| Email ID : Gauravk @acetechnologies.com | Phone: 408-442-3665 Ext 4261 Escalations : [email protected] Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered unsolicited as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line to [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience -- Keywords: business intelligence active directory information technology green card microsoft California Idaho Senior Data/Reporting Analyst :: Austin, TX(Hybrid) [email protected] |
[email protected] View all |
Wed Apr 10 20:36:00 UTC 2024 |