Tech Lead

Big Data Lead/ Architect

Location: Vancouver, WA (Onsite for 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

The pay range for this role is ***k - ***k per annum including any bonuses or variable pay. *** also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience, and location of the candidate.

*** is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at ***.