IT System Analyst – Report Automation, Data Integration

Jobtailor; Columbia (MD); On-site; USD 70,000 - 100,000; Full time

Job summary

Jobtailor is seeking a hands-on analyst-developer to support systems analysis, report automation, and data integration initiatives. You will work with PostgreSQL, Python, Java, and Tableau to deliver data-driven reporting and user-facing interfaces.

The role focuses on translating business requirements into technical solutions, supporting modernization efforts, and ensuring data quality across multiple sources. A Bachelor's degree and 1+ year of experience are expected.

Qualifications

• Bachelor's degree in IT, CS, Engineering, or related field.
• 1+ year of systems analysis experience.
• Hands-on Python, Java, SQL, Tableau, React or Angular experience.
• PostgreSQL data modeling, SQL querying, performance tuning, migrations.
• Experience with report automation and data-driven reporting.

Responsibilities

• Analyze stakeholder, business, reporting, and technical requirements.
• Translate reporting requirements into technical solutions.
• Support IT systems analysis and modernization.
• Design, develop, and support report-automation solutions.
• Develop Tableau dashboards, reports, and visualizations.
• Develop and maintain data transformation, cleansing, and validation processes.
• Integrate data from multiple systems and sources.
• Coordinate with technical teams, users, and stakeholders.

Skills

SQL

Java

Data Transformation

Data Cleansing

Data Validation

Workflow Analysis

Technical Documentation

User-Facing Apps

Data Integration

Agile

Education

Bachelor's degree in Information Technology

Tools

Tableau

React

Angular

Automated Data Collection

Metadata Management

Job description

• • Analyze stakeholder, business, reporting, and technical requirements
• • Translate reporting requirements into technical solutions
• • Support IT systems analysis and modernization
• • Design, develop, and support report-automation solutions
• • Support data-driven reporting environments
• • Develop and support data-processing and transformation workflows
• • Query and manage PostgreSQL databases
• • Develop Tableau dashboards, reports, and visualizations
• • Support database and data-management initiatives
• • Integrate data from multiple systems and sources
• • Develop and support user-facing applications and interfaces
• • Support automated data collection
• • Develop and maintain data transformation, cleansing, and validation processes
• • Support scheduled and real-time reporting
• • Implement and maintain data-quality controls
• • Maintain metadata and data dictionaries
• • Support data accessibility
• • Conduct requirements elicitation and documentation
• • Perform workflow and process analysis
• • Identify opportunities for process improvement and automation
• • Participate in testing and validation
• • Support solution implementation
• • Troubleshoot application, reporting, and data-related issues
• • Develop technical documentation and SOPs
• • Coordinate with technical teams, users, and stakeholders
• • Serve as a hands-on analyst-developer supporting systems analysis, requirements development, report automation, data integration, database/data-management activities, testing, technical documentation, and user-facing applications

Requirements

• Bachelor's degree in Information Technology, Computer Science, Engineering, or related field
• Minimum 1 year of systems analysis experience
• Hands-on experience with Python
• Hands-on experience with Java
• Hands-on experience with SQL
• Hands-on experience with Tableau
• Hands-on experience with React, Angular, or a similar modern web-interface technology
• Hands-on PostgreSQL experience, including data modeling, SQL querying, performance tuning, and database migration
• Experience with IT systems analysis and/or modernization
• Experience with report automation and data-driven reporting
• Experience with database or data-management initiatives
• Experience with requirements and workflow analysis
• Experience with technical and/or SOP documentation
• Strong communication and analytical problem-solving skills
• U.S. citizenship is required
• DHS security/background processing must be completed before work begins
• DHS security/privacy requirements apply
• Strong organizational and communication skills
• Ability to manage multiple tasks and prioritize workload based on client needs
• Ability to deal with ambiguity and frequent changes in priorities
• Ability to work with minimal supervision
• Excellent technical writing skills and proven experience in systems with complex requirements
• Excellent teamwork and interpersonal skills
• Understanding of the system development lifecycle as implemented with Agile
• Prolonged periods of sitting at a desk and working on a computer
• Ability to navigate in an office setting unassisted
• Ability to lift up to 10 pounds
• Strong speaking skills, including the ability to articulate thoughts clearly and excellent word enunciation skills

Core Competencies

Demonstrates expertise in systems analysis, report automation, and data integration, with proficiency in PostgreSQL, Python, Java, and Tableau. Capable of translating business requirements into technical solutions while ensuring data quality and accessibility.

Highest-signal resume keywords

• PostgreSQL Database Management
• Python Programming
• Tableau Dashboard Development
• Systems Analysis Experience
• Report Automation

ATS Optimization Keywords

Hard Skills

• SQL
• Java
• Data Transformation
• Data Cleansing
• Data Validation
• Workflow Analysis
• Technical Documentation
• User-Facing Application Development
• Data Integration
• Agile Methodology

Soft Skills

• Analytical Problem-Solving
• Strong Communication
• Organizational Skills
• Teamwork
• Interpersonal Skills

Industry Keywords

• Data-Driven Reporting
• IT Systems Modernization
• Requirements Elicitation
• DHS Security Requirements
• Data Management Initiatives

Tools & Technologies

• Tableau
• React
• Angular
• Automated Data Collection
• Metadata Management