We are seeking a highly skilled and experienced Data Analyst with a strong background in ETL processes, data manipulation, and SQL query writing. As a Data Analyst, you will play a key role in transforming raw data into meaningful insights to help drive business decisions. You will work closely with cross functional teams to understand business requirements, design ETL workflows, and ensure data quality, integrity, and availability.
Key Responsibilities
Design, implement, and manage ETL processes to extract, transform, and load data from multiple sources into data warehouses.
Collaborate with business stakeholders to gather requirements and understand data needs for reporting and analysis.
Write complex SQL queries for data extraction, reporting, and analysis to support business insights.
Perform data cleansing, transformation, and validation tasks to ensure data accuracy and consistency.
Create and optimize SQL queries for reporting and analysis.
Develop and maintain data pipelines using ETL tools such as e.g., Pentaho, Informatica, Talend, etc.
Design and develop automated reports and dashboards using tools like Tableau, Power BI, or similar.
Monitor ETL workflows to identify performance bottlenecks and ensure timely and efficient data loads.
Perform data profiling and analysis to identify trends, anomalies, and opportunities for process improvements.
Troubleshoot and resolve data related issues, working with other teams when necessary.
Document and maintain data models, ETL process flows, and data quality standards.Skills and Qualifications
Bachelor s degree in Computer Science, Information Systems, Engineering, or a related field.
5 years of hands on experience as a Data Analyst, with expertise in ETL processes.
Strong experience in writing complex SQL queries for data extraction, transformation, and analysis.
Proficient in SQL and database management e.g MySQL, SQL Server, Oracle, etc.
Strong experience with ETL tools such as Talend, Pentaho, Informatica, SSIS, etc. is a plus.
Experience in snowflake is plus.
Experience in data warehousing concepts and design Star Schema, Snowflake Schema, etc.
Knowledge of scripting languages such as Python, Shell, or Java is a plus.
Familiarity with data visualization tools e.g, Tableau, Power BI, etc..
Ability to work with large datasets and manage performance optimization tasks.
Strong analytical and problemsolving skills.
Excellent communication skills with the ability to interact with both technical and non technical stakeholders.
Detail oriented with strong organizational and documentation skills.
Knowledge of sanctions regulations and compliance is a plus.
Preferred Qualifications
Experience with cloud platforms AWS, Azure, Google Cloud and big data technologies Hadoop, Spark, etc.
Familiarity with Agile methodologies and version control tools Git, SVN
Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.
Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.
Virtusa is an Equal Opportunity Employer. All applicants will receive fair and impartial treatment without regard to race, color, religion, sex, national origin, ancestry, age, legally protected physical or mental disability, protected veteran status, status in the U.S. uniformed services, sexual orientation, gender identity or expression, marital status, genetic information or on any other basis which is protected under applicable federal, state or local law.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government-issued ID during each interview. All candidates must be authorized to work in the USA.
Learn more
Have any questions?
To join our bright team of professionals, you can apply directly to our website under the Careers tab and search all open jobs. https://www.virtusa.com/careers
Yes, you can. Virtusa gives you the flexibility to apply for multiple open positions that excite you about your future and align to your experience and career goals.
Yes, you can. Virtusa is a global Company, and we serve our clients through our global delivery model.
Our dedicated recruitment team will review your online application and match it to all our open jobs. We update our open jobs on a daily basis and encourage you to check back often.
Our team of recruiters will review your application, relevant job experience, and skills to appropriately align it to our open jobs. From there, the recruitment team will contact the qualified candidate to start the interview process.
Want to explore the ways you can engineer your career in technology? Our thought leaders share key career insights for candidates from entry-level job seekers to senior technologists.
Check your downloads folder for files and implementation instructions.
Assets are now available in your profile for future editing and use.