Database Analytics & Reporting Developer

IBA InfoTech Inc.
Middletown, CT, United States
about 2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours

Tech stack

Business Process Modeling Spreadsheets Databases Extract Transform Load (ETL) Data Retrieval Data Visualization Data Warehousing Database Analysis Relational Databases IT Management Microsoft SQL Server Online Analytical Processing
+8 more
Software Engineering SQL Databases SQL Server Reporting Services SQL Server Integration Services Tableau (Software) Information Technology Data Management Tools for Reporting

Job description

In conjunction with IT Management, data owners and business units, develop models, procedures, and protocols in concert with company goals.

Meet with decision makers, systems owners, business analysts and end users to define requirements and goals.

Work with application development staff to coordinate the creation and management of dashboard, scorecard, reporting and analysis presentation, structures and data.

Work with process owners and the data team to prioritize requests.

Design data visualizations and determine the best way to present data to end users using drilldowns, tables, gauges, graphs, charts and other intuitive graphical add-ons

Prepare and deliver reports, analytics and interactive intelligence in systems across the organization.

Develop expertise in specifically assigned subject areas of the warehouse.

Develop and maintain ETL and data warehousing processes and measures in assigned areas of subject expertise.

Advise managers and stakeholders regarding appropriate, effective, and efficient use of organizational data capabilities and functions.

Liaise with various business groups in the organization to facilitate implementation of improved business intelligence and reporting processes.

Coordinate post-implementation support, including end-user reviews, for modified and new data visualizations.

Requirements

Bachelor’s degree in the field of computer science, information management systems or a related field (or equivalent work experience)

Minimum 3 years related work experience.

Proven experience with report writing, dashboard development, data visualization techniques supported by technical requirements analysis, business process modeling/mapping, and data modeling.

Proven experience with reporting tools, dashboards, scorecards, and related software and other applications.

Considerable exposure to the operation and analysis of Microsoft SQL Server relational and OLAP database software and standards, as well as data retrieval methodologies.

Experience writing complicated yet efficient SQL for a relational database such as Microsoft SQL Server is essential.

Working knowledge of MDX is desirable.

Experience with SSIS, SSRS, and Tableau preferred.

Extensive practical knowledge in importing data for use in report software, spreadsheets, graphs, and flowcharts.

Able to exercise independent judgment and take action on it.

Excellent analytical, mathematical, and creative problem-solving skills.

Excellent listening, interpersonal, written, and oral communication skills.

Demonstrated ability to be logical and efficient, with keen attention to detail.

Highly self-motivated and directed.

Ability to effectively prioritize and execute tasks while under pressure.

Strong customer service orientation.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on ibainfotech.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:32 min

Recognizing the persistence and utility of spreadsheet applications

John Bettiol · WWC 2022

1:53 min

Managing infrastructure limitations with managed Amazon Aurora databases

Dharin Shah Dharin Shah · WWC 2025

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

Videos

See all

Related articles

See all