Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and manage data integration processes, reports, and data warehousing solutions.
- Company: Coeo is a trusted expert in data management and analytics, focusing on Microsoft technologies.
- Benefits: Enjoy hybrid working, comprehensive healthcare, pension, life assurance, and career progression opportunities.
- Why this job: Join a fast-growing team with a supportive culture and the chance to make a real impact.
- Qualifications: Strong SQL Server, Data Warehousing, and BI tools experience required; degree in IT or related field preferred.
- Other info: Travel to client sites in London for the first two months, then hybrid working.
The predicted salary is between 48000 - 84000 £ per year.
Coeo are trusted data management and analytics experts, delivering technology strategy and support for business. The team have deep technical and commercial experience working with Microsoft Data Services to help our clients optimise their costs and maximise the benefits from their investments in these technologies. Coeo have a strong emphasis on consulting skills, and we expect our team members to be customer facing and have a growth mind-set. This role sits within our consulting team and we have clear expectations that our team members understand the importance of personal utilisation and have the ability to spot opportunities within our clients that can be passed back to our business development team.
Coeo has been established for over 14 years and has exclusively focused on Microsoft technologies. Our mission is to "help our clients predict their future" through the better use of data, technology, people and processes. To do this our business has always focused on:
- Managed Services
- Database Consultancy
- Data Engineering and Analytics Consultancy
- Adoption and Change Management
There has never been a more exciting time to join us, we’re a fast-growing professional services and managed services business. Due to consistent growth, it is enabling us to expand out our project management and delivery teams.
We are seeking an experienced Principal Consultant with a strong background in SQL Server, Data Warehousing, and Business Intelligence tools. The ideal candidate will have hands-on experience with SQL Server Integration Services (SSIS), SAP Business Objects, and Crystal Reports. This position requires a detail-oriented and proactive individual who can design, implement, and manage data integration processes, reports, and data warehousing solutions to support our business needs.
Key Responsibilities:
- Design, develop, and maintain data integration processes using SQL Server Integration Services (SSIS).
- Work with SQL Server databases to create and optimize queries and stored procedures for data extraction and reporting.
- Develop and maintain data warehouses, ensuring they meet business requirements for reporting and analytics.
- Create and manage reports and dashboards using SAP Business Objects and Crystal Reports.
- Collaborate with cross-functional teams to gather and understand business requirements, ensuring the design of scalable and effective data solutions.
- Optimize database performance and troubleshoot any issues related to SSIS, SQL Server, and reporting tools.
- Provide ongoing support for the data pipeline and reporting systems, ensuring high availability and performance.
- Continuously evaluate and implement best practices for data management, reporting, and analytics.
Required Skills and Qualifications:
- Strong experience with SQL Server Integration Services (SSIS) for ETL processes.
- In-depth knowledge of SQL and Data Warehousing concepts, with hands-on experience in data modeling and database design.
- Experience with SAP Business Objects for business intelligence and reporting.
- Expertise in Crystal Reports for designing and delivering business reports.
- Ability to create optimized SQL queries, stored procedures, and functions.
- Strong problem-solving skills and attention to detail.
- Excellent communication skills and the ability to collaborate with cross-functional teams.
Preferred Qualifications:
- Experience with additional BI tools and technologies (Power BI, Tableau, etc.) is a plus.
- Knowledge of other data integration tools and techniques.
- Familiarity with cloud platforms and big data technologies is a plus.
- Experience in leading an off-shore development team.
Education and Experience:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Years of experience in SQL Server, data integration, and BI/reporting technologies.
Additional Information:
- Travel Required: 2-3 days per week at the client's office in London for the first 2 months, 1 day per week thereafter.
- Preferred Location: Southeast area of the UK.
- Experience: Previous experience in leading an offshore development team is highly desirable.
- Hybrid working with a monthly office visit.
- Comprehensive benefits including healthcare, pension, life assurance, and more.
- Supportive, inclusive culture with career progression opportunities.
Diversity and Inclusion: Coeo is an equal opportunity employer committed to diversity and inclusion. All qualified applicants will be considered.
Principal Consultant employer: Coeo
Contact Detail:
Coeo Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Principal Consultant
✨Tip Number 1
Familiarise yourself with the specific Microsoft technologies mentioned in the job description, especially SQL Server Integration Services (SSIS) and SAP Business Objects. Having a solid understanding of these tools will not only boost your confidence but also demonstrate your commitment to the role.
✨Tip Number 2
Network with current or former employees of Coeo on platforms like LinkedIn. Engaging with them can provide you with insider knowledge about the company culture and expectations, which can be invaluable during interviews.
✨Tip Number 3
Prepare to discuss your previous experiences in data management and analytics in detail. Be ready to share specific examples of how you've optimised data processes or improved reporting systems, as this aligns closely with the responsibilities of the Principal Consultant role.
✨Tip Number 4
Showcase your problem-solving skills by preparing for scenario-based questions. Think of challenges you've faced in past roles related to data integration or reporting, and how you overcame them. This will highlight your proactive approach and ability to handle complex situations.
We think you need these skills to ace Principal Consultant
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL Server, Data Warehousing, and Business Intelligence tools. Emphasise your hands-on experience with SSIS, SAP Business Objects, and Crystal Reports, as these are crucial for the role.
Craft a Compelling Cover Letter: In your cover letter, demonstrate your understanding of Coeo's mission to help clients predict their future through data. Share specific examples of how you've successfully implemented data integration processes or optimised reporting systems in previous roles.
Showcase Consulting Skills: Since Coeo places a strong emphasis on consulting skills, highlight any relevant experience where you've worked directly with clients. Discuss how you've identified opportunities for improvement and contributed to business development.
Highlight Problem-Solving Abilities: Given the detail-oriented nature of the role, provide examples of how you've tackled complex data challenges in the past. Mention any specific instances where your problem-solving skills led to successful outcomes in data management or reporting.
How to prepare for a job interview at Coeo
✨Showcase Your Technical Expertise
Make sure to highlight your hands-on experience with SQL Server, SSIS, and BI tools like SAP Business Objects and Crystal Reports. Be prepared to discuss specific projects where you've successfully implemented data integration processes or optimised database performance.
✨Demonstrate Consulting Skills
Since Coeo places a strong emphasis on consulting skills, be ready to share examples of how you've effectively communicated with clients and collaborated with cross-functional teams. Show that you understand the importance of customer-facing roles and can identify opportunities for business development.
✨Emphasise Problem-Solving Abilities
Prepare to discuss challenges you've faced in previous roles, particularly related to data management and reporting. Highlight your problem-solving skills and attention to detail by providing concrete examples of how you've resolved issues or improved processes.
✨Exhibit a Growth Mindset
Coeo values a growth mindset, so express your enthusiasm for continuous learning and professional development. Share any recent training or certifications you've pursued, especially those related to Microsoft technologies or data analytics, to demonstrate your commitment to staying current in the field.
