Job summary
The organization provides data-driven, business analysis to support senior organizational leaders.The team requires support specializing in data analysis to include cleaning and extracting data, and enabling/growing the existing automation efforts.The team needs candidates with Python skills that have experience extracting information from many data formats and the creation of tables for use in Oracle with SQL.
Job seniority: mid-to-senior level
Responsibilities
• The Contractor shall work closely with data scientists and technical team to implement requirements.• The Contractor shall preprocess or clean structured and unstructured Sponsor data.• The Contractor shall design and implement advanced code and table configurations for complex data sets.• The Contractor shall stay current with the Sponsor's enterprise metadata collection tools.• The Contractor shall produce ad hoc metrics reports to answer immediate needs.• The Contractor shall implement the Sponsor's existing coordination process.• The Contractor shall provide technical education to staff on an ad-hoc basis.• The Contractor shall analyze large amounts of raw data to provide new business insights.
Requirements
• Demonstrated experience writing, maintaining, and customizing Python scripts that extract text from various formats such as MS Word, PDF, or XML.• TS/SCI with poly is required.• Demonstrated experience reviewing documentation and APIs of commonly used packages to choose the one with the best fit for a given task and implement it.• Demonstrated experience writing Python scripts that pull data from web-based APIs and relational databases.• Demonstrated experience with implementing regular expressions.• Demonstrated experience conducting evaluations or transformations of data and loading the results into a relational database.• Demonstrated experience with version control systems, such as GitHub.• Demonstrated experience with SQL in Oracle.• Demonstrated experience addressing procedural and administrative issues within the assigned problem set.• Demonstrated experience with web analytics processing and procedures.
Key Skills Needed
• Python scripting• Data extraction• Table creation• SQL• Regular expressions• Version control systems (e.g., GitHub)• Data transformation• Web analytics processing