• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!


Module 10 - Understanding Job Requirements

Page history last edited by Dr. Ron Eaglin 8 years, 5 months ago

Understanding Job Requirements




For your final assignment I want you to understand the requirements for working as a systems integrator - which is also normally a senior software engineering level position. Below I have three real job postings. For this assignment look at these postings, list key skill sets that are necessary for these types of jobs and evaluate your level and what education/certifications/training you might need to be at the required level. Please note that the job postings that I selected are for $100K+ a year jobs and you are not likely to have all the skills, education, and experience for them. These are, however, a good basis for you to understand the future of your career.


This will be submitted as a word document or pdf file.




My Skills
BS Degree in CS or related BSIT Met
3 Years IT experience 5 years Met
VMWare Experience 2 classes in VMWare Met
Experience with structured programming 3 years Met
Experience using ELT tools none Need to pursue via education (covered in COP4709) and through independent work.









Job Description

Senior Software Engineer (Systems Integration) (OpenTable, Inc.; San Francisco, CA)


Design, develop, and test software modules for OpenTable's restaurant hospitality products. Work in a team environment using agile methodologies. Develop software using typesafe (Java) and interpreted (Javascript) languages along with established frameworks (Spring, NodeJS). Data modeling, design, and implementation using relational databases (MySQL, Postgres) and document-oriented databases (MongoDB). Test-driven development using unit (JUnit) and integration test and mocking (jMock) frameworks. Produce and test build artifacts using continuous integration toolsets. Provide documentation using standard notation, syntax, and tools (UML). Provide code reviews for development team. Design and implement RESTful APIs for consumption by internal and external teams. Utilize established web protocols to build fault-tolerant distributed systems. Deploy production software using AWS tools and APIs. Monitor production systems to ensure that they continue to run as designed and expected. Modify existing software to correct errors and improve its performance. Use strong communication skills to consult and advise team members on software system design and maintenance. Ensure SOLID develop practices are followed while shepherding code from concept to completion. Elicit and document business, functional, and non-functional requirements relevant to systems design.


Minimum Requirements: Master’s degree or U.S. equivalent in Computer Science, Information Systems, Information Technology, Engineering or a related field, plus 2 years of experience designing, developing, and testing software, working on relational databases, large scale client server systems that use common interface protocols (including HTTP), database client sets, and distributed computing tools (including HTTP). Within the 2 years, must have the following: experience using the following technologies: Java, Spring, JavaScript, Node.js, SQL, Relational Databases, Document-oriented stores, JUnit, Continuous Integration Servers, Windows, Linux, HTTP, REST APIs, Git, JSON, and XML; experience applying software engineering best practices using Scrum and Agile; experience designing software using Test Driven Development (TDD).


Please submit resume online at: http://www.opentable.com/careers/jobs/?jvi=owFK1fwG,Job. Please specify ad code DCKP. EOE. MFDV.



JOB 2 Description

The Federal Deposit Insurance Corporation (FDIC) mission is to preserve and promote public confidence in the U.S. financial systems by insuring deposits in banks and thrift institutions for up to $250,000; by identifying, monitoring, and addressing risks to the deposit insurance funds; and by limiting the effect on the account and the financial system when a bank or thrift institution fails.

Our client provides the day-to-day operational services to FDIC in support of infrastructure, facilities, hardware, software, and systems. Our client supports operational security, client support/help desk, data center operations, asset management, and systems engineering service areas.

Successful candidate needs to be able to design and engineer complex requirements to existing customer infrastructure in a cost effective manner. Candidate needs to be a subject matter expert and be able to articulate expertly solutions through written or verbal methods. Be able to trouble shoot complex problems quickly and effectively.
• Bachelor's degree or equivalent combination of education and experience
• Bachelor's degree in engineering, systems engineering, physics, computer science, management information systems, or related field preferred
• Nine or more years of experience in systems engineering, software engineering, operating systems programming.
• Experience working with specific software and/or hardware systems with a specific concentration in one or more areas
• Experience working with design principles and Windows Server applications

Must have experience with the following:
Microsoft Server
Microsoft application configuration (MSSQL, IIS, AD, SCCM)

Nice to have
• Team leadership ability
• Network
• Storage

Essential Job Functions
Architects highly complex, global solutions across the appropriate engineering environments to meet business requirements or enhance performance.
Reviews cost analyses and vendor comparison reports to ensure cost-effective and efficient operations. Recommends vendor/approach and presents to senior management.
Reviews and recommends highly complex systems investment(s) to management and customers based on results of independent assessment of current and future performance, stability, and systems management/life cycle issues.
Provides escalated, highly complex technical support to customers by investigating and resolving systems-related matters of significance; provides support telephonically and/or electronically.
Plans, conducts and oversees the technical aspects of large, complex projects; coordinates the efforts of technical support staff in the performance of assigned projects. Reviews completion and implementation of system additions and/or enhancements and provides management overview.
Develops and applies advanced methods, theories and research techniques in the investigation and solution of highly complex system requirements and problems. Develops training tools and documentation; oversees implementation of same.
Reviews literature, patents and current practices to support business requirements and/or new industry technology. Prepares reports and/or recommendations regarding new technology to appropriate personnel.
Provides complex technical consultation on current and proposed systems to other organizations and clients.
Provides leadership and work guidance to less experienced personnel.

