Job Description

Job Purpose:This role is responsible for designing, implementing, testing & delivering BI Reports using reporting technologies including Power BI development using Data Warehouse to replicate source data via Azure SQL Elastic Pool to the desired Power BI reports.Job Responsibilities:Essential Functions:

• Collaborate with Product, other developers and engineers to design, build, and maintain Power BI reporting services.
• Responsible to understand the business needs (existing reports & types - Standards, Scheduled, Transactional).
• Determine operational feasibility by evaluating requirements, analysis, problem definition, solution development and proposed solutions.
• Build Power BI reports for various products (multi-product) based on common data model (common datasets).
• Responsible to define the Dataset for use in Data Warehouse including Data Content (Facts, Dimensions, Measures, Standard Calculations).
• Responsible to Build Development Dataset and Report Wireframes (Define the Galaxy Schema, Build Development Dataset Dummy data exclusively used by PowerBI Dataset, Define Reports and Views, Create Wireframe for Reports and Views)
• Responsible to understand building Datawarehouse (Database Replication, Structured Views to reshape data, Stored Procedures and Azure Data Factory Pipelines to Convert Data Daily Azure Elastic Pool Jobs to schedule tasks and refresh PBI Datasets)
• Responsible to connect Data Warehouse & reporting together (Make adjustments in Dataset as necessary (data type, naming, etc xe2x80xa6), End to End Unit Testing Validate Data and Reports within the BI App, Go / No Go for every visual and data element, Release Planning)
• Document development and operational procedures.
• Engage in Peer-Reviews and validates implementations of self and others to ensure they meet requirements and match the specifications.
• Mentors and supports colleagues and developers work positively.
• Enforces and evolves software development standards and best practices.
• Troubleshoot Reporting Issues.
• Provide on-call support as necessary.

Requirements:Required Education and Experience:

• Bachelors, Masters degree or equivalent combination of education and experience
• At least 5+ years professional experience in all stages of definition, design, implementation, testing, and deployment of BI solutions using Power BI.
• Experience in the following tools/technologies: Power BI, Azure SQL Elastic Pool, SQL Server.
• Experience in running DAX queries and functions in Power BI and developing Power BI Data models.
• Experience in implementing RBAC for Power BI reports.
• Experience in development of Data Warehouse, Operational Data Store, and ETL solutions.
• Strong proficiency in Power Query (M), DAX, and Power BI Service (publishing and sharing reports).
• Solid understanding of data warehousing concepts and SQL databases.
• Experience connecting Power BI to various data sources like SQL Server, Excel, SharePoint, and cloud-based sources.
• Experience with Agile (Scrum) & working closely with Software Development Process and methodologies
• Experience with database management and security a plus
• Experience with source control such as git or Azure DevOps and branching/merging best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.

Required Skills: Power BI Report Development, SQL.Good to Have: ADF, DBA, MongoDB, RedShift, MySQL, Talend, Understanding M/S Synapse, Fabric, Data APIs, ETL, SSIS, Data pipeline, Data Factory. Knowledge of Python or R for data analysis is a plus. Familiarity with other BI tools (Tableau, Qlik) is an advantage.Work Timings :This is a full-time position. Days and hours of work are Monday through Friday, and should be flexible to support different time zones ranging between 12 PM IST to 9PM IST, Work schedule may include evening hours or weekends due to client needs per manager instructions This role will be working in Hybrid Mode and will require at least 2 days work from office at Hyderabad. Occasional evening and weekend work may be expected in case of job-related emergencies or client needs.EEO StatementCendyn provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Cendyn complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.Cendyn expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Cendyns employees to perform their job duties may result in discipline up to and including discharge.Other DutiesPlease note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.