TriTech Enterprise Systems, Inc.
Data/ETL Developer
TriTech Enterprise Systems, Inc., Baltimore, Maryland, United States, 21276
Overview
TriTech Enterprise Systems, Inc. (TriTech) 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. Responsibilities
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 lakehouses, 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 Additional Responsibilities
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 DocumentDB services ETL Development
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 Data Integration
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 Performance Optimization
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 Security and Compliance
Ensure all data practices comply with regulatory requirements and department policies Implement and maintain security measures to protect data within AWS services Team Collaboration and Leadership
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 Innovation and Continuous Improvement
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 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 Experience
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, DocumentDB, Redshift, RDS, Athena, etc.) Experience with data warehouses/RDBMS (e.g., Redshift) and NoSQL data stores (DocumentDB, DynamoDB, OpenSearch, 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 GitHub 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 TriTech is an Equal Opportunity Employer.
#J-18808-Ljbffr
TriTech Enterprise Systems, Inc. (TriTech) 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. Responsibilities
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 lakehouses, 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 Additional Responsibilities
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 DocumentDB services ETL Development
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 Data Integration
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 Performance Optimization
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 Security and Compliance
Ensure all data practices comply with regulatory requirements and department policies Implement and maintain security measures to protect data within AWS services Team Collaboration and Leadership
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 Innovation and Continuous Improvement
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 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 Experience
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, DocumentDB, Redshift, RDS, Athena, etc.) Experience with data warehouses/RDBMS (e.g., Redshift) and NoSQL data stores (DocumentDB, DynamoDB, OpenSearch, 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 GitHub 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 TriTech is an Equal Opportunity Employer.
#J-18808-Ljbffr