Data Engineer

Job Number:

22-00467

Location:

Richmond, VA, or Columbia, SC

Onsite Flexibility:

Onsite, Remote

Job Description

Qualifications:

  • Must be US Citizen or Green Card holder
  • Strong understanding of data warehousing (dimensional modeling, and ETL) and RDBMS concepts
  • 5 years of experience with:
    • ETL tools, such as Talend, Informatica, and DataStage
    • SQL, stored procedures, and table design
    • SQL query optimization and ETL data loading performance
  • 2 years of experience with:
    • Hadoop platforms on components like Hive, Kafka, NiFi, and Spark
    • Shell scripting

Preferred:

  • Experience with:
    • Snowflake cloud technologies
    • Real-time streaming technologies
    • Deploying machine learning models and automating processes
    • Cloud technologies (AWS, Azure, and GCP)

Responsibilities:

  • Design, develop, and maintain secure, consistent, and reliable ETL solutions supporting critical business processes across the various business units
  • Ensure data solutions are compliant with enterprise security standards
  • Work in complex multi-platform environments on multiple project assignments
  • Develop and perform tests, validate data flows, and prepare ETL processes to meet complex business requirements, including designing and implementing complex end-to-end solutions using BI platforms
  • Coordinate with analysts and developers to ensure jobs designed and developed meet minimum support standards and best practices before migration into the production environment
  • Partner with various infrastructure teams, application teams, and architects to generate process designs and complex transformations to various data elements to provide the business with insights into their business processes
  • Use strategies, such as indexing and partitioning to fine tune the data warehouse and big data environments to improve the query response time and scalability
  • Define and capture metadata and rules associated with ETL processes
  • Assist production support team in providing resolutions to production job failures, data issues, and performance tuning
  • Provide ETL development and process support, may require weekend/off business hours work

Location: Hybrid role in Richmond, VA, or Columbia, SC, with every other week in the office
22-00467
Data Engineer

TM Floyd & Company offers a generous array of benefits, depending on the length of assignment. We also offer a referral bonus of up to $1,000. Ask us for more details!

TM Floyd & Company participates in E-VERIFY
AAP, EEO

Job Application

  • Drop files here or
    Accepted file types: pdf, doc, docx, pages, Max. file size: 10 MB, Max. files: 2.
    • This field is for validation purposes and should be left unchanged.