Job description

Title: Database Administrator Location: New York, NY 10004 On-site/Remote/Hybrid: Onsite Interview Process: Web or In person interview Duration: 12 Months Work Schedule: 35 Hours/Week (7 Hours/Day) Job Summary: Client is seeking an experienced Security Data Science Specialist / Data Analyst to support its Office of Security with data collection, analysis, reporting, and dashboard development. The consultant will analyze fare evasion, crime-related, and security operational data across Client agencies, using SQL, Python, relational databases, and Power BI to generate actionable insights and support management decisions. Key Responsibilities: • Collect, compile, validate, and analyze fare evasion, crime-related, and security operational data from multiple Client agencies. • Use SQL and Python to process large datasets, identify trends, and generate actionable insights. • Develop, maintain, and enhance Power BI dashboards, reports, and data visualizations . • Integrate data from relational databases, spreadsheets, internal systems, and cloud-based sources. • Perform data cleansing, transformation, and validation to ensure accuracy and consistency. • Analyze security incidents, operational statistics, and historical trends to support decision-making. • Collaborate with business analysts, data engineers, security teams, and management to gather reporting requirements. • Translate business requirements into dashboards, reports, and analytical solutions. • Identify opportunities to improve data processes, reporting efficiency, and system performance. • Maintain documentation for data models, reporting specifications, and standard operating procedures. • Ensure data confidentiality, security, and compliance with applicable policies. • Present analytical findings and recommendations to technical and non-technical stakeholders. Required Qualifications: • 6+ years of relevant professional experience in data analysis, reporting, or database technologies. • 4+ years of experience developing reports and dashboards. • 4+ years of experience working with relational databases and data management technologies. • Strong hands-on experience with SQL and Python for data extraction, manipulation, and analysis. • Experience developing dashboards and visual reports using Microsoft Power BI . • Experience integrating, cleaning, validating, and organizing data from multiple sources. • Strong proficiency in Microsoft Excel, Word, PowerPoint, Visio, and Project. • Experience analyzing large datasets and presenting findings to business stakeholders. • Strong documentation, analytical, troubleshooting, and problem-solving skills. • Excellent written and verbal communication skills. • Ability to work independently, prioritize assignments, and meet deadlines in a fast-paced security environment. • Bachelor's degree in Computer Science, Information Systems, Business Administration, or a related field. Preferred Qualifications: • Microsoft Certified: Power BI Data Analyst Associate (PL-300). • Previous experience working with MTA or NJ Transit . • Experience in transportation, railroads, public transit, or public-sector environments. • Experience analyzing security incidents, crime statistics, or fare evasion data. • Familiarity with cloud-based data sources and relational database integration. • Experience supporting operational reporting and executive dashboards. About Us: InterSources Inc , is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.

Requirements

Must-haves

Title: Database Administrator
Location: New York, NY 10004
On-site/Remote/Hybrid: Onsite
Interview Process: Web or In person interview
Duration: 12 Months
Work Schedule: 35 Hours/Week (7 Hours/Day)
Collect, compile, validate, and analyze fare evasion, crime-related, and security operational data from multiple Client agencies.
Use SQL and Python to process large datasets, identify trends, and generate actionable insights.
Develop, maintain, and enhance Power BI dashboards, reports, and data visualizations .
Integrate data from relational databases, spreadsheets, internal systems, and cloud-based sources.
Perform data cleansing, transformation, and validation to ensure accuracy and consistency.
Analyze security incidents, operational statistics, and historical trends to support decision-making.
Collaborate with business analysts, data engineers, security teams, and management to gather reporting requirements.
Translate business requirements into dashboards, reports, and analytical solutions.
Identify opportunities to improve data processes, reporting efficiency, and system performance.
Maintain documentation for data models, reporting specifications, and standard operating procedures.
Ensure data confidentiality, security, and compliance with applicable policies.
Present analytical findings and recommendations to technical and non-technical stakeholders.

Nice-to-haves

Microsoft Certified: Power BI Data Analyst Associate (PL-300).
Previous experience working with MTA or NJ Transit .
Experience in transportation, railroads, public transit, or public-sector environments.
Experience analyzing security incidents, crime statistics, or fare evasion data.
Familiarity with cloud-based data sources and relational database integration.
Experience supporting operational reporting and executive dashboards.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpython

Platform: jobdiva
Effort: medium