We are seeking a skilled SQL Developer with expertise in SSRS, SSIS, and SSAS to join our client's team in the oil and gas industry. This is a 6-month contract-to-permanent position, with the expectation of working on-site five days a week.
As a SQL Developer, you will play a crucial role in designing, developing, and maintaining SQL Server solutions, particularly focusing on SSRS, SSIS, and SSAS. The ideal candidate will have experience working with cubes and tabular models and possess a strong understanding of data warehousing concepts. You will collaborate closely with the development team, business analysts, and stakeholders to create robust and efficient data solutions that meet the organization's needs.
- Design, develop, and maintain SQL Server solutions utilizing SSRS, SSIS, and SSAS to meet business requirements.
- Collaborate with business analysts to understand data reporting and analysis needs.
- Create and optimize SQL queries, stored procedures, and views to extract and transform data from various sources.
- Develop and maintain SSRS reports and dashboards, ensuring data accuracy and visual appeal.
- Implement ETL processes using SSIS to extract, transform, and load data from multiple systems into data warehouses.
- Design and develop tabular models and cubes using SSAS to enable efficient data analysis and reporting.
- Collaborate with cross-functional teams to define data integration and data modeling strategies.
- Conduct performance tuning and optimization of SQL queries, ETL processes, and data models.
- Ensure data security and integrity throughout the development and deployment process.
- Troubleshoot and resolve SQL-related issues and provide technical support as needed.
Requirements
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Proven experience as a SQL Developer, working with SSRS, SSIS, and SSAS.
- Strong understanding of data warehousing concepts and experience with designing and implementing data models.
- Proficiency in writing complex SQL queries, stored procedures, and views.
- Familiarity with cubes and tabular models, preferably using SSAS.
- Experience with data integration and ETL processes using SSIS.
- Solid understanding of database architecture and performance optimization techniques.
- Knowledge of data security best practices and experience implementing security measures.
- Excellent problem-solving and troubleshooting skills.
- Strong communication and collaboration skills to work effectively with cross-functional teams and stakeholders.
- Prior experience in the oil and gas industry is a plus.