Business Intelligence Developer

Basic Functions

• 6-8 Years of experience in enterprise application design, development & support.
• Handling high volume SQL warehouse, Extensive knowledge on MS SQL, SSIS and Visual Report
• Experienced in designing and building data warehouses/marts using Microsoft SQL.
• Proficient in developing engaging and insightful visual dashboards with Power BI.
• Possesses a strong understanding of data modelling and visualization principles.
• Design, develop, and maintain enterprise BI reports, visualizations, and dashboards in Power BI
• Work with the report team to design and implement a reporting user experience that is consistent and intuitive across environments and across report methods.
• Must have at least 1+ years of experience working on Azure Cloud Services such as Azure SQL, Data Factory and Data Bricks nice to have Synapse.
• Produce scalable and flexible, high-quality code that satisfies both functional and non-functional requirements.
• Develop, deploy, test and maintain technical assets in a highly secure and integrated enterprise computing environment & Support functional testing.
• Identify business reporting and analytic needs by collaborating with end users, stakeholders, and technology teams.
• Provide report testing support and execute report and analytics unit testing.
• Document report design and test case documentation as well as assist with end user documentation.
• Cross train & mentor team members for complete knowledge of technologies.
• Analyze and translate business requirements to technical design with security and data protection settings.
• Collaborate/communicate with on-site project team and business users as required.
• Work with development teams and product managers to ideate software solutions.
• Own all projects deliverables and ensure proper communication between teams and quality levels; responsible for end to end solution delivery
• Comprehend the fundamental solution being developed/deployed – its business value, blueprint, how it fits with the overall architecture, risks, and more.
• Would be required to provide inputs on solution and design effort to build scalable features /functionality.

Required Skills –

• SQL Server 2008 & above: SQL, Stored procedures, functions
• Power BI Reports and Self-Service Power BI Reports building
• ETL Data Load, SSIS
• Azure SQL, Azure Data Factory, Data Bricks
• Good to have experience on cloud Azure synapse and Python.

Skills Nice to Have

• Programming Languages: Python, PySparK
• Data Analysis Tools – (Online analytical processing (OLAP), ETL frameworks) &
• Azure Synapse
• Enterprise business intelligence platform (Tableau)
• Expertise in US Healthcare Insurance.
• Part of any open-source contributions
• Certifications in Agile & Waterfall Methodologies
• Certifications in Azure

Business Domain -

Soft Skills

• Good analytical skills.
• Strong communication skills - oral and verbal
• Ability to work with various stakeholders across various geography.
• Excellent Team player, with the ability to build & sustain teams
• Should be able to function as an Individual Contributor as well if required.
• Mentor people and create a high performing organization (foster relationships, resolve conflicts and so on while delivering performance feedback

Working Hours

General Shift – 12 PM to 9 PM

Will be required to extend as per project release needs