Sr. Data Engineer (Sql, Hive, TeraData)
About The Position
We have the following urgent role with our DIRECT client. This role requires very strong engineering skills, an analytical approach, and good programming skills. The engineer will provide business insights by leveraging internal tools and systems, databases, and industry data. A minimum of 5+ years of experience is required, with experience in the retail business being a plus. Excellent written and verbal communication skills are necessary for communicating with varied audiences on engineering subject matter. The ability to document requirements, data lineage, and subject matter in both business and technical terminology is crucial. This role involves guiding and learning from other team members, and a demonstrated ability to transform business requirements into code, specific analytical reports, and tools. The position will involve coding, analytical modeling, root cause analysis, investigation, debugging, testing, and collaboration with business partners, product managers, and other engineering teams.
Requirements
- Minimum of 5+ years’ experience
- Strong analytical background
- Self-starter
- Must be able to reach out to others and thrive in a fast-paced environment
- Strong background in transforming big data into business insights
- Knowledge/experience on Teradata Physical Design and Implementation, Teradata SQL Performance Optimization
- Experience with Teradata Tools and Utilities (FastLoad, MultiLoad, BTEQ, FastExport)
- Advanced SQL (preferably Teradata)
- Experience working with large data sets
- Experience working with distributed computing (MapReduce, Hadoop, Hive, Pig, Apache Spark, etc.)
- Strong Hadoop scripting skills to process petabytes of data
- Experience in Unix/Linux shell scripting or similar programming/scripting knowledge
- Experience in ETL/ processes
- Real time data ingestion (Kafka)
Nice To Haves
- Experience in retail business will be a plus
- Development experience with Java, Scala, Flume, Python
- Cassandra
- Automic scheduler
- R/R studio, SAS experience a plus
- Presto
- Hbase
- Tableau or similar reporting/dash boarding tool
- Modeling and Data Science background
- Retail industry background
Responsibilities
- Provide business insights, while leveraging internal tools and systems, databases and industry data
- Document requirements, data lineage, subject matter in both business and technical terminology
- Guide and learn from other team members
- Transform business requirements to code, specific analytical reports and tools
- Coding, analytical modeling, root cause analysis, investigation, debugging, testing and collaboration with the business partners, product managers other engineering team
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
