Data Architect
Plymouth Rock Assurance · Boston, Massachusetts, US
Data Architect We are seeking an experienced Data Architect to join our team and take a lead role in designing, developing, and optimizing our data architect...
Job description
Data Architect We are seeking an experienced Data Architect to join our team and take a lead role in designing, developing, and optimizing our data architecture. As a Data Architect, you will play a crucial role in shaping our data strategy by leveraging AWS services such as S3 for data lakes, Redshift, AWS Glue, Informatica, Python for scripting and automation, Snowflake for data warehousing, DBT for modeling, and Fivetran for data integration. Essential Functions and 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, SQL Server, and Informatica as necessary for data migration, integration, and administration tasks. - Collaborate with data engineers, analysts, and stakeholders t...