Senior Data Engineer

Locations: Merrimack, NH / Smithfield, RI / Jersey City, NJ 12+ months 2 rounds of interviews Hybrid – 50% onsite, one week on, one week off This project is to support the data needs of our institutional advisor services with portfolio construction, model management, funds comparison, etc. High exposure team working with clients and customers so communication skills are paramount. Must Haves: Python for running ETL batch jobs Heavy SQL for data analysis, validation and querying AWS and ability to move the data through the data stages and into their target databases. Postgres database is the target so that is required. Nice to haves: Snowflake Java for API development is a nice to have (will teach this) Experience in asset management for domain knowledge. Production support debugging and processing of vendor data The Expertise And Skills You Bring • A proven foundation in data engineering – bachelor’s degree + preferred, 6+ years’ experience • Extensive experience with ETL technologies • Design and develop ETL reporting and analytics solutions. • Knowledge of Data Warehousing methodologies and concepts – preferred • Advanced data manipulation languages and frameworks (JAVA, PYTHON, JSON) – required • RMDS experience (Snowflake, PostgreSQL ) – required • Knowledge of Cloud platforms and Services (AWS – IAM, EC2, S3, Lambda, RDS ) – required • Designing and developing low to moderate complex data integration solution – required • Experience with DevOps, Continuous Integration and Continuous Delivery (Maven, Jenkins, Stash, Ansible, Docker) will be preferred • Expert in SQL and Stored Procedures on any Relational databases • Good in debugging, analyzing and Production Suppor • Application Development based on JIRA stories (Agile environment) • Demonstrable experience with ETL tools (Informatica, Snaplogic) • Experience in working with Python in an AWS environment • Create, update, and maintain technical documentation for software-based projects and products. • Solving production issues. • Interact effectively with business partners to understand business requirements and assist in generation of technical requirements. • Participate in architecture, technical design, and product implementation discussions. • Working Knowledge of Unix/Linux operating systems and shell scripting • Experience with developing sophisticated Continuous Integration & Continuous Delivery (CI/CD) pipeline including software configuration management, test automation, version control, static code analysis. • Excellent interpersonal and communication skills • Ability to work with global Agile teams • Proven ability to deal with ambiguity and work in fast paced environment • Ability to mentor junior data engineers. The Value You Deliver • The associate would help the team in designing and building a best-in-class data solutions using very diversified tech stack. • Strong experience of working in large teams and proven technical leadership capabilities • Knowledge of Enterprise level implementations like Data warehouse, Automated solutions. • Ability to negotiate, influence and work with business peers and management. • Ability to develop and drive a strategy as per the needs of the team • Good to have: Full-Stack Programming knowledge, hands-on test case/plan preparation within Jira