20 Oct
|
WebSenor InfoTech
|
Noida
20 Oct
WebSenor InfoTech
Noida
Job Title : Reporting Engineer (Power BI) Experience : 5-8 Years Employment Type : Full-Time Location : Hybrid Department : Data Analytics & Business Intelligence
Role Summary
Key ResponsibilitiesPower BI Development
- Design, develop, and maintain interactive Power BI dashboards and reports.
- Build business-critical Power BI Paginated Reports and operational dashboards.
- Develop reusable datasets, semantic models, and report templates.
- Create intuitive visualizations and KPIs to support business decision-making.
- Implement row-level security (RLS) and role-based access controls.
Report Development & Analytics
- Gather and analyze reporting requirements from business stakeholders.
- Translate business requirements into scalable reporting solutions.
- Develop reports supporting finance, operations, sales, and executive leadership.
- Ensure report accuracy through data validation and quality checks.
- Automate recurring reports and reporting workflows.
Database Development
- Develop and optimize complex SQL queries, stored procedures, views, and functions using T-SQL .
- Design efficient data retrieval strategies for reporting.
- Perform SQL query optimization and performance tuning.
- Troubleshoot database and reporting performance issues.
- Ensure data consistency and integrity across reporting environments.
Data Integration
- Work with data from multiple enterprise systems including:
- SQL Server
- Snowflake
- Databricks
- Collaborate with Data Engineering teams to consume curated datasets.
- Validate data transformations and reporting accuracy.
- Support integration of structured and semi-structured data sources.
Data Warehousing
- Understand enterprise data warehouse architecture.
- Develop reporting solutions using dimensional models (Star and Snowflake Schemas).
- Work with fact and dimension tables.
- Support data modeling for reporting and analytics.
Cloud Analytics
- Build reporting solutions using cloud-based data platforms.
- Work with Snowflake and Databricks for analytics and reporting.
- Support cloud data modernization initiatives.
- Optimize report performance for cloud-based datasets.
Performance Optimization
- Optimize Power BI reports for faster performance and scalability.
- Tune SQL queries and datasets for improved report responsiveness.
- Implement efficient data refresh strategies.
- Reduce report rendering times for large datasets.
Data Governance & Security
- Implement data security best practices.
- Maintain compliance with enterprise data governance policies.
- Ensure secure access to sensitive business data.
- Support audit and compliance requirements for reporting platforms.
Collaboration
- Work closely with:
- Business Analysts
- Product Owners
- Data Engineers
- Database Administrators
- Analytics Teams
- Business Stakeholders
- Participate in Agile ceremonies including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives.
- Prepare technical documentation for reports, datasets, and reporting solutions.
Required Technical SkillsBusiness Intelligence
- Microsoft Power BI
- Power BI Dashboards
- Power BI Paginated Reports
- Power BI Service
- Power Query
- DAX
- Data Visualization
- Report Development
- KPI Dashboard Design
Database Technologies
- SQL Server
- T-SQL
- Stored Procedures
- Views
- Functions
- Query Optimization
- Performance Tuning
Cloud Data Platforms
- Snowflake
- Databricks
- Cloud Data Warehousing
Data Warehousing
- Star Schema
- Snowflake Schema
- Fact & Dimension Tables
- Data Modeling
- Data Validation
Data Integration
- ETL/ELT Concepts
- Data Transformation
- Data Mapping
- Data Validation
- Data Quality
Reporting & Analytics
- Business Intelligence
- Dashboard Design
- Report Automation
- Data Analysis
- Data Visualization Best Practices
Required Qualifications
- Bachelor's degree in Computer Science, Information Technology, Data Analytics, Engineering, or a related field.
- Minimum 5+ years of experience as a Reporting Engineer, Power BI Developer, or Business Intelligence Developer.
- Solid hands-on experience building enterprise Power BI dashboards and Paginated Reports.
- Advanced experience with SQL Server and T-SQL development.
- Experience working with Snowflake and Databricks.
- Strong analytical, troubleshooting, and problem-solving skills.
- Experience working in Agile development environments.
Preferred Qualifications
- Experience with cloud data modernization and migration projects.
- Strong understanding of enterprise data warehousing concepts.
- Experience with ETL/ELT tools and data integration processes.
- Hands-on experience optimizing SQL queries and report performance.
- Knowledge of data governance, security, and compliance in cloud environments.
- Familiarity with Azure Data Factory, Microsoft Fabric, or Azure Synapse Analytics is an advantage.
Soft Skills
- Excellent analytical and problem-solving abilities.
- Strong verbal and written communication skills.
- Abili
📌 Reporting Engineer (Power Bi) (Noida)
🏢 WebSenor InfoTech
📍 Noida