POSITION OVERVIEW:

We are seeking a motivated Junior Data Engineer to support database development, data integration, and cloud-based data management activities. The ideal candidate will have foundational SQL development skills, experience with PostgreSQL and SQL Server, and exposure to AWS data services. This role offers hands-on experience in database design, ETL development, performance tuning, and compliance support, while working closely with senior engineers, DBAs, and application development teams.

QUALIFICATIONS & REQUIREMENTS

• 1–3 years of experience in SQL development and database fundamentals.
• Hands-on experience with PostgreSQL and SQL Server (required).
• Basic understanding of database design principles, normalization, and data modeling concepts.
• Experience writing stored procedures, functions, and triggers.
• Familiarity with performance concepts such as indexing and query optimization.
• Experience building ETL processes and data pipelines using Python, SQL, or ETL platforms (e.g., AWS Glue, Step Functions, Lambda).
• Understanding of data integration patterns and best practices.
• Familiarity with data transformation and validation techniques.
• Experience with AWS services (RDS, EC2, Glue, Step Functions, Lambda).
• Exposure to Amazon Redshift preferred for data warehousing.
• Understanding of cloud database deployment and management concepts.
• Basic knowledge of Infrastructure as Code (IaC) and CI/CD principles.
• Basic knowledge of data management, cataloging tools, and metadata practices.

ADDITIONAL REQUIREMENTS:

• Ability to work collaboratively in a team environment under the guidance of senior engineers.
• Strong problem-solving skills and eagerness to learn modern data engineering tools and practices.
• Excellent communication and documentation skills.

• Assist with database schema design and data modeling.
• Develop stored procedures, functions, triggers, and other database objects.
• Build and support ETL processes and data pipelines for data integration.
• Help implement automation and CI/CD processes for database and pipeline deployments.
• Create and optimize database APIs and data access layers.
• Maintain accurate technical documentation for database and integration solutions.
• Monitor data integration performance and troubleshoot bottlenecks.
• Assist DBAs with query optimization and indexing strategies.
• Support performance testing, analysis, and partitioning efforts.
• Contribute to building monitoring dashboards and reporting solutions.
• Support database migration and upgrade projects.
• Assist with data quality validation and testing processes.
• Help implement data archiving and retention procedures.
• Participate in backup, recovery, and disaster recovery testing activities.
• Support data cataloging, metadata documentation, and knowledge management tasks.
• Implement database security controls following established policies.
• Assist with FISMA compliance documentation and audit preparation.
• Support data masking, encryption, and security monitoring processes.
• Work with cloud database platforms, primarily Amazon RDS (SQL Server, PostgreSQL), with additional support for EC2-based databases and Amazon Redshift.
• Contribute to automation and CI/CD initiatives for databases and pipelines.
• Collaborate with development teams to apply database best practices.
• Participate in technical reviews, code reviews, and ongoing learning opportunities.
• Support business users with data requirements gathering and basic reporting needs.