Junior Data Engineer

Lancesoft; Charlotte (NC); On-site; USD 65,000 - 90,000; Full time

Job summary

Lancesoft is seeking a Junior Data Engineer / Software Engineer to help build and maintain data pipelines, ETL/ELT processes, and cloud-based data solutions. You will work with Python, SQL, Java, and AWS, contributing to both data engineering and software engineering tasks.

The role involves developing REST and GraphQL APIs, performing data modeling, and creating dashboards in Tableau and Power BI. Ideal for someone eager to grow across data and software disciplines, in a collaborative team

Qualifications

• Bachelor's degree or equivalent in CS/SE/Data Eng.
• 0–2 years of experience in data/ software engineering or related field.
• Working knowledge of Python, SQL, Java, AWS, REST APIs, GraphQL.
• Familiarity with relational and NoSQL databases; basic data modeling concepts.

Responsibilities

• Develop, maintain, and support data pipelines and ETL/ELT processes.
• Build and optimize data transformations, schemas, and warehousing concepts.
• Develop and consume REST and GraphQL APIs; implement authentication and error handling.
• Create dashboards/reports using Tableau or Power BI.
• Collaborate with engineers, analysts, and stakeholders; participate in code reviews and deployments.

Skills

Analytical thinking

Communication

Collaboration

Quick learner

Problem solving

Education

Bachelor’s degree in CS/SE/Data Eng

Tools

Python

Java

SQL

AWS

Azure

REST APIs

GraphQL

SSIS

Tableau

Power BI

Git & GitHub

API Testing & Documentation

GitHub Copilot / AI Agents

Job description

Position Overview

We are seeking a Junior Data Engineer / Software Engineer to support the development and maintenance of data pipelines, ETL/ELT processes, cloud-based solutions, software services, APIs, and reporting platforms. The ideal candidate will have working knowledge of Python, SQL, Java, AWS, REST APIs, and GraphQL, along with an understanding of relational and non-relational databases. This is an excellent opportunity for someone looking to grow across both data engineering and software engineering.

Key Responsibilities

Develop, maintain, and support data pipelines and ETL/ELT processes using Python, SQL, AWS, Azure, and SSIS. Extract, transform, validate, and load data across multiple systems. Support cloud-based data solutions using AWS S3, Glue, Lambda, Redshift, RDS, and CloudWatch. Write and optimize SQL queries, stored procedures, views, and transformation logic. Support data integration across relational and non-relational databases. Assist with data modeling, data warehousing, data marts, schemas, and dimensional models. Develop, test, and support software services using Java and Python. Develop and consume REST APIs, including authentication, JSON, HTTP methods, error handling, and documentation. Support GraphQL APIs, including schemas, queries, mutations, resolvers, and integrations. Support API integrations between internal applications, data platforms, and external services. Monitor pipelines, APIs, and applications and assist with troubleshooting. Support data quality, performance, and processing issue resolution. Develop and maintain dashboards and reports using Tableau and Power BI. Use Git and GitHub for version control, collaboration, and pull requests. Participate in testing, code reviews, deployments, and production support. Document data flows, API specifications, transformation rules, and technical processes. Use approved AI-assisted development tools such as GitHub Copilot and AI agents in accordance with security and confidentiality requirements. Collaborate with engineers, architects, analysts, and business stakeholders.

Required Qualifications

Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or related field. Equivalent practical experience may be considered. 0–2 years of experience in data engineering, software engineering, application development, database development, or a related field. Working knowledge of: Python SQL Java AWS REST APIs Basic understanding of ETL/ELT, data pipelines, and data integration. Understanding of relational database concepts including tables, keys, joins, indexes, views, and normalization. Foundational knowledge of GraphQL, including schemas, queries, and mutations. Familiarity with software development practices including testing, debugging, code reviews, documentation, and version control. Familiarity with Git and GitHub. Strong analytical, problem-solving, communication, and collaboration skills.

Preferred Qualifications

Hands-on experience with AWS S3, Glue, Lambda, Redshift, RDS, and CloudWatch. Experience with Microsoft Azure data services. Experience with SSIS / SQL Server Integration Services. Familiarity with NoSQL databases such as DynamoDB or MongoDB. Experience developing or consuming REST and GraphQL APIs. Familiarity with Postman, Swagger, or OpenAPI. Experience with Java, Spring, or Spring Boot. Experience with Tableau or Power BI. Exposure to data warehousing and dimensional modeling. Knowledge of JSON, XML, and semi-structured data. Familiarity with CI/CD, containerization, monitoring, and cloud deployment. Experience with GitHub Copilot, AI agents, or other approved AI-assisted development tools.

Core Technical Skills

Python Java SQL AWS Azure REST APIs GraphQL APIs ETL/ELT SSIS Relational & NoSQL Databases Data Modeling & Data Warehousing Git & GitHub Tableau / Power BI API Testing & Documentation GitHub Copilot / AI Agents

Key Competencies

Strong analytical and problem-solving abilities. Engineering mindset with a willingness to learn and grow. Understanding of data quality, accuracy, security, and governance. Ability to collaborate with both technical and non-technical stakeholders. Strong written and verbal communication. High attention to detail and commitment to quality. Ability to quickly learn new technologies, APIs, programming languages, and cloud platforms. Responsible use of AI-assisted development tools while protecting confidential information.