What are the responsibilities and job description for the Data Warehouse Architect 2 position at Sweeney Strategies LLC?
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
Preferred Skills (Nice to Have Not Required)
Additional Information
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.
Transparent Payment Model Clear rate structures and prompt payments upon receipt.
Flexible & HighImpact Roles Work on meaningful projects that align with your expertise.
Career Support & Growth Access resources networking opportunities and expert guidance.
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.
Key Skills
Fund Management,Drafting,End User Support,Infrastructure,Airlines,Catia
Employment Type : Full Time
Vacancy : 1
