Technical Solution Architect :: Raleigh, NC (Hybrid)

Technical Solution Architect

Location: Raleigh, NC (Hybrid)

Duration: 9 months

Job Summary:

We are seeking an Senior Technical Solution Architect to provide data warehouse and Cognos analytical solution services. Will deliver strategic insights using predictive data analysis techniques, advanced technology tools, and information management principles to assist stakeholders in making informed decisions. The role requires self-sufficiency, leadership, and extensive industry experience.

Responsibilities:

• Provide technical expertise in Cognos metadata modeling, data modules/Framework Manager, fact & dimensional modeling, data mining, SAS, SQL, and quality control.
• Lead the full development lifecycle of Cognos reporting solution deployment.
• Design and develop efficient Cognos framework manager packages and data modules according to best practices.
• Specialize in solution architecture for healthcare data management to propose dashboards and operational reporting.
• Develop and maintain strategies, sourcing guidance, technical standards, blueprints, reference architectures, and technology roadmaps.
• Analyze and estimate the feasibility of Cognos solutions with various data warehouse types.
• Develop data workflows, processes, and standard operating procedures for analytics delivery.
• Enhance reporting efficiencies and accuracy through analytical techniques.
• Prepare and present analytical data initiatives to various audiences, including executive management.
• Engage with agency subject matter experts, business liaisons, and vendor representatives to align business and IT.

Must-Have Skills:

• Expert knowledge of SAS tools, SAS MACROS, Enterprise Guide, Design Studio (7 Years).
• Expert Cognos and SQL experience, including table joins in a normalized data warehouse (7 Years).
• Ability to diagnose, isolate, and resolve complex data infrastructure problems (7 Years).
• Experience managing client data requests and discerning analysis requirements (7 Years).
• Experience with Cognos framework manager, dashboard/report design, and deployment (7 Years).
• Expertise in Cognos report performance tuning with large data volumes.
• Experience in designing advanced drill-down reports and dashboards using Cognos Analytics.
• Experience in architecting efficient Cognos metadata models using Cognos framework manager and Data modules.

Desired Skills:

• Experience working with Medicaid claims data and information.