PRINCIPAL DUTIES
- Develops and tests end-to-end BI solutions, including ETL pipeline, data warehouse design and end-user visualizations, by following documented and structured plans, to ensure any developed solution meets business, technical, and functional requirements. Be able to draft formal unit test plans, when appropriate, to be executed by another individual in the division or for self-use.
- Understand business processes of Fixed Income Securities and related reporting needs. Promote best practices and standards in modern BI reporting techniques among various business groups.
- Collaborates with business users and the technical team to ensure requirements are clearly documented and understood. This person will work with other Software Development Analyst(s), Database Administrator and ITOps team to develop a design document and a project schedule which includes the project milestones and the estimated completion dates.
- Contributes to realistic and achievable project plans by providing detailed and accurate work estimates. Facilitates adjustment of resource usage so that focus is applied to projects’ critical path.
- Develops and maintains up-to-date technical and end user documentation.
- Follows disciplined change management process for program change control and contributes to any procedural changes that may be necessary.
- Effectively supports and trains users by addressing and resolving business intelligence related problems in a timely and cordial manner.
- Stays abreast of latest technical trends to develop efficiencies or improve the quality of business intelligence solutions.
PRINCIPAL REQUIREMENTS
- BS in Computer Science, Engineering, Mathematics or other technical field
- At least 6 years of general experience in the Information Technology field
- Must have a minimum of 3 years experience working with SAP Data Services/Business Objects
- Must have a minimum of 3 years experience working with MS PowerBI/PowerAutomate
- Experience in the following tools required:
PowerBI dashboard development experience and designing PowerAutomate workflows for near real-time data refreshing, or scheduling report automation tasks
SAP BO suites: Universe/Information Designer Tool, Web Intelligence; UNV/UNX conversion and BO upgrade project experience preferred; Live Office development experience is a plus
SAP BI Administration: Data Services Admin Console, BO Central Management Console (CMC)
Database Modeling Concepts: 3rd Normal Form, Star Schemas, Snowflake Schemas
RMDBS: From Sybase to modern DB technologies such as PostgreSQL; MS-SQL Server
ETL Pipeline development: Daily batch and real-time jobs
Source control system: Subversion; GitLab
Advanced SQL knowledge and data engineering skills
- MS Azure/Databricks experience is a plus
- Strong working knowledge of dimensional database design concepts
- Experience working across all aspects of the software development life cycle
- Skilled at working directly with business owners and management to demonstrate how business intelligence tools can directly benefit their overall effectiveness
- Strong problem solving skills
- Superior written and oral communication skills; demonstrated experiencing writing and / or editing procedures and documentation
- Ability to multi-task in a dynamic environment while continuing to progress on longer term project completion.