Data Engineering Consultant/Analyst

Summary

eClerx is looking for data wrangling and analytics professionals with hands-on experience with different data processes. Knowledge of data warehouse strategies, ETL processes and in using the following tools: Tableau, SQL and Python/R is also required.

The candidate should have previous experience at a banking or capital markets firm.

Duties & Responsibilities:

• Provide data wrangling services to make data (structured and unstructured), by transformations, normalization, and data mapping, consumable for a variety of downstream purposes such as applications, visualizations, and analytics
• Design and model analytical methods based on the statistical methods. Validate, test, and deploy data models and analytical products/tools
• Research, troubleshoot and recommend solutions to complex business and technical problems. Prepare and communicate through effective presentations and written communications
• Work with large data sets and identify patterns, anomalies, and propose steps for remedial actions
• Query and join multiple tables in SQL databases to provide data needed to support analytics and/or process improvement
• Prepare technical specifications and documentation for technology solutions in order to support downstream uses
• Ensure quality solution delivery by performing end to end data validation on technology solutions

Skills & Abilities: (Technical and General) 

Minimum Requirements: 

• 8 to 10 total years of data experience
• 8+ years writing complex SQL queries and performing query optimization.
• 3+ years of related, hands-on experience with Python, R or similar analytical programming language
• 3+ years’ experience in a trade-related, technology position at a financial institution
• Demonstrably proficient in ETL tools such as Informatica and Alteryx
• Knowledgeable with Jira and agile methodologies
• Experience developing data models and analytical products for financial services firms
• Strong analytical, problem solving, and troubleshooting abilities
• Innovation minded, highly capable to think systematically, capable to redefine the solutions to overcome the competitors and solving problem
• Curious and willing to challenge existing solutions with innovative technology concepts