Reporting & Analytics Specialist (Tableau/SQL) - 427682

Siri InfoSolutions Inc; Mountain Lakes (NJ); On-site; USD 90,000 - 125,000; Full time

Job summary

Siri InfoSolutions Inc is seeking a hands-on Reporting & Analytics Specialist to design, build, and automate reporting that provides trusted visibility into data. You will connect data from multiple sources, normalize and transform it via scripted pipelines, and deliver polished dashboards for technical and executive stakeholders.

You will design and optimize SQL queries, build consolidated datasets, and partner with stakeholders to translate requirements into scalable reporting products and

Qualifications

• Strong SQL skills with complex joins, aggregations, and window functions.
• Hands-on experience building dashboards in Tableau and Power BI.
• Experience aggregating data from multiple sources into reporting datasets.
• Script-based data normalization and transformation (Python or similar).
• Solid data visualization principles and dashboard design best practices.
• Translate business questions into reporting requirements with stakeholders.
• Strong attention to detail and data accuracy.
• Familiarity with CMDB concepts and ServiceNow CMDB data structures.
• Exposure to Databricks, Tableau APIs, or other automation frameworks.

Responsibilities

• Design, develop, and maintain reports and dashboards in Tableau and Power BI for operational and executive audiences.
• Write and optimize complex SQL queries for data extraction, aggregation, and performance.
• Connect and integrate multiple data sources into unified reporting datasets.
• Build scripted data normalization and transformation pipelines (e.g., Python).
• Aggregate data across domains to produce consistent metrics and KPIs.
• Apply data visualization best practices for clear storytelling and drill-down paths.
• Collaborate with business and technology stakeholders to gather requirements.
• Automate recurring reporting processes to improve speed and scale.

Skills

SQL

Dashboard design

Data visualization

Stakeholder collaboration

Data accuracy

Tools

Tableau

Power BI

Python

Databricks

ServiceNow CMDB

Job description

Reporting & Analytics Specialist (Tableau/SQL)

Must Have Technical/Functional Skills

• Strong SQL skills - complex joins, aggregations, window functions, query optimization.
• Proven hands-on experience building dashboards in Tableau and Power BI.
• Experience aggregating data and connecting multiple data sources into consolidated reporting datasets.
• Experience with script-based data normalization and transformation (Python or similar).
• Solid understanding of data visualization principles and dashboard design best practices.
• Ability to work with stakeholders to translate business questions into reporting requirements.
• Strong attention to detail and commitment to data accuracy.
• CMDB knowledge - familiarity with configuration management databases (e.g., ServiceNow CMDB), CI classes, relationships, and asset/configuration data structures.
• Exposure to Databricks, Tableau APIs, or other reporting automation frameworks.
• Familiarity with IT infrastructure concepts (servers, network devices, discovery tools).
• Experience in enterprise IT, telecom, or cybersecurity-adjacent environments.
• Experience with ServiceNow reporting, Performance Analytics, or asset management data.

Roles & Responsibilities

About the Role

We are looking for a hands-on Reporting & Analytics Specialist to design, build, and automate reporting solutions that give the organization trusted, actionable visibility into its data. You will connect and integrate data from multiple sources, normalize and transform it through scripted pipelines, and deliver polished dashboards and reports that drive decision-making for technical and executive stakeholders alike.

Key Responsibilities

• Design, develop, and maintain reports and dashboards in Tableau and Power BI for operational and executive audiences.
• Write and optimize complex SQL queries for data extraction, aggregation, joins across large datasets, and performance tuning.
• Connect and integrate multiple data sources (databases, APIs, flat files, enterprise platforms) into unified reporting datasets.
• Build and maintain scripted data normalization and transformation pipelines (e.g., Python) to standardize, cleanse, and reconcile data from disparate systems.
• Aggregate data across domains to produce consistent, reliable metrics and KPIs.
• Apply data visualization best practices to make complex data intuitive - right cha rt for the right story, clean layouts, drill-down paths.
• Partner with business and technology stakeholders to gather reporting requirements and translate them into scalable reporting products.
• Automate recurring manual reporting processes to improve speed, consistency, and scalability.
• Validate data quality and investigate discrepancies across source systems; document data lineage and reporting logic.