Job Title: SQL Programmer (SSRS/SSIS)
Job Description:
We seek a highly skilled and motivated SQL Programmer with expertise in SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services) to join our dynamic team. As a SQL Programmer, you will be responsible for designing, developing, and maintaining SQL-based solutions to support our business intelligence and data integration needs.
Responsibilities:
1. Develop and maintain SQL-based solutions: Design, write, and optimize complex SQL queries, stored procedures, views, and functions to extract, transform, and load data from various sources into our data warehouse.
2. Create and maintain SSRS reports: Design and develop interactive and visually appealing reports using SSRS to meet business requirements. Collaborate with end-users to gather report requirements, create data models, and ensure accurate and timely delivery of reports.
3. Build and manage ETL processes with SSIS: Develop and maintain SSIS packages to automate data extraction, transformation, and loading tasks. Implement data integration workflows to ensure smooth and efficient data movement between different systems and databases.
4. Perform data analysis and troubleshooting: Analyze complex data sets, identify data quality issues, and implement appropriate solutions. Troubleshoot and resolve database performance and integrity issues.
5. Collaborate with cross-functional teams: Work closely with business analysts, data engineers, and other stakeholders to understand business requirements, translate them into technical solutions, and provide recommendations for data-driven decision-making.
6. Ensure data security and compliance: Implement security measures and access controls to protect sensitive data. Adhere to data governance policies, industry best practices, and regulatory requirements.
7. Documentation and knowledge sharing: Document database schemas, data models, and ETL processes. Create technical documentation and provide knowledge transfer to other team members.
8. Stay updated on emerging technologies and best practices: Continuously enhance your skills and stay abreast of the latest advancements in SQL programming, SSRS, SSIS, and related technologies. Share your knowledge and expertise with the team.
Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
- Proven experience as a SQL Programmer, Database Developer, or similar role.
- Strong expertise in SQL programming and query optimization.
- Proficiency in SSRS (SQL Server Reporting Services) for report development and customization.
- Experience with SSIS (SQL Server Integration Services) for ETL development and data integration.
- Solid understanding of relational database concepts, data modeling, and database design principles.
- Familiarity with data warehousing concepts and dimensional modeling.
- Knowledge of database administration tasks such as backup and recovery, performance tuning, and security.
- Excellent problem-solving and analytical skills.
- Strong attention to detail and ability to work independently and as part of a team.
- Effective communication and collaboration skills.
Preferred Skills:
- Experience with other Microsoft SQL Server tools and technologies, such as SSAS (SQL Server Analysis Services) or Power BI.
- Knowledge of programming languages such as C#, Python, or PowerShell.
- Familiarity with Agile methodologies and software development life cycle (SDLC).
Join our team and contribute to developing and optimizing our data infrastructure. As a SQL Programmer with expertise in SSRS and SSIS, you will be crucial in leveraging data to drive informed business decisions and support our organization's growth.
