At a Glance
- Tasks: Lead and enhance critical data integration systems using SQL Server and SSIS.
- Company: Join HCLTech, a global leader in technology with a people-first culture.
- Benefits: Competitive salary, career growth, and opportunities to work with cutting-edge tech.
- Other info: Collaborate with diverse teams and enjoy excellent career development opportunities.
- Why this job: Make a real impact by solving complex data challenges in a dynamic environment.
- Qualifications: Advanced SQL and SSIS skills required; experience in BAU support is a plus.
The predicted salary is between 47250 - 57750 £ per year.
BAU Support Manager / Senior SQL Developer Job Specification Role summary: A hands‑on BAU support and SQL/SSIS technical leadership role responsible for the stability, troubleshooting, enhancement, and documentation of critical data integration systems across DEV, UAT, and PROD environments.
About the Role We are seeking an experienced BAU Support Manager / Senior SQL Developer to lead the support, maintenance, troubleshooting, and enhancement of critical data integration and reporting solutions.
The successful candidate will combine strong hands‑on SQL Server 2019 and SSIS 2019 development skills with the ability to manage business‑as‑usual support activity, diagnose complex issues, and work effectively across distributed environments where Production is owned and supported by a separate team outside the development lab.
Key Responsibilities
- Lead and coordinate BAU support activities across data integration and reporting platforms.
- Investigate, troubleshoot, and resolve complex incidents across SQL Server, SSIS, source data, transformation logic, and downstream outputs.
- Perform root cause analysis and implement robust, permanent fixes rather than short-term workarounds.
- Manage support queues, defects, incidents, and enhancement requests through JIRA.
- Maintain clear support documentation, technical notes, runbooks, and knowledge articles in Confluence.
- Work closely with separate Production support teams to diagnose issues, coordinate releases, and restore service.
- Communicate issue status, impact, resolution options, and progress clearly to technical and non‑technical stakeholders.
- Design, develop, maintain, and troubleshoot SQL Server 2019 database components.
- Create, optimise, and support complex T‑SQL scripts, stored procedures, views, functions, and SQL Agent jobs.
- Investigate data quality, reconciliation, performance, locking, failure, and integrity issues.
- Tune queries and stored procedures for performance, reliability, and maintainability.
- Support controlled deployments and fixes across DEV, UAT, and PROD environments.
- Design, build, enhance, and troubleshoot SSIS 2019 packages and ETL workflows.
- Support systems that ingest data from CSV files, Excel files, SQL Server databases, and other structured sources.
- Develop and maintain package scripting, expressions, transformations, connection managers, and error handling.
- Diagnose package failures, data load errors, scheduling issues, performance bottlenecks, and environment‑specific failures.
- Improve existing ETL processes through automation, validation, monitoring, and operational hardening.
- Operate effectively across distributed DEV, UAT, and PROD environments.
- Work within a support model where Production is owned and supported by a separate team outside the lab.
- Ensure defects, fixes, releases, and operational processes are documented and traceable.
- Use Confluence to maintain clear technical documentation, support procedures, known issues, and operational runbooks.
- Use own initiative to identify improvement opportunities, design practical solutions, and reduce recurring BAU issues.
Required Skills & Experience Area Requirement Level SQL Server 2019 Advanced SQL development, complex T‑SQL scripting, stored procedure creation, troubleshooting, query tuning, and performance optimization.
Advanced SSIS 2019 Package design, development, scripting, troubleshooting, deployment support, transformations, and error handling.
Advanced BAU Support Hands‑on support of critical systems ingesting CSV, Excel, and SQL data sources and transforming data using SSIS and SQL.
Essential Environments Experience supporting distributed DEV, UAT, and PROD environments, including models where PROD support is owned by a sepa
BAU Support Manager / Senior SQL Developer Job Specification Role summary: A hands‑on BAU support and SQL/SSIS technical leadership role responsible for the stability, troubleshooting, enhancement, and documentation of critical data integration systems across DEV, UAT, and PROD environments.
About the Role We are seeking an experienced BAU Support Manager / Senior SQL Developer to lead the support, maintenance, troubleshooting, and enhancement of critical data integration and reporting solutions.
The successful candidate will combine strong hands‑on SQL Server 2019 and SSIS 2019 development skills with the ability to manage business‑as‑usual support activity, diagnose complex issues, and work effectively across distributed environments where Production is owned and supported by a separate team outside the development lab.
Key Responsibilities BAU Support & Incident Management Lead and coordinate BAU support activities across data integration and reporting platforms.
Investigate, troubleshoot, and resolve complex incidents across SQL Server, SSIS, source data, transformation logic, and downstream outputs.
Perform root cause analysis and implement robust, permanent fixes rather than short-term workarounds.
Manage support queues, defects, incidents, and enhancement requests through JIRA.
Maintain clear support documentation, technical notes, runbooks, and knowledge articles in Confluence.
Work closely with separate Production support teams to diagnose issues, coordinate releases, and restore service.
Communicate issue status, impact, resolution options, and progress clearly to technical and non‑technical stakeholders.
SQL Server 2019 Development Design, develop, maintain, and troubleshoot SQL Server 2019 database components.
Create, optimise, and support complex T‑SQL scripts, stored procedures, views, functions, and SQL Agent jobs.
Investigate data quality, reconciliation, performance, locking, failure, and integrity issues.
Tune queries and stored procedures for performance, reliability, and maintainability.
Support controlled deployments and fixes across DEV, UAT, and PROD environments.
SSIS 2019 Development & Troubleshooting Design, build, enhance, and troubleshoot SSIS 2019 packages and ETL workflows.
Support systems that ingest data from CSV files, Excel files, SQL Server databases, and other structured sources.
Develop and maintain package scripting, expressions, transformations, connection managers, and error handling.
Diagnose package failures, data load errors, scheduling issues, performance bottlenecks, and environment‑specific failures.
Improve existing ETL processes through automation, validation, monitoring, and operational hardening.
Environment, Governance & Documentation Operate effectively across distributed DEV, UAT, and PROD environments.
Work within a support model where Production is owned and supported by a separate team outside the lab.
Ensure defects, fixes, releases, and operational processes are documented and traceable.
Use Confluence to maintain clear technical documentation, support procedures, known issues, and operational runbooks.
Use own initiative to identify improvement opportunities, design practical solutions, and reduce recurring BAU issues.
Required Skills & Experience Area Requirement Level SQL Server 2019 Advanced SQL development, complex T‑SQL scripting, stored procedure creation, troubleshooting, query tuning, and performance optimization.
Advanced SSIS 2019 Package design, development, scripting, troubleshooting, deployment support, transformations, and error handling.
Advanced BAU Support Hands‑on support of critical systems ingesting CSV, Excel, and SQL data sources and transforming data using SSIS and SQL.
Essential Environments Experience supporting distributed DEV, UAT, and PROD environments, including models where PROD support is owned by a sepa
At HCLTech, you'll supercharge your potential.
You'll find your career.
And you'll find your spark.
All at a place that knows that helping its customers stay on top starts by putting its people first.
HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry‑leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products.
We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.
Consolidated revenues as of 12 months ending June 2026totaled $14.8billion.
#J-18808-Ljbffr
Microsoft Power BI Technical Specialist employer: HCL Technologies Limited
At HCLTech, we pride ourselves on being an exceptional employer that prioritises the growth and well-being of our employees. As a Senior Administrator in Support & Operations, you will thrive in a collaborative work culture that encourages continuous learning and innovation, while also benefiting from our commitment to operational excellence and customer satisfaction. With access to advanced tools like Qualys and opportunities for mentorship, you'll be empowered to make a meaningful impact in a dynamic global environment.
StudySmarter Expert Advice🤫
We think this is how you could land Microsoft Power BI Technical Specialist
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like HCL Technologies Limited!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Microsoft Power BI Technical Specialist at HCL Technologies Limited.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like HCL Technologies Limited.
✨Apply Directly through Our Website
When you find a suitable opening like Microsoft Power BI Technical Specialist at HCL Technologies Limited, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Microsoft Power BI Technical Specialist
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at HCL Technologies Limited, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at HCL Technologies Limited. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at HCL Technologies Limited
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at HCL Technologies Limited!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
