SQL/ETL Developer

What we're looking for:

In the role of SQL/ETL Developer, you will be integral to the development and management of data warehousing and Extract, Transform, Load (ETL) processes. Your main objective will be to design, build, and enhance data solutions that align with organizational goals. This role involves a comprehensive set of duties including but not limited to requirement analysis, data modeling, and the end-to-end management of ETL and data warehouse initiatives. Utilizing your profound knowledge in ETL practices and tools, with a strong emphasis on Microsoft SSIS, you will ensure the delivery of reliable, efficient, and scalable data solutions.

This job might be for you if you're interested in:

• Working at a not-for-profit, mission-based organization that is focused on its members.
• A welcoming and supportive environment that gives you an opportunity to impact patient care.
• Excellent work-life balance - reasonable working hours, generally no evenings or weekends in a hybrid or fully remote workplace environment
• A competitive compensation package that includes outstanding medical/dental benefits, incredible long-term savings benefits, generous time off (including a week-long Winter Break), paid parental leave and more.
• Training and professional development opportunities.
• Enjoy the challenge of creating new solutions for a variety of tasks.
• An opportunity to work with a team that has longevity at RSNA, a culture of continuous improvement, a true sense of teamwork and support, and a great sense of humor.

What you'll do:

• Producing and optimizing complex SQL queries, views, stored procedures, triggers, and functions to meet application and business requirements.
• Acquiring an in-depth understanding of the RSNA's data systems to support and enhance data management and integration processes.
• Designing, developing, and managing ETL (Extract, Transform, Load) processes using tools like SSIS, ensuring data is accurately transferred and transformed for reporting and analysis.
• Collaborating on the design and development of database structures and ETL procedures to facilitate efficient and effective reporting and business intelligence initiatives.
• Estimating ETL project timelines and resource requirements based on detailed business specifications, contributing to project planning and management activities.
• Assisting in the development of data models for the organization's Enterprise Data Marts to ensure data integrity and availability for end-users.
• Building SSAS Tabular models and advancing data modeling techniques to support complex data analysis and reporting needs.
• Developing and maintaining data solutions across a range of technologies such as Azure/AWS, Elasticsearch, MySQL, and various other relational and non-relational databases, ensuring they meet the evolving needs of the business.
• Monitoring and ensuring the successful execution of SQL agent jobs, scheduled tasks, ETL processes, and services, addressing any issues to minimize downtime and data discrepancies.
• Providing ongoing support for existing data warehouse, reporting, and analytics solutions, including troubleshooting issues and managing regular data processing tasks.

Additionally, you may be involved in:

• Collaborating with cross-functional teams to understand data needs and deliver comprehensive data solutions that support organizational goals.
• Participating in the continuous improvement of the data management and analytics infrastructure to adapt to evolving business needs and technology advancements.
• Be involved in initiatives to evaluate and implement new data technologies and methodologies to enhance the organization's data capabilities.

Requirements:

• Proven experience in ETL development and data warehousing, with a strong preference for expertise in Microsoft SSIS.
• Solid understanding of database principles, SQL programming, data modeling techniques, and data integration methodologies.
• Ability to gather and interpret business requirements and translate them into technical specifications and robust data solutions.
• Experience with data analysis and the ability to identify and solve complex data-related issues.
• Strong problem-solving skills, with an emphasis on developing efficient and scalable ETL processes.
• Excellent communication and collaboration abilities, with the capacity to work effectively across teams and with non-technical stakeholders.

Nice to Have, but not required:

• Experience with the Power BI Platform is a plus.
• Any experience using RESTful APIs and other API interfaces, utilizing tools such as Postman for comprehensive development and testing.
• Familiarity with cloud platforms, especially Azure, is a big plus but not mandatory.
• Source Control experience using Azure DevOps, TFVS, and GIT/Bitbucket.