Sr. Business intelligence developer (Tableau and quicksight)

Accord Technologies Inc; Piscataway Township (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

A technology consulting firm is seeking a Mid-Senior level Business Intelligence Developer. The role involves extracting, transforming, and analyzing data using SQL and Amazon Redshift. Candidates should have strong analytical skills and experience with Data APIs. This is a contract position based in Piscataway, NJ, and offers opportunity to work onsite.

Qualifications

• Proven experience with SQL, including complex queries and performance tuning.
• Hands-on experience with Amazon Redshift or similar cloud data warehousing solutions.
• Strong analytical skills with the ability to interpret large datasets.

Responsibilities

• Develop, optimize, and maintain SQL queries and scripts for data extraction.
• Design and manage data models in Amazon Redshift.
• Perform complex data analysis to identify trends and insights.

Skills

SQL expertise

Data analysis

Experience with Amazon Redshift

Data API familiarity

Analytical skills

Education

Bachelor's degree in Data Science, Computer Science, Statistics, or related field

Tools

Tableau

Power BI

Looker

Job description

Sr. Business Intelligence Developer (Tableau and QuickSight)

Overview

• Location: Piscataway, NJ (Onsite from day one)
• Duration: 6-12 months
• Employment type: W2 contract

Job Summary

We are seeking a skilled Data Analyst with strong expertise in SQL, data analysis, and experience working with Amazon Redshift. The ideal candidate will be responsible for extracting, transforming, and analyzing large datasets, building data pipelines, and providing actionable insights. Familiarity with Data APIs to facilitate data access and integration is also essential.

Key Responsibilities

• Develop, optimize, and maintain SQL queries and scripts for data extraction, transformation, and analysis.
• Design and manage data models and schemas in Amazon Redshift to support reporting and analytics needs.
• Perform complex data analysis to identify trends, patterns, and insights that inform business decisions.
• Build and maintain data pipelines, including integration with Data APIs to access external or internal data sources.
• Collaborate with cross-functional teams to understand data requirements and deliver relevant datasets and dashboards.
• Create reports, dashboards, and visualizations to communicate findings effectively.
• Monitor and troubleshoot data pipeline issues, ensuring data accuracy and integrity.
• Document data processes, schemas, and analytics methodologies.

Qualifications

• Proven experience with SQL, including complex queries, stored procedures, and performance tuning.
• Hands-on experience with Amazon Redshift or similar cloud data warehousing solutions.
• Strong analytical skills with the ability to interpret large datasets.
• Familiarity with Data APIs (RESTful APIs, GraphQL, or similar) for data access and ingestion.
• Knowledge of ETL/ELT processes and data pipeline orchestration tools.
• Experience with data visualization tools (Tableau, Power BI, Looker, etc.) is a plus.
• Excellent problem-solving and communication skills.
• Bachelor's degree in Data Science, Computer Science, Statistics, or a related field preferred.

Preferred Skills

• Programming knowledge in Python, R, or similar languages.
• Experience with AWS services beyond Redshift (e.g., Lambda, S3, Glue).
• Understanding of data security and privacy best practices.

Seniority level

• Mid-Senior level

Employment type

• Contract (W2)

Job function

• Information Technology