Position: BI Lead
Company: Allvue
Category: Data Science
Experience required: 3y
English level: upper

WHAT WE NEED
- Minimum of 3 years of relevant experience working in Business Intelligence / Report Development or ETL  
- Experience with SQL 2012 or later, and SQL Server Reporting Services. Clear understanding of Microsoft’s SQL Stack with Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS) and SQL Agent Jobs; and the role of data movement in data analytics
Experience with Power BI, C# in database Assembly integration, or SharePoint integration a plus
- Knowledge and understanding of relational database design and programming
- Knowledge and understanding of data warehouse star schema design and structure
- In depth SQL querying skills with understanding and experience in optimizing speed of queries
- Master’s degree or equivalent experience 
- Background knowledge in finance, economics, statistics or mathematics a plus
- Full professional proficiency in written/spoken English

YOUR RESPONSIBILITIES
- Serve in a leadership role in the Power BI and ETL team – welcome and mentor new developers
- Lead Power BI and ETL team to develop, test, implement and maintain Allvue data products 
- Lead, design and develop ETL processes for the data warehouse lifecycle 
- Collaborate and work alongside with Product Owner and other technical professionals 
- Design and develop SQL Server stored procedures, functions and views be used and to feed SSRS reports
- Troubleshoot data issues and performance tuning of SQL queries
- Maintain and support existing data products  

WHAT WE OFFER
- Fun, fast-paced work environment
- Constantly evolving, cutting edge technology
- The ability to make a significant impact immediately upon jumping in
- An opportunity to work with some of the best firms and the best people in the financial industry
- The ability to create change in the product we sell, by using the very same solution (in a very different way) to perform your daily job
- Commitment to diversity and inclusion in our workplace and workforce
Allvue Academy continuous training and education
- Numerous team building activities to promote collaboration