Data Architect

3 weeks ago

Boston, United States Compunnel Inc. Full time

Rek ID

BD-25-1076-OCDDE-OCD01-110646,

Title

Data Architect (Snowflake)

Client

State of MA - Executive Office of Housing and Livable Communities

Duration

12+ Months

Location

Boston, MA - 4 days onsite in a Month


Description of Duties:

  1. Design, develop, and maintain complex snowflake data warehouses, including data modeling, ETL processes, and data quality control.
  2. Ensure data integrity, quality, and security across all data warehousing activities.
  3. Develop and maintain data pipelines to integrate data from various internal and external sources.
  4. Develop and maintain data pipelines using tools for data transformation, testing, and deployment. Ensure data pipelines are scalable, reliable, and efficient.
  5. Write Python code to automate data processing, transformation, and loading tasks, including data ingestion, data quality control, and data visualization.
  6. Collaborate with data analysts and business stakeholders to understand data requirements and develop data solutions that meet business needs.
  7. Develop and maintain data visualizations and reports using Snowflake's built-in visualization tools or third-party tools like Tableau.
  8. Ensure data quality, integrity, and security by developing data validation rules, data cleansing processes, and data access controls.
  9. Optimize snowflake data warehouse performance, scalability, and reliability, including monitoring and troubleshooting data issues.
  10. Develop and maintain technical documentation, including data dictionary, data flow diagrams, and code comments.
  11. Participate in code reviews and provide feedback to ensure high-quality code and adherence to coding standards.
  12. Work closely with the agency’s data team and the overall state technology team to ensure alignment on data strategy and technology standards.
  13. Communicate complex data findings to non-technical stakeholders in a clear and concise manner
  14. Provide technical guidance and mentorship to junior analysts and other team members

Qualifications:

  1. 8+ years of experience in Snowflake data warehouse development and management, data engineering field.
  2. Strong understanding of Snowflake architecture, data modeling, and data warehousing concepts.
  3. Proficiency with SQL, including snowflake’s SQL dialect and complex query writing for performance optimization.
  4. Experience with Snowflake features, including cloning, time travel, data sharing, and micro-partitioning.
  5. Strong understanding of Snowflake’s architecture, including virtual warehouses, storage, and compute separation.
  6. Expertise in Snowflake Role-Based Access Control (RBAC), data masking, and encryption.
  7. Proficiency with data integration tools and ETL/ELT processes.
  8. Experience in Python or similar scripting languages for automation and data processing.
  9. Knowledge of data security and compliance standards as they relate to Snowflake.
  10. Experience with cloud platforms like AWS, Azure.
  11. SnowPro Advanced certification is a plus.
  12. Knowledge of data governance frameworks and tools.
  13. Strong experience integrating Snowflake with Tableau, Salesforce, third party APIs etc.
  14. Strong analytical, problem-solving, and communication skills
  15. Ability to work collaboratively in a cross-functional team environment
  16. Excellent verbal and written communication skills with project teams and business teams
  17. Team-oriented attitude and the proven ability to collaborate at all levels of an organization


