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