Senior Data Engineer

This position is designated as a hybrid role based out of our headquarters near Portland, Oregon. The current expectation is for employees to work onsite four days per week, subject to change based on business needs. This in-office requirement may be adjusted at the discretion of the company.

Columbia Sportswear Company is seeking a Senior Data Engineer in Portland, OR responsible for designing and implementing Kimball-style dimensional models and analytical datasets; developing transformations with tests, documentation, and data contracts; building and maintaining ELT/ETL workflows into data warehouses/lakes, including orchestration, monitoring, and cost/performance tuning; developing governed BI semantic models and datasets for Power BI; enabling self-service while enforcing data quality, lineage, and security policies; evangelizing data and tools that increase organizational access to data and ad hoc capabilities to help stakeholders draw conclusions and drive data-informed decisions; continuously exploring internal and external data sources and working with BSAs and Data Engineering teams to ingest data into data lake/data bricks/synapse for analysis and development; eliciting and clarifying business requirements; documenting specs, KPIs, and acceptance tests; delivering demos, office hours, and enablement; implementing CI/CD (Git-based), unit/integration testing, and data observability SLAs/SLOs; profiling SQL and storage strategies, caching, and compute scaling; and contributing to catalog/lineage, RBAC/ABAC, PII handling, and retention standards. This is a hybrid role.

 

Requirements: Bachelor’s degree in Computer Science, Information Technology, Electrical Engineering, or related field (foreign equivalent), and 36 months of experience in the job offered or related position, including experience with: SQL development, including writing complex queries, stored procedures, views, joins, and performing performance tuning in SQL Server environments; ETL/ELT development using SSIS or equivalent tools, including data mapping, transformations, workflow scheduling, and job automation; Power BI development, including building semantic models, dashboards, and reports; creating DAX measures; performing Power Query (M) transformations; and publishing to Power BI Service; dimensional data modeling, including designing star and snowflake schemas using Kimball or equivalent methodologies; data validation and profiling, including dataset optimization, incremental refresh, and cross-system data reconciliation; working with databases and cloud platforms such as Azure SQL or Snowflake; and JIRA for issue tracking and project management.

This job description is not meant to be an all-inclusive list of duties and responsibilities, but constitutes a general definition of the position's scope and function in the company. 

Columbia Sportswear Company is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law. Columbia Sportswear is committed to working with and providing reasonable accommodation for individuals with disabilities. https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf. If you need reasonable accommodation because of a disability for any part of the employment process, please notify your recruiter.

At Columbia Sportswear Company, we’re proud to offer regular full-time employees a benefits package that includes a variety of services and products to help make your life and work more rewarding. Our benefit programs contribute to overall employee well-being by aligning those programs with the fundamental elements of well-being: physical, social/emotional, financial, career and community. Benefits that can protect your family’s financial future and help you save money through our 401k plan plus a generous company match. Columbia offers medical, dental, vision, life Insurance, disability, flexible spending accounts, health savings account, and an assortment of voluntary benefit offerings (accident, critical illness, hospital indemnity, and legal services). In addition, Columbia offers EAP + which is free and confidential 24/7/365 counseling services. We have extensive wellness benefits, employee discounts and a generous time off program available.

If you need an accommodation/adjustment to successfully complete and submit your application, please reach out to [email protected] with the Subject: Applicant Assistance Requested.