ETL Developer

Company Overview

Milestone Technologies is a global IT managed services firm that partners with organizations to scale their technology, infrastructure and services to drive specific business outcomes such as digital transformation, innovation, and operational agility. Milestone is focused on building an employee-first, performance-based culture and for over 25 years, we have a demonstrated history of supporting category-defining enterprise clients that are growing ahead of the market. The company specializes in providing solutions across Application Services and Consulting, Digital Product Engineering, Digital Workplace Services, Private Cloud Services, AI/Automation, and ServiceNow. Milestone culture is built to provide a collaborative, inclusive environment that supports employees and empowers them to reach their full potential.

Our seasoned professionals deliver services based on Milestone s best practices and service delivery framework. By leveraging our vast knowledge base to execute initiatives, we deliver both short-term and long-term value to our clients and apply continuous service improvement to deliver transformational benefits to IT. With Intelligent Automation, Milestone helps businesses further accelerate their IT transformation. The result is a sharper focus on business objectives and a dramatic improvement in employee productivity. Through our key technology partnerships and our people-first approach, Milestone continues to deliver industry-leading innovation to our clients. With more than 3,000 employees serving over 200 companies worldwide, we are following our mission of revolutionizing the way IT is deployed.

Job Overview

We are seeking a skilled ETL Developer to join our dynamic team. The ideal candidate will be responsible for designing, developing, and maintaining robust ETL (Extract, Transform, Load) processes to support our data integration and business intelligence initiatives. This role requires a strong understanding of data warehousing concepts, data modeling, and ETL best practices.

Key Responsibilities

1. ETL Process Design and Development:

• Design, develop, and implement ETL processes for data extraction, transformation, and loading from various data sources into data warehouses and data marts.
• Create and maintain ETL workflows and scripts to ensure efficient and accurate data movement.

2. Data Integration:

• Integrate data from multiple disparate sources, ensuring consistency, accuracy, and completeness.
• Develop and maintain data integration solutions to support business intelligence and analytics requirements.

3. Data Quality and Performance:

• Implement data quality checks and validation routines to ensure the integrity of the data.
• Optimize ETL processes for performance, scalability, and efficiency.

4. Documentation and Maintenance:

• Document ETL processes, data flows, and data models for future reference and maintenance.
• Monitor ETL jobs and workflows to ensure timely and accurate data processing.

5. Collaboration:

• Work closely with data analysts, data scientists, and business stakeholders to understand data requirements and deliver solutions that meet their needs.
• Collaborate with IT and database administrators to ensure data infrastructure supports ETL processes.

6. Troubleshooting and Support:

• Diagnose and resolve issues related to ETL processes and data integration.
• Provide ongoing support and maintenance for ETL processes, ensuring minimal downtime and disruption.

Qualifications

1. Education and Experience:

• Bachelor s degree in computer science, Information Systems, or a related field.
• 1-3 years of proven experience as an ETL Developer or in a similar role.

2. Technical Skills:

• Proficiency in ETL tools such as Oracle Data Integrator (ODI), SQL Server Integration Services (SSIS), and Snowpark.
• Strong SQL skills and experience with database technologies (e.g., Oracle, SQL Server, MySQL).
• Knowledge of data warehousing concepts and data modeling techniques.
• Experience with Databricks and Snowflake.
• Experience with scripting languages (e.g., Python, Shell scripting) is a plus.

3. Soft Skills:

• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities.
• Attention to detail and a commitment to data quality.

4. Additional Skills:

• Experience with cloud data platforms (e.g., AWS, Azure, Google Cloud) is an advantage.
• Familiarity with big data technologies (e.g. Spark) is a plus.

Compensation

Estimated Pay Range:

Exact compensation and offers of employment are dependent on circumstances of each case and will be determined based on job-related knowledge, skills, experience, licenses or certifications, and location.

Our Commitment to Diversity & Inclusion