Title: Senior IT Compliance Business Intelligence Developer
Location: New York, NY
Duration: 5 months
Client: Undisclosed Investment Bank
Type: Contract
Compensation: Very competitive daily rate
Summary of position:
Our client, a leading investment bank, is looking to hire a Senior IT Compliance Business Intelligence Developer.
The candidate will be performing data analysis, report & system developments for the Compliance clients & Project Management teams.
She/He must understand the Software Development Life Cycle and be able to perform effective change management. Additionally, the candidate must have already worked with Compliance businesses.
Responsibilities:
- Design, develop and integrate functional dashboard systems using Tableau Desktop and Server to enable easy interpretation of transactional data, client data, KPI and Data Quality metrics
- Provide expertise developing Tableau code that provides predictive results from analytical trending and modeling including those around data quality
- Establish workflows processing to ensure data is refreshed and available in a timely manner via the use of Informatica ETL
- Develop and maintain data integration solutions using Informatica PowerCenter that connect heterogeneous databases, web sources, XML sources, Microsoft SharePoint and Salesforce
- Collaborate with various functional teams to achieve required business results
Required qualifications and experience:
- Strong knowledge of Tableau development, optimization and tuning and designing of charts and graphs
Strong knowledge on tableau report creation and extraction from the user interface (pdf customization and extraction) - Strong SQL skills using DB2, Oracle databases, Microsoft SQL Server databases
- Strong knowledge of best practices for dashboards and BI reporting
Nice to have qualifications and experience:
- Strong skills in a scripting language such as Perl, windows batch, shell and ETL processes
- Experience in integrating XML, web sources and various Compliance monitoring tools using data integration tools such as Informatica, IDQ
- Experience with business intelligence visualization tools and business intelligence tools
- Expertise in the research, development, and support of data visualization techniques
- Experience with requirements gathering – working with clients to determine analytical needs and carrying those needs through the development of data-driven tools to facilitate the requirements
- Experience with predictive and prescriptive data analytics, to include regression analysis and simulation
- Expertise in designing, building and representing complex databases and data modeling
- Knowledge in Microsoft PowerBI is a plus
- Knowledge in designing Business objects reports and Universes using Webi
- Experience working in for a Financial Institution a plus
- Experience with Informatica Data Quality data consumption a plus
Interpersonal skills:
- Excellent written and oral communication skills, particularly with clients, team leads, & managers
- Strong problem-solving abilities
- Excellent time management skills with ability to multi-task and prioritize workload, while maintaining a high attention to detail and meet deadlines, in a dynamic fast-paced environment
- Must be able to work independently
- The willingness to take on tasks both big and small