Basic Qualifications
Bachelor's degree or equivalent combination of education and experience
Bachelor's degree in engineering, systems engineering, physics, computer science, management information systems, or related field preferred
Nine or more years of experience in systems engineering, software engineering, operating systems programming or naval architecture
Experience working with specific software and/or hardware systems with a specific concentration in one or more areas
Experience working with one or more structured programming languages
Experience working with design principles and applications

Other Qualifications
Strong leadership skills to effectively mentor and lead junior level personnel
Strong analytical and creative problem solving skills for design, creation and testing of complex systems
Strong communication skills to communicate systems proposals to management and customers and provide systems diagnoses and resolution for current systems
Strong interpersonal skills to interact with customers, senior level personnel, subordinates and team members
Strong organization skills to prioritize work, balance and lead complex projects
Ability to work independently and as part of a global team
Ability to integrate highly complex hardware and software systems


Systems Analyst (Systems Integration)

About the Job


Hillsborough County Government is looking for new members to join our team who are aligned with our core values of commitment to excellence; stellar customer service; and embracing diversity, transparency, and accountability.​  Our employees enjoy careers that are professionally and personally rewarding and that provide fair and reliable compensation.​   

Hillsborough County Government consists of many independent agencies and thousands of employees.​  We provide a wide range of municipal services to the citizens of Hillsborough County, including law enforcement, fire protection, street construction and maintenance, courts, libraries, parks and recreation, planning and zoning, property appraisal, tax collection, water, sewer, and solid waste collection services.​ In addition, we also employ professionals, paraprofessionals, and clerical staff in a wide range of service support functions, including management, finance, information technology, human resources, facilities, communications, etc.​ 

Read below to learn more about this exciting opportunity to join our team.​


The ideal candidate has a BS degree in Computer Science with four years experience implementing and supporting enterprise-wide systems.​ Has extensive knowledge creating MS SQL queries, scripts and reports.​ Has knowledge of enterprise ELT tools and secure FTP messaging systems.​ Has knowledge of healthcare functions (eligibility, services, billing, contracts), data warehouse support/​reporting, and data export, import and integration experience.​ Has the ability to manage projects with external vendors and ensure project deliverables are completed on schedule.​  


A Bachelor's degree from an accredited college or university with a major in computer technology field; and three years recent experience implementing and supporting enterprise-wide software applications including applying and testing patches/​upgrades, supporting data migration/​export/​import/​integration  activities, creating SQL queries and scripts to control, monitor or load data, creating of workflow processes, creating data warehouse queries and reports, working knowledge of the Secure FTP and document managementAn equivalent combination of education, training and experience that would reasonably be expected to provide the job-specific competencies noted below.​

OR Any equivalent combination of education, training, and experience that would reasonably be expected to provide the job-related competencies noted below.​


  • Extensive knowledge of creation of MS SQL complex queries, scripts and reports.​Extensive knowledge of software applications installation, operation, testing, and maintenance methods and techniques
  • Considerable knowledge of current computer hardware and/​or software characteristics and features
  •  Considerable knowledge of systems analysis
  • Considerable knowledge of operating system software
  • Extensive knowledge of healthcare functions related to eligibility and billing utilizing a third-party administrator
  • Working knowledge of data warehouse design and reporting
  • Working knowledge of provider setup and tracking for billing
  • Working knowledge of ETL tools related to job monitoring
  • Working knowledge of HIPAA security and privacy requirements
  • Skill in communicating technical information to non-technical users
  • Skill in systematic problem solving
  • Skill in developing, reviewing and editing technical/​user documentation
  • Skill in troubleshooting application interface/​integration issues
  • Skill in writing SQL query statements, scripts and reports
  • Ability to detect, analyze and solve routine hardware problems
  • Ability to detect, analyze and solve complex software problems
  • Ability to analyze and create complex reports utilizing business intelligence tools
  • Ability to establish and maintain effective working relationships with internal and external personnel
  • Ability to work collaboratively in a team environment
  • Ability to create documentation for system procedures or processes
  • Ability to operate a standard motor vehicle safely
  • Ability to train others


Note: The following duties are illustrative and not exhaustive.​ The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position.​ Depending on assigned area of responsibility, incumbents in the position may perform some or all of the activities described below.​

  • Create or modify complex MS SQL queries, scripts or reports for Data Warehouse.​
  • Assist with integration of export and import files of eligibility and claims data into the Date Warehouse.​
  • Provide analysis of the impact of business process changes to the Department’s applications.​
  • Manage ETL processes using MS SQL queries, workflow creation and issue resolution
  • Ability to manage projects with external vendors and ensure project deliverables are completed on schedule.​




Comments (0)

You don't have permission to comment on this page.