City of London, London
£60000 - £85000 per annum + Bonus + Full Benefits
3 months ago
*Design, develop, test, and deploy data integration processes (batch or real-time) using tools such as Informatica PowerCenter and/or Cloud, Microsoft SSIS, MuleSoft, DataStage, Sqoop, etc.
*Create functional & technical documentation - e.g. data integration architecture documentation, unit testing plans and results, data integration specifications, data testing plans, etc.
*Ensures proper execution/creation of methodology, training, templates, resource plans and engagement review processes
*Identifies and encourages opportunities for cross team collaboration on competency deliverables and methodology development.
*Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, conceptual, logical, and physical data models based on those needs.
*Perform data analysis to validate data models and to confirm ability to meet business needs.
*Architect, design, and develop enterprise self-service analytic solutions, business intelligence reports, visualizations and best practice standards. Toolsets include but not limited to: IBM Cognos, SQL Server Analysis and Reporting Services, Microsoft Power BI, SAP Business Objects, Microstrategy, Tableau, Qlik, and Oracle Business Intelligence Enterprise Edition (OBIEE).
*Strong data warehousing and OLTP systems from an integration perspective
*Strong understanding of data integration best practices and concepts
*Strong development experience under Unix and/or Windows environments
*Strong SQL skills required scripting (e.g., PL/SQL) preferred
*Minimum of 5 years of data architecture, data modeling or similar experience
*Experience using major data modeling tools (examples: ERwin, ER/Studio, PowerDesigner, etc.)
*Experience with major database platforms (e.g. Oracle, SQL Server, Teradata, etc.)
*Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.)
*Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data.
The JM Group is operating and advertising as an Employment Agency for permanent positions and as an Employment Business for interim / contract / temporary positions. The JM Group is an Equal Opportunities employer and we encourage applicants from all backgrounds.