What are the responsibilities and job description for the Data Warehouse Architect - Hybrid position at cyberThink?
Job Description :
As a Data Warehouse Architect, you will be responsible for developing data mapping between legacy and new systems, ensuring accurate data migration and transformation. You will leverage Azure Data Factory Pipelines and SQL Server stored procedures or SSIS packages to support data processing and integration.
Key Responsibilities :
- Manage data mapping from legacy systems to new platforms, ensuring accuracy and consistency.
- Develop and maintain Azure Data Factory Pipelines or SSIS packages for SQL Server environments.
- Maintain source code in a GIT repository using Azure DevOps.
- Estimate level of effort for tasks and manage deadlines effectively.
- Perform data profiling and comparisons using tools like Toad Datapoint.
- Ensure compliance with HIP nd PII regulations through proper data handling.
- Provide clear documentation of technical processes and workflows.
- Support and maintain ETL packages on both cloud-based and local servers.
- Collaborate with business partners and stakeholders to define data transformation requirements.
- Successfully pass CJIS background checks and complete security training.
Required Skills, Experiences, Education, and Competencies :
The hourly range for roles of this nature are $40.00 to $80.00 / hr. Rates are heavily dependent on skills, experience, location, and industry.
cyberThink is an Equal Opportunity Employer.
Salary : $40 - $80