Database Developer (REMOTE)

This position may be filled prior to the posted deadline. Interested candidates are encouraged to apply as soon as possible.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. This position requires the candidate to be able to obtain a Public Trust to support KGS and our government customer.Benefits include medical, dental, and vision insurance, 401(k) retirement plan, paid time off, paid parental leave, life and disability insurance, flexible spending accounts, commuter benefits and tuition reimbursement.Koniag IT Solutions is in search of a talented Database Developer to join our team. 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, and data warehousing, with expertise in data manipulation and transformation.We are seeking a highly skilled and technical Data Developer to join our team. This role will focus on data modeling, building, and optimizing data engineering pipelines, implementing CI/CD practices, and developing serverless functions, across AWS and Azure environments. The ideal candidate will be adept at managing both data engineering and infrastructure requirements to support seamless data processing, deployment, and monitoring.Education and Experience Required:Bachelor's degree in computer science, Data Development, Information Technology, or a related field7+ years of experience in data engineering, data architecture, or similar technical rolesDemonstrated expertise in database systems, data warehousing, and ETL processes6+ years as Python programming language expertRequired Skills and Competencies:ETL/ELT Processes — Building data pipelines using a mix of stored procedures, views, and Python scripts. Knowledge of tools like dbt (for SQL transformations) or simple orchestration (e.g., Airflow basics) is a plusData Quality & Testing — Implementing checks, validation, and monitoring for pipelinesVersion Control & Collaboration — Git for code (Python + SQL scripts), plus experience with CI/CD basicsPerformance & Scalability — Tuning for large volumes, understanding indexing/partitioning impacts, and basic cloud database conceptsSoft Skills — Problem-solving for debugging complex queries/pipelines, clear documentation of models and procedures, and ability to collaborate with members of a teamData Modeling:Strong experience in designing relational schemasEntity-Relationship (ER) modeling, dimensional modeling, and understanding trade-offs between normalization vs. denormalizationPractical application: Creating efficient table structures, relationships, constraints, and indexes to support query performance and scalabilityAdvance SQL & Database Querying:Mastery of complex queries: JOINs (all types), subqueries, CTEs (Common Table Expressions), window functions (ROW_NUMBER, RANK, LAG/LEAD, etc.), aggregation, pivoting, and recursive queriesQuery optimization and performance tuning: Indexing strategies, execution plans, partitioning, and handling large datasets efficientlyAdvanced techniques: CASE statements, dynamic SQL, error handling, and working with timestamps/time zonesDatabase Administration & Objects:Creating and managing stored procedures (for encapsulating business logic, ETL processes, and reusable code)Creating and optimizing views (including materialized views where supported) for exposing cleaned/transformed data to reporting applicationsOther DBA tasks: Triggers, user-defined functions, permissions/security, backups, and basic maintenanceFamiliarity with ACID properties, constraints, and database-specific featuresPython Programming for Data Engineering:Solid proficiency in Python for scripting, automation, and data manipulationKey libraries: pandas (data wrangling), NumPy, SQL Alchemy or psycopg2/pyodbc (for database connectivity), requests (APIs), and basic ETL scriptingWriting modular code: Functions, classes, error handling, logging, and integrating Python with databases (e.g., running queries, loading data, or orchestrating processes)Experience building or supporting data pipelines that combine Python with SQL (e.g., Python calling stored procedures or handling complex transformations)Relational Database Experience:Hands-on work with at least one major RDBMS (e.g., SQL Server for T-SQL/stored procedures, PostgreSQL, MySQL (Preferably)Understanding of database-specific dialects, as stored procedures and advanced features vary (e.g., T-SQL vs. PL/pgSQL)Other Key Skills:Excellent problem-solving and analytical abilities with attention to detailStrong communication and collaboration skills in cross-functional and distributed teamsSecurity Requirement:Ability to obtain Public TrustOur Equal Employment Opportunity PolicyThe company is an equal opportunity employer. The company shall not discriminate against any employee or applicant because of race, color, religion, creed, ethnicity, sex, sexual orientation, gender or gender identity (except where gender is a bona fide occupational qualification), national origin or ancestry, age, disability, citizenship, military/veteran status, marital status, genetic information or any other characteristic protected by applicable federal, state, or local law. We are committed to equal employment opportunity in all decisions related to employment, promotion, wages, benefits, and all other privileges, terms, and conditions of employment.The company is dedicated to seeking all qualified applicants. If you require an accommodation to navigate or apply for a position on our website, please get in touch with Heaven Wood via e-mail at accommodations@koniag-gs.com or by calling 703-488-9377 to request accommodations.Koniag Government Services (KGS) is an Alaska Native Owned corporation supporting the values and traditions of our native communities through an agile employee and corporate culture that delivers Enterprise Solutions, Professional Services and Operational Management to Federal Government Agencies. As a wholly owned subsidiary of Koniag, we apply our proven commercial solutions to a deep knowledge of Defense and Civilian missions to provide forward leaning technical, professional, and operational solutions. KGS enables successful mission outcomes for our customers through solution-oriented business partnerships and a commitment to exceptional service delivery. We ensure long-term success with a continuous improvement approach while balancing the collective interests of our customers, employees, and native communities. For more information, please visit www.koniag-gs.com.Equal Opportunity Employer/Veterans/Disabled. Shareholder Preference in accordance with Public Law 88-352Job DetailsJob Family Databases and Data WarehousingJob Function Database ArchitectPay Type SalaryHiring Min Rate 130,000 USDHiring Max Rate 155,000 USD