A global Fintech client of ours has a critical need to expand their Data Engineering team located in Iselin, NJ (MetroPark) as their platform continues to expand and the flow of data in and out of the complex systems continues to increase exponentially. This platform monitors trades, analyzes market data, and provides deep and actionable insights for their clients and users. Currently, they are looking to add a Data Engineer with a strong hands-on background working with SSIS (SQLServer 2012 and 2016) as well as Big Data / Data Lake applications. This is a unique opportunity for someone who eats, sleeps and breathes Data, to join a stellar team and work on cutting edge projects that have an impact on the global marketplace.
Responsibilities: Responsible for designing and implementing ETL solutions using SQL Server Integration Services 2012 and 2016, TSQL and Stored Procedures. Technically evaluate, design and implement Big Data / Data Lake applications on cloud platform (AWS) Provide advanced technical support in design and use of information systems technology including ETL Design and database management. Technically evaluate existing ETL architecture / design of information technology systems and providing alternative solutions and recommend appropriate path for a product / project. Perform code reviews, analyze execution plans, and re-factor inefficient code. Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes. Conduct system tests, troubleshoot customer issues and correct database defects. Respond quickly to bug fixes and enhancement requests. Ability to translate complex business requirements into technical solutions. Requirements: 4+ years of IT experience of which 3+ years should be in data engineering. 2+ years of hands on experience in implementing Data Lake applications in cloud platform (AWS) 2+ years of hands-on working experience in implementing complex, high performance ETL solutions using SSIS and SQL 2012 and SQL 2016 Working experience in developing applications on cloud platform (AWS) Experience with Database Design and Data Modeling Excellent SQL skills Hands-on working experience in MS SQL Server, and experience with other databases such as DB2 or Oracle a plus. Experience with Microsoft Business Intelligence Toolset Experience in database-related performance tuning. Should have up-to-date knowledge of latest technologies, technology trends, and third party solutions for data solutions. Should have excellent analytical and communication skills. Working experience in high volume, low latency environment. Working experience in high availability environment for disaster recovery with zero data loss. Ability to work on complex projects with globally distributed teams and tight timelines. Strong communication skills (both verbal and written) Ability to work with and motivate diverse, globally distributed teams Quality oriented and demonstrate great attention to detail Desired Experience in financial services industry Exposure/experience of Microsoft Data Transformation Services (MS DTS). Associated topics: data analytic, data center, data integrity, data quality, data warehouse, data warehousing, database, database administrator, sybase, teradata
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.