Solution Intelligence Analyst II- analytics- SQL & Databricks

About Essex Lake Group LLC: With global headquarters in New York, U.S.A. and operations in India, Canada, China and the United Kingdom, Essex Lake Group LLC (“Essex”) delivers transformative profit enhancement solutions, anchored on insights from Big Data, Advanced Analytics and its extensive executive and industry experience. Essex’ customized battle-tested solutions deliver a measurable positive impact within 6 to 18 months. Essex solutions have created substantial profit increases for clients in the areas of revenue growth, cost reduction, consumer and enterprise risk management regulatory compliance. Every Essex solution is customized for the client and the specific problem or opportunity. Essex has proven success and experience in working with leading Financial Institutions (Banking, Insurance, Private Equity), Telecommunication and Healthcare companies. Essex delivers visibility in complex businesses to help clients make sound business decisions and its experienced industry experts work with clients through full implementation of its solutions to ensure the organization receives all the benefits from its solutions and methodologies. Further information on the company can be found on its website: www.essexlg.com Position: Solution Intelligence (SI) Analyst II Location(s): Toronto, Canada Roles and Responsibilities: SI Analyst II are key executors on consulting & analytics work streams of a project where they are required to support hypothesis generation, interact with client working teams, collect data, perform analysis and support solution design and implementation blueprints. SI Analysts II are able to structure complex problems and produce high quality analyses under the guidance of SI Managers and Client Initiative Leaders. SI Analysts II are highly proficient in big-data analytical tools such as SQL, SAS, Python or R and are experienced in manipulating granular transactional or customer-level data . They help identify relationships among complex data from diverse areas, contribute to identification of “so what”, produce insights and recommendations from the results of data manipulation, and prepare presentations for internal and external clients. SI Analysts collaborate closely with data scientists to support development of AI/ ML solutions and UI/ UX designers on translating business needs to solution designs. Required Qualifications Graduate from Premier Educational Institutes, with excellent academic records 4+ years of professional experience Proficient in Excel/ PowerPoint and one of more big data analytics languages - SQL, Hive, SAS, Python/PySpark and R Ability to structure complex analytical tasks and product high quality solutions and implementable insights Strong ownership mindset and experience in collaborating with cross-functional stakeholders and working teams across business, finance, analytics and technology Enthusiasm to quickly learn and thrive in a fast-paced environment Willingness to work in an international environment with a global team and clients from diverse geographies Bonus Points For: Experience working in professional services firms and/ or banking, insurance or other financial institutions Open to travel and exploring the world Working knowledge of statistical techniques and practical experience in developing AI/ ML models Experience in and enthusiasm towards guiding UI/UX design of visualization products (Tableau, QlikView, PowerBI) or web/ iOS applications

The SI Analyst II executes consulting and analytics work streams by supporting hypothesis generation, performing complex data analysis, and designing solution blueprints. They translate granular data into actionable insights and recommendations for internal and external clients while collaborating with data scientists and UI/UX designers.

Candidates must have a degree from a premier educational institute and over 4 years of professional experience. Proficiency in big data analytics languages such as SQL, Python, or SAS, along with strong Excel and PowerPoint skills, is required.

• SQLPreferred
• PythonPreferred
• Microsoft ExcelPreferred
• Data analysisPreferred
• Business analysisPreferred

Identified from the job description. Confirm important requirements above.

• SQL
• Databricks
• Python
• PySpark
• R
• SAS
• Hive
• Excel
• PowerPoint
• Data Analysis
• Solution Design
• Hypothesis Generation
• AI/ML Support
• UI/UX Design Collaboration
• Stakeholder Management
• Business Analysis

• Data & Analytics
• Consulting
• Finance & Accounting
• Technology
• Management & Leadership

Minimum education

Bachelor’s degree

Minimum experience

2+ years

Apply by

Oct 10, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Associate

Application method

Direct apply is available