3 days ago
Remote, WorldwideMid Level
H1B sponsor
Responsibilities
- Write, review, and optimize complex SQL queries, stored procedures, functions, and database structures in MS SQL Server and MySQL.
- Build, deploy, and maintain ETL/ELT pipelines primarily with SQL Server Integration Services.
- Design end-to-end data models, calculated columns, measures, and reporting layers using Power BI, DAX, and Power Query.
- Develop, publish, deploy, and maintain Power BI reports, executive dashboards, workspaces, access controls, and security settings.
- Perform data validation, reconciliation testing, root-cause analysis, and data quality rule implementation.
- Provide database operational support, troubleshooting, performance tuning, and maintenance for internal business applications.
- Collaborate with software developers and business stakeholders across sales, finance, contracts, and operations to translate requirements into technical solutions.
Requirements
- Strong experience with MS SQL Server and T-SQL, including complex queries, stored procedures, functions, and query performance optimization.
- Knowledge of MySQL administration and query development.
- Experience building and maintaining ETL processes, particularly with SQL Server Integration Services.
- Ability to design data processing workflows from source systems through reporting layers.
- Experience developing advanced Power BI reports and dashboards and designing Power BI data models.
- Proficiency in DAX and Power Query.
- Experience managing Power BI workspaces, report publishing, access control, and security settings.
- Experience with data validation, reconciliation testing, data quality rules, and discrepancy analysis.
- Experience working with on-premises SQL Server and MySQL environments and across DEV, TEST, and PROD stages.
- Ability to collaborate with application development teams on database integrations and provide database troubleshooting and operational support.
- Nice to have: experience with BigQuery and Google Cloud Platform ETL processes, plus basic Python knowledge for data analysis.
Benefits
- Remote position.
Tech Stack
Categories
Data Engineering
About Virtusa
Virtusa is a global IT services and consulting firm that builds and runs digital platforms, applications, and cloud systems for large enterprises. It sells project-based engineering, systems integration, and managed services across industries such as financial services, healthcare, and telecommunications. Founded in 1996 and headquartered in Southborough, Massachusetts, Virtusa is privately held and owned by BPEA EQT after previously trading on NASDAQ.