CIT is a leading national bank focused on empowering businesses and personal savers with the financial agility to navigate their goals. CIT Group Inc. (NYSE: CIT) is a financial holding company with over a century of experience and operates a principal bank subsidiary, CIT Bank, N.A. (Member FDIC, Equal Housing Lender). The company's commercial banking segment includes commercial financing, community association banking, middle market banking, equipment and vendor financing, factoring, railcar financing, treasury and payments services, and capital markets and asset management. CIT's consumer banking segment includes a national direct bank and regional branch network. Discover more at cit.com/about.
The SQL Developer is responsible for the use of cutting edge Microsoft technologies to shape our Web, Service, Sales and Marketing data.
Key duties of the position include: implementing technology improvements to our Data Warehouse environment, writing and executing Windows shell scripts; implementing and enhancing ETL programs using SSIS, SSAS and SSRS against our Microsoft SQL Server 2012 Data Warehouse, applying database skills including T-SQL, procedures, indexing and query tuning; contributing to technical architectural planning, data modeling, process flow documentation and the design and development of innovative solutions for the business; creating technical designs and mapping specifications; developing and testing extraction, transformation, and load (ETL) processes; defining and capturing metadata and rules associated with ETL processes; adapting ETL processes to accommodate changes in source systems and new business user requirements; working with both technical staff and business partners to translate requirements into technical implementations; performing unit and system test and validation tasks; estimating time to deliver and participating in an Agile team approach; maintaining technical and user documentation; providing on-call support of the Data Warehouse nightly and monthly processing; and participating in both technology and business initiatives.