AMS PSR

On behalf of FCDO, we are looking for a Data Modeller (Outside IR35) for a 3 month contract based Hybrid in London.

The Foreign, Commonwealth & Development Office (FCDO) pursues our national interests and projects the UK as a force for good in the world. We promote the interests of British citizens, safeguard the UK's security, defend our values, reduce poverty, and tackle global challenges with our international partners.

As a Data Modeller, your main responsibilities will be:

Responsibilities:

• Develop and maintain complex data models, including establishing relationships, hierarchies, and calculated columns. Develop data integration tasks, including data source connections and data transformation processes.
• Perform complex data analysis tasks using DAX (Data Analysis Expressions) functions to create
• calculated measures and solve intricate business problems. Develop advanced DAX calculations for financial, statistical, or performance analysis.
• Create and maintain advanced data models that support complex reporting requirements, including
• handling large datasets and optimising performance. Advise team members in data modelling techniques.
• Optimise report and dashboard performance by improving data queries, data model efficiency, and report rendering speed. Identify and address bottlenecks and resource constraints.
• Collaborate closely with business analysts, stakeholders, and end-users to gather and refine requirements for analysis, reports and dashboards.

Essential:

• Passionate about Excel and data with a proven track record of delivering high-quality Excel-based solutions.
• Experienced using PowerQuery.
• Extensive experienced in developing, managing, and optimising Excel-based solutions to support various business functions, has a strong understanding of Excel's advanced features and capabilities, and be able to translate requirements into effective Excel solutions
• Able to work with various data sources, including databases, Excel, SharePoint, APIs, and web services.
• Familiar with data visualisation and the ability to think creatively and innovatively to design and create visually appealing and insightful custom report.
• Able to work independently but also has strong collaboration skills to work closely with business analysts, data engineers, and other team members in multidisciplinary projects.

Please be aware that this role can only be worked within the UK and not Overseas.

Disability Confident 

As a member of the Disability Confident Scheme, FCDO guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply.

Armed Forces Covenant

FCDO guarantees to interview veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group.

In applying for this role, you acknowledge the following "this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different".