Senior Data Analyst: Python, ETL & Dashboards

DataAnalystJobs; Village of Menands (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

Diverse Agile Solutions seeks a Data Analyst Level 3 to support COVID-19 dashboards and data distribution for large-scale analytics programs. The role requires strong Python, ETL, cloud, and data visualization skills and experience with relational and NoSQL databases.

You will collaborate with engineers, analysts, and managers to research designs, develop programming solutions, test and validate data, and ensure quality across complex datasets and workflows.

Qualifications

• Bachelor's degree or higher in a related field
• 6+ years of experience on medium- to large-scale technical projects
• 6+ years of experience with data analytics including data processing, transformation, reporting, visualization, and analysis
• Experience ensuring deliverables and scope are documented
• Must be legally authorized to work in the United States

Responsibilities

• Perform data analysis and management supporting COVID-19 dashboards and data distribution initiatives
• Prepare, process, transform, analyze, and report on large and complex datasets
• Support the development and maintenance of data processing and ETL pipelines
• Research, analyze, and document technical requirements and solution designs
• Develop programming solutions to support data analytics and management requirements
• Write and execute unit test plans to validate data processing and application functionality
• Research, troubleshoot, resolve, and test software and data-related defects
• Develop and maintain data transformation and processing workflows
• Support data visualization initiatives involving large datasets
• Develop reports, dashboards, and analytical products for stakeholders
• Provide customer technical support and assist with troubleshooting data-related issues
• Work collaboratively with other developers, analysts, engineers, project managers, and stakeholders
• Ensure technical deliverables are properly documented and meet project requirements
• Support cloud-native and hybrid data applications and solutions
• Work with relational and NoSQL databases containing large volumes of data
• Assist with data quality, validation, and integrity activities
• Participate in technical discussions, design reviews, testing, and implementation activities
• Perform other related duties as assigned

Skills

Python

Data analytics

Data processing

Data transformation

ETL

Data modeling

Education

Bachelor's degree or higher in Data Engineering, Computer Science, MIS, Information Technology, or a related field

Tools

Oracle

PostgreSQL

MongoDB

DynamoDB

Tableau

Job description

Diverse Agile Solutions seeks a Data Analyst Level 3 to support COVID-19 dashboards and data distribution for large-scale analytics programs. The role requires strong Python, ETL, cloud, and data visualization skills and experience with relational and NoSQL databases.

You will collaborate with engineers, analysts, and managers to research designs, develop programming solutions, test and validate data, and ensure quality across complex datasets and workflows.