Data Analyst

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

Job Title: Data Architect - CRA Data Architecture & Reporting (CDAR)

Location: Irving TX

Duration: Contract - 2+ months, with potential extension (end date TBD)

Pay Range: $58.62/hr to $60.70/hr

Job ID: 410610

About BCforward

BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.

Job Description

We are seeking a Data Architect - CRA Data Architecture & Reporting (CDAR) to join our dynamic team. The ideal candidate will have strong experience in Microsoft SQL Server, SSIS-based ETL architecture, and SSRS reporting and a proven ability to design, govern, and optimize data solutions that enable compliant CRA regulatory reporting and scalable analytics.

Responsibilities:

• Design and maintain enterprise data models supporting CRA reporting, regulatory compliance, and business analytics.
• Define and enforce data architecture standards, patterns, and best practices across the CDAR ecosystem.
• Analyze source systems and design scalable solutions to integrate new data assets with lineage and metadata.
• Establish data governance, data quality, and stewardship frameworks for accurate reporting.
• Lead architecture reviews and provide technical guidance on database, ETL, and reporting initiatives.
• Kadince Software experience with data migration, import, export, and report creation. Create and maintain procedural documentation.

SQL Server & Database Engineering:

• Design, develop, and optimize solutions in Microsoft SQL Server and Azure SQL Managed Instance.
• Create complex stored procedures, views, functions, and database objects with performance in mind.
• Execute performance tuning, indexing, query optimization, and capacity planning.
• Support upgrades, security controls, high availability, and disaster recovery plans.
• Ensure platform stability, availability, and compliance with enterprise technology standards.
• Leverage REST APIs and GraphQL for data integration and migration where applicable.

ETL & Data Integration:

• Architect, develop, and maintain enterprise ETL solutions using SQL Server Integration Services (SSIS).
• Use Autosys to schedule, orchestrate, and monitor ETL workflows.
• Design and optimize ingestion from internal and external data sources with integrity controls.
• Automate workflows supporting monthly, quarterly, and annual reporting cycles.
• Partner with upstream and downstream teams to resolve integration issues.

Reporting & Analytics:

• Develop and support SSRS reporting solutions for regulatory, operational, and executive reporting.
• Design scalable reporting architectures with automation and distribution controls.
• Translate business reporting requirements into robust technical solutions.

Required Skills & Qualifications:

• Expertise in Microsoft SQL Server, Azure SQL Managed Instance, and Transact-SQL development.
• Hands-on SSIS ETL architecture, development, deployment, and monitoring experience.
• Proficiency with SSRS report design, performance optimization, and automation.
• Experience with REST APIs and GraphQL for data integration and migration use cases.
• Knowledge of data governance, lineage, metadata, and data quality practices in regulated environments.
• Ability to translate business requests into technical requirements and communicate with non-technical stakeholders.
• Strong attention to detail and validation of SQL queries and reports.

Preferred Skills:

• Experience with Microsoft BI Stack components: SSAS, Excel Services, PerformancePoint, and PowerPivot.
• SharePoint experience with BI integrations.
• Autosys scheduling in enterprise data environments.

Why BCforward?

At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to:

• Competitive compensation and benefits.
• Opportunities for growth with global clients.
• A supportive, inclusive culture that values innovation and people.
• Exposure to cutting-edge technologies and projects.

About Our Commitment

BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.