Senior Software Developer

Job Description Job Purpose The New York Stock Exchange, a subsidiary of Intercontinental Exchange, Inc. (ICE) presents an opportunity for a full-time Senior Software Engineer to join a team responsible for development of data analytics workflows and visualizations. The Senior Software Engineer will have experience in all phases of software development lifecycle, from requirements gathering, to design, coding, unit testing, debugging, and supporting in production. The candidate will be part of a highly visible team responsible for ingesting and analyzing large quantities of trading data at NYSE. The ideal candidate should be knowledgeable in writing complex SQL and experience with BI tools. This position requires technical proficiency/problem solving as well as an eager attitude, professionalism, and solid communication skills. Strong written and oral communication is required as the applicant will frequently be interacting with different teams across NYSE to achieve business goals. Responsibilities On any day, the candidate could be doing any or all of the following: Work closely with both onsite and offshore teams to participate in different phases of SDLC Write complex SQL to implement business logic Develop dashboards in BI tools Optimizing the SQL queries for performance Search through large sets of data for meaningful information. Develop and maintain databases, data systems - reorganizing data in a readable format. Work with project managers to compile a work breakdown structure of tasks for a given deliverable and provide realistic estimates for completing the assignment. Develop and unit test all functions created or modified according to software development best practices. Collaborate with other Developers and QA Engineers to execute full cycle integration, functional and regression testing. Continuously improve the system performance and propose better solutions. Effectively interact with business and operations for solving design and operational challenges. Knowledge and Experience Bachelor s degree in computer science, data science, finance or mathematics with a minimum of five years of experience. Strong knowledge and experience in SQL coding is a must Experience in data visualization and business analytics tools like Alteryx, Tableau and Microsoft PowerBI Knowledge in programming languages like Python, Scala or Java. SQL Query tuning using different tools. Clear understanding of query plan management. Experience in timeseries database Experience in Spark SQL and different file/table formats like ORC, Parquet is a plus Experience in scripting languages like AWK/bash shell scripting is beneficial. Experience working in Agile teams comprised of 5-8 cross-skilled engineers. Solid understanding of version control tools (ideally Git). Experience applying data-driven statistical analysis and modeling to financial market data. Experienced in writing complex programs and implementing custom algorithms. Expertise in tailoring open-source frameworks to specific needs by writing custom code that integrates seamlessly. Experience in data management, data analytics middleware, platforms and infrastructure, cloud and fog computing are a plus. Additional experience working in cloud environments such as AWS is desirable. Excellent communication skills (oral and written) to explain complex algorithms, solutions to stakeholders across multiple disciplines, and ability to work in a diverse team. Schedule This role offers work from home flexibility of one day per week.