Title: Software Engineer, SQL
Employer: Association of American Medical Colleges (AAMC)
Job Type: Full-time, direct hire
Location: 655 K Street NW, Washington DC
How to apply: Please apply online. The link to the job posting can be found here: http://ch.tbe.taleo.net/CH10/ats/careers/requisition.jsp?org=AAMC&cws=1&rid=462
SUMMARY: Responsible for the design, development and support of IT application and data systems utilizing PL/SQL technologies, Microsoft SQL Server Reporting Services , and object-oriented programming. Develops design specifications, artifacts and performs post implementation support and system enhancements as assigned. Creates and uses Software Development Life Cycle (SDLC) artifacts in accordance with established standards and maintains documentation for effective system lifecycle support. Collaborates with IT managers and leads to develop and maintain technical and development artifacts and to track and report progress. Participate in creating technical standards and improving support and development processes.
RESPONSIBILITIES:
- Prepare software requirements data model and database specifications, and prototypes for translation into structured applications.Research, analyze and propose program-specific business rules used in system with the necessary interfaces into other systems or across platforms. Help formulate and define scope and objectives with AAMC Division staff.
- Conduct systems design analysis and prepare systems application and database designs that are scalable, adhere to standards, practice reuse, ensure fail-safe integration of programs into production systems, and adhere to the enterprise technology model and application standards.
- Code, debug, unit test, systems integration test and document applications and enhancements including, but not limited to screens, reports, underlying logic and interface components on assigned tasks.
- Devise, modify and tune procedures and system features to solve complex problems considering computer equipment capacity and limitations, operation time, user load and performance requirements against desired results.
- Assume responsibility for ongoing technical maintenance and support for assigned applications. Analyze, debug and revise existing system logic difficulties and documentation as necessary.
- Assist database administrators, data stewards, quality assurance team and other staff in ways to ensure data integrity, consistency, security and privacy
- Assist in defining required tasks, estimating durations for tasks, deliverables and activities.
- Meet deadlines and formally report progress regularly to IT Management against assigned tasks.
- Adhere to organizational policies, standards and best practices in application development, documentation, and maintenance.
- Provide technical expertise and actively participate in creating systems development, software, hardware, and application development standards, procedures and policies.
QUALIFICATIONS:
- Requires a Bachelor’s degree in computer science, information systems, engineering, business, or related scientific or technical discipline required (may be waived with strong practical experience) plus a minimum 2 years of experience in all phases of application system analysis, application development and application maintenance support utilizing Microsoft SQL Server Reporting Services , PL/SQL technologies, andobject-oriented programming.
- Requires experience with relational databases, database development,web-to-database connectivity, as well as experience with SQL, PL/SQL, Microsoft Transact SQL syntax for writing SQL expressions. HTML, CSS, XML, and web services.
- Experience with Customer Relationship Management (CRM) systems (Salesforce, Avectra, NetForum) or Association Management Systems (AMS) desired.
- Experience in requirements gathering and requirements analysis for Web-based applications required.
- Excellent oral and written communication skills required.
About the AAMC: Founded in 1876 and based in Washington, D.C., the Association of American Medical Colleges (AAMC) is a not-for-profit association representing all 141 accredited U.S. and 17 accredited Canadian medical schools; nearly 400 major teaching hospitals and health systems, including 51 Department of Veterans Affairs medical centers; and 90 academic and scientific societies. Through these institutions and organizations, the AAMC represents 128,000 faculty members, 83,000 medical students, and 110,000 resident physicians.
Why work at AAMC?
We have a great Mission: The AAMC serves and leads the academic medicine community to improve the health of all. Through its many programs and services, the AAMC strengthens the world's most advanced medical care by supporting the entire spectrum of education, research, and patient care activities conducted by our member institutions.
You don’t have to be a Doctor to make a difference: As the leading provider of technology-enabled medical school application services, such as the Medical College Admission Test (MCAT), the American Medical College Application Service (AMCAS), and the Electronic Residency Application Service (ERAS), our Information Technology staff plays a critical role in supporting and fulfilling our mission.
We tackle the “big” challenges in Healthcare today: The AAMC facilitates solutions to address complex challenges in healthcare today such as transforming medical education, improving health equality, and redesigning patient care delivery. We help our members address complex issues with solutions based on research, best practices, and innovative ideas
Our culture: At the AAMC, we commit to being an organization that unites mission-driven staff, diverse in their experiences, talents, and approaches to solutions. The AAMC offers a rewarding workplace with opportunities for personal and professional growth. We agree to cultivate a respectful environment where employees and their work are valued for the contributions they make to the organization. We hold ourselves and others accountable in our words and actions to these values. Together, we strive for excellence in supporting the missions of our member institutions.