Big Data Lead/ Architect
Location : vancouver , WA (Onsite foe Weekly 2 days)
Fulltime
Description
SQL Server (EDW architecture, performance tuning, indexing)
Advanced SQL (complex joins, window functions, stored procedures)
Data warehousing concepts (star schema, data marts, dimensional modeling)Informatica PowerCenter / IICS
SSIS (advanced pipeline development, orchestration)
ETL performance tuning
optimization
Exposure to Databricks / Spark (preferred)
Cloud data platforms (Azure Fabric / Lakehouse concepts)
Batch + streaming ingestion concepts
SSRS, Tableau (understanding of reporting layer integration)
Data provisioning for dashboards and SL reporting
Data quality frameworks, reconciliation
Metadata and lineage awareness
Git/version control
CI/CD basics for ETL deployments
Job scheduling tools
Provide end to end ownership of EDW/data platform operations across SQL Server, data marts, and reporting layers
Lead design and optimization of data pipelines (ETL/ELT) using Informatica / SSIS
Drive modernization roadmap towards cloud data platforms (Fabric/Databricks)
Ensure data quality, integrity, and reconciliation across clinical, financial, and operational datasets
Design and support high volume reporting architectures (SSRS/Tableau/BI reporting ecosystem)
Act as SME for stored procedures, business logic, and EDW transformations
Collaborate with stakeholders to translate business KPIs into scalable data models and dashboards
Drive automation, performance tuning, and capacity optimization of EDW environments
Numbers & Facts
Location
Vancouver, WA
Skills
Automationunmatched
Big Dataunmatched
Business Intelligenceunmatched
Cloud Computingunmatched
Continuous Deployment/Deliveryunmatched
Continuous Integrationunmatched
Data Managementunmatched
Data Martunmatched
Data Modelingunmatched
Data Qualityunmatched
Data Setsunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Dimensional Modelingunmatched
Ecosystemsunmatched
Financial Operationsunmatched
Informaticaunmatched
Microsoft SQL Serverunmatched
Microsoft Windows Azureunmatched
Performance Metricsunmatched
Performance Tuning/Optimizationunmatched
Reconciliationunmatched
Reporting Dashboardsunmatched
SQL (Structured Query Language)unmatched
SQL Server Integration Services (SSIS)unmatched
SQL Server Reporting Services (SSRS)unmatched
Server Architectureunmatched
Star Schemaunmatched
Stored Proceduresunmatched
Tableauunmatched
Technical Leadershipunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.