Assistant Manager-Data Engineer

Job Description

POSITION SUMMARY: Responsible for developing and maintaining the financial analytics datamart for the organization with opportunity to: work directly with the Finance leadership team on key strategic initiatives be involved with financial planning and analysis operations work with skilled professionals with diverse backgrounds and supporting multiple stakeholders The SQL Developer, Financial Planning will report to the Sr Manager, FP&A and will be dedicated to developing and ensuring alignment of all models and analytics with direct financial impact on the organization. In addition to managing the development and oversight of analytics data mart within Finance, this role will partner with teams outside of Finance that maintain responsibility for development and maintenance of analytics systems affecting their business unit or department. JOB FUNCTION AND RESPONSIBILITIES: Develop and maintain analytics datamart to accommodate needs of the Finance group Work with cross section of leadership throughout the organization to centralize data requirements for analytics and models forecasting originations volume and margins, capacity and staffing requirements, customer retention (recapture), portfolio performance and delinquency, prepayment, and advance forecasts Detailed duties will include developing and maintaining automated DataMart processes, creating and validating data used for analytics, and ensuring data and metric accuracy Contribute to multiple projects through all phases in a timely and effective manner through collaboration with various departments. Identify and implement process improvements and efficiencies Provide highest level of internal and external customer service Participate in gathering and understanding requirements and document processes existing and new QUALIFICATION: Minimum of 5 years of relevant experience in SQL (T-SQL/PL SQL) and understanding data lineage and governance, developing SQL stored procedures and ETL solutions is required In-depth understanding of RDBMS concepts Proficiency in developing SSIS / ETL packages and working with MS SQL Server Knowledge of Hyperion is a plus Bachelors degree in engineering or technology or equivalent experience required. Ability to work with teams, especially across locations and time zones, in execution of projects and identification/ resolution of deficiencies or opportunities for improvement Strong analytical ability and understanding of data lineage and process dependencies Strong written and verbal communication skills. Advanced proficiency with SQL and managing SQL processes and data structures Competencies in problem solving, creativity, organizational skills while showing good judgment and execution within a fast-paced environment WORK SCHEDULE OR TRAVEL REQUIREMENTS: Late Shift