Senior Data Engineer

Axial connects professionals who run, advise, finance and acquire private companies. Our mission is to connect every private company with the capital necessary to finance or exit their company. The network allows providers of capital to private companies, including lenders, equity investors, and strategic buyers, to find and be found by the right opportunities from the right entrepreneurs and the right bankers at the right time.

Axial is looking for a Senior Data Engineer with a diverse background in data integration. We are looking for someone who can load, stream, process, manage and analyze data that can vary in its size and structure. We use PostgreSQL and Amazon Redshift and most of our code is in Java and Python. This role will involve close collaboration with other data engineers as well as other teams such as product development, marketing and sales operations. You will design and build custom data and reporting solutions, sync processes, and other Data Warehouse related tasks to achieve data consistency and accuracy. You will provide thought leadership on new data processing, aggregation, and storage technologies to help accelerate our growing data expertise.

* Build and own the Data Engineering Roadmap in collaboration with key stakeholders * Provide thought leadership in data architecture and data engineering decisions * Build and maintain data sync processes between third party applications, production databases and the Data Warehouse * Design, build and support data related projects in traditional row-oriented (PostgreSQL) and non-traditional columnar (Amazon Redshift) databases * Build new and extend existing data models and ETL processes to support new business requirements * Improve performance of reporting and increase data reliability * Connect and integrate available data sets for better analysis and decision-making * Create new calculations and reports in Tableau * Provide training to empower other teams to effectively use the available data and reports

* 7+ years of experience with traditional row-oriented database development * 2+ years of experience with columnar databases such as Redshift, Vertica, and Greenplum * 2+ years of experience with dimensional modelling: facts, slowly changing dimensions, etc. * Advanced knowledge of SQL * Experience in data modeling at the physical and logical layers * Experience setting up infrastructure based on architectural requirements * Experience with UNIX/Linux operating systems including shell scripting in bash, korn, etc. * Intermediate to advanced programming skills in Python, Java * Experience managing and using business intelligence solutions in tools like Tableau * Willingness to learn new technologies beyond basic responsibilities **Additional Qualifications** * Experience in database administration * Experience with statistical modeling and visualization in R, Python * Experience with Apache stack: Hadoop, Kafka, Storm, etc.