Job description

Company Description Job Title: Senior Analytics Developers Location: Various and unanticipated worksites throughout the U.S. (HQ: Chicago, IL) Schedule: Full-time Requisition ID: LMT83558D At Northwestern Medicine, every patient interaction makes a difference in cultivating a positive workplace. This patient-first approach is what sets us apart as a leader in the healthcare industry. As an integral part of our team, you'll have the opportunity to join our quest for better healthcare, no matter where you work within the Northwestern Medicine system. At Northwestern Medicine, we pride ourselves on providing competitive benefits: from tuition reimbursement and loan forgiveness to 401(k) matching and lifecycle benefits, we take care of our employees. Ready to join our quest for better? Job Description Senior Analytics Developer for various and unanticipated worksites throughout the U.S. (HQ: Chicago, IL). Deliver solutions by writing ETL packages, developing visualizations, performing data and statistical analyses, data warehouse and analytic solutions and administering systems to deliver information to the health system. Gather and scope requirements and recommend analytical solutions to meet business needs. Serve as a functional and content expert of pipelines to allow synthesizing of raw data into actionable information, including healthcare claims and eligibility data. Apply knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures. Query and analyze data and use SQL for data extraction, manipulation, and reporting. Perform solution analysis, design, development, support and structured programming. Mentor junior level staff on analytic tools and solutions and serve as subject matter expert within team and department. Lead upgrade activities and communication with stakeholders. Build custom data cloud pipelines, warehouses & marts and administrative auditing products. Tech Environment: Agile Environment; Epic Clarity; SQL Server Business Intelligence Studio; SQL; SQL Server; C#.NET; SSRS; SSIS; SSAS; SMSS; Python; Excel; PowerPoint; Azure Data Bricks; Azure Data Factory. Qualifications Bachelor’s degree in Computer Science, IT, Information Systems or related field plus 4 years of experience in ETL/DW/data analytics required. Required: 4 years with SQL for data extraction, manipulation, and reporting; 2 years: SQL Server DB: create complex queries and stored procedures; Tableau /PowerBI /CrystalR/ SSRS; SSIS; SSAS; SSMS. Experience must include: gather and scope requirements and recommend analytical solutions to meet business needs; mentor/train junior staff on analytics tools and solutions; serve as analytics subject matter expert; Agile environment; solution analysis, design, development and support; structured programming. Background check and drug screen required. Some remote work available from states NM is registered for business but must be available for onsite training or meetings as needed. $102,294/year-$132,389/year. Additional Information Northwestern Medicine is an affirmative action/equal opportunity employer and does not discriminate in hiring or employment on the basis of age, sex, race, color, religion, national origin, gender identity, veteran status, disability, sexual orientation or any other protected status. If we offer you a job, we will perform a background check that includes a review of any criminal convictions. A conviction does not disqualify you from employment at Northwestern Medicine. We consider this on a case-by-case basis and follow all state and federal guidelines. Benefits We offer a wide range of benefits that provide employees with tools and resources to improve their physical, emotional, and financial well-being while providing protection for unexpected life events. Please visit our Benefits section to learn more.

Requirements