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.
Interested? Apply Now!
If this sounds like the right opportunity for you, please apply with your most recent resume.