ALTA IT is looking for a SQL Data Analyst with strong SQL report writing skills (SSRS and other tools). This role will primarily involve developing and maintaining SQL queries and reports essential for business operations and decision-making processes, especially during peak periods of tax-related activities.
About the Role:
Core Responsibilities:
- Query Optimization: Write and optimize complex SQL queries to efficiently retrieve, manipulate, and aggregate data from databases. Ensure optimal query performance by understanding execution plans, indexing strategies, and database statistics.
- Report Development: Collaborate with stakeholders including business analysts, data scientists, and end-users to understand reporting requirements. Design and develop SQL-based reports using tools like SQL Server Reporting Services (SSRS), Power BI, or similar platforms.
- Data Extraction and Transformation: Extract data from multiple databases or sources and transform it as necessary for reporting purposes. Perform data joins, apply business rules, and aggregate data to meet specific reporting needs.
- Data Validation and Accuracy: Ensure the accuracy and reliability of data used in reports through thorough testing and validation procedures. Verify data integrity across different sources and ensure consistency in reporting outputs.
- Report Deployment and Maintenance: Deploy SQL-based reports to reporting servers (e.g., SSRS), ensuring proper configuration and accessibility for end-users. Monitor and maintain existing reports to accommodate changing business requirements and data sources.
- Performance Monitoring: Monitor the performance of SQL queries used in reports. Identify opportunities for optimization, analyze query execution times, and monitor database server performance metrics.
Qualifications:
- Bachelors degree in computer science, Information Technology, or related field.
- Proven experience as a SQL Data Analyst with a focus on report writing.
- Strong proficiency in SQL programming and database management systems (e.g., SQL Server, MySQL).
- Experience with SQL Server Reporting Services (SSRS) or similar reporting tools.
- Familiarity with data visualization tools such as Power BI.
- Knowledge of database optimization techniques and performance tuning.
- Excellent analytical and problem-solving skills with a keen attention to detail.
- Ability to work collaboratively in a team environment and communicate effectively with stakeholders.
- Certification in SQL Server or relevant technologies (optional but preferred).
Pay range and compensation package:
60-70/hr W-2
Equal Opportunity Statement:
Include a statement on commitment to diversity and inclusivity.