Systems Analyst Intern

Radian Group Inc. Philadelphia , PA 19107

Posted 2 months ago

Job Description: The Systems Analyst Intern will be responsible to diagram and document system implementations for the Electronic Content Management team.

Primary Duties and Responsibilities:

  • Create artifacts such as systems diagrams and data flow diagrams

  • Other related duties as assigned

Job Specifications:

Knowledge, Skills and Abilities:

  • Ability to write SQL queries required

  • Ability to create systems diagrams using Microsoft Visio

  • Experience with SQL Server or Oracle is required

  • Hands on experience with a relational database such as Oracle or Sql Server

  • Ability to write SQL code

  • Working knowledge of SQL Server Management Studio preferred

  • Ability to create system diagrams using tools such as Microsoft Visio

  • Must be a team player with effective interpersonal, written and verbal communication skills to clearly and professionally interact with internal and external parties.

  • Strong creative thinking, problem solving and analytical skills.

  • High commitment to excellent service levels and satisfaction with partners.

  • Organizational skills with the ability to multi-task are necessary.

  • Detail-oriented outlook coupled with ability to manage time effectively, plan ahead and meet deadlines.

  • Good business writing and presentation skills.

Education: Working towards a Bachelor's degree in Engineering, Computer Science, Information Systems or other IT discipline.

Location: 1500 Market Street Philadelphia, PA 19102

EEO Statement

Radian complies with all applicable federal, state, and local laws prohibiting discrimination in employment. All qualified applicants will receive consideration for employment without regard to gender, age, race, color, religious creed, marital status, sexual orientation, national origin, ethnicity, ancestry, citizenship, genetic information, disability, protected veteran status or any other characteristic protected by applicable federal, state, or local law.

If you are a person with a disability and need assistance in the application process please send an e-mail message to recruitment@radian.biz.

Apply Apply Not ready to Apply?

CHECK OUT OUR SIMILAR JOBS

  • Business Analyst Jobs

  • Systems Analyst Jobs

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Intelligence Analyst Intern

Source One, A Corcentric Company

Posted Yesterday

VIEW JOBS 5/24/2019 12:00:00 AM 2019-08-22T00:00 <a href="http://www.sourceoneinc.com/">Source One</a> is seeking a <u>Business Intelligence Analyst Intern</u> to support our procurement consulting firm based in Willow Grove, PA. A qualified candidate should demonstrate understanding and expertise in classifying and managing large data sets. This role requires a unique blend of research, data entry, data manipulation, organizational skills and logical problem solving.<br /> Our clients engage us for guidance, expertise, and solutions to help transform their procurement and supply chain groups within their organization. One of our firm’s growth areas has been data & analytics, including spend analysis, e-procurement, and procurement department “health” metrics.<br />   <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Spend Analysis is the practice of reviewing a client’s expenditures, suppliers, general ledger and other sources of information in order to classify their spending habits into category structures (taxonomy).</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">E-Procurement is the facilitation of bid collection using an online platform. This includes collection and analysis of data from Source One’s proprietary e-procurement site, ZipRFP.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Procurement department “health” metrics are the collection and analysis of internal and client data points intended to track the performance of a procurement organization.</li> </ul> <br /> <br /> We are looking for an individual that can help us develop internal and external (client-facing) dashboards which communicate critical business information to stakeholders. You will work closely with our in-house data & analytics team as well as members of our cross-functional leadership teams to understand the business requirements, translate them into analytical processes, and build reporting and dashboards that communicate the results. An ideal candidate for this position has technical analytics expertise with a desire to develop their business acumen.<br /> <br /> <strong>What will I do?</strong><br /> <br /> <strong>Key responsibilities include:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Provide day-to-day monitoring and support around the execution and the maintenance of recurring business reports.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Support in requirements gathering and the development of new dashboards.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Monitor and refine existing reports on an ongoing basis. Support ad-hoc analytics requests as needed.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Liaise with internal stakeholders regarding support requests/tickets and ensure that they are properly routed and resolved.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Perform unit testing to ensure that your deliverables achieve the expected outcomes.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Contribute to user acceptance testing by collaborating cross-functional stakeholders, ensuring that the business requirements have been properly satisfied.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Assist in the identification, construction, and integration of new internal and external data sources.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Document processes and develop training materials in support of BI applications.</li> </ul>  <br /> <strong>Who should apply?</strong><br /> <br /> <strong>Required Qualifications:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Currently pursuing an undergraduate or master’s degree in mathematics, statistics, analytics, business information systems, or an equivalent major.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Ability to write complex SQL queries.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Understanding of database management best practices.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience with data visualization tools.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Understanding of elementary statistical analysis and familiarity with core statistical functions.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Intermediate to advanced Excel skills.</li> </ul> <strong> <br /> Preferred Qualifications:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Familiarity with procurement processes and strategic sourcing principals.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Proficiency with SQL systems, especially MS Access, MySQL, and PostgreSQL.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Capable of automating tasks in Microsoft Office via VBA.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Ability to lead and execute against projects related to data management, process design, workflows, application management/deployment, etc.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Prior experience with Qlik Sense and Python.</li> </ul> <br /> <br /> <strong>Company Insights</strong><br /> Since 1992, Source One has been and is a premier procurement services provider and strategic sourcing consulting firm. Our team of spend management and category experts support best-in-class organizations by ensuring their procurement and sourcing capabilities are optimized and that they are getting the most value at the best possible price from their suppliers. Simply put, we help our customers save money by renegotiating existing contracts, streamlining and optimizing processes, and acting as decision support for their procurement and sourcing needs operating under three main verticals: IT & Telecom, Marketing, and Supply Chain.<br /> <br /> As a group of out-of-the-box thinkers and motivated individuals, we are always eager to have new members to the team to gain fresh ideas and insights for continuous process improvement and growth.<br /> <br /> We take pride in recruiting, developing and retaining highly talented individuals. In addition to the competitive salaries offered to our full-time employees, we provide an attractive vacation policy and benefits which include access to a 401K plan and disability, life, and medical insurance. Please visit us on the web at <a href="http://www.sourceoneinc.com/">www.sourceoneinc.com</a>.<br />  <br /> <strong>Interested in a career at Source One? Here’s how to apply:</strong><br /> <br /> Please apply on our web portal: <a href="http://jobs.sourceoneinc.com/">http://jobs.sourceoneinc.com/</a><br /> <br /> We ask that you make sure to include your salary requirements. Please do not contact anyone at the company directly.<br />   Source One, A Corcentric Company Philadelphia PA

Systems Analyst Intern

Radian Group Inc.