TriTech Enterprise Systems, Inc. (TriTech) is seeking a Data/ETL Developer to support a State of Maryland contract by designing, building, and maintaining data pipelines and infrastructure to support data-driven decisions and analytics.
Requirements
- Minimum 5 + years ETL coding experience
- Proficiency in programming languages such as Python and SQL for data processing and automation
- Experience with distributed computing frameworks like Apache Spark or similar technologies
- Experience with AWS data environment, primarily Glue, S3, DocumentDB, Redshift, RDS, Athena, etc.
- Experience with data warehouses/RDBMS like Redshift and NoSQL data stores such as DocumentDB, DynamoDB, OpenSearch, etc.
- Experience in building data lakes using AWS Lake Formation
- Experience with workflow orchestration and scheduling tools like AWS Step Functions, AWS MWAA, etc.
Responsibilities
- Design, develop and maintain data pipelines, and extract, transform, load (ETL) processes to collect, process and store structured and unstructured data
- Build data architecture and storage solutions, including data lakehouses, data lakes, data warehouse, and data marts to support analytics and reporting
- Develop data reliability, efficiency, and qualify checks and processes
- Prepare data for data modeling
- Monitor and optimize data architecture and data processing systems
- Administer testing and troubleshooting related to performance, reliability, and scalability
- Design and implement robust, scalable data models to support PMM application, analytics, and business intelligence initiatives
Other
- Collaboration with multiple teams to understand requirements and objectives
- Create and update documentation
- Lead and mentor junior data engineers and team members on AWS best practices and technical challenges
- 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
