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
The Software Applications Engineer is responsible for operational execution and will participate in design, vendor evaluation, implementation, and management of multiple projects. This position collaborates with our Information Systems team to develop and support applications to serve prAna. This position will span many roles including Systems Integration, Database Administration and Database Development and Operational Support.
This position will focus on System Integrations, Application Development and Support activities. Examples include:
Integrate with Email Service Provider including data feed generation and API calls.
Digital asset manager integration including automation of asset transfer and metadata.
Develop and support a Product Lifecycle Management tool
Integrate and modify third party vendors to our data warehouse using data feeds and API methods.
Troubleshoot and support existing integrations.
HOWYOULLMAKE A DIFFERENCE
Responsible for Systems Integration, Application Development, BI Reporting, Integration & Data Management
Develop integration strategies for new systems.
Documentation of complex concepts such as security models and technical decisions.
Coordinate the transition between specification and implementation.
Experience in ETL using SQL Server Integration Services (SSIS).
Experience in performance tuning especially tuning complex queries, stored procedures, functions, and indexing strategies.
Impact analysis for organization change management support.
Work with business users to establish reporting and analytic requirements.
Develop user interfaces within the Microsoft Power Apps and Power Automate framework
Perform Sharepoint 365 site administration
Create end-to-end design for each requirement and generate professional documentation for requirements, design, development, and testing
Build data sources to power the visualizations and create data models for each data source
Design and develop ETL jobs or extracts to pull the data required for the visualizations
Tune ETL code\Reports to the optimum performance possible
Investigate data issues and document root causes and resolutions
Outstanding interpersonal abilities, and strong written and verbal communication skills in order to communicate clearly with technology partners and business users to demonstrate your expertise of technology.
Adaptable, flexible with ability to adjust to any changing environment.
Self-Directed and self-reliant and able to work independently to accomplish goals
Strong attention to detail
Demonstrated ability to set priorities, use time effectively and efficiently to meet deadlines and commitments
Bachelors in computer engineering, computer science, or related field
5+ years of enterprise applications system administration/development experience
5+ years of experience with SQL Server databases
Experience with SQL Server, advanced stored procedures and SSIS package development
Microsoft Power Platform (PowerApps, Power Automate)
SharePoint 365 Site Administration to support application development
Development and support of data models and Business Intelligence solutions
Demonstrated knowledge in XML/JSON and web services
Writing and tuning complex SQL queries, views, indexes, and functions
Agile SDLC methodology
Expert in visualizations and data source design & development (DOMO expert is preferred, if not we can check resources with Tableau\Spotfire\other visualization tools)
Experience with data science tools, R/ Python
Occasional domestic travel to Portland, OR when necessary
To learn more about our hiring process during COVID-19, click here.
We create versatile, stylish, and sustainable clothing and accessories that you can wear during every activity, every adventure, every day. How do we know? Because we base our designs on our own experiences. You see were more than makers, were doersyogis, climbers, and world travelersand we use our knowledge to make adventurous, free-spirited clothes that look good and play hard.
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.
At Columbia Sportswear Company (CSC), we are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and teammates without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, military and veteran status, and any other characteristic protected by applicable law. CSC believes that diversity and inclusion among our teammates is critical to our success as a global company, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool. All employment is decided on the basis of qualifications, merit, and business need.