Data Analyst - SQL, Python & BI Dashboards (Onsite)

Pyramid Consulting; Baltimore (MD); On-site; USD 55,000 - 62,000; Full time

Job summary

Pyramid Consulting, Inc. is seeking an experienced Data Analyst for a 6-month contract, onsite in New York NY or Baltimore MD. The role involves building and maintaining reports, writing SQL and Python code, and developing ETL workflows.

Dashboards will be created in Tableau or Power BI to support sales, operations and finance teams. Applicants should have a bachelor’s degree in a related field and 2+ years of data analytics experience.

Qualifications

• Bachelor’s degree or equivalent experience required.
• 2+ years of data analytics, BI, data operations or reporting.
• Strong SQL and Python skills.
• Experience with ETL, data transformation, data validation and cloud data environments.
• Experience creating dashboards in Tableau or Power BI.

Responsibilities

• Build, maintain and improve recurring and ad-hoc reporting.
• Write SQL and Python for data extraction, transformation and validation.
• Develop and support ETL workflows, pipelines and scheduled processes.
• Create dashboards and visualizations using Tableau or Power BI.
• Monitor data quality and fix issues in production workflows.
• Gather requirements and support testing, releases and user adoption.

Skills

Python

SQL

Snowflake

Education

Bachelor’s degree in analytics, computer science, information systems, engineering, finance, economics or a related field

Tools

Tableau

Power BI

Databricks

Git

APIs

Workflow tools

Job description

Pyramid Consulting, Inc. is seeking an experienced Data Analyst for a 6-month contract, onsite in New York NY or Baltimore MD. The role involves building and maintaining reports, writing SQL and Python code, and developing ETL workflows.

Dashboards will be created in Tableau or Power BI to support sales, operations and finance teams. Applicants should have a bachelor’s degree in a related field and 2+ years of data analytics experience.