Data Architect – SQL Server, Power BI & Azure

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

Mandatory Background Security And CJIS/CLETS Requirements

Candidates must be able to successfully complete required background security screening, including applicable state and federal fingerprint-based criminal history checks, and satisfy all applicable CJIS/CLETS requirements before accessing ARJIS SANDAG systems or data. Continued eligibility requires annual security reviews and applicable training or certification renewals. Existing clearance is not required to apply.

Seeking a Data Architect

Seeking a Data Architect to define and guide the data and reporting architecture for a phased migration from IBM Cognos to Power BI Report Server and subsequently to the CSSA Government Cloud. The role requires strong SQL Server, reporting data model, Power BI, and Azure migration expertise.

The Data Architect will collaborate with ARJIS technical teams to preserve existing reporting logic, optimize data access, document reporting structures, and provide technical guidance for the client-executed cloud migration.

Responsibilities

• Assess existing SQL Server tables, views, Cognos Framework Manager models, report dependencies, and data relationships.
• Design and optimize reporting SQL views and Power BI semantic models to support accurate, accessible reporting.
• Preserve and reuse existing SQL views where appropriate, including those supporting NIBRS/CIBRS reporting.
• Develop data architecture documentation, enterprise data dictionaries, entity relationship diagrams, and semantic model documentation.
• Define the technical approach for on-premises Power BI Report Server implementation and subsequent cloud transition.
• Prepare SQL migration strategies, migration runbooks, and recommendations for rebuilding or adapting reporting models in the cloud.
• Guide ARJIS teams on cloud configuration, data integrity, performance validation, and deployment.
• Design agency workspace organization under a centralized tenant and support usage tracking, resource governance, and chargeback planning.
• Identify opportunities to reduce duplicate reports, datasets, models, and processes across environments.