SME Data Engineer

2 weeks ago

Ashburn, United States CMCI Full time
Job Description
SME Data Engineer

Location: Ashburn, VA

Why CMCI?

CMCI provides management consulting and IT services that empower enterprises to achieve their business goals in today's highly competitive market. Our goal is to seamlessly integrate into each customer's organization to fully understand their business and technology needs. This approach allows us to quickly deliver high quality solutions while achieving the highest level of customer satisfaction on time and within budget. By choosing CMCI, you are choosing a company that can deliver business outcomes and mission needs in the most cost-effective manner and without sacrificing capability. As a part of CMCI's culture of loyalty and commitment to its employees, CMCI is committed to providing a tremendous career path by promoting employees to their highest potential.

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.

Requirements

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.


Security Clearance Requirements:
Must be a U.S Citizen with the ability to obtain DHS CBP Suitability

Physical Requirements:
The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery, or to communicate with co-workers, management, and customers, which may involve delivering presentations.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

  • Remote SME Data Engineer

    1 week ago

    Ashburn, Virginia, United States Shuvel Digital Full time

    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,...

  • Remote SME Data Engineer

    3 weeks ago

    Ashburn, United States Shuvel Digital Full time

    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,...

  • Splunk Engineer SME

    2 months ago

    Ashburn, United States Gray Tier Technologies LLC Full time

    Gray Tier Technologies is looking for a Splunk Engineer SME proficient with recognizing and on-boarding new data sources into Splunk, analyzing the data for anomalies and trends, and building dashboards highlighting the key trends of the data. The Splunk engineer should be proficient within a Linux environment, editing and maintaining Splunk configuration...

  • Splunk Engineer SME

    1 week ago

    Ashburn, Virginia, United States Gray Tier Technologies LLC Full time

    Gray Tier Technologies is looking for a Splunk Engineer SME proficient with recognizing and on-boarding new data sources into Splunk, analyzing the data for anomalies and trends, and building dashboards highlighting the key trends of the data. The Splunk engineer should be proficient within a Linux environment, editing and maintaining Splunk configuration...

  • Splunk Engineer SME

    3 weeks ago

    Ashburn, United States Gray Tier Technologies LLC Full time

    Gray Tier Technologies is looking for a Splunk Engineer SME proficient with recognizing and on-boarding new data sources into Splunk, analyzing the data for anomalies and trends, and building dashboards highlighting the key trends of the data. The Splunk engineer should be proficient within a Linux environment, editing and maintaining Splunk configuration...

  • SME DATA Engineer Hybrid Position at Ashburn, VA

    2 weeks ago

    Ashburn, United States TechnoGen Inc Full time

    Job DescriptionJob DescriptionHi, I am Arunkumar Talent Acquisition Specialist with TechnoGenInc, we are looking to hire a Talented Professional with below skill-set to work with one of our clients and came across your profile and wondering if you might interested or exploring the job market, if so, Please share me your resume at...

  • SME DATA Engineer Hybrid Position at Ashburn, VA

    2 weeks ago

    Ashburn, United States TechnoGen Inc Full time

    Job DescriptionJob DescriptionHi, I am Arunkumar Talent Acquisition Specialist with TechnoGenInc, we are looking to hire a Talented Professional with below skill-set to work with one of our clients and came across your profile and wondering if you might interested or exploring the job market, if so, Please share me your resume at...

  • SME DATA Engineer Hybrid Position at Ashburn, VA

    3 weeks ago

    Ashburn, United States TechnoGen Inc Full time

    Job DescriptionJob DescriptionHi, I am Mohammad Kashif Ali Senior Talent Acquisition Specialist with TechnoGenInc, we are looking to hire a Talented Professional with below skill-set to work with one of our clients and came across your profile and wondering if you might interested or exploring the job market, if so, Please share me your resume at...

  • Data Center Critical Facilities Engineer V- HVAC SME- Days

    4 weeks ago

    Ashburn, Virginia, United States Equinix Full time

    Who are we?Equinix is the world's digital infrastructure company, operating over 250 data centers across the globe. Digital leaders harness Equinix's trusted platform to bring together and interconnect foundational infrastructure at software speed. Equinix enables organizations to access all the right places, partners and possibilities to scale with agility,...

  • Data Center Critical Facilities Engineer V- HVAC SME- Days

    4 weeks ago

    Ashburn, Virginia, United States Equinix Full time

    Who are we?Equinix is the world's digital infrastructure company, operating over 250 data centers across the globe. Digital leaders harness Equinix's trusted platform to bring together and interconnect foundational infrastructure at software speed. Equinix enables organizations to access all the right places, partners and possibilities to scale with agility,...

  • Data Center Critical Facilities Engineer V- HVAC SME- Days

    4 weeks ago

    Ashburn, United States Equinix Full time

    Who are we?Equinix is the world’s digital infrastructure company®, operating over 250 data centers across the globe. Digital leaders harness Equinix's trusted platform to bring together and interconnect foundational infrastructure at software speed. Equinix enables organizations to access all the right places, partners and possibilities to scale...

  • Data Center Critical Facilities Engineer V- HVAC SME- Days

    3 weeks ago

    Ashburn, United States Equinix Full time

    Who are we?Equinix is the world’s digital infrastructure company®, operating over 250 data centers across the globe. Digital leaders harness Equinix's trusted platform to bring together and interconnect foundational infrastructure at software speed. Equinix enables organizations to access all the right places, partners and possibilities to scale...

  • Data Center Critical Facilities Engineer V- HVAC SME- Days

    1 month ago

    Ashburn, United States Equinix Full time

    Who are we?Equinix is the world’s digital infrastructure company®, operating over 250 data centers across the globe. Digital leaders harness Equinix's trusted platform to bring together and interconnect foundational infrastructure at software speed. Equinix enables organizations to access all the right places, partners and possibilities to scale...

  • sda mission planning sme

    1 week ago

    Ashburn, Virginia, United States Modern Technology Solutions Inc Full time

    Own Your Future. Modern Technology Solutions, Inc. (MTSI) is seeking Mission Planning SME to fill a SETA (Scientific, Engineering, and Technical Assistance) position with the Space Development Agency (SDA). SDA is breaking the norms of the DoD acquisition cycle, delivering a new tranche of hundreds of satellites every two years. SDA is a fast-paced...

  • Hardware Engineer SME

    4 weeks ago

    Ashburn, United States Esmcorp Full time

    Enterprise Solutions and Management (ESM) is a rapidly growing government contractor that provides strategic IT services that meet mission needs for Defense and Federal customers. We are hiring a Hardware Engineer SME for an exciting opportunity located in Ashburn, Va. Job Description and Responsibilities Exciting opportunity supporting a Department of...

  • Hardware Engineer SME

    4 weeks ago

    Ashburn, United States Esmcorp Full time

    Enterprise Solutions and Management (ESM) is a rapidly growing government contractor that provides strategic IT services that meet mission needs for Defense and Federal customers. We are hiring a Hardware Engineer SME for an exciting opportunity located in Ashburn, Va. Job Description and Responsibilities Exciting opportunity supporting a Department of...

  • Hardware Engineer SME

    4 weeks ago

    Ashburn, United States ESM Full time

    Job DescriptionJob DescriptionEnterprise Solutions and Management (ESM) is a rapidly growing government contractor that provides strategic IT services that meet mission needs for Defense and Federal customers. We are hiring a Hardware Engineer SME for an exciting opportunity located in Ashburn, Va. Job Description and ResponsibilitiesExciting opportunity...

  • Hardware Engineer SME

    1 month ago

    Ashburn, United States ESM Full time

    Job DescriptionJob DescriptionEnterprise Solutions and Management (ESM) is a rapidly growing government contractor that provides strategic IT services that meet mission needs for Defense and Federal customers. We are hiring a Hardware Engineer SME for an exciting opportunity located in Ashburn, Va. Job Description and ResponsibilitiesExciting opportunity...

  • Infrastructure Engineer SME

    4 weeks ago

    Ashburn, United States ESM Full time

    Job DescriptionJob DescriptionEnterprise Solutions and Management (ESM) is a rapidly growing government contractor that provides strategic IT services that meet mission needs for Defense and Federal customers. We are hiring a Infrastructure Engineer SME for an exciting opportunity located in Ashburn, Va. Job Description and ResponsibilitiesExciting...

  • Hardware Engineer SME

    1 month ago

    Ashburn, United States Family Promise of NorthCentral Palm Beach County Full time

    Enterprise Solutions and Management (ESM) is a rapidly growing government contractor that provides strategic IT services that meet mission needs for Defense and Federal customers. We are hiring a Hardware Engineer SME for an exciting opportunity located in Ashburn, Va. Job Description and Responsibilities Exciting opportunity supporting a Department of...