Database Administrator – Security Data Science Specialist

Location: New York, NY 10001
Job Type: Contract [NO BENEFITS]
Contract Duration: 12 Months
Work Schedule: 7 hours per day, 35 hours per week, with scheduling based on subject matter expert (SME) availability for meetings and other requirements
Experience Required: 6–8 Years

Job Summary

We are seeking an experienced Database Administrator – Security Data Science Specialist to support security operations through data collection, database management, statistical analysis, and reporting. The ideal candidate will have strong SQL and Python skills, experience working with relational databases, and the ability to transform complex datasets into actionable insights that support operational decision-making.

This role involves gathering and analyzing security-related data, maintaining accurate records, developing dashboards, and collaborating with stakeholders to improve data quality and reporting efficiency in a fast-paced environment.

Key Responsibilities

Data Collection and Management

• Collect and compile statistical data related to security incidents and operational activities across multiple locations.
• Gather data from various internal departments, agencies, databases, spreadsheets, and other designated sources.
• Utilize established computer systems, reporting interfaces, and databases to retrieve and maintain accurate information.
• Organize, validate, and clean datasets to ensure accuracy, consistency, and suitability for analysis.
• Maintain records and follow established workflows, standard operating procedures, and data management guidelines.

Data Analysis and Reporting

• Analyze security-related data using SQL, Python, and other appropriate analytical tools.
• Identify relevant data fields, assign priorities, evaluate data relevance, and transform raw information into actionable insights.
• Compile and analyze operational statistics to support daily reporting and management decisions.
• Develop, maintain, and enhance reports and dashboards to communicate key findings and performance indicators.
• Present analytical results and communicate complex information clearly to technical and non-technical stakeholders.
• Prepare action plans, coordinate schedules, and provide timely updates to meeting participants and relevant stakeholders.

Database Integration and Optimization

• Connect and integrate data from multiple sources, including relational databases, spreadsheets, and cloud-based services.
• Develop and maintain synchronized datasets to support reporting and analytical requirements.
• Identify opportunities to improve database performance, reporting workflows, and existing business processes.
• Maintain documentation for data models, reporting specifications, database processes, and established best practices.

Security and Stakeholder Collaboration

• Follow data security procedures to maintain confidentiality and support compliance with applicable data protection requirements.
• Collaborate with business analysts, data engineers, and other stakeholders to understand business requirements and deliver effective data solutions.
• Work effectively in a fast-paced, high-pressure security operations environment while maintaining professionalism.
• Perform additional data management, analysis, and reporting duties as assigned.

Required Skills and Competencies

• Proficiency in SQL and Python for data extraction, manipulation, and analysis.
• Experience gathering, organizing, maintaining, and managing computer-based data.
• Strong working knowledge of relational databases and database management principles.
• Experience developing reports, dashboards, and data visualizations.
• Proficiency in Microsoft Office applications, including Excel, Word, PowerPoint, Visio, and Project.
• Familiarity with Microsoft Windows-based operating systems and related business applications.
• Strong analytical and problem-solving skills, with the ability to interpret large and complex datasets.
• Excellent written and verbal communication skills.
• Ability to collect, interpret, and synthesize information from verbal and written sources.
• Ability to translate business requirements into meaningful reports and dashboards.
• Strong organizational skills, attention to detail, and the ability to manage multiple priorities.
• Ability to work independently, meet deadlines, and maintain composure in a high-pressure environment.
• Professional demeanor and the ability to collaborate effectively with individuals at all organizational levels.

Education and Experience Requirements

• Bachelor's degree in Information Systems, Computer Science, Business Administration, or a related field.
• 6–8 years of relevant professional experience.
• Progressive experience working with relational databases and database technologies.
• At least 4 years of experience in reporting and dashboard development.
• At least 4 years of experience working with database technologies.
• Demonstrated experience using SQL and Python for data analysis and reporting.
• Strong technical writing, documentation, and presentation skills.
• Experience in the transportation industry, particularly the railroad sector, is preferred.

Preferred Qualifications

• Microsoft Power BI Data Analyst certification.
• Experience developing dashboards and reports using Power BI or similar business intelligence tools.
• Experience analyzing security, incident, or operational data.
• Experience integrating data from multiple systems and sources.

Interested candidates with strong SQL, Python, database management, and reporting experience are encouraged to apply.