Sr. Data Analyst
, IN, United States
18690BR
Indiana
Job Description
Job Description
Roles And Responsibilities
Develop, optimize, and maintain SQL queries, stored procedures, and functions for efficient data retrieval and manipulation.
Design and implement ETL processes using SSIS for data extraction, transformation, and loading from various sources.
Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications.
Create and maintain data models, ensuring data integrity, normalization, and performance.
Generate insightful reports and dashboards using SSRS to facilitate data-driven decision-making.
Create reports and data extracts utilizing reporting tools such as SSRS, Crystal Reports, and/or reporting resources and functionality available within specific applications.
Troubleshoot and resolve database performance issues, bottlenecks, and data inconsistencies.
Conduct thorough testing and debugging of SQL code to ensure accuracy and reliability.
Stay up to date with emerging trends and advancements in SQL technologies and provide recommendations for improvement.
Requirements:
Strong experience in MS SQL server, SQL Programming, ETL development.
Proven experience as a SQL Developer with a strong focus on MS SQL Server.
Proficiency in SQL programming, including writing complex queries, stored procedures, and functions.
Have Strong knowledge of SQL Server (can write ad-hoc queries), knows SQL Server Reporting Services and Crystal Reports.
In-depth knowledge of ETL processes and hands-on experience with SSIS.
Strong expertise in creating reports and dashboards using SSRS.
Familiarity with database design principles, query optimization, and data modeling.
Experience with performance tuning and troubleshooting SQL-related issues.
Excellent problem-solving skills and attention to detail.
Strong communication and collaboration abilities.
Ability to work independently and handle multiple tasks simultaneously.
Value added - US Healthcare domain experience.
Qualifications
Bachelors
Range of Year Experience-Min Year
8
Range of Year Experience-Max Year
15
#J-18808-Ljbffr