Data Warehouse Modernization Administrator

Randstad is partnering with an insurance firm that is looking to hire a contract Data Warehouse Modernization Administrator. This role will play a key part in modernizing and optimizing our data infrastructure. As a Data Warehouse Modernization Administrator your primary responsibilities will include designing deploying and managing our data warehouse infrastructure using Snowflake DBT Fivetran and other relevant technologies such as AWS Glue Python SageMaker DB2 SQLServer and Informatica. You will collaborate closely with crossfunctional teams to ensure data integrity optimize performance and enhance scalability all while contributing to data warehouse administration efforts.

Responsibilities:

Design implement and maintain Snowflake data warehouse solutions to fulfill business requirements effectively.

Deploy and optimize DBT models and transformations to streamline data processing and facilitate analytics.

Manage Fivetran data pipelines to enable seamless data integration and synchronization.

Utilize AWS Glue for data cataloging executing ETL jobs and performing data transformation operations.

Apply Python and SageMaker for advanced analytics machine learning initiatives and data science projects.

Employ DB2 SQLServer and Informatica as necessary for data migration integration and administration tasks.

Collaborate with data engineers analysts and stakeholders to comprehend data needs and deliver actionable insights.

Develop and enforce data governance and security protocols to uphold data quality and regulatory compliance.

Monitor system performance troubleshoot issues and implement performance optimization strategies.

Stay abreast of industry best practices and emerging technologies in data warehousing and cloud computing domains.

Qualifications:

Bachelors degree in Computer Science Information Technology or related field.

5 years of experience in a data engineering or analytics role

Proven experience working with Snowflake DBT Fivetran AWS Glue Python SageMaker DB2 SQLServer and Informatica technologies

Certifications in Snowflake DBT AWS Glue Python SageMaker or related technologies.

Knowledge of data governance frameworks and data privacy regulations (e.g. GDPR CCPA).

Excellent SQL skills and experience with data modeling ETL/ELT processes and data pipeline management.

Familiarity with cloud platforms such as AWS Azure or Google Cloud Platform.

Experience with scripting languages (e.g. Python Bash) for automation and orchestration tasks.

Excellent analytical problemsolving and communication skills.

Ability to work independently and collaboratively in a fastpaced environment.