Associate, Software Engineer
Req #: 170112760
Job Category: Technology
Duties: Work as part of the Program and Portfolio Management Tools team developing application software to support the firm’s Business Intelligence (BI) Solutions and Data Warehousing. Create technical design recommendations for developing and integrating programs per written specifications. Develop, plan, and coordinate matters related to Report Development using Jasper Reports, Business Objects, and other suitable BI engines. Gather and document functional and technical report requirements, and translate requirements into reporting solutions. Test, modify, and implement application code and make standard modifications to existing software applications and modules in accordance with high-level specifications, application support and industry standards. Develop data models and business domains to ensure reports meet client needs. Create technical documentation of report logic and processes. Create new processes and procedures, and suggest improvements to current processes and procedures. Utilize system application methodology and software technologies to support programming logic, system analysis, system testing, documentation, troubleshooting, and user support. Work closely with business and service delivery teams to ensure appropriate business measures are defined. Examine applications to ensure adherence to firm guidelines, processes and procedures.Minimum education and experience required: Master’s degree or equivalent in Computer Science, or related field plus two (2) years of Application Development and Business Intelligence Reporting experience, or related experience OR Bachelor’s degree or equivalent in Computer Science, or related field plus five (5) years of Application Development and Business Intelligence Reporting experience, or related experience.
*Skills required: Experience capturing, gathering, analyzing, and documenting functional and business requirements for data specifications. Experience working in the financial domain. Experience writing reports using Business Objects and JasperSoft. Knowledge of Business Intelligence Tools including Business Objects, Crystal Reports, and JasperSoft. Experience with universe development tool OLAP and Relational Data Modeling Concepts. Experience working with version upgrades and interfacing with users and developers. Experience with databases including Oracle and tools Toad and SQL developer. Knowledge of data warehousing concepts including Star Schema, Snowflake Schema, and Mutli-Dimensional Data Models for query analysis. Experience using PL/SQL to create database objects including stored procedures, triggers, and packages. Experience creating documents including technical design, business, and functional requirements. Experience resolving and troubleshooting issues and bugs and providing user support. Knowledge of ad-hoc reporting concepts. Employer will accept any amount of professional experience with the required skills.