Summary

The Department: Analytics

The Role: Senior Data Engineer

As a member of our data engineering team, you'll deliver high quality work while solving challenges that impact the whole or part of the team's data architecture. You'll update yourself with recent advances in Big data space and provide solutions for large-scale applications aligning with team's long term goals. Your work will help resolve complex problems with identifying root causes, documenting the solutions, and implementing Operations excellence (Data auditing, validation, automation, maintainability) in mind. Communicating your insights with leaders across the organization is paramount to success.

Responsibilities:

• Design, architect and implement best-in-class Data Warehousing and reporting solutions
• Lead and participate in design discussions and meetings
• Mentor data engineers and analysts
• Design, automate, build, and launch scalable, efficient and reliable data pipelines into production using Python
• Build real-time data and reporting solutions
• Design, build and enhance dimensional models for Data Warehouse and BI solutions
• Research new tools and technologies to improve existing processes
• Develop new systems and tools to enable the teams to consume and understand data more intuitively
• Partner with engineers, project managers, and analysts to deliver insights to the business
• Perform root cause analysis and resolve production and data issues
• Create test plans, test scripts and perform data validation
• Tune SQL queries, reports and ETL pipelines
• Build and maintain data dictionary and process documentation

Minimum Qualifications:

• 5+ years experience in data engineering with data warehouse technologies
• 5+ years experience in custom ETL design, implementation and maintenance
• 5+ years experience with schema design and dimensional data modeling
• Experience building real-time data solutions and processes
• Advanced skills with Python and SQL are a must
• Experience with one or more MPP databases(Redshift, Bigquery, Snowflake, etc)
• Experience with one or more ETL tools(Informatica, Pentaho, SSIS, Alooma, etc)
• Strong computer science fundamentals including data structures and algorithms
• Strong software engineering skills in any server side language, preferable Python
• Experienced in working collaboratively across different teams and departments
• Strong technical and business communication

Preferred Qualifications:

• Kafka, HDFS, Hive, Cloud computing, machine learning, text analysis, NLP & Web development experience is a plus
• Experience with Continuous integration and deployment
• Knowledge and experience of financial markets, banking or exchanges
• Web development skills with HTML, CSS, or JavaScript

It Pays to Work Here The compensation & benefits package for this role includes:

• Competitive starting salary
• A discretionary annual bonus
• Long-term incentive in the form of a new hire equity grant
• Comprehensive health plans
• 401K with company matching
• Annual Learning & Development stipend
• Paid Parental Leave
• Flexible time off

Salary Range: The base salary range for this role is between $136,000 - $190,000 in the State of New York, the State of California and the State of Washington.

Skills

• Communications Skills
• Database Management
• Python
• Software Engineering
• SQL
• Team Collaboration