Bi Report Developer

Acesoft Labs; Bengaluru; Hybrid; INR 900,000 - 1,800,000; Full time

Job summary

Acesoft Labs in Bengaluru seeks a Data Insights Analyst specializing in dashboard development, data validation, and ETL testing using Tableau, Cognos, and SQL. 3-6 years of experience is expected in delivering data-driven insights and reliable analytics products.

The role emphasizes cross-functional collaboration, data quality assurance, and hands-on SQL-based data preparation for dashboards and reports, with a focus on IBM Cognos tooling and Tableau visualizations.

Qualifications

• 3-6 years of experience in data insights/BI
• Experience validating data and performing ETL testing
• Strong SQL and dashboard development skills

Responsibilities

• Develop, maintain, and enhance dashboards and static reports using Tableau and IBM Cognos.
• Collaborate with Senior Data Insights specialists to design solutions that meet customer needs.
• Utilize data from modeled Business Data sources, Structured DB2 Datamarts, and DB2 Operational Data stores to fulfill business requirements.
• Conduct internal analytics testing on all data products to ensure accuracy and reliability.
• Use SQL to pull and prepare data for use in Dashboards and Reports.
• Test new ETL developments, break-fixes, and enhancements using SQL-based tools to ensure the accuracy, volume, and quality of ETL changes.
• Participate in data projects, delivering larger-scale data solutions as part of a project team.
• Report defects using Jira and work closely with IT team professionals to ensure the timely retesting of data defects.
• Utilize Spec. Documentation and Data lineage tools to understand flow of data into Analytics Data sources.
• Develop repeatable testing processes using SQL based tools

Skills

SQL

Data Visualization

Report Design

Cognos Analytics

Cognos Transformer

OLAP Modeling (Cognos)

Python

SAS Programming

MS Excel

MS Access

Tools

Tableau

IBM Cognos

Cognos Transformer

OLAP Modeling (Cognos)

DB2 Datamarts

DB2 Operational Data Stores

Job description

Role & responsibilities

Description: Job Description Reports Developer

Description - Data Insights Analyst specializing in dashboard development, data validation, and ETL testing using Tableau, Cognos, and SQL.

Work Experience: 3-6 years

Key Responsibilities

Insights Solution Development:

• Develop, maintain, and enhance dashboards and static reports using Tableau and IBM Cognos.

• Collaborate with Senior Data Insights specialists to design solutions that meet customer needs.

• Utilize data from modeled Business Data sources, Structured DB2 Datamarts, and DB2 Operational Data stores to fulfill business requirements.

• Conduct internal analytics testing on all data products to ensure accuracy and reliability.

• Use SQL to pull and prepare data for use in Dashboards and Reports

Data Management Tasks:

• Test new ETL developments, break-fixes, and enhancements using SQL-based tools to ensure the accuracy, volume, and quality of ETL changes.

• Participate in data projects, delivering larger-scale data solutions as part of a project team.

• Report defects using Jira and work closely with IT team professionals to ensure the timely retesting of data defects

• Utilize Spec. Documentation and Data lineage tools to understand flow of data into Analytics Data sources

• Develop repeatable testing processes using SQL based tools

Technical Experience

• SQL

• Tableau

• Data Visualization

• Report Design

• Cognos Analytics

• Cognos Transformer

• OLAP Modeling (Cognos)

Additional Skills

An Ideal Candidate would have the following additional Skills

• Python

• SAS Programming

• MS Access

• MS Excel

Work Hours: We would like to have the majority of the work hours align to U.S. Eastern time zone with people working until 5 p.m. est. so that work hours align to times the Senior Analysts are available and Data Bases are available.Enable Skills-Based Hiring No