Overview The successful candidate will join the existing SIG's Enterprise Software Solutions (ESS) team.
This team builds and maintains software systems that facilitate trading, operations, and regulatory management.
The ESS team provide software solutions for internal users, which involves complex business application rules and database schemas.
SIG has implemented a business reporting environment using the Qlikview application set in order to provide end users and key business decision makers with reporting dashboards.
The successful candidate will be involved in the environment support, the data extraction process definition and implementation, as well as working with end users to define and develop the dashboards/reports required.
The core business data resides in Oracle databases.
Some development maybe be required using the Microsoft office tools (MS Access and Excel).
An understanding of the core business processes, of complex database schemas, and data querying using SQL will be required in order to successfully perform in the role.
Core ResponsibilitiesWork with users to define reporting requirements.
Define the data extraction processes based on requirements defined.
Develop the SQL and Qlikview data extraction scripts.
Develop the reporting dashboards.
Maintain the production data extraction schedule and Qlikview dashboard deployments.
Interact with various internal IT support functions to troubleshoot and resolve complex problems as they happen.
What we're looking forDegree or equivalent in Business, Engineering, or Computing.
Knowledge & SkillsStrong SQL skills.
Min 2 years experience in using business reporting tools like Qlikview, Cognos, etc essential.
Experience with relational databases such as SQL Server and Oracle.
Experience developing in and supporting MS Access and Excel a plus.
Experience working with end users to define requirements.
Excellent analytical/troubleshooting skills.
Experience working with financial applications a plus.
Experience in data warehousing concepts a plus.
Experience working with ETL tools like Informatica a plus.
Personal SkillsInitiative – proven record of seeking continuous improvement and implementing best practiceAbility to work under pressure and tight deadlinesSelf-motivated and creativeStrong communication (verbal and written) – ability to convey complex subjects in a clear and concise mannerAttention to detail – thorough in work carried outInterpersonal – friendly and approachableTeamwork – working together to meet deadlinesExcellent time management, organization and prioritization skillsDesire to learn and improve skills and knowledgeSIG is not accepting unsolicited resumes from search firms.
All resumes submitted by search firms to any employee at SIG via-email, the Internet or directly without a valid written search agreement will be deemed the sole property of SIG, and no fee will be paid in the event the candidate is hired by SIG.