Vacancy expired!
If you want more than just an assignment and to work with an organization that values your contribution to our growth AND has deployed a proprietary Consultant Appreciation Program (CAP) to continue to support your job search efforts in the future Hired by Matrix could be just what you need. We are a distributed organization working with some of the premier Fortune 500 organization across the US in multiple verticals and disciplines. If you embrace positive culture, a dynamic teaming approach, robust benefits, 401k matching, paid time off, and want more than just your next assignment we could be a great Match. Hired by Matrix has been providing talent solutions to help organizations enhance team capacity for decades. As a full-service search firm, we have partnered with companies across industries, including Financial Services, Fintech, Consumer Goods and Services, Security and Logistics, Pharmaceutical / Biotech, Technology, Automotive, Engineering, and Healthcare.Job Description
- Responsible for interacting with key users to support the reporting needs within our including production, ad-hoc, and manual reporting.
- Responsible for enhancing the Data Mart (DM), Remarketing DM, Data Warehouse Staging area, and the DW by following formal system development methods.
- Generating reports and information for supported departments (Alliance Business Center, HQ, all brands, all countries).
- Development of COGNOS repots for supported departments accurately and within estimated development times and according to the approved scope specifications.
- For supported departments, utilization of Cognos Impromptu, PowerPlay, Access, SQL, 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.
- Assess prepared scope statement and provide estimated effort estimation of effort (in hours).
- Update scope statement as necessary during report development.
- 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.
- 5+ Years of experience
- Bachelor s degree in Computer Science or equivalent
- Experience with the following
- Cognos 8 - Report Studio, Analyst Studio, Transformer
- Cognos 7 - Impromptu, Transformer, Powerplay
- CoGNOS PowerPlay
- Crystal Reports
- Business Objects
- MS Access
- MS SQL Server
- Oracle
- ID: #43653960
- State: Michigan Farmingtonhills 48331 Farmingtonhills USA
- City: Farmingtonhills
- Salary: $46 hr
- Job type: Contract
- Showed: 2022-06-28
- Deadline: 2022-08-26
- Category: Et cetera