Back

ETL Developer - Billings

$75,000 - $90,000 yearly
Full time Analysis Computer Science Data Engineering Software

Job Description

Job Description

Kampgrounds of America, Inc. (KOA) is the world’s largest network of privately owned campgrounds and the leader in outdoor hospitality.   KOA has 500+ locations across the United States and Canada including a mix of franchised and company-owned parks (OAK).  Founded in 1962, the mission of KOA is “connecting people to the outdoors and each other,” and those who represent the brand share the values of being family-oriented, passionate, entrepreneurial, customer-focused, and innovative. 

At KOA, we believe the outdoors is fun and for everyone.  We are committed to having an environment where all are treated with dignity and respect.  We strive to:

  • intentionally create a sense of community and belonging for our guests, employees and franchise partners
  • continually educate ourselves and expand our knowledge to foster an inclusive and supportive environment
  • sustain a culture that promotes diversity of thought and experiences
  • ensure everyone has the ability to experience the outdoors and that our facilities are accessible to all
  • drive change in our company and industry through action and implementation 

Summary:

The ETL Developer (Extract, Transform, and Load) is responsible for designing, developing, and maintaining robust data integration solutions and transforming KOA data into a format that is consumable by end users and applications.  This position builds scalable ETL pipelines, ensuring data accuracy, consistency, and efficient delivery from various sources into the data warehouse for analytics and reporting. 

 Essential Duties and Responsibilities:

  • Design and develop data aggregation pipelines that extract data from various sources, transform it into the desired format, and load it into the appropriate data storage systems using tools like Azure Data Factory, SSIS, or custom scripts.
  • Optimizes data pipelines and data processing workflows for performance, scalability, and efficiency.
  • Monitor, test, and troubleshoot ETL jobs to ensure high availability, performance, and data quality.
  • Implements data quality checks and validations within data pipelines to ensure the accuracy, consistency, and completeness of the data.
  • Collaborate with data scientists and data analysts to optimize models and algorithms for data quality, security, and governance.
  • Write and optimize complex SQL queries and scripts for data manipulation.
  • Integrates data from different sources, including databases, data warehouses, APIs, and external systems.
  • Develop source-to-target mappings and detailed transformation logic.
  • Transforms raw data into a usable format by applying data cleansing, aggregation, filtering, and enrichment techniques.
  • Ensures data quality and accuracy by performing data validation, monitoring, error-handling processes, and cleaning as needed.
  • Identifies and implements optimizations to continually enhance query performance, reduce processing time, and increase overall productivity.
  • Delivers well-defined, transformed, tested, documented, and code-reviewed datasets for analysis.
  • Collaborate with business analysts and stakeholders to understand data requirements and deliver effective data solutions.

 Non-Essential Duties and Responsibilities:

  • This job description is not intended to cover or contain a comprehensive listing of activities, duties, or responsibilities. Other duties, responsibilities and activities may change or be assigned at any time with or without notice.

 Required Education and Experience:

  • Bachelor's degree in Computer Science, IT, or related field (or equivalent experience).
  • Proven experience in designing and building ETL pipelines.
  • Experience with cloud data platforms (Azure, AWS, GCP). Strong SQL proficiency and database knowledge (e.g., MS SQL Server, Oracle).
  • Experience with at least one major ETL tool (Data Factory, SSIS) 
  • Programming skills in Python, Java, or similar.
  • Understanding of data warehousing concepts and dimensional modeling.
  • Excellent analytical, problem-solving, and communication skills. 

 Preferred Education and Experience:

  • Familiarity with CI/CD practices and data governance
  • Experience with Power BI

 Physical Demands and Working Conditions:

  • Work is performed in an office environment and requires the ability to operate standard office equipment and keyboard, including lifting and carrying a laptop and other small items up to 20 pounds.
  • Prolonged exposure to computer screens and artificial lighting.
  • Use of repetitive motion, standing, bending, sitting, lifting, and walking short distances.
  • May be expected to drive a vehicle to KOA locations, other locations as directed, and conferences which requires close and distance vision, sitting, seeing and reading signs, traffic signals, other vehicles, etc. Travel occurs in all weather conditions, including extreme heat and cold.
  • Frequent in person interaction with KOA employees in various settings, where noise level is typically low to moderate, including office spaces.
  • Will experience occasional interruptions and shifting priorities.

 KOA does not sponsor Visas

KOA currently does NOT hire in the following states:

Alabama

Idaho

Mississippi

Pennsylvania

Alaska

Illinois

Missouri

Rhode Island

Arkansas

Iowa

Nebraska

South Carolina

Delaware

Kansas

New Hampshire

South Dakota

District of Columbia

Louisiana

North Dakota

Vermont

Hawaii

Maryland

Oklahoma

West Virginia

 

Minnesota

Oregon

Wisconsin

Benefits Offered:

  • Medical/Vision Insurance
  • Dental Insurance
  • Health Savings Account
  • Flexible Spending Account
  • Dependent Care Account
  • Paid Life & AD&D Insurance
  • Paid Short Term and Long Term Disability
  • Voluntary Life & AD&D Insurance
  • Voluntary Critical Illness Insurance
  • Voluntary Accident Insurance
  • Voluntary Hospital Indemnity Insurance
  • Paid Time Off
  • Paid Parental Leave
  • Employee Assistance Program
  • 401K Retirement Plan
  • 401K Company Contributions

Kampgrounds Of America, Inc. is an Equal Opportunity Employer and strives to provide an environment where all employees and applicants are treated with respect.  The company is committed to fair treatment of all people. This value ensures employees and candidates are treated equally and are protected from discrimination or harassment of any kind.  All employment decisions shall be made without regard to race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, or other non-merit-based factors, or any other protected status.

Kampgrounds of America, Inc. (KOA)
About Kampgrounds of America, Inc. (KOA)

With over 500 campgrounds nationwide, Kampgrounds of America Inc. (KOA) is the world’s largest system of privately held campgrounds. KOA has been nationally recognized for its work in public relations, marketing, and franchise satisfaction. At KOA, our mission is to connect people to the outdoors and each other.

Apply Now