Senior Data/Reporting Analyst

Job Title - Senior Data/Reporting Analyst

Location - Fort Worth Texas

Rate- 65/Hr. on C2C

Visa- NO OPT, CPT

Client- Comerica Bank

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