Data​/ETL Developer

Overview

Tri Tech Enterprise Systems, Inc. (Tri Tech) is seeking a Data/ETL Developer to support a State of Maryland contract. This hybrid position is located in Baltimore, Maryland. The candidate will be responsible for designing, building, and maintaining data pipelines and infrastructure to support data-driven decisions and analytics.

• Design, develop and maintain data pipelines and ETL processes to collect, process, and store structured and unstructured data
• Build data architecture and storage solutions, including data lake houses, data lakes, data warehouses, and data marts to support analytics and reporting
• Develop data reliability, efficiency, and quality checks and processes
• Prepare data for data modeling
• Monitor and optimize data architecture and data processing systems
• Collaborate with multiple teams to understand requirements and objectives
• Administer testing and troubleshooting related to performance, reliability, and scalability
• Create and update documentation

In addition to the responsibilities listed above, the individual will perform the following using data architecture and modeling techniques:

• Design and implement robust, scalable data models to support PMM applications, analytics, and business intelligence initiatives
• Optimize data warehousing solutions and manage data migrations in the AWS ecosystem, utilizing Amazon Redshift, RDS, and Document
  
  DB 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 issues 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 data engineers and team members on AWS best practices and technical challenges
• Collaborate with UI/API teams, 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

• 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

• Minimum of three (3) years of experience as a data engineer
• Specialized experience: experience as a data engineer or similar role with strong understanding of data architecture and ETL processes
• Minimum 5+ years ETL coding experience
• Proficiency in Python and SQL for data processing and automation
• Experience with distributed computing frameworks like Apache Spark
• Experience with AWS data environment (Glue, S3, Document
  
  DB, Redshift, RDS, Athena, etc.)
• Experience with data warehouses/RDBMS (e.g., Redshift) and No
  
  SQL data stores (Document
  
  DB, Dynamo
  
  DB, Open Search, etc.)
• Experience in building data lakes using AWS Lake Formation
• Experience with workflow orchestration and scheduling tools (AWS Step Functions, AWS MWAA, etc.)
• Strong understanding of relational databases (tables, views, indexes, table spaces)
• Experience with source control tools such as Git Hub and related CI/CD processes
• Ability to analyze a company’s data needs and strong problem-solving skills
• Experience with the SDLC and Agile methodologies

Tri Tech is an Equal Opportunity Employer.