Junior Data Analyst

Jobtailor; Town of Florida (NY); On-site; USD 65,000 - 90,000; Full time

Job summary

Jobtailor in New York is seeking a data analytics professional to write SQL queries, automate reporting in Python, and build dashboards in Power BI. You will work with data from Snowflake, Excel, CSV, JSON, and REST APIs, collaborating with senior analysts to ensure accuracy across operational, clinical, and financial datasets.

Ideal candidates have 1–3 years in data analytics, strong SQL, Python, and BI tool experience, plus familiarity with cloud data platforms and Git.

Qualifications

• 1–3 years of experience in data analytics, BI, or related field.
• Strong foundational SQL skills (joins, aggregations, filtering, transformations).
• Working knowledge of Python for data analysis or automation.
• Experience with Power BI, Tableau, or comparable BI tool.
• Strong Excel skills.
• Understanding of relational databases and basic data modeling concepts.
• Experience with Snowflake or another cloud data platform preferred.
• Experience with REST APIs, JSON, or automated data processes preferred.
• Familiarity with Git or source-control tools preferred.

Responsibilities

• Write SQL queries to extract, combine, and analyze data from multiple systems.
• Use Python to automate reporting, data validation, file processing, and repetitive tasks.
• Build and maintain reports and dashboards using Power BI and other reporting tools.
• Analyze operational, clinical, and financial data to support decision making.
• Support recurring reporting and ad hoc data requests.
• Clean, validate, and reconcile data to ensure reporting accuracy.

Skills

SQL

Python

Power BI

Excel

Data Analysis

Education

Bachelor’s degree in data analytics or related field

Tools

Snowflake

Tableau

Microsoft Azure

Git

Job description

• Write SQL queries to extract, combine, and analyze data from multiple systems
• Use Python to automate reporting, data validation, file processing, and repetitive tasks
• Build and maintain reports and dashboards using Power BI and other reporting tools
• Assist with analyzing operational, clinical, and financial data
• Support recurring reporting and ad hoc data requests
• Clean, validate, and reconcile data to ensure reporting accuracy
• Work with data from SQL databases, Snowflake, Excel, CSV, JSON, and APIs
• Investigate discrepancies between reports and source systems
• Support development of automated data pipelines and reporting processes
• Work with senior analysts and business leaders to understand reporting and analytics needs
• Document queries, reports, and automated processes
• Identify opportunities to simplify manual processes through data and automation

Requirements

• 1–3 years of experience in data analytics, business intelligence, reporting, or a related field
• Strong foundational SQL skills, including joins, aggregations, filtering, and data transformation
• Working knowledge of Python for data analysis or automation
• Experience with Power BI, Tableau, or a comparable BI tool
• Strong Excel skills
• Understanding of relational databases and basic data modeling concepts
• Strong analytical and problem-solving skills
• Ability to organize work, troubleshoot issues, and meet deadlines
• Strong attention to detail and data accuracy
• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Business Analytics, or a related field; equivalent experience will also be considered
• Experience with Snowflake or another cloud data platform preferred
• Experience working with REST APIs, JSON, or automated data processes preferred
• Familiarity with Git or source-control tools preferred
• Healthcare or home health experience preferred
• Familiarity with Microsoft Azure preferred
• Exposure to healthcare operational, clinical, or financial data preferred

Core Competencies

Proficient in SQL for data extraction and analysis, with strong skills in Python for automation and reporting. Experienced in building reports and dashboards using Power BI, with a solid understanding of data validation and reconciliation processes.

Highest-signal resume keywords

• SQL Query Writing
• Python Automation
• Power BI Reporting
• Data Validation
• Data Analysis

ATS Optimization Keywords

Hard Skills

• SQL
• Python
• Data Analysis
• Data Validation
• Data Reconciliation
• Reporting
• Data Modeling
• Excel
• REST APIs
• JSON

Soft Skills

• Analytical Skills
• Problem-Solving
• Attention to Detail
• Organizational Skills
• Time Management

Industry Keywords

• Healthcare Data
• Business Intelligence
• Operational Data
• Clinical Data
• Financial Data

Tools & Technologies

• Power BI
• Tableau
• Snowflake
• Microsoft Azure
• Git