We are seeking a highly skilled and motivated Software Engineer to join our team. The ideal candidate will have extensive experience with PowerBI, a strong background in transitioning data warehouses from Microsoft SQL Server to Snowflake, and expertise in creating SQL Server stored procedures and views. This role will also involve working with various reporting tools, including SQL Server Reporting Services (SSRS) and Crystal Reports, and generating ad hoc reports as needed
Key Responsibilities
- Assess current SQL Server architecture and develop a comprehensive migration plan.
- Utilize Snowflake’s tools and best practices to perform data extraction, transformation, and loading (ETL).
- Developed and maintained SQL Server stored procedures and views to support internal reporting and business processes.
- Ensure that stored procedures and views are optimized for performance and accuracy.
- Create and manage reports using PowerBI to provide actionable insights and support data-driven decision-making.
- Develop and deploy reports using SQL Server Reporting Services (SSRS) and Crystal Reports as required.
- Provide support for existing reporting tools and troubleshoot issues as they arise.
- Offer training and documentation to users on report generation and data analysis tools.
Required Experience/Skills
- Bachelor’s degree in Computer Science, Information Technology, or a related field. Advanced degrees or certifications are a plus.
- Minimum of [8] years of experience in software engineering with a focus on data warehousing and reporting.
- Proven experience with transitioning data warehouses from SQL Server to Snowflake.
- Hands-on experience in developing SQL Server stored procedures and views.
- Proficiency with PowerBI, SQL Server Reporting Services (SSRS), and Crystal Reports.
- Experience with data modeling, ETL processes, and performance tuning.