Cognos Developer / BI Analyst

Job Title: Cognos Developer / BI Analyst Platform: Cognos Location: Alpharetta, GA (Onsite) Duration: Long Term Visa: Any Role Summary: We are seeking skilled Cognos professionals to join our team in Alpharetta. The ideal candidate will be responsible for developing, maintaining, and enhancing business intelligence reports and dashboards using IBM Cognos Analytics. You will work closely with business stakeholders to translate data needs into effective and scalable reporting solutions. Key Responsibilities: Design, develop, test, and deploy sophisticated reports, dashboards, and metadata models (Framework Manager packages) using IBM Cognos Analytics (v11/12). Collaborate with business users to gather and analyze reporting requirements. Write and optimize complex SQL queries and interact with relational databases (e.g., DB2, Oracle, SQL Server) to source data. Perform troubleshooting, resolve issues with existing reports, and provide performance tuning. Participate in the full software development lifecycle for BI projects. Create and maintain technical documentation for reports and data models. Required Qualifications: Overall Experience: 8+ years of hands-on experience with IBM Cognos Analytics. Technical Skills: Proficiency in Cognos Report Studio, Framework Manager, and Query Studio. Strong experience in building complex reports (Crosstabs, Lists, Charts) and dashboards. Solid understanding of dimensional data models (star/snowflake schemas). Strong SQL skills for data validation and analysis. Level-Specific Expectations: For E2.2 Level (Mid-Level): A solid independent contributor who can execute defined tasks, build complex reports, and troubleshoot effectively with minimal supervision. For E3.1 Level (Senior-Level): All of the above, plus the ability to lead small workstreams, design complex Framework Manager models, mentor junior team members, and interact directly with business stakeholders to guide requirement gathering. Preferred Qualifications: Experience with Cognos BI version 11.x or 12.x. Knowledge of other BI tools (Tableau, Power BI) is a plus. Local to the Alpharetta, GA area is strongly preferred.