Chennai, Tamil Nadu
Job Summary
AutoRek Software Engineer

AutoRek Application:
AutoRek is an automated software reconciliations tool used within LBG to provide robust financial controls and mitigate financial and operational risk. It is built on a MS SQL database which eliminates the use of spreadsheets, giving improved governance and enables the business to focus on value-add tasks and improve regulatory reporting processes.

The Role:
Working as part of a multi-disciplined team to implement and support complex reconciliation solutions, the role will encompass using a variety of software tools and analytical skills to deliver high quality, fully functional reconciliation processes to the finance business community.

Involved in the full end-to-end project lifecycle, the software engineer is responsible for the design/development/configuration of the solution and will also provide technical support and guidance during the design/analysis and testing phases, as well as delivering training and post implementation support to the end users.

Competencies:
Third party application development and support
Experience of working in software application development/support role in fast paced client facing environment.
Excellent communication skills, both written and verbal.
Ability to convey technical solutions in a visual manner.
Strong analysis skills, to quickly identify and resolve client incidents.
Customer focussed to support incidents and ensure that they actioned in a timely manner.
Quality driven approach to deliver highest standard reconciliations at pace.

Team working




Ability to collaborate closely with clients and analysts to establish requirements and forming them into viable outline and detailed designs:
Participating in client meetings and workshops
Designing solutions or sub-sets of solutions at a complex level & scale, with experience of the following:
Visio
PowerPoint
Word
Excel
Documenting and building solutions from high-level specifications or requirements.

MS SQL Server
Experience of MS Development tools : SSMS, Visual Studio, Report Builder
Complex SQL scripting on tables/views/stored procedures/functions.
Strong SQL analysis and issue resolution skills.
Experience using large/complex databases.
SSRS report development.
Ability to build scalable and performant SQL procedures.

Software processes
Firm grasp of core s/w processes including governance, configuration control and release management, with experience of one or more of the following:
GitHub
JIRA

Self-Organisation
Exhibits good self-organisation, with focus on agreed priorities and creation of plans or work lists to achieve the goals.
Ability to manage multiple competing tasks.
Ability to work independently.

Key Responsibilities
1.



Collaborate with stakeholders to understand data requirements and translate them into ssas solutions.
2. Design and develop ssas cubes, dimensions, and measures based on business needs.
3. Optimize ssas models for improved query performance and data accessibility.
4. Troubleshoot and resolve issues related to ssas solutions and data discrepancies.
5. Implement security measures to ensure data integrity and confidentiality.
6. Provide technical support and guidance to end-users on ssas functionalities.
7. Stay updated on the latest ssas features and recommend enhancements for existing systems.
Skill Requirements
1. Proficiency in sql server analysis services (ssas) including tabular model and multidimensional model.
2. Robust understanding of data warehousing concepts and etl processes.
3. Experience in optimizing ssas cubes for performance enhancements.
4. Ability to write complex mdx and dax queries for data analysis.
5. Familiarity with data visualization tools such as power bi or tableau.
6. Excellent problem-solving skills and attention to detail.
7. Strong communication and collaboration abilities to work effectively with cross functional teams.
Other Requirements
1.Microsoft Certified1.Data Analyst Associate or similar SSASrelated certifications are a plus.
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-

📌 SQL Server Analysis Services (SSAS) Technical Specialist (Chennai)
🏢 HCLTech
📍 Chennai