Demo

Remote SME Data Engineer

Shuvel Digital
Ashburn, VA Remote Full Time
POSTED ON 1/11/2025
AVAILABLE BEFORE 3/10/2025

Job Description:

Each day U.S. Customs and Border Protection (CBP) oversees the massive flow of people, capital, and products that enter and depart the United States via air, land, sea, and cyberspace. The volume and complexity of both physical and virtual border crossings require the application of solutions to promote efficient trade and travel. Further, effective solutions help CBP ensure the movement of people, capital, and products is legal, safe, and secure. CBP seeks capable, qualified, and versatile SME Data Engineers to help develop complex data analytical solutions for law enforcement personnel to assess risk of potential threats entering the country.

Responsibilities include, but are not limited to:

  • Design, develop, and maintain scalable data pipelines and architectures to support data extraction, transformation, and loading (ETL/ELT) processes. Utilize strong SQL skills to perform complex data transformations and optimize database queries, ensuring high performance and efficiency.
  • Building comprehensive datasets by aggregating data sourced from various relational databases, facilitating data analysts and data scientists in creating machine learning models, reports, and dashboards.
  • Collaborate with cross-functional teams (data analysts, data scientists, and business stakeholders) to understand business requirements and translate them into technical solutions.
  • Assist with the implementation of data migration/pipelines from on-prem to cloud/non-relational storage platforms.
  • Leverage distributed computing frameworks like Apache Spark to process large volumes of data efficiently.
  • Utilizing data analysis, problem-solving, investigative, and creative thinking skills to handle extremely large datasets, transforming them into various formats for diverse analytical products.
  • Respond to data queries/analysis requests from various groups within an organization. Create and publish regularly scheduled and/or ad hoc reports as needed.
  • Troubleshoot data-related issues, identify root causes, and implement solutions to ensure data integrity and accuracy.
  • Implement best practices for data governance, security, and quality supporting the core business applications.
  • Responsible for data engineering source code control using GitLab.

Basic Qualifications:

  • Experience with relational databases and knowledge of query tools and/or BI tools like Power BI or OBIEE and data analysis tools.
  • Extensive experience with SQL and proficiency in writing complex queries.
  • Solid understanding of data warehousing concepts and platforms such as Oracle and cloud-based solutions.
  • Strong experience in automating ETL jobs via UNIX/LINUX shell scripts and CRON jobs.
  • Demonstrate a strong practical understanding of data warehousing from a production relational database environment.
  • Strong experience using analytic functions within Oracle or similar tools within non-relational (MongoDB, Cassandra etc.) database systems.
  • Strong understanding of distributed computing principles and experience with frameworks like Apache Spark
  • Hands-on-experience with data lake architectures and technologies in a cloud environment.
  • Experience with Atlassian suite of tools such as Jira and Confluence
  • Knowledge of Continuous Integration & Continuous Development tools (CI/CD)
  • Must be able to multitask efficiently and progressively and work comfortably in an ever-changing data environment. 
  • Must work well in a team environment as well as independently.
  • Excellent verbal/written communication and problem-solving skills; ability to communicate information to a variety of groups at different technical skill levels.

Preferred Qualifications:

  • 5 years of experience in developing, maintaining, and optimizing complex Oracle PL/SQL packages to aggregate transactional data for consumption by data science/machine learning applications.
  • 10 years of experience in working in data engineering, with a focus on building and optimizing data pipelines and architectures. Must have full life cycle experience in design, development, deployment, and monitoring.
  • Experience with one or more relational database systems such as Oracle, MySQL, Postgres, SQL server, with heavy emphasis on Oracle.
  • Extensive experience with cloud platforms (e.g. AWS, Google Cloud, etc) and cloud based ETL/ELT tools.
  • Experience with Amazon services such as S3, Redshift, EMR and Scala.
  • Experience with migrating on-prem legacy database objects and data to the Amazon S3 cloud environment.
  • Experience or familiarity with data science/machine learning and development experience for supervised and unsupervised learning with structure and unstructured datasets.
  • Certifications in relevant technologies (e.g. AWS Certified Big Data, Google Professional Data Engineer) are a plus.

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Remote SME Data Engineer?

Sign up to receive alerts about other jobs on the Remote SME Data Engineer career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$92,929 - $122,443
Income Estimation: 
$122,257 - $154,284
Income Estimation: 
$92,929 - $122,443
Income Estimation: 
$122,257 - $154,284
Income Estimation: 
$122,257 - $154,284
Income Estimation: 
$143,391 - $179,890
Income Estimation: 
$168,522 - $211,152
Income Estimation: 
$189,259 - $248,928
Income Estimation: 
$71,122 - $96,652
Income Estimation: 
$92,929 - $122,443

Sign up to receive alerts about other jobs with skills like those required for the Remote SME Data Engineer.

Click the checkbox next to the jobs that you are interested in.

  • AI -Artificial Intelligence Skill

    • Income Estimation: $128,831 - $170,669
    • Income Estimation: $139,950 - $184,196
  • Analysis of Algorithms Skill

    • Income Estimation: $125,799 - $152,617
    • Income Estimation: $136,683 - $171,343
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Shuvel Digital

Shuvel Digital
Hired Organization Address Washington, DC Full Time
List of Tasks to be Performed: Project management and project oversight Develop software requirement specification (SRS)...
Shuvel Digital
Hired Organization Address Ashburn, VA Full Time
Job Description: We are seeking a Mobile App Developer to provide technical expertise on a mission-critical program whos...
Shuvel Digital
Hired Organization Address Sterling, VA Full Time
Job Title : Systems Engineer Location : Dulles, VA - Hybrid Duration : Contract Clearance : Active Secret. Must be able ...
Shuvel Digital
Hired Organization Address Washington, DC Full Time
Clearance: Must have an active Top Secret clearance. About the Role We are seeking a SharePoint PowerApps Developer to d...

Not the job you're looking for? Here are some other Remote SME Data Engineer jobs in the Ashburn, VA area that may be a better fit.

Cybersecurity Engineer SME / Advisor

Incept Data Solutions, Inc., Fort Belvoir, VA

SME Information Security Analyst (REMOTE)

Koniag Data Solutions, LLC, Chantilly, VA

AI Assistant is available now!

Feel free to start your new journey!