BI/Data Architect

Title: BI/Data Architect
Location: Remote
Job Type: Contract

Visa: USC, GC Only.

Job Description
client is seeking an experienced Data Architect for an immediate contract engagement. This is a hands-on role requiring active involvement in both development and solution architecture. The ideal candidate will have strong expertise in Snowflake, Oracle-based environments, enterprise data warehousing, and Power BI solutions.
Key Responsibilities

• Design, develop, and maintain scalable enterprise data warehouse and ELT/ETL architectures
• Build and optimize data pipelines using Snowflake, Fivetran, dbt, and/or Matillion
• Work within Oracle environments and integrate Oracle EBS data into Snowflake platforms
• Develop data models, transformation logic, and enterprise reporting solutions
• Support Power BI Premium/Fabric implementations and enterprise BI initiatives
• Collaborate with business and technical stakeholders to gather requirements and define scalable solutions
• Ensure data quality, performance optimization, governance, and architectural standards
• Create and maintain technical documentation, standards, and best practices
• Participate in hands-on development, troubleshooting, and deployment activities

Required Skills

• 8+ years of experience in Data Architecture and Data Warehousing
• Expert-level experience with Snowflake
• Strong experience with Power BI Premium/Fabric in enterprise environments
• Hands-on experience working in Oracle environments using Snowflake for ETL processes
• Experience building scalable ELT/ETL pipelines using Fivetran, dbt, and/or Matillion
• Strong understanding of Oracle EBS backend tables and data relationships
• Experience with enterprise data modeling, transformation, and integration
• Excellent communication and documentation skills

Nice to Have

• Experience integrating AI-driven features into BI solutions
• Exposure to predictive analytics, Copilot, or automated insights
• Experience working with Marketing, Paid Media, or E-commerce data
• Familiarity with Snowflake Intelligence or Cortex AI for natural language insights

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field
• Strong analytical and problem-solving skills
• Ability to work independently in fast-paced enterprise environments