SSIS Developer

Employment Type

: Full-Time


: Miscellaneous

Job Details



Alterra Mountain Company Shared Services Inc. (the Company) is a family of 15 iconic year-round destinations, including the world’s largest heli-ski operation, offering the Ikon Pass, the new standard in season passes. The Ikon Pass connects the most iconic mountains across North America, Australia, New Zealand, Japan and Chile, delivering authentic, memorable snow adventures. The Company owns and operates a range of recreation, hospitality, real estate development, food and beverage, retail and service businesses. Headquartered in Denver, Colorado, with destinations across the continent, Alterra Mountain Company is rooted in the spirit of the mountains and united by a passion for outdoor adventure. Alterra Mountain Company’s family of diverse playgrounds spans six U.S. states and three Canadian provinces: Steamboat and Winter Park Resort in Colorado; Squaw Valley Alpine Meadows, Mammoth Mountain, June Mountain and Big Bear Mountain Resort in California; Stratton and Sugarbush in Vermont; Snowshoe in West Virginia; Tremblant in Quebec, Blue Mountain in Ontario; Crystal Mountain in Washington; Deer Valley Resort and Solitude Mountain Resort in Utah; and CMH Heli-Skiing & Summer Adventures in British Columbia. Also included in the portfolio is Alpine Aerotech, a worldwide helicopter support and maintenance service center in British Columbia, Canada. Alterra Mountain Company honors each destination’s unique character and authenticity and celebrates the legendary adventures and enduring memories they bring to everyone.


Alterra Mountain Company is looking for an SSIS Developer to support the Company’s ongoing ERP implementation (Dynamics 365 Finance & Operations) and integration efforts towards a companywide vision. This role will work directly with the Enterprise Applications Manager to realize solutions to the various business requirements given. On the technical-level-- having an eye for efficiency, flexibility and automation are highly beneficial, as well as having solid interpersonal skills and excellent written and oral communication of potentially complex topics with fellow team members and end-users.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.


General Responsibilities

  • Understand and analyze requirements to develop, test, configure and deploy complex SSIS packages
  • Use of SQL Server 2012, 2014 or 2016 experience to implement robust, maintainable solutions that meet requirements
  • Evaluate large and complex data sets
  • Troubleshoot SSIS packages to address critical production issues
  • Optimize data warehouse performance by dealing with any data conflicts that arise and keep data definitions up to date
  • Assist application developers in refining complex queues and performance tuning 
  • Create tables, assign permissions, import data, perform app configurations, etc. 
  • Manage source code versioning and deployments 
  • Stay knowledgeable with the latest advances in SQL Server and other data technologies 
  • Responsible for daily load procedures using SSIS, T-SQL, and SQL Agent jobs
  • Conduct multi-dimensional cube development, maintenance, and processing
  • Work with business users and other stakeholders to understand business processes and translate them into functional and non-functional specifications for development
  • Identify problem trends and corrective actions and documenting these through modification of existing best practices guidelines
  • Conducts unit testing and debugging along with system and integration testing
  • Produces technical specifications and software design documents

    Education & Experience

  • Bachelor’s degree in Computer Science or related field. Or equivalent combination of education and experience.
  • 3-5 years of data integration development experience
  • Experience with MS SQL server, SSIS, SSRS, job Scheduling tool, and normalized and dimensional modeling
  • Experience with database migration automation in support of a continuous integration, continuous delivery model
  • Experience working successfully with both technical personnel and non-technical customers and staff

  • Microsoft Business Intelligence tools, specifically TSQL and SSIS
  • Must have a good understanding of data relationships and a strong command of SQL syntax
  • Data warehousing, data mart and database technologies, standards, and methodologies desired
  • Database tuning and performance
  • Analysis and design skills, critical thinking, and analytical problem solving
  • Managing company information databases
  • Ability to analyze, meet and recommend adjustments for company requirements
  • Knowledge of data conversion techniques
  • Experience with cloud based or self-service business intelligence platforms is also desired
  • Microsoft DevOps/VSTS, .Net

    The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

    While performing the duties of this job, the employee is regularly required to walk, talk, see, hear, smell, and ski. Must be capable of walking or standing 90% or more of a normal 8 hour work shift. Must be capable of frequently carrying, lifting, pushing or pulling up to 15lbs. Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perceptions and the ability to adjust focus.


    Indoor/Outdoor: While performing the duties of this job, the employee may be exposed to outside weather conditions.

    Hazardous Materials/Noise: The noise level in the work place is usually moderate.

    This job description is not an exhaustive list of all functions and responsibilities that an employee may be required to perform in this position. Alterra Mtn Co Shared Services Inc. and its affiliates reserve the right to modify, increase, decrease, suspend, and or eliminate any of the essential duties and/or the position in its entirety.

    This job description is not an express or implied contract, guarantee, promise, or covenant of employment for any set term or duration, or for termination only for cause.

    Employment with Alterra Mtn Co Shared Services Inc. or any of its affiliates “at will” meaning either party may terminate the employment relationship at any time with or without cause and with or without notice.

    This position is located in Colorado, and the work is primarily in Alterra Mtn Co Shared Services Inc. and, as such, employment in this position is subject to the labor and employment laws of the state of Colorado.

    Alterra Mtn Co Shared Services Inc. and its affiliates are equal opportunity employers and maintain drug-free workplaces. All employees and candidates are reminded that Alterra Mtn Co Shared Services Inc. and its affiliates adhere to all applicable labor and employment laws, and State-specific labor and employment regulations, where applicable.

    Launch your career - Create your profile now!

    Create your Profile

    Loading some great jobs for you...