virtusa
Architect (ATC)
Job description
Databases
Strong experience with MS SQL Server (T-SQL) - writing complex queries, stored procedures, functions, query performance optimization.
Good knowledge of MySQL in terms of administration and query development.
ETL / Data Processing
Experience in building and maintaining ETL processes, particularly using SQL Server Integration Services (SSIS).
Ability to design end-to-end data processing workflows from source systems to reporting layers.
Power BI
Developing advanced reports and dashboards in Power BI.
Data modelling in Power BI (Data Model, relationships, hierarchies).
Proficiency in DAX and Power Query.
Publishing reports and managing Power BI workspaces, including access and security settings.
Data Quality & Testing
Experience in data validation and reconciliation testing.
Ability to define and implement data quality rules.
Identifying and analysing business data errors.
Environments
Experience working in on-premises environments (SQL Server, MySQL).
Willingness and ability to work across all environments (DEV, TEST, PROD).
Application Support
Ability to collaborate with application development teams regarding database integrations.
Troubleshooting and resolving performance issues related to databases.
Maintenance and support of databases used by business applications.
Other Technologies (nice to have)
Experience with BigQuery (SQL, ETL processes in Google Cloud).
Basic knowledge of Python for data analysis (a plus, but not mandatory).
Business Skills
Good understanding of business processes such as
sales,
finance,
contract management.
Familiarity with CRM / ERP systems (e.g. data structures, integrations).
Soft Skills
Ability to work independently, including
planning and organizing tasks,
prioritizing workload,
solving problems without constant supervision.
Strong communication skills for collaboration with both business stakeholders and technical experts.
High attention to detail and analytical


