SQL/ETL Developer

2 weeks ago

Oak Brook, United States Radiological Society of North America Full time
Job DescriptionJob Description

What we’re looking for: As an SQL/ETL Developer, you will play a pivotal role in the lifecycle of data warehousing and Extract, Transform, Load (ETL) processes, focusing on the creation, implementation, and refinement of data solutions to meet business needs. This role encompasses a broad set of responsibilities, from the initial stages of gathering requirements and data modeling to the development, testing, deployment, and ongoing maintenance of ETL and data warehouse projects. You will leverage your deep expertise in ETL methodologies and tools, primarily Microsoft SSIS, to ensure that data solutions are robust, efficient, and scalable.

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 remote 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 fabulous 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.
  • Implementing and maintaining data solutions leveraging a variety of technologies, including AWS, Elasticsearch, MySQL, and other relational and non-relational database platforms.
  • 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.


The Radiological Society of North America is an equal opportunity employer and prohibits discrimination and harassment of any kind. RSNA is committed to hiring and employing qualified people without regard to race, color, religion, sex, marital status, national origin, age, disability, veteran status, citizenship status, genetic information, sexual orientation, unfavorable military discharge, ancestry, order of protection status, pregnancy, or any other legally protected characteristic. All employment decisions at RSNA are based on business needs, job requirements, and individual qualifications.

  • SQL/ETL Developer

    1 month ago

    Oak Brook, United States Radiological Society of North America Full time

    Job DescriptionJob DescriptionWhat 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...

  • Mid- Senior SQL/ETL Developer

    3 weeks ago

    Oak Brook, Illinois, United States Motion Recruitment Full time

    Job Description: Our client is a leading force in the field of radiology, dedicated to advancing medical imaging through education, research, and innovation. They are looking for a SQL/ETL Developer to help them with an exciting project with significant impact on a hybrid basis in the Chicagoland area. As a Developer, you'd handle the crucial task of...

  • Java Developers

    1 month ago

    Oak Brook, United States Axiom Technology Group Full time

    Job DescriptionJob DescriptionJob Description:Axiom Group LLC seeks Senior Java Developers (multiple positions) in Oak Brook, IL. Develop, create, and modify applications following the Software Development Lifecycle (SDLC). Gather user requirements and identify appropriate environment. Translate user requirements into detailed specifications and design and...

  • Data Insights Analyst

    6 days ago

    Oak Brook, Illinois, United States Chamberlain Group Full time

    Job SummaryChamberlain Group is a leading provider of access solutions, with a global presence and a portfolio of top brands. We are seeking an experienced Advanced Analytics Specialist to join our team and contribute to the development of our myQ Azure data platform.Key ResponsibilitiesDesign and implement data visualizations that provide actionable...

  • Application Developer

    3 months ago

    Oak Brook, United States PLS Financial Services, Inc. Full time

    PLS®: People. Location. Service PLS—which stands for People – Location – Service—is a leading retail provider of alternative financial services. The PLS Group, headquartered in Chicago, is comprised of over 200 financial service centers in 12 states. Through our check cashing stores, we provide consumers with convenient financial products and...

  • Application Developer

    3 months ago

    Oak Brook, United States PLS Financial Services, Inc. Full time

    PLS®: People. Location. Service PLS—which stands for People – Location – Service—is a leading retail provider of alternative financial services. The PLS Group, headquartered in Chicago, is comprised of over 200 financial service centers in 12 states. Through our check cashing stores, we provide consumers with convenient financial products and...

  • Data Analytics Specialist

    1 week ago

    Oak Brook, Illinois, United States Chamberlain Group Full time

    Position OverviewThis role is integral to supporting various Business Units and functional teams within Chamberlain Group, focusing on the myQ Azure data platform.About Chamberlain GroupChamberlain Group stands as a prominent player in access solutions, featuring renowned brands like LiftMaster and Chamberlain, utilized in countless residential, commercial,...

  • Data Analytics Specialist

    1 week ago

    Oak Brook, Illinois, United States Chamberlain Group Full time

    Company Overview:Chamberlain Group stands as a global frontrunner in access solutions, featuring renowned brands like LiftMaster and Chamberlain, which are present in millions of residences, businesses, and communities around the globe.Position Summary:The Advanced Analytics Analyst plays a pivotal role in supporting various Business Units and functional...

  • Sr. MuleSoft Developer

    1 month ago

    Oak Brook, Illinois, United States Inspira Financial Full time

    Take the next step in your journey at Inspira Financial. You will help businesses and individuals thrive today, tomorrow, and into retirement. Become part of a company that is people centric and client obsessed in every interaction; a community of forward-thinking individuals focused on driving results to deliver our mission with an unwavering commitment to...

  • Application Services Developer 1

    3 months ago

    Oak Brook, United States Pls Financial Services, Inc. Full time

    Overview: PLS: People. Location. Service PLSwhich stands for People Location Serviceis a leading retail provider of alternative financial services. The PLS Group, headquartered in Chicago, is comprised of over 200 financial service centers in 12 states. Through our check cashing stores, we provide consumers with convenient financial products and services to...

  • Sr. MuleSoft Developer

    1 month ago

    Oak Brook, United States Inspira Financial Full time

    Take the next step in your journey at Inspira Financial. You will help businesses and individuals thrive today, tomorrow, and into retirement. Become part of a company that is people centric and client obsessed in every interaction; a community of forward-thinking individuals focused on driving results to deliver our mission with an unwavering commitment to...

  • Advanced Analytics Specialist

    1 week ago

    Oak Brook, Illinois, United States Chamberlain Group Full time

    Position Overview: The Advanced Analytics Specialist plays a crucial role in supporting various Business Units and functional teams at Chamberlain Group, focusing on the myQ Azure data platform.About Chamberlain Group: As a global leader in access solutions, Chamberlain Group is recognized for its top brands, including LiftMaster and Chamberlain, which are...

  • Advanced Analytics Specialist

    6 days ago

    Oak Brook, Illinois, United States Chamberlain Group Full time

    Job SummaryThis role provides support to the Business Units and functional teams across Chamberlain Group as it relates to the myQ Azure data platform. The Advanced Analytics team leverages tools that ingest, process, store and analyze large volumes of transactional data collected from connected device and user interactions via iOS and Android phone apps.Key...

  • Systems Administrator

    3 months ago

    Oak Ridge, United States ITR Full time

    Job DescriptionJob DescriptionSystems Administrator – SQL DBAQualification Requirements for System Administrator 3 – MS SQL DBA Responsibilities Database Administration Design, install, deploy, migrate, troubleshoot, and manage Microsoft SQL Servers. Design, install, deploy, migrate, troubleshoot, and manage Microsoft SQL Server Reporting Services (SSRS)...

  • Sr. Pricing Analytics Manager

    2 months ago

    Oak Brook, Illinois, United States Chamberlain Group Full time

    If you are a current Chamberlain Group employee, please click here to apply through your Workday account.This role is within the Business Unit organization and will be responsible for owning business unit pricing strategy, data, reporting, and analysis capabilities to proactively generate insights that optimize strategic pricing decisions. They will report...

  • API Solutions Engineering Lead

    2 weeks ago

    Oak Brook, Illinois, United States Inspira Financial Full time

    Job OverviewEmbark on a rewarding career at Inspira Financial, where you will play a pivotal role in empowering businesses and individuals to thrive in their financial journeys. Our organization is dedicated to fostering a people-centric and client-focused environment, driven by a community of innovative thinkers committed to achieving results with...

  • Lead Application Developer

    2 months ago

    Oak Brook, United States PLS Financial Services, Inc. Full time

    Our Lead Developer/ Solutions Architect is a key development role at PLS responsible for building and designing critical enterprise solutions. The candidate will participate as a technical expert in design and development of software in support of digital transformation, application modernization, and BI initiatives. The specific responsibilities will vary...

  • Lead Application Developer

    2 months ago

    Oak Brook, United States PLS Financial Services, Inc. Full time

    Our Lead Developer/ Solutions Architect is a key development role at PLS responsible for building and designing critical enterprise solutions. The candidate will participate as a technical expert in design and development of software in support of digital transformation, application modernization, and BI initiatives. The specific responsibilities will vary...

  • Intern, BI Developer for myQ DevOps

    3 weeks ago

    Oak Brook, United States Chamberlain Group Full time

    About Chamberlain Group:Chamberlain Group is a global leader in access solutions. Our leading brands like LiftMaster, Chamberlain, Merlin and Grifco are found in millions of homes and commercial applications across the globe. Our innovative products powered by the myQ digital ecosystem provide customers with smart access solutions to move safely through...

  • Analyst, Advanced Analytics

    4 weeks ago

    Oak Brook, United States Chamberlain Group Full time

    If you are a current Chamberlain Group employee, please click here to apply through your Workday account. Chamberlain Group is a global leader in access solutions with top brands, such as LiftMaster and Chamberlain, found in millions of homes, businesses, and communities worldwide. As a leader in the Smart Home industry, we boast one of the largest IoT...