Extract, Transform, Load (ETL) Developer Onsite and Partial Telework

Arcetyp LLC is a growing small business that provides a broad range of consulting services to US Federal Government, US Military, and Commercial clients.  Services include Management & IT Consulting, Program & Project Management, and Professional & Admin Services.

For a client engagement we have need to fill a position for a Extract, Transform, Load (ETL) Developer. The position must work 2 to 3 days a week onsite at the Government client site in Baltimore MD and telework for other days. 

POSITION OVERVIEW:

Seeking a highly skilled ETL developer whose responsibilities include designing, building, automating, and maintaining sophisticated programs that extract, convert, and load data into the Provider Management Module (PMM). This role may also supports other projects within the Project Management Office (PMO) as needed.   

Responsible for designing, building, and maintaining data pipelines and infrastructure to support data-driven decisions and analytics. The individual is responsible for the following tasks: 

1. Design, develop and maintain data pipelines, and extract, transform, load (ETL) processes to collect, process and store structured and unstructured data
2. Build data architecture and storage solutions, including datalakehouses, data lakes, data warehouse, and data marts to support analytics and reporting
3. Develop data reliability, efficiency, and qualify checks and processes
4. Prepare data for data modeling
5. Monitor and optimize data architecture and data processing systems
6. Collaboration with multiple teams to understand requirements and objectives
7. Administer testing and troubleshooting related to performance, reliability, and scalability
8. Create and update documentation

RESPONSIBILITIES:

-- Design and implement robust, scalable data models to support the application, analytics and business intelligence initiatives.

-- Optimize data warehousing solutions and manage data migrations in the AWS ecosystem, utilizing Amazon Redshift, RDS, and DocumentDB services.

-- Develop and maintain scalable ETL pipelines using AWS Glue and other AWS services to enhance data collection, integration, and aggregation.

-- Ensure data integrity and timeliness in the data pipeline, troubleshooting any issues that arise during data processing.

-- Integrate data from various sources using AWS technologies, ensuring seamless data flow across systems.

-- Collaborate with stakeholders to define data ingestion requirements and implement solutions to meet business needs.

-- Monitor, tune, and manage database performance to ensure efficient data loads and queries.

-- Implement best practices for data management within AWS to optimize storage and computing costs.

-- Ensure all data practices comply with regulatory requirements and department policies.

-- Implement and maintain security measures to protect data within AWS services.

-- Lead and mentor junior staff and team members on AWS best practices and technical skills

-- Collaborate with UI/API team, business analysts, and other stakeholders to support data-driven decision-making.

-- Explore and adopt new technologies within the AWS cloud to enhance the capabilities of the data platform.

-- Continuously improve existing systems by analyzing business needs and technology trends.

QUALIFICATIONS:

Education: This position requires a bachelor’s or master’s degree from an accredited college or university with a major in computer science, statistics, mathematics, economics, or related field. Three (3) years of equivalent experience in a related field may be substituted for the Bachelor’s degree.

General Experience: The proposed candidate must have a minimum of three (3) years of experience as an ETL Developer.

Specialized Experience: The candidate should have experience as an ETL Developer or data engineer or similar role with a strong understanding of data architecture and ETL processes. The candidate should be proficient in programming languages for data processing and knowledgeable of distributed computing and parallel processing.

-- Minimum 5 years ETL coding experience

-- Proficiency in programming languages such as Python and SQL for data processing and

automation

Arcetyp is an Equal Opportunity Employer and we highly value diversity of our workforce. We accept resumes from all interested parties and consider applicants for all positions without regard to race, color, religion, sex, national origin, age, marital status, sexual preference, personal appearance, family responsibility, the presence of a non-job-related medical condition or physical disability, matriculation, political affiliation, veteran status, or any other legally protected status. 

In submitting an application for this position via our site you are confirming that Arcetyp can submit your resume to our client(s) for review.