Data Analyst
Job ID: 37877
Date Added: 10/02/2026
Job Title: Data Analyst (CRA Data Architecture & Reporting)
Location: Hybrid if located near a hub (60% in office). Remote considered only if candidate meets/exceeds requirements.
Anticipated Duration: Contract through 12/31/2026 (extension possible; end date TBD)
Position Summary
The CRA Data Analyst supports data solutions for Community Reinvestment Act (CRA) reporting and analytics. This role helps design, build, optimize, and govern data and reporting solutions for the CDAR platform—partnering with technical teams and business stakeholders to deliver high-quality, scalable, and compliant reporting.
Responsibilities
- Design and maintain data models supporting CRA reporting, compliance, and analytics
- Define data architecture standards and best practices across the CDAR ecosystem
- Analyze source systems and integrate new data assets into scalable solutions
- Support data governance efforts (lineage, metadata, and data quality)
- Develop and optimize SQL Server / Azure SQL Managed Instance solutions
- Build and tune stored procedures, views, functions, and complex queries
- Performance tuning (indexing strategies, query optimization, capacity planning)
- Develop and support SSIS ETL pipelines and data ingestion workflows
- Use scheduling tools (e.g., AutoSys) to manage ETL job execution
- Develop and support SSRS reporting, including automation and performance optimization
- Partner cross-functionally to translate reporting needs into technical delivery
- Strong hands-on experience with Microsoft SQL Server (T-SQL development and performance tuning)
- Experience building ETL solutions using SSIS
- Experience developing reports using SSRS
- Strong communication skills (ability to translate business needs into technical requirements)
- Experience operating in a regulated and/or compliance-focused environment (preferred)
- Azure SQL Managed Instance
- REST APIs and/or GraphQL (especially for data migration/integration)
- Experience with Kadince (data migration, import/export, reporting)
- Documentation / procedure creation experience
- Exposure to Microsoft BI stack tools beyond SSRS/SSIS (e.g., SSAS, SharePoint BI)
Synergis is proud to be an Equal Opportunity Employer. We value diversity and do not discriminate on the basis of race, color, ethnicity, national origin, religion, age, gender, gender identity, political affiliation, sexual orientation, marital status, disability, military/veteran status, or any other status protected by applicable law.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with the requirements of applicable state and local laws, including but not limited to, the San Francisco Fair Chance Ordinance, the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
For immediate consideration, please forward your resume to dreeves@synergishr.com
If you require assistance or an accommodation in the application or employment process, please contact us at dreeves@synergishr.com.
Synergis is a workforce solutions partner serving thousands of businesses and job seekers nationwide. Our digital world has accelerated the need for businesses to build IT ecosystems that enable growth and innovation along with enhancing the Total Experience (TX). Synergis partners with our clients at the intersection of talent and transformation to scale their balanced teams of tech, digital and creative professionals. Learn more about Synergis at www.synergishr.com.