Data Architect: CRA Reporting & ETL (Contract)

BCforward; Irving (TX); On-site; USD 167,971,000 - 173,930,000; Full time

Job summary

BCforward is seeking a Data Architect for the CRA Data Architecture & Reporting (CDAR) team in Irving, TX. You will design robust data models and govern data assets to support CRA regulatory reporting and scalable analytics.

Key responsibilities include leading data architecture standards, ETL with SSIS, and reporting with SSRS, leveraging REST APIs and GraphQL for data integration, and ensuring data quality and governance across the CDAR ecosystem.

Qualifications

• Expertise in Microsoft SQL Server and Azure SQL Managed Instance.
• Proficient SSIS ETL architecture, deployment, and monitoring.
• Strong SSRS reporting design and optimization.
• Experience with REST APIs and GraphQL for data integration.
• Knowledge of data governance, lineage, metadata, and quality.

Responsibilities

• Design and maintain enterprise data models for CRA reporting.
• Define data architecture standards and best practices.
• Analyze source systems and design scalable data integration.
• Establish data governance, quality, and stewardship.
• Lead architecture reviews and guide ETL and reporting initiatives.
• Kadince Software experience with data migration, import, export, and report creation.

Skills

Microsoft SQL Server

SSIS

SSRS

Azure SQL Managed Instance

Data governance

ETL design

REST APIs

GraphQL

Tools

Autosys

SQL Server Management Studio

Azure

Power BI

Job description

BCforward is seeking a Data Architect for the CRA Data Architecture & Reporting (CDAR) team in Irving, TX. You will design robust data models and govern data assets to support CRA regulatory reporting and scalable analytics.

Key responsibilities include leading data architecture standards, ETL with SSIS, and reporting with SSRS, leveraging REST APIs and GraphQL for data integration, and ensuring data quality and governance across the CDAR ecosystem.