Associate Data Architect II jobs in United States
cer-icon
Apply on Employer Site
company-logo

Axelon Services Corporation ยท 2 weeks ago

Associate Data Architect II

Axelon Services Corporation is seeking an Associate Data Architect II to develop and optimize SQL queries for data extraction and transformation. The role involves designing and maintaining ETL processes, collaborating with business analysts, and ensuring compliance with healthcare regulatory standards.

ConsultingProject ManagementRecruitingStaffing Agency
check
H1B Sponsor Likelynote

Responsibilities

Develop and optimize complex SQL queries for data extraction, transformation, and loading across multiple systems and large datasets
Perform data mapping and transformation between source and target systems to ensure accurate and consistent data flow
Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications for ETL and reporting solutions
Design, develop, and maintain ETL processes using Microsoft technologies including SSIS, SSRS, and Visual Studio to support data integration and reporting needs
Demonstrate strong communication skills and a self-starter attitude, working independently and as part of a team to meet project deadlines and objectives
Implement and maintain data warehousing solutions, applying best practices for architecture, modeling, and performance tuning
Create and maintain SSRS reports and dashboards, delivering actionable insights to business users
Troubleshoot and resolve data integration issues, ensuring timely and accurate data delivery across systems
Document ETL processes, data flows, and system configurations, maintaining clear and comprehensive technical documentation
Log, track, and manage defects using tools such as Jira or Azure DevOps, collaborating closely with testers and other data engineers to resolve issues and provide fixes
Ensure all development and deliverables comply with healthcare regulatory standards (e.g., HIPAA) and support audit and compliance requirements

Qualification

SQLETL processesSSISSSRSVisual StudioData warehousingJiraAzure DevOpsCommunication skillsSelf-starter attitudeDocumentation

Required

Develop and optimize complex SQL queries for data extraction, transformation, and loading across multiple systems and large datasets
Perform data mapping and transformation between source and target systems to ensure accurate and consistent data flow
Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications for ETL and reporting solutions
Design, develop, and maintain ETL processes using Microsoft technologies including SSIS, SSRS, and Visual Studio to support data integration and reporting needs
Demonstrate strong communication skills and a self-starter attitude, working independently and as part of a team to meet project deadlines and objectives
Implement and maintain data warehousing solutions, applying best practices for architecture, modeling, and performance tuning
Create and maintain SSRS reports and dashboards, delivering actionable insights to business users
Troubleshoot and resolve data integration issues, ensuring timely and accurate data delivery across systems
Document ETL processes, data flows, and system configurations, maintaining clear and comprehensive technical documentation
Log, track, and manage defects using tools such as Jira or Azure DevOps, collaborating closely with testers and other data engineers to resolve issues and provide fixes
Ensure all development and deliverables comply with healthcare regulatory standards (e.g., HIPAA) and support audit and compliance requirements
6+ years of ETL Developer / Data Integration - Develop and optimize complex SQL queries for data extraction, transformation, and loading across multiple systems and large datasets
6+ years of maintain ETL processes using Microsoft technologies including SSIS, SSRS, and Visual Studio to support data integration and reporting needs
6+ years of Create and maintain SSRS reports and dashboards, delivering actionable insights to business users
6+ years of Log, track, and manage defects using tools such as Jira or Azure DevOps
Please make sure relevant experience with Microsoft Databases technical stack is strongly demonstrated
Ensure all development and deliverables comply with healthcare regulatory standards (e.g., HIPAA) and support audit and compliance requirements

Company

Axelon Services Corporation

company-logo
For more than 40 years, Axelon has been exceeding market expectations and delivering top talent to the Fortune 500.

H1B Sponsorship

Axelon Services Corporation has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (13)
2024 (14)
2023 (3)
2022 (7)
2021 (17)
2020 (12)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Tania Obeid
Chief Executive Officer
linkedin
leader-logo
Cynthia Lah
Chief Operating Officer
linkedin
Company data provided by crunchbase