UPDATE: The consultant must be able to lead. This architect will ensure the engineers are executing based on the architecture. Need to have done this before. Dealing with lots of data, lots of kinds, mature data that could use some improvement. Familiar with modern approaches - medallion layer approaches- gold silver, bronze. Knowing Snowflake is required
Title: Data Architect
Location: Providence, Rhode Island (Hybrid 1 Day Per Week in Office)
Duration: 12+ months
Visa: Any
Interview: Video
Qualifications
Minimum Education and Experience
Bachelor s degree in Computer Science, Information Science, or related field, or equivalent experience.
10 or more years of experience in data architecture, data engineering, or related disciplines.
10 or more years of experience designing logical and physical data models for complex, cross-domain environments (relational, dimensional, and/or canonical).
8 or more years influencing enterprise-level technical architecture decisions.
Experience with modern ELT/ELT development patterns, data orchestration methodologies, and cloud-native architecture best practices.
Required Knowledge & Skills
Technical
Hands-on, advanced expertise with Snowflake as a cloud data platform, including advanced features (Snowpipe, Streams & Tasks, performance optimization, and governance capabilities).
Experience with modern ELT tools such as Matillion, dbt, or similar.
Strong experience with modern storage paradigms - NoSQL, data lakes, unstructured content management.
Strong experience with modern integration patterns - APIs, FHIR, event streaming, real-time data flows.
Advanced knowledge of industry-leading BI tools (such as Power BI)
Strong experience with layered/lakehouse architectures (e.g., raw/bronze, conformed/silver, curated/gold).
Strong background in designing canonical models, conformed dimensions, and large-scale data integration patterns.
Experience in healthcare or health insurance industry, especially with claims, clinical, provider, and member data.
Strong business acumen, including the ability to understand operational, clinical, and analytical workflows.
Demonstrated ability to lead and manage day to day work of vendor or offshore engineering teams.
Strong leadership and communication skills with the ability to influence stakeholders, mentor technical teams, and drive clarity in complex data environments.
Creativity and innovation in developing modern data solutions.
Preferred Education and Experience
Master s degree in Information Systems, Engineering, Computer Science, or related field.
Experience with healthcare administrative systems (e.g., Facets) is a plus.
Experience building or governing data products
Raj Kiran