Data Architect

4 days 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

    4 days 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

    4 days 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

    2 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 Architect

    4 days 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

    2 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

    2 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

    6 days 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 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...

  • 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...

  • 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...

  • 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 Architect

    4 days 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...

  • Data Architect

    2 weeks 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...

  • Data Warehouse Architect

    1 day 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

    19 hours 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

    2 months ago

    Boston, United States Triverus Consulting Full time

    The data architect will be responsible for the analysis, design, architecture and development of a new data integration, data warehouse and analytic solution. A strong background in data integration, data modeling and cloud architecture with the ability to undertake complex challenges and deliver measurable results is required.What You Can DoLeverage...

  • Enterprise Architect

    3 weeks ago

    Boston, United States NTT DATA, Inc. Full time

    Req ID:287857NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking an Enterprise Architect / Solution Executive to join our Client Growth team.This role will work remotely from your home...

  • AWS Data Architect

    2 days ago

    Boston, United States Saxon Global Full time

    Position: AWS Data ArchitectLocation: Boston, MA. Hybrid role required to work on site from day 1. Open to relo candidates, but must be on site, out of pocket, from day one. Prefer resources closer to Boston, MA. NO WEST COAST CANIDATES will be considered.Duration: Long termInterviews – Video Client is requiring this role to be onsite at min of 1x per...

  • AWS Data Architect

    2 days ago

    Boston, United States Saxon Global Full time

    Position: AWS Data ArchitectLocation: Boston, MA. Hybrid role required to work on site from day 1. Open to relo candidates, but must be on site, out of pocket, from day one. Prefer resources closer to Boston, MA. NO WEST COAST CANIDATES will be considered.Duration: Long termInterviews – Video Client is requiring this role to be onsite at min of 1x per...