Senior Power Bi Developer

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