Principal Data Modeler

OUTGROWN YOUR OWN BACKYARD? COME PLAY IN OURS. 

At Columbia, we’re as passionate about the outdoors as you are. And while our gear is available worldwide, we’re proud to be based in the Pacific Northwest, where natural wonders are our playground.   

Every product we make and every task we undertake is inspired by the famous words of our founder Gert Boyle: “It’s perfect. Now make it better.” As pioneers of relentless improvement, we are constantly evolving.  

We believe the outdoors is ours to protect and strive to keep our planet healthy. We believe in empowering people to experience the outdoors to the fullest.   

And we believe in you.

ABOUT THE POSITION
Although we’re an apparel and footwear focused company, technology is central to everything we do. Columbia Sportswear’s Digital Technology (CDT) teams enable an IT infrastructure across four global brands, a global supply chain, and 500+ geographically dispersed stores. These teams support in-store, mobile, and data platforms to enhance customer interface and service in an ever-evolving industry.

As the Principal Data Modeler, you will own the data model/schema in support of CSC’s analytics initiatives.  In this role, you will be the owner of the Data & Analytics data assets.  You will determine appropriate modeling standards and develop processes to ensure compliance with these patterns.   The responsibility of this role will span components in Azure Data Lake, Azure Synapse Data Warehouse, and Azure Analysis Services.

HOW YOU WILL MAKE A DIFFERENCE

• Develop and maintain conceptual, logical, and physical data models.
• Work closely with delivery teams and subject matter experts to deliver data warehousing solutions that are reliable, flexible, scalable, and provide low-cost ownership.
• Participate in the design, development, documentation, and application of best practices and procedures that govern the implementation of data assets.
• Partner with Enterprise Architecture to ensure the data architecture aligns with the company’s overall IT and data strategies
• Partner with Data Governance to enforce governance policies, including data quality, data security, and metadata management
• Provide technical mentoring, guidance, and training to Data and Analytic engineering resources.

YOU ARE

• Able to envision a strategy, communicate and promote, and then dive in to help others achieve the vision
• An excellent communicator that can document and present complex technical information in a clear and concise manner to a variety of audiences
• Highly structured with the ability to organize others around you
• A creative thought leader that is consultative in their approach

YOU HAVE

• 5+ years of experience delivering data centric solutions on warehousing, big data, and cloud platforms
• 3+ years of experience design and tuning a MPP environment
• 3+ years of experience with an Enterprise Reporting Suite (preferred PowerBI, Analysis Services)
• Proficient in data modeling tools (Erwin, ER/Studio, or similar)
• Expert SQL and query optimization techniques
• Expert data modeling (Kimball/Inmon) techniques

#LI-JD1
 

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 is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. The Know Your Rights poster is available here: https://www.eeoc.gov/poster The pay transparency policy is available here: https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf Columbia Sportswear is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a 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.