Learn Data Skills
Beta

Shadi Merhej

Manager of Research

Invest Alberta

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

Mindful analyst, decoding patterns to unravel the big picture.

My Work

Take a look at my latest work.

course

Data Manipulation with pandas

course

Introduction to Python

course

Intermediate Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Invest Alberta | Nov 2022 - Present

Manager, Market Intelligence

-Create innovative tools to support intelligence sharing within the organization. -Conduct comparative market analysis, e.g., marginal locational pricing in ERCOT versus uniform clearing pricing in AESO -Provide research and intelligence advisory services to business development, c-suite, and market and communication teams. -Notable accomplishments include using PowerBI to automatically fetch CANSIM data from Statistics Canada to populate dashboards and being the second tallest person in the office.
Show More

Invest Alberta | Jan 2022 - Nov 2022

Senior Analyst

-Use Python (pandas) to manipulate/analyze secondary data. -Create workflow to populate reports using dynamic fields. -Lead the creation of IAC intelligence portal and periodic intelligence newsletter.

Government of Alberta | Aug 2020 - Jan 2022

Economist

• Perform impact analysis of policies and make recommendations to better align policy outcomes with ministerial objectives. • Analyze economic impacts of programs and policies using I/O (input/output) modelling techniques. • Use dynamic modelling systems to estimate economic impacts of different programs over time, forecasting important indicators such as GDP, employment, and industry output. • Provide memorandum and briefing notes review pertaining to economic and fiscal impact of policy or program. • Assist and advise managers and directors as necessary on analyses, program recommendations, and economic evaluation. • Provide cross-ministerial support as necessary to help define economic impacts of programs.

Alberta Rural Development Network (ARDN) | Jul 2019 - Aug 2020

Senior Policy and Research Analyst

• Advise on data analysis for housing analysis reports and develop methodologies to forecast housing gaps in communities. • Suggest policies to municipalities to help boost affordable housing supplies, taking economic factors and existing policy frameworks into account. • Lead proposal development process and respond to RFPs across Canada. • Developed necessary processes to extract and use large datasets from Statistics Canada, CMHC, etc. to enhance overall reporting capabilities of the organization. • Work alongside stakeholders internally and externally to collaboratively design custom solutions for housing crunches in rural communities across Canada and access funding. • Lead on strategy development and business plan creation for largest division within the Alberta Rural Development Network. • Use Python and QGIS software programs to create spatial analysis toolkit for Housing Needs Assessment reports. • Create scripts in MATLAB to autonomously create concise visualizations from complex datasets.

Alberta Rural Development Network (ARDN) | Dec 2017 - Jul 2019

Research Analyst

• Create compelling data-narratives using secondary data, modelling techniques, and data synthesize and visualization methods. • Standardized research methodologies and templates for pre-developmental services, including documents such as a housing needs assessment, business cases, and financial analyses reports. • Bolstered research methodologies to more accurately estimate the housing gap in rural communities, where secondary data is often lacking. • Performed both primary and secondary data analysis on communities in Canada, including Rocky Mountain House, Whitecourt, Fort Saskatchewan, and many others. • Technical writer and analyst in team which secured 3.8 million dollars in funding for an affordable housing project in Alberta. • Updated and created Excel Macros to automate and enhance financial modeling. • Subject matter expert on housing policies to external stakeholders. • Plan and engage with communities to determine housing and other social issues affecting residents.

My Education

Take a look at my formal education

Masters of Arts (MA) in EconomicsUniversity of Alberta | 2000
Bachelors of Science (BSc) in Mathematics/EconomicsUniversity of Alberta | 2000

About Me

Current Manager of Research and Market Intelligence at Invest Alberta.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free