We are committed to excellence and are looking for a dynamic Data Engineer to join our team. If you are passionate about leveraging cutting-edge technologies to solve complex problems, we want you on our team.
The successful candidate will have 3-5 years' strong experience designing BI solutions using Microsoft stack, preferably within investment banking or financial services (general products and processes knowledge, market, reference, credit risk, and regulatory data).
Responsibilities include:Designing and building end-to-end BI solutions that will extract data from multiple systems, transforming and loading into multiple reporting data warehouses.Working with end users and analysts on requirements and translating them into technical specifications, providing estimation to management.Supporting existing BI Platform, reverse engineering, and improving processes.Following and contributing to departmental development processes in terms of standards, methodologies, testing, version control, and documentation; driving and implementing industry best practices, evaluating and introducing new tools, designing and improving existing ETL framework, and data validation framework.Assisting in the migration to an off-premises Cloud Solution (specifically Microsoft Azure).Experience, Skill and Capability:3-5 years of Data Engineering experience.Excellent data analysis and exploration using T-SQL, and strong SQL programming (stored procedures, functions).Extensive experience using SSIS, script tasks, and custom plugins.Experience building solutions with SSAS, advanced knowledge of SSAS, MDX, performance tuning, and best practices (2008 onwards).Knowledge and experience of data warehouse modeling methodologies.Microsoft SQL Server (2005/2008/2008R2/2012/2014/2019) performance tuning, backup and recovery, data encryption, capacity planning, understanding of database engine internals, and all database objects.Experience loading data from different sources – XML, CSV, Excel, web services, different databases, MQ messages, etc.Significant experience designing solutions following Kimball methodology and good knowledge of data modeling concepts.Post-release support of deployed BI solutions.Experience building reports using SSRS, PowerBI, PowerPivot, integration with SharePoint, building corporate reporting portals, KPIs, dashboards, and self-service BI.Azure Cloud Data Engineer Competencies (ideal):Experience in Azure, in particular Data Factory, Synapse, and Databricks.Experience using source control, specifically GIT and deployment pipelines.Delivering to all stages of the data engineering process.Data ingestion, transformation, data modeling, and data warehousing, and building self-service data products.Good understanding of Data Lakes, in particular Azure Data Lake Gen2.Experience building robust and performant ETL processes.Building and maintaining Analysis Services databases and cubes (both multidimensional and tabular).Knowledge of financial markets and industry financial reporting standards.Azure Certification will be beneficial.If you believe that you're a fit and feel as if Dotcom is an environment where you can thrive, then WE WANT YOU!
#J-18808-Ljbffr