Desired Skills/Experience:

  • SnowPro Advanced Architect or SnowPro Data Engineering certification is preferred.
  • Experience in building complex data pipelines in an multi cloud environment.
  • Experience implementing data masking, and aggregation to reduce privacy risks
  • Experience integrating data from Salesforce solutions
  • Knowledge of CI/CD practices and tools.
  • Familiarity JIRA or other project management tools
  • Experience using GitHub
  • Experience working on projects in the affordable housing sector or other public benefit programs

  • Data Architect

    2 days ago

    Boston, United States Saviance Full time

    You will join our team as a Sr. Data Architect who will work directly with clients. Responsibilities: * Guide and advise on the architecture of the Data Catalog using Data.World product * Implement the appropriate Graph database into the data infrastructure * Lead the Security Architecture and implementation Minimum Job Qualifications: * Experience working...

  • Data Architect

    1 week ago

    Boston, United States Venusgeo Solutions Full time

    DATA ARCHITECTHC is absolutely required for this role. Client is requiring this role to be onsite at min of 1x per week. Mass is now pushing for in office return. Top Required for this role:Deep experience working as a Data Solution Architect with 5+ years AWS Cloud –Location-MA’s platform of choice and the Director is a former AWS employee.10+ years...

  • Data Architect

    1 week ago

    Boston, United States Venusgeo Solutions Full time

    DATA ARCHITECTHC is absolutely required for this role. Client is requiring this role to be onsite at min of 1x per week. Mass is now pushing for in office return. Top Required for this role:Deep experience working as a Data Solution Architect with 5+ years AWS Cloud –Location-MA’s platform of choice and the Director is a former AWS employee.10+ years...

  • Data Architect

    1 week ago

    Boston, United States ERPMARK INC Full time

    Job Title: Data ArchitectLocation: Boston MA (Hybrid)ContractJob Description:(1) Currently client is working on a migration from its legacy systems (SSIS) to modern day cloud lakehouse built around AWS - S3/Lambda/Snowflake.(2) From functional knowledge standpoint, Data Architect should be having knowledge of Investment domain (with focus on risk).(3) The...

  • Data Architect

    3 weeks ago

    Boston, United States ERPMARK INC Full time

    Job Title: Data ArchitectLocation: Boston MA (Hybrid)ContractJob Description:(1) Currently client is working on a migration from its legacy systems (SSIS) to modern day cloud lakehouse built around AWS - S3/Lambda/Snowflake.(2) From functional knowledge standpoint, Data Architect should be having knowledge of Investment domain (with focus on risk).(3) The...

  • Data Solution Architect

    2 days ago

    Boston, United States Futran Tech Solutions Pvt. Ltd. Full time

    Data Solution Architect Location: Boston, MA _ Onsite Pay Rate: $70/hr on C2C - Critical Minimum of 15 years IT experience in Data BIA solution architecting of which at least 3 years in Azure Snowflake Databricks Good experience in Data architecture data warehousing architecture ETLELT parallel and multiprocessing APIs Streaming and real time data...

  • Data Architect

    7 days ago

    Boston, United States Coforge Full time

    Role: Data ArchitectKey Skill: Data Architecture, AWS, Snowflake, Asset Management DomainExperience: 10+ yearsLocation: Boston, MAMode of Hire: Full TimeWe at Coforge are hiring a Data Architect with the following skillset :-Responsibilities :- Design, develop, and maintain scalable data architectures and pipelines on AWS and Snowflake.Collaborate with...

  • Data Architect

    7 days ago

    Boston, United States Coforge Full time

    Role: Data ArchitectKey Skill: Data Architecture, AWS, Snowflake, Asset Management DomainExperience: 10+ yearsLocation: Boston, MAMode of Hire: Full TimeWe at Coforge are hiring a Data Architect with the following skillset :-Responsibilities :- Design, develop, and maintain scalable data architectures and pipelines on AWS and Snowflake.Collaborate with...

  • Data Architect Expert

    1 month ago

    Boston, Massachusetts, United States Slalom Full time

    Job Description:Data Architect ExpertAbout the Role:At Slalom, we're seeking a highly skilled Data Architect Expert to join our team. In this role, you'll design and develop multi-phased cloud data strategies, including implementation roadmaps and technology roadmaps based on business needs. You'll also serve as a subject matter expert in a cloud platform...

  • Data Architect Position

    2 weeks ago

    Boston, Massachusetts, United States Intus Care Full time

    Job OverviewWe are seeking a highly skilled Data Architect to join our team at Intus Care, a leading healthcare analytics platform dedicated to transforming care for PACE programs. Our platform empowers care providers to prevent high-risk events while equipping executives with the insights needed to make data-driven decisions.As a Data Architect, you will...

  • Data Architect

    2 months ago

    Boston, United States Mindtech Inc Full time

    Data Architect Mindtech is your gateway to exciting and impactful tech projects. We specialize in end-to-end software outsourcing, linking Latin American talent with global opportunities. Our fast, cost-effective approach ensures that our clients receive exceptional service and innovative solutions. With a diverse team of over 70 skilled professionals...

  • Data Architect

    2 months ago

    Boston, United States Mindtech Full time

    Data Architect Mindtech is your gateway to exciting and impactful tech projects. We specialize in end-to-end software outsourcing, linking Latin American talent with global opportunities. Our fast, cost-effective approach ensures that our clients receive exceptional service and innovative solutions. With a diverse team of over 70 skilled professionals across...

  • Senior Data Architect

    1 month ago

    Boston, Massachusetts, United States ICS Global Soft INC Full time

    Job Title: Senior Data Architect",">About the Company:",">ICS Global Soft INC is a forward-thinking company that specializes in data-driven solutions.",">Salary Range:",">$120,000 - $180,000 per year",">About the Job:",">We are seeking an experienced Senior Data Architect to lead our data engineering team and design scalable data...

  • Enterprise Data Architect

    2 days ago

    Boston, United States Saviance Full time

    Job Title: Enterprise Data Architect Location: Remote- East Coast Hours Duration: 6 Months Contract to Hire bout BigRio: BigRio is a remote technology consulting firm headquartered in Boston. We deliver a range of solutions including custom machine learning/AI integrations and data warehousing and processing solutions. Our comprehensive approach serves...

  • Data Architect BCBSMA

    2 days ago

    Boston, United States United IT Solutions Full time

    Top Required for this role: Deep experience working as a Data Solution Architect with 5+ years AWS Cloud - This is BCBS-MA's platform of choice and the Director is a former AWS employee. 10+ years of creating data engineering solutions, ETL/ELT pipelines on multi-terabyte SQL/NoSQL databases, data warehouse environment Data Solution Architect must excel in...

  • Data Warehouse Architect

    3 days ago

    Boston, United States Franklin Fitch Full time

    Data Warehouse Architect | Contract-to-Hire | Boston - Hybrid (Remote First)As the Data Warehouse Architect, you will be responsible for creating the data architecture for a newly established enterprise data warehouse. You will design, implement, and optimize ETL processes, data models, and integrations from multiple data sources, including APIs. You will...

  • Data Architect

    7 months ago

    Boston, United States HexaQuEST Global, Inc. Full time

    Job Description : This posting is for one (1) contracted position: The Business Enterprise Systems Transformation (BEST) Conversion Data Architect. The Conversion Data Architect will be part of a team of System Integration (SI) staff and product vendor and Program staff that will design and implement tasks necessary to migrate data from legacy systems to...

  • Data Warehouse Architect

    5 days ago

    Boston, United States Franklin Fitch Full time

    Data Warehouse Architect | Contract-to-Hire | Boston - Hybrid (Remote First)As the Data Warehouse Architect, you will be responsible for creating the data architecture for a newly established enterprise data warehouse. You will design, implement, and optimize ETL processes, data models, and integrations from multiple data sources, including APIs. You will...

  • Data Warehouse Architect

    5 days ago

    Boston, United States Franklin Fitch Full time

    Data Warehouse Architect | Contract-to-Hire | Boston - Hybrid (Remote First)As the Data Warehouse Architect, you will be responsible for creating the data architecture for a newly established enterprise data warehouse. You will design, implement, and optimize ETL processes, data models, and integrations from multiple data sources, including APIs. You will...

  • Data Architect

    1 week ago

    Boston, United States Coforge Full time

    We at coforge are looking for a Data Architect with the following skills:Domain Experience:Proven experience in the asset management domain, with a strong understanding of middle and back-office operations.Any experience with Investment Risk will be a plus.Key Responsibilities:Design, develop, and maintain scalable data architectures and pipelines on AWS and...