Lead Cognos Analytics Consultant

For more details, please connect with Rahil Khan at 609-371-5400 Ext 120 or email him at rahilk@vgroupinc.com Client: NYC Department of Consumer and Worker Protection (DCWP) Job Title: Lead Cognos Analytics Consultant Duration: 16 Weeks Start Date: Anticipated 07/01/2026 – 10/21/2026 Location: On-site (Broadway, NY) Position Type: Contract Interview Type: in-person or via video conference Ceipal ID: NYC_COGN213_RK Department: Division of Technology & Strategic Solutions (DoTSS) Overview The NYC Department of Consumer and Worker Protection (DCWP) is seeking a Lead Analytics Consultant to conduct a comprehensive assessment of its IBM Cognos Analytics environment and develop an actionable migration roadmap toward a future-state solution in the Microsoft Azure ecosystem—prioritizing Microsoft Fabric and Power BI. The consultant will inventory current reports and data models, analyze usage and security, perform a fit‑gap against Azure/Fabric, and deliver a phased transition roadmap, future-state architecture, training plan, and an executive presentation. Key Responsibilities Current State Assessment (Cognos) • Analyze architecture, environments, deployments, and integrations. • Inventory reports, packages/data models, data volumes/usage, scheduling/distribution, and performance. • Review security & access controls, governance, compliance, and operational processes. Requirements & Gap Analysis • Elicit and document reporting requirements, data‑source mappings, user roles/permissions, interactivity needs, export/distribution patterns, and compliance constraints. • Perform a fit‑gap comparing current Cognos capabilities with Azure/Fabric stack (e.g., OneLake, Synapse, Power BI) to identify modernization opportunities and limitations. Future-State Definition • Propose a future‑state architecture within Azure/Microsoft Fabric (data storage, semantic models, pipelines, governance, security, and visualization layers). • Define migration approach (re‑platform vs. re‑architecture), sequencing, dependencies, and risk mitigations. Roadmap & Timeline • Develop a milestone‑based roadmap with estimates for discovery, build, test/validate, cutover, and stabilization phases. • Provide staffing assumptions, management considerations, and success metrics. Enablement & Handover • Create a training plan for DCWP resources (admin, developer, analyst/end‑user tracks). • Deliver an executive‑ready final presentation with recommendations, costs/efforts, and next steps. Required Qualifications • 8+ years in BI/Analytics with hands‑on experience in IBM Cognos Analytics (reporting, Framework Manager/metadata modeling, administration). • 5+ years designing solutions on Microsoft Azure with fluency in Microsoft Fabric, Power BI, OneLake, and Synapse (or Azure Data Factory/Databricks with clear mapping to Fabric). • Demonstrated delivery of at least two Cognos → Power BI/Fabric (or Azure) assessments/migrations including report rationalization and security model redesign. • Strong grounding in data governance, security, and compliance (role‑based access, data classification, auditing, least privilege). • Expertise in requirements discovery with business & technical stakeholders; ability to translate findings into actionable roadmaps. • Excellent communication skills; able to brief executive and technical audiences and produce high‑quality deliverables. • Bachelor’s degree in computer science, Information Systems, Data/Analytics, or related field (or equivalent experience). Preferred Qualifications • Public sector experience and familiarity with procurement and compliance processes. • Experience with semantic modeling (Power BI datasets, Fabric models) and governance tooling (Purview). • Background in performance optimization and cost governance for cloud analytics platforms. Core Skills & Tools • Platforms: IBM Cognos Analytics; Microsoft Fabric (OneLake, Power BI, Synapse) • Data & ETL: Azure Data Factory / Synapse Pipelines; SQL; basic Python/Databricks familiarity a plus • Security & Governance: RBAC/ABAC, workspace governance, lineage, data classification • Practices: Report inventory & rationalization, fit‑gap assessments, migration planning, stakeholder facilitation, change management • Documentation: Architecture diagrams, migration plans, training materials, executive presentations Deliverables (Aligned to SOW) • Current State Assessment Report (Cognos architecture, inventory, usage, security, infra landscape) • Fit‑Gap Analysis (Cognos vs. Azure/Fabric capabilities and limitations) • Future-State Architecture Diagram (recommended Azure/Fabric design) • Transition Roadmap (milestones, timeline, dependencies, estimates) • Training Plan (admin/developer/analyst tracks, post‑implementation support) • Final Executive Presentation (recommendations & next steps) Success Metrics • Complete inventory with >95% coverage of active Cognos reports/assets. • Signed‑off fit‑gap and future‑state within project timeline. • Stakeholder satisfaction (≥4/5) on clarity and usefulness of roadmap and training. • Approved final deck enabling decision on migration path and funding. How to Apply Please submit a resume highlighting relevant Cognos→Fabric/Power BI migration experience, two references for similar assessments, and sample artifacts (e.g., sanitized roadmap or architecture diagram). V Group Inc. is a New Jersey-based IT Services and Products company, strategically organized into multiple business units: Public Sector, Enterprise Solutions, Ecommerce, and Digital. Within our Public Sector unit, we specialize in delivering IT Professional Services to Federal, State, and Local governments. We hold multiple contracts across 30+ states across US, which include NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, MN, NM, VT, and WA. If you're considering a career opportunity with V Group or exploring a partnership, I welcome you to reach out to me with any questions about our services and the unique advantages we offer to consultants. And please feel free to share my contact information with others who may benefit from connecting with us. Website: https://www.vgroupinc.com/publicsector LinkedIn: https://www.linkedin.com/company/v-group/ Facebook: https://www.facebook.com/VGroupIT Twitter: https://www.twitter.com/vgroupinc