Job ID: req4907
Job Category: Corporate
Location: Hamel, MN, US
Job Title: ETL Developer
FLSA Status: Exempt
Department: Information Technology
Reports to: VP of IT
Flex Work Eligible! This position qualifies for the Flexible Work Policy. Employees receive 75 workdays annually to work remote! The initial amount of days is prorated for the first year based on start date.
GENERAL DESCRIPTION / PURPOSE:
This role of ETL Developer will be responsible for the data in the data warehouse integration process. They are responsible for designing, engineering, and implementing the ETL pipelines that extract data from various source systems, transforming the data based on requirements and design, and loading it into the data warehouse. Candidates must have a strong understanding of data modeling, SQL, and ETL tools such as Informatica, Talend, or SSIS. This role will support in the assurance of data accuracy for use in reporting and analysis.
ESSENTIAL JOB FUNCTIONS:
- Designing and implementing robust data warehouse architectures that support business requirements.
- Collaborating with business analysts and data scientists to understand analytical needs and deliver appropriate data structures.
- Writing complex SQL queries for data manipulation and retrieval.
- Assisting in the creation of data models that accurately represent business processes and support analytics.
- Developing ETL (Extract, Transform, Load) processes to integrate data from multiple sources into a centralized repository.
- Ensuring the security of the data warehouse and compliance with data governance standards.
- Optimizing data warehouse performance through indexing, partitioning, and query tuning.
- Testing and troubleshooting data systems to ensure accuracy and quality of data.
- Assist in documenting the data warehouse environment and maintaining metadata repositories.
- Assist in providing support and training to end-users on data warehouse usage and best practices.
EDUCATION:
- Bachelor’s degree in computer science, information technology, data science, statistics, applied mathematics, software engineering or related fields.
- Preferred master’s in computer science or information systems.
REQUIRED QUALIFICATIONS:
- 10+ years of relevant professional experience.
- 5+ years of experience in SQL/ETL development tools.
- 5+ years of database development experience with Oracle or SQL Server.
- 3+ years of hands-on working with dimensionally modeled data, data marts and data warehouses.
- Any experience with a cloud platform like Azure or AWS.
- Proficiency in SQL required.
- Solid understanding of data warehousing concepts and best practices.
DESIRED SKILLS:
- Well organized with the ability to manage multiple priorities.
- Solid communication and interpersonal skills, ability to work on a team.
- Ability to drive work to completion and escalate when necessary.
- Ability to learn new skills and technologies as needed.
- Experience with Microsoft Fabric with the Power BI Reporting Services.
WORKING CONDITIONS:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the role. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Office deskwork, requiring sitting, walking, using phone & computer
- May lift up to 30 lbs. occasionally
- 10% or more travel including international
Benefits for this role include a comprehensive package with company-sponsored medical, dental, and vision insurance; Health Savings Account (HSA) and Flexible Spending Account (FSA) options; wellness programs; basic life and AD&D insurance; voluntary life insurance; company paid short-term and long-term disability coverage; 401(k) retirement plan including an employer match of 150% up to the first 6% you contribute to the Plan; Employee Assistance Program (EAP); behavioral health support; and leaves of absence. Additional benefits include tuition reimbursement, payroll charity contributions, adoption assistance and optional plans such as legal, critical illness, and hospitalization.
Loram determines compensation based on factors such as skills, competencies, education, and/or experience. Certain positions may be eligible for an annual bonus and paid time off in addition to base compensation.
Starting pay for the position is between $$103,110.40 – $128,888.00
Loram is an Equal Opportunity Employer and will make all employment-related decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, marital status, familial status, status with regard to public assistance, membership or activity in a local commission, protected veteran status, or any other status protected by applicable law.
Revised: May 2025
#LI-HYBRID
#LI-KK1
Job ID: req4907
Job Category: Corporate
Location: Hamel, MN, US
DESCRIPTION
Job Title: ETL Developer
FLSA Status: Exempt
Department: Information Technology
Reports to: VP of IT
Flex Work Eligible! This position qualifies for the Flexible Work Policy. Employees receive 75 workdays annually to work remote! The initial amount of days is prorated for the first year based on start date.
GENERAL DESCRIPTION / PURPOSE:
This role of ETL Developer will be responsible for the data in the data warehouse integration process. They are responsible for designing, engineering, and implementing the ETL pipelines that extract data from various source systems, transforming the data based on requirements and design, and loading it into the data warehouse. Candidates must have a strong understanding of data modeling, SQL, and ETL tools such as Informatica, Talend, or SSIS. This role will support in the assurance of data accuracy for use in reporting and analysis.
ESSENTIAL JOB FUNCTIONS:
- Designing and implementing robust data warehouse architectures that support business requirements.
- Collaborating with business analysts and data scientists to understand analytical needs and deliver appropriate data structures.
- Writing complex SQL queries for data manipulation and retrieval.
- Assisting in the creation of data models that accurately represent business processes and support analytics.
- Developing ETL (Extract, Transform, Load) processes to integrate data from multiple sources into a centralized repository.
- Ensuring the security of the data warehouse and compliance with data governance standards.
- Optimizing data warehouse performance through indexing, partitioning, and query tuning.
- Testing and troubleshooting data systems to ensure accuracy and quality of data.
- Assist in documenting the data warehouse environment and maintaining metadata repositories.
- Assist in providing support and training to end-users on data warehouse usage and best practices.
QUALIFICATIONS
EDUCATION:
- Bachelor’s degree in computer science, information technology, data science, statistics, applied mathematics, software engineering or related fields.
- Preferred master’s in computer science or information systems.
REQUIRED QUALIFICATIONS:
- 10+ years of relevant professional experience.
- 5+ years of experience in SQL/ETL development tools.
- 5+ years of database development experience with Oracle or SQL Server.
- 3+ years of hands-on working with dimensionally modeled data, data marts and data warehouses.
- Any experience with a cloud platform like Azure or AWS.
- Proficiency in SQL required.
- Solid understanding of data warehousing concepts and best practices.
DESIRED SKILLS:
- Well organized with the ability to manage multiple priorities.
- Solid communication and interpersonal skills, ability to work on a team.
- Ability to drive work to completion and escalate when necessary.
- Ability to learn new skills and technologies as needed.
- Experience with Microsoft Fabric with the Power BI Reporting Services.
WORKING CONDITIONS:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the role. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Office deskwork, requiring sitting, walking, using phone & computer
- May lift up to 30 lbs. occasionally
- 10% or more travel including international
Benefits for this role include a comprehensive package with company-sponsored medical, dental, and vision insurance; Health Savings Account (HSA) and Flexible Spending Account (FSA) options; wellness programs; basic life and AD&D insurance; voluntary life insurance; company paid short-term and long-term disability coverage; 401(k) retirement plan including an employer match of 150% up to the first 6% you contribute to the Plan; Employee Assistance Program (EAP); behavioral health support; and leaves of absence. Additional benefits include tuition reimbursement, payroll charity contributions, adoption assistance and optional plans such as legal, critical illness, and hospitalization.
Loram determines compensation based on factors such as skills, competencies, education, and/or experience. Certain positions may be eligible for an annual bonus and paid time off in addition to base compensation.
Starting pay for the position is between $$103,110.40 – $128,888.00
Loram is an Equal Opportunity Employer and will make all employment-related decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, marital status, familial status, status with regard to public assistance, membership or activity in a local commission, protected veteran status, or any other status protected by applicable law.
Revised: May 2025
#LI-HYBRID
#LI-KK1
ABOUT
Based in Hamel, Minnesota, Loram Maintenance of Way, Inc. designs and builds some of the most sophisticated railway maintenance equipment in the world, delivering high quality products and services to our global customers. This is made possible by employees who are passionate about delivering advanced equipment, innovative solutions, and unrivaled customer service.
For more information about Loram go to:
Based in Georgetown, Texas, Loram Technologies, Inc. provides innovative solutions for the railroad industry. From our friction management application systems to our Aurora® track inspection systems, our products are technologically advanced, safer, more efficient, and more productive than traditional maintenance methods.
For more information about LTI go to:
http://www.loramtechnologies.com
Loram is proud to be an Equal Opportunity Employer of Minorities, Females, Protected Veterans, and Individuals with Disabilities.
Job Title: ETL Developer
FLSA Status: Exempt
Department: Information Technology
Reports to: VP of IT
Flex Work Eligible! This position qualifies for the Flexible Work Policy. Employees receive 75 workdays annually to work remote! The initial amount of days is prorated for the first year based on start date.
GENERAL DESCRIPTION / PURPOSE:
This role of ETL Developer will be responsible for the data in the data warehouse integration process. They are responsible for designing, engineering, and implementing the ETL pipelines that extract data from various source systems, transforming the data based on requirements and design, and loading it into the data warehouse. Candidates must have a strong understanding of data modeling, SQL, and ETL tools such as Informatica, Talend, or SSIS. This role will support in the assurance of data accuracy for use in reporting and analysis.
ESSENTIAL JOB FUNCTIONS:
- Designing and implementing robust data warehouse architectures that support business requirements.
- Collaborating with business analysts and data scientists to understand analytical needs and deliver appropriate data structures.
- Writing complex SQL queries for data manipulation and retrieval.
- Assisting in the creation of data models that accurately represent business processes and support analytics.
- Developing ETL (Extract, Transform, Load) processes to integrate data from multiple sources into a centralized repository.
- Ensuring the security of the data warehouse and compliance with data governance standards.
- Optimizing data warehouse performance through indexing, partitioning, and query tuning.
- Testing and troubleshooting data systems to ensure accuracy and quality of data.
- Assist in documenting the data warehouse environment and maintaining metadata repositories.
- Assist in providing support and training to end-users on data warehouse usage and best practices.
RECEIVE JOB ALERTS
Be the first to know about the jobs that are right for you. Set your criteria and sign up now.
About the area
Find out more about Hamel, MN
Loram is an Equal Opportunity Employer and will make all employment-related decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, marital status, familial status, status with regard to public assistance, membership or activity in a local commission, protected veteran status, or any other status protected by applicable law.
Loram is committed to protecting the identity and personal information of any potential employee. Loram applicants will only be contacted by Loram employees with an authentic Loram email address ending in @loram.com. We encourage you to verify the identity of any individual who claims to be a member of the Loram team by confirming the email address is @loram.com with no additional characters or letters. We will never request financial information or a financial commitment as part of the recruitment process. If you have a question about the authenticity of any communication claiming to be from Loram, please contact loramrecruiting@loram.com. Reports can be submitted online at www.loram.ethicspoint.com or by calling 1-844-635-4640.
- © 2024 Loram Maintenance of Way, All rights reserved.
- Terms of Use
- Privacy Policy