Financial Data Modeler

Mastech Digital; Chicago (IL); Remote; USD 115,000 - 155,000; Full time

Job summary

A leading company in IT Services is seeking a Mid-Senior level Analyst with expertise in Excel modelling. The role involves creating robust financial models, analyzing data, and providing insights to drive strategic decisions. Ideal candidates will possess strong analytical skills and a Bachelor's degree in finance or related fields. This is a contract position with a duration of 6 months, fully remote, offering competitive compensation.

Benefits

Medical insurance

Vision insurance

401(k)

Qualifications

• Minimum of 3-5 years of experience in financial and data modelling using Excel.
• Strong numerical and analytical skills with attention to detail.

Responsibilities

• Design, develop, and maintain complex financial and operational models in Excel.
• Prepare detailed reports, dashboards, and presentations using Excel.

Skills

Analytical Skills

Communication Skills

Organizational Skills

Education

Bachelor’s degree in finance

CFA

CPA

Tools

Microsoft Excel

Power BI

Tableau

Job description

Direct message the job poster from Mastech Digital

Lead Recruiter @ Mastech Digital | Global Talent Acquisition, Staffing Services

Looking for W2 Only

Duration: 6 Months +

Location: Remote

(ONLY W2)

Job Description:

We are seeking a highly skilled and detail-oriented Analyst with extensive experience in Excel modelling to join our dynamic team. The ideal candidate will have a strong analytical background, excellent problem-solving skills, and the ability to create complex and robust financial and data models using Excel. The analyst will be responsible for analyzing data, preparing reports, and providing insights that drive strategic decisions.

Key Responsibilities:

Design, develop, and maintain complex financial and operational models in Excel.

Ensure models are robust, scalable, and user-friendly, with clear documentation and version control.

Conduct scenario analysis, sensitivity analysis, and stress testing within Excel models.

Gather, clean, and analyze large datasets to identify trends, patterns, and insights.

Interpret data and provide actionable insights and recommendations to stakeholders.

Ensure data accuracy and integrity throughout the analysis process.

Reporting:

Prepare detailed and visually appealing reports, dashboards, and presentations using Excel, pivot tables, charts, and other visualization tools.

Communicate findings and insights to both technical and non-technical audiences.

Work closely with cross-functional teams including finance and operations, to understand their data needs and provide analytical support.

Act as a subject matter expert on Excel modelling, providing guidance and support to other team members.

Stay current with industry trends and best practices in Excel modelling, data analysis, and financial analysis.

Identify and implement process improvements to enhance the efficiency and effectiveness of data analysis tasks.

Requirements:

Education:

Bachelor’s degree in finance, Economics, Business Administration, Mathematics, Statistics, or a related field. An advanced degree or relevant certifications (e.g., CFA, CPA) is a plus.

Experience:

Minimum of 3-5 years of experience in a similar role, with a strong emphasis on financial and data modelling using Excel. Proven experience in developing and maintaining complex Excel models for business analysis, forecasting, budgeting, and strategic planning.

Technical Skills:

Advanced proficiency in Microsoft Excel, including complex formulas, VBA, macros, pivot tables, and data visualization techniques.

Strong knowledge of data manipulation and cleansing techniques. Familiarity with other data analysis tools and programming languages (e.g., SQL, R, Python) is an advantage, though not required.

Analytical Skills: Excellent problem-solving abilities with a keen attention to detail.

Strong numerical and analytical skills, with the ability to interpret complex data sets and translate them into actionable insights.

Communication Skills:

Excellent written and verbal communication skills.

Ability to effectively present complex information in a clear and concise manner to stakeholders at all levels.

Organizational Skills:

Strong organizational and time management skills, with the ability to manage multiple projects simultaneously and meet tight deadlines.

High level of initiative and the ability to work independently as well as within a team environment.

Professional Attributes:

Strong work ethic and integrity.

A proactive and results-oriented mindset with a commitment to continuous improvement.

Preferred Qualifications:

Experience in financial services, consulting, or a related industry.

Knowledge of business intelligence tools (e.g., Power BI, Tableau).

Certification or training in data analytics or financial modelling

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Consulting

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Mastech Digital by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Get notified when a new job is posted.

Sign in to set job alerts for “Data Modeler” roles.

Chicago, IL $115,000.00-$155,000.00 1 day ago

PowerPoint Expert (To Start Immediately)

Greater Chicago Area $30.00-$70.00 1 week ago

Senior ADABAS Mainframe Systems Programmer

REMOTE AI Systems Engineer - High-Performance Computing

Chicago, IL $175,000.00-$300,000.00 1 week ago

Planning Analytics Consultant - Fully Remote

Chicago, IL $100,000.00-$120,000.00 1 day ago

Chicago, IL $130,000.00-$205,000.00 2 days ago

Python and Kubernetes Software Engineer - Data, AI/ML & Analytics

Infection Prevention Data Abstractor: Full-Time

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.