Mimecast are seeking an experienced B.I. Architect with deep level subject matter expertise across the board, and proven ability to deliver projects in a fast paced and changing business environment.
Outstanding technical skills should be paired with good communications skills as the role involves working closely with business partners in Finance, Marketing, Sales and Customer Operations.
You will be working as part of a dynamic team, delivering best-in-class B.I. capabilities using the Microsoft B.I. stack. Focus is primarily in delivering a data warehouse that is utilised by our Tableau based Analytics teams. As such the main skills focus is SQL Server, SSIS and SSAS rather than SSRS.
The BI Architect will:
Redesign the Current Data warehouse and scale it up into an Enterprise level solution.
Mentor the more junior team members
Bring in coding standards and source control.
Estimate, plan, design, develop and support Business Intelligence solutions to agreed specifications and timescales.
Automate current processes and develop efficiencies.
Cleanse, manipulate/transform and format large datasets to enable data quality improvements.
Support end to end data migration and project plans. Taking responsibility for project deliverables.
Ensure data availability and uptime of the BI apparatus.
Be available to help in any area of the team where the successful person’s skillset fits.
Essential Skills and Experience:
At least 6 years’ experience working with the Microsoft BI stack (SQL Server, SSIS, SSAS).
Experience designing and implement Data warehousing solutions.
SQL Server 2012 or later.
Experience developing complex SQL queries, MDX, stored procedures and triggers required.
Understanding of dimensional modelling. Kimball preferred.
Strong problem solving, exceptional numeracy, analytical rigor and attention to detail.
Ability to translate business needs into technical specifications.
Strong project management and organizations skills
Ability to work in a fast-paced, rapidly evolving company environment
We offer a highly competitive rewards and benefits package including private healthcare, life cover and gym subsidisation. Mimecast is an entrepreneurial and high growth company which will provide the right candidate with a wealth of career development opportunities. All Mimecasters strive on being high performers, problem solvers, team players with passion, integrity and effectiveness.
We strive to attract exceptional people who have ''that extra something'' and really enjoy what they do.
Are you ready to jump onboard with us?