Data Engineer

Pantheon Data • Full-time • Remote (Leesburg, Virginia, United States) • $100k - $132k / year • 3d ago

Company Overview

Pantheon Data (a Kenific Holding company) is a private, small business based in the Washington, DC, area. Pantheon Data was founded in 2011, initially providing acquisition and supply chain management services to the US Coast Guard. Our service offerings have grown in the past ten years, including infrastructure resiliency, contact center operations, information technology, software engineering, program management, strategic communications, engineering, and cybersecurity. We have also grown our customer base to include commercial clients. The company has used this experience to expand our service offerings to other agencies within the Department of Homeland Security (DHS), the Department of Defense (DoD), and other Federal Civilian Agencies.

Position Overview

Pantheon Data is seeking a Data Engineer with a background in architecture of data-centric technical solutions who is technically proficient and eager to learn. A successful candidate should have a history of hands-on experience with data integration and/or data migration, and ideally with data warehousing ETL pipelines. This team will be supporting a "cloud-first" migration for various legacy databases and applications. They will be able to communicate clearly and effectively with other engineers as well as less technical team members (e.g., project managers).

Responsibilities

Data profiling on RDBMS databases (using T-SQL) to inform mapping rules and validate data requirements.
Work within a growing engineering team to build and support technical solutions across customers and projects.
Collaborate with team leads/members to design and develop solutions that exceed customer expectations.

Required Skills and Experience

A Bachelor of Science (BS) degree in Information Technology, Cybersecurity, Data Science, Information Systems, or Computer Science, from an ABET accredited or CAE designated institution.
Security+ certification
5 years professional, hands-on experience in a data engineering role.
Expert-level SQL, relational databases.
Experience with ETL or data migration.
Excellent verbal communication skills with the ability to interact clearly and succinctly in peer review and design sessions.
Willing to learn/contribute meaningfully across technical areas of our projects.
Working knowledge of CI/CD methodology and related tools for database development.
Working knowledge of Agile Scrum methodology.
Detail-oriented, self-motivated, and organized
Ability to work effectively remotely in cross-functional teams.
Ability to meet deadlines and produce quality work.
Proficient in Microsoft Suite software including Outlook, Word, Excel, SharePoint, and PowerPoint.

Preferred Skills and Experience

Strong experience with Python.
Experience writing ETL source-target documentation.
Experience with legacy ETL tools such as Informatica and SSIS.
Experience with cloud-based ETL tools such as DBT and Airflow.
AWS (Amazon Web Services) and/or Microsoft Azure. Certification(s) a plus.
Experience with cloud-hosted databases, either AWS or Azure.
Experience using big data technologies (Hadoop, Hive, HBase, Spark, EMR, etc.)
Experience with AI/ML a plus.

Clearance Requirements

U.S. Citizenship with the ability to obtain and maintain a DoD Secret clearance.

Work Location: United States - Remote

Our company prioritizes the benefits of flexibility and collaboration, whether that happens in person or remotely.
If the position is remote or hybrid, you may periodically work from a Pantheon Data office location or client site.
If this position is assigned to a Pantheon Data office location or client site, you'll work with colleagues and clients in person, as needed for specific client requirements.

Compensation

The salary range for this position is $100,000 - $132,000. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Benefits Overview

We are always looking for good people! Pantheon Data is committed to providing its employees with competitive salaries and benefits in order to increase employee satisfaction and productivity.In addition to our benefits, we also offer SmartBenefits through the Washington Metro Area Transportation Authority, where you specify an amount of your pre-tax wages be paid directly to your SmarTrip account. In some cases, tuition assistance may be available for continuing education expenses and certifications related to their position. Additional details may be found at https://pantheon-data.com/careers/

Pantheon Data Important Information

All qualified applicants will be considered for employment without regard to disability, status as a protected veteran, or any other status protected by applicable federal, state, local, or international law.

SoTalent • Full-time • Remote (McLean, VA, US) • $158k - $181k / year • 5d ago

Data Engineering

5d ago

Apply

Senior Lead Data Engineer

Information Technology Senior Management Forum • Full-time • McLean, Virginia, United States • $204.90k - $257.20k / year • 6d ago

Data Engineering

6d ago

Apply