Proficiency in writing advanced SQL queries and expertise in performance tuning Database Administration background (SQL Server) Experience in designing and developing ETL data pipelines (SSIS) Experience with the concepts and administration of a Data Warehouse Data modeling knowledge and a thorough understanding of logical modeling concepts Solid understanding of data visualization tools (SSRS, Power BI) Proven experience with .net and source control systems (VSTS) Know-how of cloud computing (PaaS and IaaS) in Azure Experience with the Financial Service industry and eFront FIA software is a definite plus Experience working with IaaS, PaaS and SaaS platforms and Databases (On premise and Cloud) Experience with project management frameworks and delivery (e.g. Prince2, Agile). Experience with document management solutions and intranets (e.g. Sharepoint)
Develop and support SQL Server databases
Perform data wrangling using a variety of tools and techniques
Build scalable and supportable data platforms and support the fast-growing data within the business
Ensure data quality and integrity through well-defined acceptance criteria and testing
Support our financial application FrontInvest and Analytics (FIA)
Build strong, auditable processes that support the operations of the Database infrastructure
We are looking to appoint a candidate who is comfortable in solving complex problems whilst maintaining a high standard for development. A self-starter mentality, strong team working skills and a passion for continuous improvement are all required to help us meet challenging and dynamic business objectives. Our ideal candidate will be able to competently challenge assumptions, business cases and approaches if there could be a better option.
You will be a proactive and critical thinker who is able to anticipate and prevent challenges before they occur with solid design and a careful attention to detail, and commercial enough to understand the purpose of your output. Effective balancing of time and resources will be key, as business as usual priorities need to be met along with more strategic planning for current and future services; maximizing our internal teams and 3rd party resources.