Job Details
Job Description
Job Summary: The Principal Data Engineer is responsible for the design, development, testing, maintenance, and support of enterprise data assets.
- Provides technical design, development and analytical support.
Enables improvements in environment design, efficiency, controls, and the overall user
experience:
of enterprise data assets, and leads activities.
- Coordinates with senior leadership, several enterprise support organizations, and end users.
Responsibilities:
50% Continuously delivers and improves prioritized enterprise data assets that enable the growth of global analytics, reporting, and visualization solutions. 20% Provides expertise in all end-to-end components in our BI/DW architecture and knows how they contribute to compose solutions for business partners.
- Demonstrates strong command of both technical delivery as well as comprehension of various business functions.
Understands the role of various enterprise applications. 5% Identifies project risks and impediments, notifies management, and proactively works with other team members to complete assigned tasks as defined by project scope, timelines, and budgets. 5% Participates in the use of Agile practices to elicit and refine
requirements:
through an iterative process of planning, defining acceptance criteria, prioritizing, developing, and delivering enterprise data asset solutions. 10% Operates independently, functions as the lead representative for D&A on projects.
- Drives and sets design patterns for all of D&A.
10% Drives process improvement to continually raise the bar as the primary owner of function, platform, or process.
- Drives best practices across the organization.
Recognizes process deficiencies and takes independent action to improve. 5% Performs other duties as assigned. Additional
Requirements:
- Bachelor’s degree, applicable certification or equivalent
experience:
- Typically requires 8+ years of professional
experience:
and mastery of relevant technical or business
skills:
required to accomplish the job.
- Master’s Degree required Computer Science, Information Systems or a related field.
An equivalent combination of
education:
and
experience:
may be considered.
- Expert in SQL and query optimization for data platforms such as Azure SQL DW, HDInsight, Teradata, SAP BW/HANA, or Oracle • Expert in database concepts, including normalization, indexing, physical and logical modeling, creation of SQL queries and performance tuning • Familiarity with the Kimball methods of data warehousing techniques, standards and best practices •
Experience:
with management of a star schema implementation and related concepts such as slowly changing and late arriving dimensions • 4+ years professional
experience:
with one or more ETL tools such as Informatica, SQL Server Integration Services, Business Objects Data Services, or IBM Datastage • Sound judgment and decision-making, and the appropriate sense of urgency and is a self-starter • Familiarity with data content from typical Supply Chain scenarios, or
experience:
in environments integrated with data from SAP ERP or Microsoft Dynamics a plus •
Experience:
with large scale data processing, data structure optimization and scalability of algorithms a plus •
Experience:
with Microsoft Azure: Data factory, data lake and data warehouse a bonus • Travel: Occasional - 10% • Work Schedule: Standard Hours Career Band: Professional Jobs on this career band have a knowledge management focus and are primarily responsible for results achieved through their own work. Requires the application of theoretical knowledge, typically gained through formal
education:
or equivalent work
experience:
that provides knowledge of and exposure to fundamental theories, principles and concepts of a defined profession. Jobs at higher career levels may guide small teams in their area of subject matter expertise. Jobs at the at the most senior levels of this career band set disciplinary strategy within their areas of expertise.
Criteria & Management
Requirements:
- Problem Solving: Identifies and solves complex problems that impact multiple areas.
Applies independent analysis based on in-depth research and critical thinking to recommend solutions.
- Decisions: Routinely analyzes unique issues or problems and functions with a high degree of autonomy.
- Knowledge: Requires specialized knowledge and expertise in own job discipline and deep
experience:
in integrating related disciplinary knowledge. Applies specialized knowledge of industry standards/practices on key projects and initiatives.
- Business Acumen: Interprets internal/external business challenges.
- Recommends best practices to improve products, processes, or services to distinguish from the competition.
- Communication & Influence: Communicates difficult concepts and negotiates with others to adopt a different point of view.
Converts technical information to compelling business context and advice.
- Impact: Decisions will have significant impact to multiple departments or disciplines.
- Leadership: Manages projects and end to end programs with moderate resource
requirements:
, risk and/or complexity.
- Provides training and leadership for other team members.
Key role in planning and coordinating with others for projects or tasks. May contribute input to the performance review of other team members. Primary role is an individual contributor however may also manage one lower level employee. Work Environment: Typical Office Other Work Environment
Requirements:
Typical Office: Operates in a typical office environment, routinely uses computer and other standard office equipment. Other Physical
Requirements:
Typical Office: Generally sedentary for prolonged periods, may occasionally require ability to move
about:
or adjust/move items weighing up to 10 lbs. in all directions; Constantly requires collaboration and the ability to communicate with others to exchange information while in a typical office setting. Collaboration is generally conducted in person unless the role has been pre-approved for remote work. CLOTHING FOR POSITIVE CHANGE (C4PC) From the farm to the factory to our closets, we all have an
opportunity:
to create positive change through clothing as we work to fundamentally change the way clothing is made. Do you want to join a team committed to creating positive change in the world through the C4PC movement? Consider prAna, where you can transcend the current trends and demand more from your wardrobe and your employer; where you can help an enthusiastic and loyal audience celebrate the outdoors and their own unique style; and where you can help lessen our impact on the planet and its people every day.
ABOUT:
THE POSITION We’re looking for a Data Architect to design and implement prAna’s modern data and analytics platform. This role will define the architecture, data models, and governance standards that enable scalable, trusted insights across the business. You’ll partner closely with stakeholders to translate business
requirements:
into robust data solutions that power decision-making. HOW YOU’LL MAKE A DIFFERENCE Design and implement enterprise data architecture leveraging Microsoft Azure Data & Analytics services and Databricks for scalable ingestion, transformation, and storage.
- Develop logical and physical data models that align with business processes, ensuring clarity, consistency, and performance across analytics and reporting layers.
Partner with business teams to gather
requirements:
and translate them into data architecture blueprints, semantic models, and KPI frameworks.
- Establish standards for data governance, security, and quality, including lineage and metadata management.
- Build and optimize data pipelines and orchestration workflows using Azure Data Factory, Databricks, and related tools.
Enable self-service analytics by designing certified datasets and semantic layers for Power BI. Continuously evaluate emerging technologies and recommend improvements to enhance scalability and reliability. YOU ARE A strategic thinker who can bridge business needs and technical design. Collaborative and skilled at influencing cross-functional teams.
Detail-oriented with a passion for data integrity and architecture best practices. Comfortable leading technical discussions and mentoring others. YOU HAVE 7+ years in data architecture, data engineering, or BI roles; 2+ years in an architect or lead capacity. Expertise in data modeling (conceptual, logical, physical) and dimensional design for analytics.
Hands-on
experience:
with Microsoft Azure Data & Analytics services (Data Factory, Databricks, Synapse, Data Lake). Strong SQL and
experience:
with ETL/ELT frameworks. Familiarity with Power BI semantic modeling and governance. (Preferred) Exposure to ERP analytics (SAP) or similar enterprise systems. Salary Range: 145,000 Min – 242,000 Max Annual **Pay decisions are determined by multiple factors, including what the market is paying, a candidate’s capabilities and
skills:
, years of
experience:
, and internal equity.** #LI-JD1 Columbia Sportswear Company and our portfolio of brands, including Columbia, SOREL, Mountain Hardwear and prAna, know a thing or two
about:
adventures. After all, we've been on one since 1938, working to perfect the art of enjoying the outdoors. Behind everything we make is an employee who's found that the greatest adventure starts with joining a company that strives to do the right thing. 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. If you need an accommodation/adjustment to successfully complete and submit your application, please reach out to AskHR@columbia.com with the Subject: Applicant Assistance Requested.
Our name means breath in Sanskrit, the life force that’s part of everything. You might have noticed that we capitalize the A halfway through. That’s because we’re interested in middles. Specifically, the choices you make between your first inhale and last exhale. While your job doesn’t define your life, where you choose to work is important.
prAna started over thirty years ago with the intention of making clothes that solve problems for climbers, yogis, and creatives so they could spend more of their life doing what they love. Today, we’re still working with the same intention in mind, and if you’re interested in adding your
skills:
et to Team prAna – we would love to get to know you.
