Database Developer

Role Description

Koniag IT Systems, LLC, a Koniag Government Services company, is seeking a Database Developer to support KITS and our government customer. The position is remote and requires the candidate to be able to obtain a Public Trust.

The Database Developer will play a critical role in designing, building, and maintaining data systems to support business needs. The ideal candidate will have a strong background in:

• Data architecture
• Data modeling
• Data warehousing
• Data manipulation and transformation

This role will focus on:

• Data modeling
• Building and optimizing data engineering pipelines
• Implementing CI/CD practices
• Developing serverless functions across AWS and Azure environments

Qualifications

• Bachelor’s degree in computer science, Data Development, Information Technology, or a related field
• 7+ years of experience in data engineering, data architecture, or similar technical roles
• Demonstrated expertise in database systems, data warehousing, and ETL processes
• 6+ years as a Python programming language expert

Requirements

• ETL/ELT Processes: Building data pipelines using a mix of stored procedures, views, and Python scripts. Knowledge of tools like dbt or simple orchestration (e.g., Airflow basics) is a plus.
• Data Quality & Testing: Implementing checks, validation, and monitoring for pipelines.
• Version Control & Collaboration: Git for code (Python + SQL scripts), plus experience with CI/CD basics.
• Performance & Scalability: Tuning for large volumes, understanding indexing/partitioning impacts, and basic cloud database concepts.
• Soft Skills: Problem-solving for debugging complex queries/pipelines, clear documentation of models and procedures, and ability to collaborate with team members.
• Data Modeling: Strong experience in designing relational schemas, Entity-Relationship (ER) modeling, dimensional modeling, and understanding trade-offs between normalization vs. denormalization.
• Advanced SQL & Database Querying: Mastery of complex queries, query optimization, and performance tuning.
• Database Administration & Objects: Creating and managing stored procedures, optimizing views, and other DBA tasks.
• Python Programming for Data Engineering: Solid proficiency in Python for scripting, automation, and data manipulation.
• Relational Database Experience: Hands-on work with at least one major RDBMS (e.g., SQL Server, PostgreSQL, MySQL).
• Other Key Skills: Excellent problem-solving and analytical abilities with attention to detail, strong communication and collaboration skills.

Benefits

• Competitive compensation
• Extraordinary benefits package including health, dental, and vision insurance
• 401K with company matching
• Flexible spending accounts
• Paid holidays
• Three weeks paid time off
• And more

Security Requirement

• Ability to obtain Public Trust