Sr. Data Engineer

Position Overview
Supports Mitsubishi HC Capital America, Inc. (MHCA)'s reporting needs across the enterprise.

Essential Duties And Responsibilities

1. Works with BI Leader to develop, test, implement and support reporting needs across departments utilizing current and emerging reporting tools.
2. Support the timely migration and operation of an existing on-premises SQL Server Data Warehouse to Microsoft Azure
3. Gather requirements and build customized data feeds and reports.
4. Learn and promote the use of newer BI tools and participate in their implementation.
5. Be part of an extended Reporting team comprised of US/Canada architects and report developers.
6. Performs data analysis and development in support of the data integration of new system implementations and upgrades, business projects, and changes to existing reports.
7. Provide development team and end-user support and training around reporting systems.
8. Performs technical & architecture review of BI solutions developed by junior team members and consultants.
9. Collaborates with extended development teams on large scale projects and provides coaching on best practices and new product capabilities.
10. Monitors reporting performance and data quality, troubleshooting inconsistencies.
11. Analyzes and resolves critical path technical issues and escalates to vendors as needed.
12. Works with Infrastructure team and vendors on implementation and validation of BI Tech Stack upgrades to ensure product success and compliance with EOL mandates.
13. Follows all development policies and guidelines when coding fixes and enhancements, as well as when fixes and enhancements are migrated to a production environment.
14. Responds to IT Audit requests, as required.
15. Assist on other IT projects and tasks as assigned.

Qualifications :

• Minimum 10-year experience with SQL development and relational database experience, including significant utilization of Microsoft Business Intelligence development tech stack.
• Advanced data integration skills utilizing Microsoft SSIS or similar ETL toolset.
• Experience in commercial leasing, and/or other financial application systems.

Skills Required:

• Advanced data analysis skills with ability to trace lineage of report and application data back to source and reverse engineer existing reporting solutions as needed.
• Advanced Microsoft data management skills including RDBMS and performance tuning.
• Advanced Power BI development skills and best practices.
• Advanced SSIS / SSRS development skills and best practices.
• Experience with market-leading BI tools.

Education and Experience:

• Bachelor's degree or equivalent experience.
• 3 - 5 years related program development and support experience with comparable financial or leasing institution.