We are looking for an intermediate person who has good logic (Go through a log file to determine issues), knows their way around UNIX, and can do some basic SQL calls in Oracle.
DESCRIPTION
Responsible for data analysis, validation, cleansing, collection and reporting. Extract and analyze data from various sources, including databases, manual files, and external websites. Respond to data inquiries from various groups within an organization. Create and publish regularly scheduled and/or ad hoc reports as needed. Document reporting requirements and process and validate data components as required. Experience with relational databases and knowledge of query tools and/or statistical software required.
Strong analytical and organizational skills required. Must possess expert level knowledge of MS Excel. 3-5 years of prior experience as a Data Analyst is required.
ADDITIONAL JOB DETAILS
Defines technology system scope, objectives, and requirements as well as tuning programs for processing efficiency. Documents technical solutions for Information Technology (IT) projects within the CLIENT Technology-Transportation Applications organization. Projects will focus very broadly within the Positive Train Control business area including messaging, vendor software, custom software, testing, and high-availability systems. Information Technology (IT) Applications Development with responsibilities for new development and existing systems support. Primary Activities and Responsibilities: - Research, analyze, and define business solutions. Prepare detailed project specifications and design solutions for business problems. - Support critical application instances for production environments. - Document test cases, expected results, test data requirements, and collaborate with testing teams/business partners to resolve testing problems. - Code, debug, test, and support utilities, tools, and programs as part of the application development process. - Provide impact analysis for changes to programs and systems. - Serve as technical resource on project team. - Assist in the definition of team processes and strategies. - Design and deploy reusable services. - Work collaboratively with a team to resolve production problems. - Support disaster recovery activities. - Miscellaneous activities and responsibilities as assigned by manager. Knowledge and Skills: - Ability to design, development, and integrate business systems - Written and oral communication skills - Knowledge of Service Oriented Architecture (SOA) - Ability to design test data suites - Problem solving skills - Ability to design and deploy web-based technologies using object-oriented methodologies - Systems documentation skills - Microsoft Office skills including Visio - Ability to write queries using Structured Query Language (SQL) in Oracle Database and SQL Server Databases - Knowledge of Linux / UNIX environment - Experience with Mercury Quality Center - Knowledge of Extensible Markup Language (XML), and Web Services - Knowledge of Agile Scrum methodologies and their application - The ability and flexibility to work on multiple projects simultaneously