Description

About the Role:

Title : Lead Data Engineer

Job Description

  • 10+ years' experience in data integration, data warehousing, and data modeling, preferably recent,
  • 8+ years’ experience with relational database technologies (SQL Server, Oracle, Teradata, or similar)
  • 7+ years’ experience with ETL/ELT tools such as Apache Spark, Informatica PowerCenter/BDM, SSIS, AWS Glue, DataStage, or similar
  • Experience with custom ETL/ELT and programming/scripting language experience: Python, PHP, Perl, or Scala (Python required)
  • Experience with data migration from SQL to snowflake preferred
  • Analyze existing data sources and determine migration requirements.
  • Ability to document source to target (S2T) mapping documents
  • Expert knowledge of SQL (T-SQL, MSSQL, TSQL and NoSQL) including programmability features and techniques, as well as best practices for performance and readability
  • Current experience with developing on a Public Cloud Environment (Snowflake preferred)
  • Experience in development, design, and application of data modeling (on star-schema model), data mining and data architecture concepts and techniques
  • Experience working in an Agile team and delivery capability.
  • Excellent communication skills with the ability to relay information between technical and non-technical teams.
  • Ability to work independently on multiple projects and prioritize workload.
  • Sharp skills in critical thinking and problem solving.
  • Familiarity with Data Visualization platforms (e.g. Tableau, Power BI)
  • Familiarity with common security measures for analytical systems
  • Experience with source control tools
  • BS Degree or equivalent required in Computer Science or similar area of study.

Preferred Qualifications

  • Management consulting experience strongly preferred
  • Experience working with large datasets and big data technologies, preferably cloud-based, such as Redshift, Snowflake, Databricks, Azure SQL Data Warehouse, MongoDB, Cosmos, or similar

Location : Dallas TX (3 days/Week) 

Preferred Skills:

  • Snowflake
    • SQL Server
    • PySpark
    • Data Engineer

Education

Any Graduate