Kampgrounds of America, Inc. · 20 hours ago
ETL DEVELOPER
1205 N Transtech Way, Billings, MT 59102, USA
Full-time
Onsite
Mid Level
$90K/yr - $90K/yrKampgrounds of America, Inc. (KOA) is the world’s largest network of privately owned campgrounds and the leader in outdoor hospitality. The ETL Developer is responsible for designing, developing, and maintaining robust data integration solutions to transform KOA data into a consumable format for end users and applications.
Vacation Rental
No H1B
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
Qualification
Required
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
Familiarity with CI/CD practices and data governance
Experience with Power BI
Benefits
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
Company
Kampgrounds of America, Inc.
Kampgrounds of America Inc. (KOA) is the world’s largest family camping company, helping family and friends enjoy the great outdoors for 55 years.
Founded in 1962East Lansing, Michigan, USA
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Kathryn Berta
Co-Owner
Recent News
2025-11-20
Company data provided by crunchbase