Jr. Data Engineer

Kalani Consulting, Inc.; Leesburg (VA); On-site; USD 70,000 - 90,000; Full time

Job summary

Kalani Consulting, Inc. seeks a Junior Data Engineer who will build and maintain scalable automated data pipelines and cloud data solutions. The ideal candidate will have a BA or BS degree in Computer Science or a related field, with experience in ETL pipeline development using Apache Spark and SQL. A collaborative work culture rooted in integrity and excellence is offered, along with competitive benefits. This position is remote and requires a US citizenship for security clearance.

Qualifications

• BA or BS degree in CS, Information Systems, or related field.
• Experience developing and deploying ETL pipelines using Apache Spark and/or Databricks.
• Experience in SQL and/or Spark SQL.
• Familiarity with Informatica a plus.
• Knowledge of dimensional models in data warehouses.
• Experience working on loading data to the Star Schema.

Responsibilities

• Engineer, build and maintain scalable automated data pipelines.
• Build cloud data solutions and provide domain perspective on storage and big data platform services.
• Deploy, automate, maintain, and manage cloud-based production system.
• Implement best practices in the management of data including master data and data quality.
• Support regular and ad-hoc data querying and analysis.

Skills

Experience developing and deploying ETL pipelines using Apache Spark and/or Databricks

Experience in SQL and/or Spark SQL

Familiarity with Informatica

Knowledge of dimensional models in data warehouses

Experience working on loading data to the Star Schema

Education

BA or BS degree in CS, Information Systems, or related field

Job description

JUNIOR DATA ENGINEER

REMOTE

Overview

Kalani Consulting, Inc. is a multi-award-winning small business based in Northern Virginia, proudly supporting federal government clients through expert Information Technology and Management Consulting services. We’re an employee-focused company that values hard work, integrity, and excellence—offering competitive benefits, meaningful opportunities, and a culture rooted in The Aloha Spirit.

Responsibilities

• Engineer, build and maintain scalable automated data pipelines.
• Build cloud data solutions and provide domain perspective on storage, big data platform services, serverless architecture, RDBMS, DW/DM, NoSQL databases and security.
• Deploy, automate, maintain, and manage cloud-based production system, to ensure the availability, performance, scalability, and security of productions systems.
• Implement best practices in management of data, including master data, reference data, metadata, data quality and lineage.
• Support regular and ad‑hoc data querying and analysis to understand customer behaviors.

Qualifications

• BA or BS degree in CS, Information Systems, or related field.
• Experience developing and deploying ETL pipelines using Apache Spark and/or Databricks.
• Experience in SQL and/or Spark SQL.
• Familiarity with Informatica a plus.
• Knowledge of dimensional models in data warehouses.
• Experience working on loading data to the Star Schema.

Preferred Qualification

• Knowledge of and experience with automated testing.
• Knowledge and experience of deployment of Spark Notebooks.

Clearance Requirement

Must be US Citizen with the ability to obtain and maintain a US Public Trust Suitability.

Kalani Consulting, Inc. is an equal opportunity employer that values the strength diversity brings to the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law.