Data Architect

Day-to-Day:

Lead technical architecture strategy across enterprise data platform initiatives
Define and enforce ETL/ELT architecture, standards, and best practices
Design scalable data pipelines (batch, streaming, real-time)
Oversee Snowflake architecture including governance, RBAC, and performance optimization
Review data engineering pipeline designs and ensure quality and scalability
Provide technical leadership to data engineers and data scientists (no direct management)
Establish reusable frameworks, patterns, and blueprints for pipelines
Drive enterprise data modeling and semantic layer design
Collaborate across engineering, analytics, and business teams
Lead data platform governance, including cost optimization, security, and observability
Support enterprise migration efforts (Oracle → Snowflake on Azure)
Conduct architecture reviews, troubleshooting, and performance tuning

Job Description:

Insight Global is seeking an IT Architect – Data & Snowflake for a leading enterprise analytics initiative. This individual will serve as a strategic technical leader responsible for designing and evolving a modern enterprise data platform. The role focuses on architecting scalable, high-performance data pipelines and establishing best practices across Snowflake and cloud ecosystems.

This architect will guide a team of data engineers and data scientists by defining pipeline frameworks, governance standards, and architecture strategy while remaining hands-on at a design and review level. The ideal candidate brings deep expertise in Snowflake, Oracle Exadata, and ETL/ELT tooling (with a strong preference for Talend), along with experience building enterprise-grade data models and enabling analytics and AI/ML use cases.

This is a high-impact, long-term role within a multi-year data transformation initiative, offering the opportunity to shape enterprise data strategy, drive technology decisions, and influence every major data-related project across the organization.

Pay Range: ($60-$68/HR)

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

- 7+ years experience in data architecture, data engineering, or enterprise data platforms
- Advanced hands-on expertise with:
- Snowflake (performance tuning, RBAC, resource management, streams, tasks, data sharing)
- Oracle Exadata
- Strong SQL and ELT/ETL framework experience
- Cloud data services experience (Azure and/or AWS)
- Proven experience designing analytical data models:
- Star schema
- Snowflake schema
- Data vault
- Semantic layers
- Experience building scalable pipelines using tools like: dbt, Airflow, ADF, Databricks, Informatica, Talend (highly preferred)
- Experience with tool-based data pipeline development (Talend or Informatica strongly desired)
- Experience with Dataiku for analytics and ML enablement
- Strong communication and cross-functional collaboration skills

- Certifications (Snowflake, Azure, Databricks, Informatica, etc.)
- Dataiku + ML pipeline exposure
- Experience with AI/ML data architecture or feature pipelines
- Exposure to DataOps / CI-CD frameworks
- Experience migrating from on-prem (Oracle) to cloud (Snowflake on Azure)

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.