Lead Assistant Manager

Designing interactive reports and dashboards using PowerBI or leverage SSRS or Report BuilderWriting complex DAX expressions for custom measures and calculationsConfiguring scheduled data refresh and Power BI Gateways, Implementing Row Level SecurityPublishing and sharing content through Power BI ServiceConnecting to various data sources (SQL Server, Excel, APIs, etc)Data extraction from relational databases and external sourcesCreate, modify and test various SQL queries, stored procedures and views for obtaining data from diverse source systems and platforms
Design and develop new SQL/SSIS code as part of an ETL process to support report development on PowerBISupport multi-dimensional cube development using MDX in SSAS for select use cases or run existing assetsDevelop stored procedures functions using T-SQL/SQL to automate report refresh or data viewsExcellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people Candidate Profile: Bachelor s/Masters degree in economics, mathematics, computer science/engineering, operations research or related analytics areas candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply5+ years in analytics (Preferably with Insurance)Must have experience in reporting tools like PBI,SSRS and good advance SQL skillsMust have experience in using ETL tools like SSIS or Azure etcGood to have experience in MS Access, Excel, VBA, SSASGood critical thinking and problem solving skillsStrong record of achievement, solid analytical ability, and an entrepreneurial hands-on approach to workOutstanding written and verbal communication skills, and presentation skillsAble to work in fast pace continuously evolving environment and ready to take up uphill challengesIs able to understand cross cultural differences and can work with clients across the globe What we offer: EXL Analytics offers an exciting, fast paced and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions From your very first day, you get an opportunity to work closely with highly experienced, world class analytics consultants You can expect to learn many aspects of businesses that our clients engage in You will also learn effective teamwork and time-management skills - key aspects for personal and professional growth Analytics requires different skill sets at different levels within the organization At EXL Analytics, we invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques We provide guidance/ coaching to every employee through our mentoring program wherein every junior level employee is assigned a senior level professional as advisors Sky is the limit for our team members The unique experiences gathered at EXL Analytics sets the stage for further growth and development in our company and beyond