Data Warehouse Architect 2
Data Warehouse Architect 2
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
One of our clients is seeking an experienced Data Warehouse Architect to lead data mapping ETL development and data integration efforts as part of a legacytomodern system migration project. The selected candidate will work with business partners to ensure smooth data mapping migration and transformation while managing Azure Data Factory Pipelines and SQL Server ETL processes.
This position is ideal for a detailoriented professional who thrives in managing largescale data mapping projects ensuring data accuracy and developing robust ETL solutions.
Local Richmond VA candidates are required and onsite interviews are mandatory.
Key Responsibilities
- Work with business partners to define and implement data mappings from a legacy system to a new system.
- Develop and maintain Azure Data Factory Pipelines and SQL Server stored procedures or SSIS packages for data transformation and migration.
- Conduct data profiling and validation to ensure data integrity during the migration process.
- Manage and maintain source code in a GIT repository using Azure DevOps.
- Estimate level of effort and manage deadlines to ensure timely completion of tasks.
- Support onpremises and cloudbased data integration efforts as needed.
- Maintain HIPAA and PII compliance by successfully completing required training.
- Ensure CJIS background check compliance and adherence to security protocols.
Requirements
- 5 years of experience with Azure Data Factory Pipelines or SSIS packages for SQL Server environments.
- 2 years of experience managing source code in a GIT repository using Azure DevOps.
- 3 years of experience estimating level of effort and managing deadlines in data migration projects.
- Excellent communication skills (written and verbal) to interact with business partners and technical teams.
- Selfmotivated independent and flexible work ethic to accommodate changing project needs.
- Highspeed internet connection required for remote work when applicable.
- Must pass CJIS background checks and successfully complete HIPAA and PII training.
Preferred Skills (Nice to Have Not Required)
- 3 years of experience with data profiling and comparison using Toad Datapoint.
Additional Information
- Work Location: Onsite at least 3 days per week with additional days if requested.
- Interview Process: Onsite interviews required (No Exceptions).
- Local candidates only.
- Must have lived in the U.S. for a minimum of 10 years.
Benefits
We ensure transparency efficiency and career growth for our candidates by connecting them with impactful opportunities. Our commitment to fair compensation strong client relationships and career support makes us a trusted partner in the industry.
Experience gathering business requirements from internal and external stakeholders 5+ years Expert-level proficiency in Microsoft Excel, Visio, Project, and PowerPoint 5+ years Experience creating, managing, and tracing business and IT requirements 5+ years Ability to facilitate brainstorming sessions, lead discussions, and drive teams toward defined goals 5+ years Experience working in a PMO or managing multiple simultaneous projects 5+ years Proven ability to analyze and interpret complex data and information and present findings clearly 5+ years Ability to work independently, manage shifting priorities, and effectively multi-task 5+ years Experience generating project reports (status updates, dashboards, budgets, etc.) 3+ years Experience working on Agile project teams 3+ years Self-starter with an inquisitive nature and a problem-solving mindset 5+ years Experience working with Medicaid IT and/or Healthcare systems 3+ years PMP or other project management certification Additional Information Work Location: Hybrid (3 days on-site, 2 days remote) parking NOT provided. Interview Process: Candidates must complete a USE CASE business requirements work product as part of the interview process. Local candidates strongly preferred. Final hiring decisions will be made after all interviews and work products are reviewed.
Employment Type
Full Time
