Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as an ERP Principal Consultant, transforming data into insights with cutting-edge BI tools.
- Company: Mphasis is a leading consulting firm in Greater London, known for innovation and excellence.
- Benefits: Enjoy flexible work options, competitive salary, and opportunities for professional growth.
- Why this job: Be part of a dynamic team, tackle exciting challenges, and make a real impact in the tech world.
- Qualifications: 5+ years in Data Analysis & ETL development with expertise in Microsoft BI tools required.
- Other info: EU work permit is necessary; experience in Agile methodologies is a plus.
The predicted salary is between 48000 - 72000 £ per year.
Social network you want to login/join with:
ERP Principal Consultant, Greater London
Client:
Mphasis
Location:
Greater London, United Kingdom
Job Category:
Consulting
EU work permit required:
Yes
Job Reference:
242313d20d63
Job Views:
7
Posted:
03.03.2025
Expiry Date:
17.04.2025
Job Description:
Who are we looking for:
Years of experience needed: 5 years of experience as Data Analyst & ETL developer in Microsoft Business Intelligence tools.
Technical Skills:
- Must have at least 5 years of experience as Data Analyst & ETL developer in Microsoft Business Intelligence tools like SQL Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, Power BI, and AWS Redshift.
- Expertise in creating visualizations and reports using Power BI.
- Experience in writing T-SQL Stored Procedures, Functions, Constraints, and Indexes using various DDL and DML commands.
- Experience in writing complex SQL Queries using Joins, Sub Queries, Correlated Sub Queries, and others.
- Involved in the transformation of OLTP data to the Data Warehouse using SSIS.
- Experience in Designing and Developing SQL Server Integration Services Packages with different Control Flow Tasks and Data Flow Transformations.
- Implementing logging, checkpoint configuration, package configurations, and performance tuning at various levels.
- Worked extensively on ETL Process using SSIS Package.
- Scheduled Jobs in Flows and ADF Pipelines.
- Created Tabular, Matrix, Sub reports, Charts, Drill-down and Drill-through reports in SSRS.
- Designed reports and published the reports to the Power BI web.
Teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision. Self-confident team player with a fast learning curve along with strong analytical, problem-solving, knowledge transfer, communication & interpersonal skills. Experienced in all project phases using Waterfall and Agile Methodologies.
Other Technical Skills:
- Reporting Tools: SQL Server Reporting Services, Power BI, Tableau.
- Programming Languages: C, C++, Core Java, T-SQL, PL/SQL.
#J-18808-Ljbffr
ERP Principal Consultant employer: TN United Kingdom
Contact Detail:
TN United Kingdom Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land ERP Principal Consultant
✨Tip Number 1
Make sure to showcase your experience with Microsoft Business Intelligence tools prominently. Highlight specific projects where you've utilized SQL Management Studio, SSIS, and Power BI to demonstrate your hands-on expertise.
✨Tip Number 2
Network with professionals in the field of data analytics and ETL development. Join relevant online communities or attend local meetups in Greater London to connect with others who may have insights or referrals for the position.
✨Tip Number 3
Prepare to discuss your experience with both Agile and Waterfall methodologies during interviews. Be ready to provide examples of how you've successfully navigated different project phases and adapted to changing requirements.
✨Tip Number 4
Demonstrate your teamwork skills by sharing specific instances where you collaborated with others on complex projects. Emphasize your ability to work under minimal supervision while still contributing effectively to team goals.
We think you need these skills to ace ERP Principal Consultant
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your 5 years of experience as a Data Analyst and ETL developer. Emphasize your expertise in Microsoft Business Intelligence tools, especially SQL Management Studio, SSIS, and Power BI.
Craft a Strong Cover Letter: In your cover letter, explain why you are a great fit for the ERP Principal Consultant role. Mention specific projects where you utilized your skills in SQL, ETL processes, and report creation using Power BI.
Showcase Technical Skills: Clearly list your technical skills relevant to the job description, such as experience with Azure Data Factory, SQL Server Reporting Services, and your ability to write complex SQL queries. Use bullet points for clarity.
Highlight Teamwork and Problem-Solving Abilities: Include examples of how you've worked effectively in teams and solved complex problems in previous roles. This will demonstrate your teamwork skills and ability to work under minimal supervision.
How to prepare for a job interview at TN United Kingdom
✨Showcase Your Technical Skills
Be prepared to discuss your experience with Microsoft Business Intelligence tools in detail. Highlight specific projects where you utilized SQL Management Studio, SSIS, and Power BI to create visualizations and reports.
✨Demonstrate Problem-Solving Abilities
Expect questions that assess your analytical and problem-solving skills. Prepare examples of complex SQL queries you've written or challenges you've faced during ETL processes and how you overcame them.
✨Emphasize Teamwork and Communication
Since teamwork is crucial for this role, be ready to share experiences where you collaborated with others. Discuss how you communicated technical information to non-technical stakeholders effectively.
✨Familiarize Yourself with Agile and Waterfall Methodologies
Understand the differences between Agile and Waterfall project management methodologies. Be prepared to discuss your experience in both and how you adapted your approach based on project needs.
