Our client is seeking a Business Intelligence Developer with experience in Cognos BI architecture, design, development, and implementation.
The ideal candidate will have extensive knowledge of data warehousing, data analysis, and ETL processes, along with proficiency in Cognos 11x framework and various data modeling techniques. You will play a key role in developing and optimizing Cognos BI reports and data models, ensuring performance and security best practices are implemented.
Duration: 12 months
Location: Hybrid 2d/week NYC
Key Responsibilities:
- Architect, design, and develop Cognos BI solutions with a focus on security implementation at the FM model, package, and report levels.
- Build and maintain data warehouse solutions using star schema, snowflake schema, fact and dimension tables, and ETL processes.
- Install, configure, and maintain the Cognos suite of tools, ensuring high availability and performance.
- Lead the development of Cognos 11x frameworks, reports, and models using tools like Framework Manager, Report Studio, and Query Studio.
- Apply OLAP and dimensional modeling techniques to create efficient data models for reporting and analysis.
- Implement Cognos best practices for performance optimization, architecture tuning, and monitoring to improve system performance.
- Develop and deliver data visualizations and reports using Cognos, ensuring adherence to data visualization best practices.
- Perform source-to-target mapping and data analysis, developing accurate and timely reports for business stakeholders.
- Extend Cognos capabilities using scripting and SDK as required for custom solutions.
- Collaborate with business users to design and develop reporting solutions that provide clear insights into business metrics.
- Utilize advanced SQL query techniques for data extraction, transformation, and analysis.
- Keep up to date with other reporting tools like Power BI, Azure Analysis Services, or Tableau to integrate or support multi-platform environments.
- Communicate complex technical concepts clearly to both technical and non-technical stakeholders across the organization.
Requirements:
- Minimum 10 years of experience in Cognos BI architecture, design, development, and security implementation at the model, package, and report level.
- Extensive experience in data warehousing, data analysis, and ETL processes.
- Expertise with Cognos 11x Framework Manager, Report Studio, and Query Studio.
- Strong proficiency in OLAP and dimensional modeling techniques.
- Advanced knowledge of SQL and database query languages.
- Experience with other reporting tools like Power BI, Azure Analysis Services, or Tableau.
- Strong understanding of Cognos SDK and scripting to extend the tool’s capabilities.