JUNIOR ANALYST JOB DESCRIPTION
Discover what employers expect from junior analysts, with sample job descriptions spanning finance, government, technology and operations roles.

Junior Analyst Job Description Template
1. About the Role
A Junior Analyst handles the unglamorous but consequential work that keeps commercial decisions grounded in fact. Raw data arrives from production systems, client accounts and market sources; without someone to clean, structure and translate it, senior stakeholders make calls on instinct rather than evidence. This role sits within analytics or commercial operations teams, typically reporting to a lead analyst or department manager, and is responsible for turning structured data into reports, presentations and insights that business units can act on. Econometric modeling for policy reviews and customer segmentation for marketing promotions are among the concrete outputs this role owns - work that sits squarely in the data-to-decision chain.
2. Position Summary
As the Junior Analyst, you own the day-to-day analysis and reporting that converts raw operational data into structured outputs used by commercial, marketing and senior leadership teams to guide planning and investment decisions. You work within an analytics or commercial function alongside senior analysts, team leads and cross-functional stakeholders, supporting multiple projects and report cycles simultaneously across a defined business domain.
3. Why Join Us
Career Impact: Junior Analysts who develop proficiency in quantitative research and customer segmentation analysis build a track record that is directly transferable to senior analyst and data science roles within two to three years.
Business Impact: The reports and models this role produces feed directly into go-to-market decisions, budget planning and expansion strategies, meaning errors or delays in output have measurable downstream consequences for revenue and operational direction.
Growth Opportunity: Working across database management, statistical evaluation and stakeholder communication in parallel gives this role's holder exposure to the full analytical skillset required to move into a specialist or lead analyst position.
4. Key Responsibilities
- Analyse commercial and operational data to identify trends, opportunities and risks for senior decision-makers.
- Compile and distribute recurring reports on a daily, weekly and monthly basis to operations, marketing and leadership teams.
- Collaborate with production and business units to review incoming databases and validate data accuracy before reporting.
- Support the development of new databases and reporting frameworks that meet evolving business and customer needs.
- Coordinate with stakeholders to gather project requirements, communicate progress and present findings in structured formats.
- Maintain administrative control of client accounts and update presentation materials to reflect current performance objectives.
- Execute ad hoc data processing assignments and special projects in support of cross-functional business initiatives.
5. Required Qualifications
- Bachelor's degree in Economics, Statistics, Business Administration, Marketing or a related field, or equivalent work experience.
- 1 or more years of experience in data analysis, commercial reporting or project coordination, with demonstrated numerical aptitude.
- Proficiency in structured data analysis and reporting, including advanced spreadsheet modeling and formula-based data manipulation.
- Experience carrying out statistical evaluation of datasets and translating outputs into clear written or visual summaries.
- Ability to manage multiple concurrent tasks under tight deadlines while maintaining accuracy and attention to detail.
- Strong written and verbal communication skills, with the ability to explain data-driven findings clearly to non-technical stakeholders.
- Demonstrated organisational discipline, including the ability to follow formal quality or documentation processes consistently.
6. Preferred Qualifications
- Experience working within a formal quality management system such as ISO accreditation, or an equivalent compliance-governed environment.
- Knowledge of data visualisation principles and experience building dashboards or visual reporting outputs for business audiences.
- Prior exposure to customer segmentation analysis, econometric modeling or quantitative policy evaluation.
- Familiarity with cloud-based data platforms or migration from on-premises database environments to cloud infrastructure.
7. Success Metrics and Environment
- Report delivery rate, measuring the percentage of recurring outputs distributed on time against the defined schedule.
- Data accuracy rate, tracking the proportion of report fields validated without correction after stakeholder review.
- Ad hoc request turnaround time, measuring average days from request receipt to completed analytical output.
- Stakeholder query resolution rate, reflecting the share of data enquiries fully addressed without escalation to senior analysts.
- Database uptime and job completion rate, measuring the proportion of daily automated data jobs that complete without manual intervention.
- Typical tools: spreadsheet and modeling platforms (commonly Excel or Google Sheets); BI and visualisation platforms (commonly Tableau or Power BI).
8. Compensation and Benefits (US Market Benchmark)
- Base Salary Range: $48,000 to $68,000 per year, depending on location and experience.
- Bonus: Discretionary annual bonus, typically 5 to 10 percent of base salary.
- Equity: Not standard at this level; occasionally offered at growth-stage companies.
- Health Benefits: Medical, dental and vision coverage; employer contribution varies by organisation.
- PTO: 10 to 15 days annually, plus standard public holidays.
- Common Perks: Professional development stipend, tuition assistance, flexible hybrid work schedule.
Figures are estimates based on general US market benchmarks and may be outdated. Adjust based on location, company size, and seniority level.
9. EEO and Legal
Background checks are a standard condition of employment for this role, and offers are contingent on successful completion. All qualified applicants will be considered without regard to race, color, religion, sex, national origin, age, disability, veteran status or any other characteristic protected under applicable federal, state and local law. Reasonable accommodations are available to applicants and employees with disabilities upon request. Candidates must be authorized to work in the United States prior to commencing employment.
Junior Analyst Job Description Example
1. Junior Analyst (Health Tech and Commercial Data)
The Junior Analyst owns the analysis of commercial data to surface opportunities and risks across UK and international markets, using Salesforce to manage pipelines and support expansion initiatives. Working alongside senior management, an advisory board and external stakeholders, this role enables the commercial team to optimise sales processes and strengthen client account management across a health tech organisation.
Key Responsibilities
- Analyse commercial data to highlight opportunities and risks.
- Support UK and international expansion opportunities.
- Deliver cross-business initiatives and projects.
- Use Salesforce as a pipeline and contract management system.
- Work alongside senior management, advisory board and external stakeholders.
- Optimise the company's sales processes with commercial team leaders.
- Support the commercial team in managing client accounts.
- Manage numerous systems across departments in the organisation.
- Serve as the go-to person for all data-related needs.
Required Qualifications
- Bachelor's degree or higher, ideally in a technical discipline.
- 6 months to 1 year of experience in a data analyst or project management role.
- Strong numerical and Excel skills.
- Experience with data analysis tools such as Tableau.
- Excellent communication skills.
- Ability to grasp complex problems and explain them clearly to key stakeholders.
- Ambitious and curious with a desire to learn and improve new technologies.
- Interest in working in a fast-growing health tech or mental health organisation.
2. Junior Analyst (Proficiency Testing and Quality Systems)
Embedded within the Proficiency Testing Group, the Junior Analyst sets up and manages proficiency tests using round management software while carrying out statistical evaluation and preparing final reports. Working closely with scheme participants, prospective participants and internal PTG members, this role supports the integrity of laboratory quality programmes and ensures timely, accurate delivery of testing outcomes.
Core Functions
- Set up and manage proficiency tests using round management software.
- Ensure the procurement of suitable proficiency test materials.
- Carry out statistical evaluation of data.
- Prepare proficiency testing final reports.
- Manage risk and work to project milestones.
- Answer general enquiries from scheme participants and prospective participants.
- Provide ad hoc support to other members of PTG as required.
Qualifications and Experience
- 5 GCSEs at Grade C or above including English and Maths or Science, or equivalent experience.
- Practical IT experience, particularly in Microsoft Word and Excel.
- Experience operating within a formal quality system such as ISO accreditation.
- Flexible, adaptable and detail-oriented approach to work.
- Ability to manage multiple tasks simultaneously and prioritise accordingly.
- Self-motivated with the ability to build good working relationships with colleagues.
- Confident and effective communication skills.
3. Junior Analyst (Database Reporting and Administration)
Reporting to business leadership, the Junior Analyst delivers day-by-day report generation from business databases, responding to requests with timeliness and quality to support operational decision-making. Partnering with production teams and commercial stakeholders, this role enables data accuracy and supports the development of new databases and reports that meet the needs of the company and its customers.
Primary Duties
- Review databases sent by production.
- Collaborate in the creation of reports based on information provided in business databases.
- Take administrative control of client accounts.
- Update information in presentations to meet established objectives.
- Execute activities related to data processing and special projects to facilitate the development of new databases and reports.
Skills and Qualifications
- Bachelor's degree in Administration, Industrial Engineering, Marketing or a similar field.
- Advanced Excel level.
- Power BI knowledge desirable.
- Effective communication skills.
- Report creation and administrative and operational skills.
4. Junior Analyst (Army Logistics Systems Development)
Sitting at the intersection of software development and military logistics, the Junior Analyst assists senior analysts with designing, planning and small-team management of development efforts for the Army War Reserve Deployment System (AWRDS). Operating across analyst-led teams that include assigned programmers, testers and end users, this role enables on-schedule delivery of application redesigns and documentation that meet customer and corporate requirements.
Duties
- Work directly with senior analysts and system end users to determine application requirements and analyse program specifications.
- Evaluate user requests for redesign or upgrades of existing software.
- Coordinate with assigned senior analysts, programmer and tester to ensure task completion within scheduled time limits and design specifications.
- Generate design documentation for software development covering platform specification, GUI design and relational database design.
- Convert project specifications into detailed algorithms for coding.
- Support product briefings and demonstrations to meet customer and internal corporate requirements.
- Conduct system testing periodically as needed.
Position Requirements
- Proficiency with Microsoft Office including Word, PowerPoint, Excel and Access.
- Previous experience with U.S. Army logistics or DoD STAMIS systems such as AWRDS, LMP and GCSS.
- Basic knowledge of SQL, database structure and auditing databases to determine potential issues.
- Basic knowledge of C# and/or Delphi.
- Experience with CMMI, LEAN or ITIL.
- Ability to read and understand design specifications including workflows.
- Ability to obtain a Microsoft Security+ certification.
- Critical thinking, diagnostic ability and strong interpersonal skills.
- Ability to plan, prioritise work and communicate effectively in writing and presentations.
5. Junior Analyst (Social Protection and Labor Markets)
A key member of the country team for Mexico, the Junior Analyst contributes to major components of reports covering labor markets, skills, jobs, and cash and non-cash transfers, applying quantitative analysis and econometric modelling to support policy dialogue. Collaborating across Task Team Leaders, government counterparts and survey data sources including ENOE and ENIGH, this role shapes evidence-based recommendations on social protection expenditure and active labor market programs.
Accountabilities
- Ensure fiscally sustainable social protection expenditures through efficiency and effectiveness public expenditure reviews.
- Promote employability and jobs through public employment services, training and active labor market programs.
- Contribute to major components of country-specific reports in Mexico covering labor markets, skills and jobs, and cash and non-cash transfers.
- Support Task Team Leaders in policy dialogue, coordination and capacity building activities.
- Carry out database management, descriptive statistics, econometric modeling, data visualisation and inputs for presentations.
Experience and Qualifications
- Bachelor's degree in Economics, Public Policy, Statistics or other relevant social sciences.
- 2 years of professional experience in economic or policy analysis with a focus on quantitative analysis.
- Advanced Stata skills with experience in analysis of micro-data.
- Experience working with Mexico's ENOE, ENIGH, Census and inter-census survey data.
- Prior knowledge of social protection systems from work experience or academic studies.
- Solid analytical skills in quantitative research.
- Excellent oral and written communication skills in Spanish and proficiency in English.
- Ability to manage multiple tasks with tight deadlines and work in a multicultural team environment.
6. Junior Analyst (Data Science and Customer Analytics)
Delivering compelling insights from complex problems depends on the Junior Analyst, who deploys data science algorithms and analytical techniques on a chosen tech stack while executing projects in alignment with dunnhumby Quality Assurance processes and coding standards. Based within a team of senior data scientists, this role enables client-facing solutions that translate customer data into actionable business outcomes through robust documentation and knowledge sharing.
What You'll Do
- Provide analytical support by identifying and implementing the most appropriate analytical technique for each project.
- Deploy data science algorithms and market products on chosen tech stack for efficient and cost-effective delivery.
- Build strong relationships with internal contacts to ensure full understanding of client requirements.
- Distil complex problems into compelling insights with senior team members.
- Participate in client meetings to help explain solutions as required.
- Maintain robust documentation after deploying solutions to capture feedback and increase knowledge sharing.
- Execute projects on time and follow dunnhumby Quality Assurance processes and coding standards.
Background and Experience
- Bachelor's degree or equivalent in a numerate subject such as Statistics, Mathematics, Physics or Economics.
- Programming experience in Python, R or other standard data mining and modelling packages.
- SQL knowledge and experience in data interpretation and insight analysis.
- Skills in analytical techniques, desk research and data visualisation.
- Proficiency in the Hungarian language.
- Experience connecting work directly to the customer experience.
- Client relationship building, presentation and insight storytelling skills.
7. Junior Analyst (Real Estate Asset Management)
As the Junior Analyst, this role supports the Country Head Germany with investment analyses, due diligence, NOI forecasting and asset-level risk identification across a last mile real estate portfolio. The Strategy, Planning and Analytics team relies on this work to produce high-quality country-specific reporting, inform hold/sell decisions and support annual budgeting across stabilised assets, value add opportunities and acquisitions.
Role Responsibilities
- Provide analytical support to the Country Head and team on investment analyses, due diligence and new opportunities.
- Perform in-depth asset and portfolio-level analysis covering leasing, Capex and NOI, and prepare high-quality reporting on past, current and projected performance.
- Collaborate with the SP and A team by providing country-specific input for regular and ad hoc reporting.
- Provide integral support in the hold/sell analysis of individual assets.
- Assist in the creation of NOI forecasts on stabilised assets, value add opportunities and acquisitions.
- Collaborate on asset business plans and annual budgeting.
- Analyse and identify specific asset level risks.
- Learn and optimise systems used to manage and track portfolio performance.
Education and Experience
- Bachelor's degree in Finance, Real Estate or a relevant field.
- Up to 3 years of experience in private equity, asset management or real estate.
- Strong numerical and analytical skills with the ability to work with complex and large data sets.
- Proficiency in Excel, Yardi, Tableau and banking systems.
- Fluency in German and excellent command of English.
- Commercial mindset with strong problem-solving skills.
- Strong communication skills with the ability to explain data to stakeholders.
- Team-oriented with the ability to build relationships across a fast-paced environment.
8. Junior Analyst (FOIA Case Management)
Junior Analyst supports a range of Freedom of Information Act activities including case workflow, appeals, information research and process optimisation for a federal consulting engagement. The work directly supports accurate case file management, timely communication of FOIA status and the redaction and analysis of documentation in compliance with applicable regulations.
Job Functions
- Sort incoming mail and other communications and distribute accordingly.
- Scan incoming mail requests and answer incoming phone calls to communicate FOIA status.
- Maintain accurate case files and status in customer provided software.
- Arrange meeting logistics and ensure accurate record keeping.
- Conduct relevant research, analysis and redaction of personal information.
- Analyse documentation and prioritise workloads to meet deadlines.
- Provide general support as required.
Minimum Qualifications
- Bachelor's degree.
- 1 or more years of relevant work experience.
- Comprehensive knowledge of MS Office and experience with FOIAXpress.
- Basic understanding of the Freedom of Information Act (FOIA).
- Excellent analytical, organisational and customer service skills.
- Excellent verbal and written communication skills.
- Ability to work independently under general guidance and manage repetitive tasks while remaining prepared for auxiliary duties.
- Attention to detail and ability to produce consistently high-quality work under fluid conditions.
9. Junior Analyst (International Logistics and Supply Chain)
The Junior Analyst delivers end-to-end logistics support across order processing, shipping coordination and track-and-trace management for one of the world's largest paper producers and exporters expanding its European operations. Working with headquarters, external warehouses, sheeting companies and carriers, this role enables accurate order fulfilment and timely resolution of in-transit issues for internal and external customers.
Day-to-Day Responsibilities
- Interact with company headquarters, European external warehouses, sheeting companies and clients to support the team in steering products to their destination.
- Support all logistics activities from order processing to delivery, including investigating product availability, building compatible loads, scheduling shipping and providing proper documentation.
- Communicate effectively by phone and email to provide order status, product and availability information and resolve issues with internal and external customers.
- Maintain an effective track and trace process for in-transit shipments.
- Ensure accurate input of all orders into the Order Entry system and inform affiliates of any purchase order problems.
- Consolidate and report within established timeframes.
Technical Qualifications
- University degree, ideally in Economics or Logistics.
- Experience in a corporate environment preferred.
- Practical knowledge of Microsoft Office and SAP.
- Above average inductive and numerical reasoning ability.
- Excellent oral and written communication skills in English, with German, Portuguese or other European languages advantageous.
- Self-motivated, diligent, credible and detail-oriented with strong time management skills.
10. Junior Analyst (Maritime Finance and Investment Research)
Embedded within a finance team, the Junior Analyst builds financial models, develops investment proposals and produces in-depth research reports across various areas of the business while communicating findings to senior management. Working closely with senior leadership and using tools including Power BI, SharePoint and Excel, this role enables well-informed commercial decisions through rigorous data analysis and high-quality presentation materials.
Scope of Work
- Prepare internal presentations and maintain presentation archives.
- Prepare financial models and present business cases.
- Develop investment proposals and materials.
- Develop research materials and maintain data sets for producing reports.
- Support ship sale and purchase activities.
- Ensure all processes are followed in line with company procedures.
- Communicate and report to senior management.
Knowledge, Skills and Abilities
- Bachelor's degree at 2.1 or above from a top university.
- Proficiency with Power BI, SharePoint, PowerPoint and Excel.
- Exceptional analytical skills and strong commercial acumen.
- Strong written and verbal communication skills and stakeholder management.
- Excellent document preparation and presentation skills.
- Self-starter with energy, drive and sound judgement.
- Organised with great attention to detail and strong problem-solving ability.
11. Junior Analyst (DC Network LMS and Training Operations)
Reporting to DC and operations leadership, the Junior Analyst leads facilitation of DC network LMS platforms, auditing productivity data and distributing reporting on a daily, weekly, monthly and quarterly basis to operations, training and finance teams. Partnering with onsite training coordinators, 3PL manager liaisons and IT, this role enables workforce performance visibility and supports Supply Chain SOP compliance across all Sprouts-run and 3PL facilities.
Key Deliverables
- Audit, analyse and process LMS productivity data for all direct operations team members.
- Produce and distribute reporting on a daily, weekly, monthly and quarterly basis as stand-alone and network comparative reports.
- Maintain LMS platforms for all Sprouts-run facilities and assist with 3PL facilities as needed.
- Correct daily systemic errors, modify worker profiles and troubleshoot platform failures.
- Provide training to new users on the labor management platform and maintain user training guidelines.
- Facilitate weekly meetings to familiarise new team members on LMS data and inventory control processes.
- Oversee the On the Job Trainer program and coordinate with the onsite training coordinator.
- Guide internal audit programs in accordance with risk and safety team protocols.
- Manage recognition and team member appreciation programs.
- Manage the Appspace platform and run communication campaigns for each site.
- Maintain Supply Chain SOPs and support new process rollouts by organising training sessions.
Professional Experience
- Bachelor's degree or a minimum of 2 years of relevant experience.
- Prior experience with a warehouse LMS platform.
- Proficiency in MS Office Suite.
- Demonstrated leadership, interpersonal and change management abilities.
- Proficient time management skills with the ability to manage concurrent projects and priorities under deadlines.
- Excellent verbal and written communication and problem-solving skills.
- Committed to customer service, confidentiality and dependability.
12. Junior Analyst (DoD Cybersecurity and Endpoint Defense)
Sitting at the intersection of cybersecurity operations and DoD compliance, the Junior Analyst installs, secures, configures and maintains DoD-approved commercial off-the-shelf software applications used to monitor, detect and defend government computer networks and systems. Operating across network, system and application levels, this role enables continuous vulnerability remediation, STIG compliance and alignment with Risk Management Framework requirements across the Patriot Testbed Enclave infrastructure.
Engineering Responsibilities
- Install, secure, configure and maintain DoD-approved commercial off-the-shelf software applications used to monitor, detect and defend DoD computer networks and systems.
- Test and evaluate new and updated endpoint products before approval.
- Develop and implement plans to apply patches, hot fixes and other critical updates.
- Create and tune policy exemptions for Host Intrusion Prevention, Endpoint Security and Data Loss Prevention.
- Maintain security status of Patriot Testbed Enclave infrastructure including OS and STIG compliance.
- Develop Tactics, Techniques and Procedures for operation and maintenance of DoD commercial off-the-shelf software applications.
- Conduct risk and vulnerability assessments at the network, system and application level.
- Research, evaluate and recommend new security tools, techniques and technologies aligned with IT security strategy.
- Utilise tools and processes to scan, identify, contain, mitigate and remediate vulnerabilities and intrusions.
- Assist in implementing government policy such as Risk Management Framework and recommend process tailoring.
Skills and Qualifications
- Bachelor's degree and 2 or more years of relevant experience, or high school degree with 5 years of relevant experience.
- Current DoD 8570 IAT II certification or equivalent, and active CompTIA Security+ certification.
- HBSS-specific training and certification including DISA HBSS 201 and 301.
- Certified Information Systems Security Professional (CISSP) certification.
- Currently certified Microsoft Windows Server 2019 or 2021.
- Current Secret clearance with ability to obtain TS/SCI.
- Experience with DoD commercial off-the-shelf software applications, ACAS and RSA MFA.
- Experience with Windows Servers, Linux Server Operating Systems and VM applications.
- Familiarity with DISA STIG, US Cyber Command OPORD requirements and best practices for DoD network administration.
- Proven experience supporting Information Assurance Certification and Accreditation processes and implementing applicable NIST and CNSS IA directives.
13. Junior Analyst (Natural Gas Trading and Marketing)
A key member of a start-up US Gas Trading and Marketing team, the Junior Analyst builds and evolves fundamental modelling capacity, maintains awareness of regional pipeline open seasons and supports commercial deal execution with existing and prospective external counterparts. Collaborating across the Commercial Analytics team, contracts, risk, legal and credit functions, this role enables the team to develop trading positions and origination opportunities with growing authority and corporate visibility.
Activities
- Maintain pro-active awareness of regional pipeline open seasons, short-term capacity releases and structured origination opportunities.
- Support the evolution of short and long-term fundamental analysis to the benefit of the US Gas Trading and Marketing team.
- Collaborate with the Commercial Analytics team to build and evolve a fundamental modelling capacity aligned with the team's ambitions.
- Participate in all aspects of the trading and marketing business, including working with contracts, risk, legal and credit teams and external customers.
- Interact with existing and prospective external counterparts to support commercial deal execution.
- Contribute to the evaluation of structural Natural Gas Origination opportunities.
- Create and update reports on trading activities, credit, contracts and pipeline agreements.
- Assist traders and schedulers with various ad hoc reports and suggest improvements to trading and compliance processes.
Qualifications and Experience
- Bachelor's degree in Marketing, Business, Finance or Engineering.
- 4 to 6 years of relevant Gas Analysis experience.
- Advanced computer skills including Excel VBA, SQL and Python.
- Knowledge of TC Energy-specific pipeline tariffs along ANR, GLGT, ANR Storage and Northern Border Pipeline.
- Experience on pipelines adjoining TC Energy's pipeline footprint.
- Self-motivated, solutions-oriented analytical thinker with strong problem-solving and communication skills.
- Ability to thrive in a fast-paced team environment with competing priorities.
14. Junior Analyst (Business Process and Enterprise Solutions)
Sustained business transformation depends on the Junior Analyst, who conducts business process analyses, needs assessments and cost and benefit evaluations to align enterprise solutions with company strategy across Waste Management business units. Serving as a resource to management, team leaders and both internal and external partners, this role enables the adoption of re-engineered processes and the on-schedule delivery of quality enterprise projects.
Operational Focus
- Conduct business process analyses, needs assessments and preliminary cost and benefit analyses to align business solutions with company strategy.
- Undertake projects requiring specialised business knowledge and decision-making that influence adoption of re-engineered processes.
- Contribute strategic vision and integrate a broad range of ideas regarding business solutions development with management and team leaders.
- Assist with project plans and coordinate resources to accomplish project tasks.
- Conduct business process and systems analysis while considering current and future business environment implications.
- Assist with deliverables, cost, schedule and quality management for one or more enterprise solutions projects.
- Review progress and evaluate results for accuracy and efficiency.
- Work with internal and external customers, suppliers and partners to resolve problems and refine solutions.
Requirements
- Bachelor's degree or equivalent experience with at least 5 or more years of experience.
- PMI Certification preferred.
- Effective communicator with the ability to lead and influence others.
- Ability to identify and build strategic relationships across teams, departments and organisations to achieve business goals.
- Strong analytical and problem-solving skills with the ability to compare data from multiple sources and draw sound conclusions.
- Ability to convey information and ideas clearly and compellingly to individuals and groups.
15. Junior Analyst (Marketing Database and Business Intelligence)
As the Junior Analyst, this role builds and maintains marketing analytical databases, SQL Analysis Services cubes and ETL pipelines while leading continuous improvement of the marketing datamart to automate tasks and support new projects. The marketing and BI team relies on this work to generate accurate customer segmentation files, deliver actionable reporting and support the organisation's migration from on-premises to cloud-based infrastructure.
Key Responsibilities
- Maintain marketing analytical databases, procedures, functions and metadata tables and ensure daily jobs are running and up to date.
- Develop procedures and functions to create reports, automate tasks and support new projects.
- Create mail files and vendor files based on customer segmentation for marketing promotions.
- Develop and maintain SQL Analysis Services cubes and dashboards.
- Lead continuous improvement of the marketing datamart including innovative data capture, SQL reporting and process streamlining.
- Create ETLs to transfer data from different sources to the datamart.
- Support data pipelines and Lambda functions as the platform migrates from on-premises to cloud.
- Work closely with stakeholders to gather project requirements and communicate status and findings regularly.
- Support end users as a Subject Matter Expert through troubleshooting, recommending solutions and identifying business intelligence opportunities.
Required Qualifications
- Bachelor's degree.
- 2 to 3 years of database development experience using TSQL for creating tables, views, procedures and functions.
- 2 to 3 years of database design, architecture and optimisation experience including index tuning and advanced query writing.
- 2 to 3 years of experience designing and developing SSAS cubes and SSIS packages.
- Experience with SQL Server, Analysis Services and Integration Services.
- Experience with R, Python and cloud-based technology platforms is a plus.
- Full project life cycle experience with the ability to design and code from specifications.
- Strong organisational, problem-solving and communication skills with excellent attention to detail.
- Ability to manage multiple projects simultaneously under tight deadlines.
16. Junior Analyst (Federal Government Cost and Price Proposals)
Junior Analyst prepares detailed cost and price proposals in response to RFPs from Federal and Civilian government agencies, developing complex Excel-based pricing models and Price to Win analyses across multiple contract types. Success in the position means delivering compliant, competitive and profitable proposals by collaborating with Contracts, Purchasing, Legal, Proposal Development and Operations while managing subcontractor RFQ documentation and pricing negotiations.
Core Responsibilities
- Lead the development and preparation of cost and price proposals compliant with government policies, regulations and CGI internal procedures.
- Develop complex cost and price models using MS Excel based on RFP requirements.
- Assist in the development of Price to Win models and target rate analyses.
- Prepare subcontractor Request for Quote documentation and templates.
- Assist in price analysis on subcontractor quotes and negotiate prices as needed.
- Prepare Price Analysis Memoranda and Negotiation Memoranda as required.
- Prepare and present detailed cost and price briefings for management covering RFP requirements, competitive analysis, pricing strategies and key financial metrics.
- Maintain detailed pricing documentation files for future reference and audits.
- Work closely with Contracts, Purchasing, Legal, Proposal Development and Operations to ensure proposals are compliant, accurate and competitive.
Background and Experience
- Bachelor's degree plus 1 to 5 years of experience.
- Experience with all contract types including FFP, T and M, CPFF, CPAF, CPIF, LH, BPA and IDIQ.
- Experience developing Price to Win artifacts and familiarity with Government CAS and FAR.
- Highly proficient in MS Office applications including Excel, Word, PowerPoint and Project.
- Ability to communicate and interact effectively with all levels of the organisation.
- Ability to work effectively under time-critical deadlines and with minimal direct supervision.
17. Junior Analyst (IT Help Desk and Network Administration)
The Junior Analyst delivers troubleshooting, network administration and system management support across desktop, laptop and server environments, working under the guidance of management and senior administrators to maintain LAN and WAN operating capability. Working alongside the Systems Architect and cross-functional staff, this role enables reliable infrastructure performance and ensures systems meet documented user requirements across hardware and software lifecycles.
Primary Duties
- Troubleshoot and address software-related issues, requests and defects through identification, investigation, analysis, solution design and resolution.
- Support and ensure operating capability of both LAN and WAN networks, wired and wireless, for all hours of operation.
- Administer domain, network, server, desktop, laptop, printer and telecommunications hardware and software.
- Work with the Systems Architect to implement, upgrade and maintain software, hardware, server and computer technologies.
- Provide input for documentation on new and existing systems.
- Develop and conduct tests to ensure systems meet documented user requirements.
- Communicate and collaborate with staff members through meetings, electronic communication and project management software.
Education and Experience
- 2-year degree or equivalent training in computer information systems, or 3 or more years of experience in help desk support, IT systems and network administration.
- A+ or Network+ certifications or equivalent.
- Windows 10 desktop experience and knowledge of Server 2012 and 2016, Hyper-V and VMs.
- Familiarity with PowerShell scripting, Jira or other ticketing systems, ITIL or ITSM practices, and Mac OS.
- Highly skilled in communications, collaboration and team dynamics.
- Excellent problem-solving abilities and a proactive approach with significant attention to detail.
18. Junior Analyst (Commercial Real Estate Brokerage)
Embedded within a commercial real estate brokerage, the Junior Analyst develops new business through in-person contacts, canvassing and presentations while representing client firms to locate office space through surveys, tours, lease analysis and financial modelling. Working closely with Senior Agents, brokers and Market Research, this role enables client-facing deal execution and strengthens the firm's pipeline of prospective tenants across a competitive commercial property market.
Day-to-Day Responsibilities
- Develop new business through in-person contacts, phone calls, canvassing and follow-up including presentations to decision-makers and those who influence them.
- Report and update the supervisor on calling program status covering clients met, potential deals, issues and next steps.
- Use and maintain the firm's CRM software for tracking new business development.
- Assist Senior Agents with calls and business development activities as needed.
- Represent client firms to locate office space through researching companies, preparing surveys, conducting tours, evaluating proposals, conducting financial analysis, preparing lease abstracts and reviewing lease documents.
- Collaborate with brokers to prepare proposals and strategies for presentations and work with Market Research to compile market information for clients.
- Update internal and external databases including property availability, building information, comps and exclusive listings.
- Prepare financial analyses comparing purchase versus lease options and manage prospect activity reports.
Qualifications and Experience
- Bachelor's degree.
- 0 to 3 years of experience in real estate or professional business.
- Commercial real estate license required.
- Proficient in Excel with experience in data entry and data management.
- Articulate communicator with strong oral and written communication skills.
- Highly detail-oriented with the ability to plan, organise and manage deadlines in fast-paced environments.
- Professional acumen and demonstrated interest in commercial real estate.
19. Junior Analyst (Business Intelligence and Qlik Development)
Reporting to the BI team, the Junior Analyst builds new visualisation applications, maintains existing Qlik solutions and performs data analysis and business process mapping to identify inefficiencies that can be resolved through automation and reporting. Partnering with stakeholder groups, the data enterprise team and relevant IT functions, this role enables cross-departmental business intelligence through robust application development, user acceptance testing and subject matter support.
Functions
- Partner with stakeholder groups to understand business needs and identify new solutions for improving business processes.
- Develop new visualisation applications and maintain and support existing applications.
- Develop product reports including recurring status updates, meeting agendas, minutes, presentations and training materials.
- Perform application troubleshooting and problem-solving.
- Coordinate with the data enterprise team and relevant IT teams to acquire data for business intelligence purposes.
- Complete user acceptance and stress testing on new application features and functionality.
Skills and Qualifications
- 1 or more years of experience in data analysis, project management or BI development, preferably in software.
- Strong knowledge of Microsoft Office Suite.
- Knowledge of or experience with Qlik, Tableau or similar BI and visualisation platforms.
- Familiarity with SQL Server Management Studio.
- Strong analytical, priority-setting, planning and problem-solving skills.
- Excellent customer service skills and well-developed written and verbal communication skills.
20. Junior Analyst (Navy Configuration Management)
Sitting at the intersection of engineering documentation and DoD program management, the Junior Analyst provides technical program support to the HM and E APM by developing and reviewing technical data packages and implementing Configuration Management across work products through identification, control, status accounting and audits. Operating across government and contractor personnel, this role enables specification accuracy, CM policy compliance and proper integration of designs across US Navy and DoD ACAT I programs.
Delivery Expectations
- Provide technical program support to the HM and E APM with configuration management and engineering change document development and reviews.
- Develop and review technical data packages for specification accuracy and proper integration across designs.
- Implement Configuration Management by establishing and maintaining integrity of work products through configuration identification, control, status accounting and audits.
- Create, maintain and enforce CM policies and processes.
- Leverage GOTS and COTS CM tools to manage configuration items.
- Collaborate with government and contractor personnel to develop technical documentation in accordance with TI-specific requirements.
Minimum Qualifications
- Bachelor's or advanced degree in a business or technical field.
- 0 to 6 years of experience in configuration management analysis.
- 3 or more years of relevant experience in engineering and science management, operations research analysis or financial and cost analysis.
- Active Secret clearance verifiable in JPAS, with ability to obtain Secret clearance.
- Significant experience in US Navy programs or operations and DoD and Navy ACAT I programs.
21. Junior Analyst (High Yield Credit and Investment Research)
A key member of a middle market investment team, the Junior Analyst analyses and evaluates high yield debt and equity investment opportunities across public and private markets while monitoring the firm's alternative investment portfolio through credit analysis, cash flow modelling and impairment testing. Collaborating across fund managers and internal portfolio teams, this role enables well-grounded investment recommendations and supports fund surveillance and special process improvement initiatives.
Areas of Ownership
- Analyse and evaluate new high yield debt and equity investment opportunities in public and private markets.
- Monitor existing portfolio investments and provide analytical and reporting support for the firm's middle market debt and alternative investment portfolio.
- Assist with fund investment underwriting and due diligence.
- Assist in managing existing investment positions while making new investment recommendations.
- Perform fund and portfolio surveillance and fundamental credit analysis, cash flow analysis, impairment testing and portfolio holding performance analysis.
- Interact with key market participants including fund managers.
- Participate in special projects and process improvement initiatives.
Professional Experience
- Bachelor's degree.
- 2 years of credit or investment research experience.
- Advanced financial modeling experience and fundamental accounting and financial analysis skills.
- Ability to read and analyse financial statements.
- Ability to analyse and synthesise complex financial data and make actionable investment recommendations.
- Excellent communication, interpersonal and presentation skills.
Editorial Process and Content Quality
This content is developed by the Lamwork Editorial Team using structured analysis of real-world job data, skill requirements, and hiring patterns.
Research framework by Lam Nguyen, Founder & Editorial Lead.
Reviewed by Thanh Huyen, Managing Editor.
Learn more about our editorial standards.