Data Architect - SQL, Power BI & Azure Cloud Migration

Vinsys Information Technology Inc; California; On-site; USD 120,000 - 180,000; Full time

Job summary

Vinsys Information Technology Inc. is seeking a Data Architect to define and guide the data and reporting architecture during a phased migration from IBM Cognos to Power BI Report Server and eventually to the CSSA Government Cloud.

The role requires strong SQL Server, reporting data model, Power BI, and Azure migration expertise working with ARJIS technical teams to preserve reporting logic, optimize data access, and document structures while providing guidance for cloud migration.

Qualifications

• Strong SQL Server expertise and data modeling.
• Experience migrating reports/data to cloud platforms.
• Proficiency with Power BI and Power BI Report Server.

Responsibilities

• Assess existing SQL Server tables, views, Cognos models, report dependencies, and data relationships.
• Design and optimize reporting SQL views and Power BI semantic models.
• Preserve and reuse existing SQL views, including those supporting NIBRS/CIBRS reporting.
• Develop data architecture documentation, data dictionaries, ER diagrams, and semantic model docs.
• Define technical approach for on-prem Power BI Report Server and cloud transition.
• Prepare SQL migration strategies and migration runbooks for cloud reporting models.
• Guide ARJIS teams on cloud configuration, data integrity and deployment.
• Design agency workspace organization under a centralized tenant and support usage tracking and chargeback planning.
• Identify opportunities to reduce duplicate reports/datasets/models across environments.

Skills

SQL Server

Power BI

Azure migration

Data modeling

Tools

Cognos

Power BI Report Server

Job description

Vinsys Information Technology Inc. is seeking a Data Architect to define and guide the data and reporting architecture during a phased migration from IBM Cognos to Power BI Report Server and eventually to the CSSA Government Cloud.

The role requires strong SQL Server, reporting data model, Power BI, and Azure migration expertise working with ARJIS technical teams to preserve reporting logic, optimize data access, and document structures while providing guidance for cloud migration.