Jr Data Engineer

Priwils, Inc • Full-time • Washington, District of Columbia, United States • $70.50k - $104.97k / year • 2d ago

Job Summary
This role involves supporting database development, integration, and automation with a focus on PostgreSQL, SQL Server, and AWS platforms such as RDS, EC2, Glue, Step Functions, and Lambda. The responsibilities include designing schemas, building ETL pipelines, optimizing queries, implementing security measures, supporting compliance, and assisting with migrations, monitoring, and documentation. The position requires 1–3 years of SQL development experience, strong knowledge of database fundamentals, hands-on ETL skills, and familiarity with Redshift, data modeling, CI/CD, and data management concepts.

Responsibilities:

Assist with database schema design and data modeling
Develop stored procedures, functions, triggers, and database objects
Build data integration solutions including ETL processes and data pipelines
Implement database automation tools and CI/CD processes for database and data pipeline deployments
Create and optimize database APIs and data access layers
Create and maintain technical documentation for database solutions
Monitor integration performance
Assist DBA with query optimization
Implement indexing strategies and partitioning under supervision
Support performance testing and analysis efforts
Help develop 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
Support backup and recovery testing activities
Support data cataloging and metadata documentation efforts
Participate in database testing and validation activities for new features or changes
Support data relevant documentation and knowledge management activities.
Implement database security controls following established policies
Assist with FISMA compliance documentation and audit preparation
Support data masking and encryption implementation
Help maintain security monitoring processes
Work with cloud database platforms, primarily RedShift, SQL Server and PostgreSQL on RDS but may include others, and SQL Server and PostgreSQL on EC2 instances
Support database automation and CI/CD implementation
Collaborate with development teams on database best practices
Participate in technical reviews and learning opportunities
Support business users with data requirements gathering

Qualifications:

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

We will never send communications through any other domain, including @Priwilscareers.com, @gmail.com or@yahoo.com). We will never request payment from you, nor will we send payment to you, prior to your start date. If you have been asked to send or receive any payment, or if you have any doubt about whether you have been contacted by a Priwils employee, please contact us at jobs@Priwils.com

nsZ473ktKt