What are the responsibilities and job description for the Technical Architect Data & Analytics position at Promantis Inc?
Skills / Experience
- Experience in Data engineering and Analytics with the expertise in a solution/technical architect role on enterprise-scale programs
- Deep, hands-on expertise in Snowflake — query optimization, clustering, Data Metric Functions, Snowpipe, Streams, and native AI capabilities
- Experience in Platform Architecture, Snowflake Data Mesh, AI-Augmented Delivery and Enterprise-Scale Modernization
- Key Skills – Snowflake, AWS S3, Matillion, dbt (data build tool), Collibra, Profisee MDM, Python, SQL, Snowflake Cortex AI, WinAIDM, SnowConvert AI, Tableau, Power BI, CI/CD (DevOps), Git, ACORD Data Model
- Proven experience designing medallion/lake house architectures with AWS S3 as the raw data lake layer
- Strong command of dbt — project structure, macros, testing frameworks, and CI/CD integration
- Experience architecting data governance solutions using Collibra — Catalog, lineage, business glossary, and certification workflows
- Demonstrated ability to lead multi-wave, multi-workstream data modernization programs in a regulated (insurance, healthcare, or financial services) environment
- Hands-on experience migrating legacy ETL (Informatica or SSIS) to modern dbt/Matillion pipelines
- Bachelor’s or Master’s degree in Computer Science, Engineering, or related technical discipline
- Strong communication skills—ability to explain technical concepts clearly; Proactive, ownership-driven mindset with high accountability
- Ability to collaborate across engineering, operations, and support teams; Adaptability to fast-paced iterative environments