JOB DESCRIPTION : 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, functionsPower BI Reports and Self-Service Power BI Reports buildingETL Data Load, SSISAzure SQL, Azure Data Factory, Data BricksGood to have experience on cloud Azure synapse and Python.Skills Nice to Have
Programming Languages : Python, PySparKData Analysis Tools – (Online analytical processing (OLAP), ETL frameworks) &Azure SynapseEnterprise business intelligence platform (Tableau)Expertise in US Healthcare Insurance.Part of any open-source contributionsCertifications in Agile & Waterfall MethodologiesCertifications in AzureBusiness Domain - US Healthcare Insurance & Payer Analytics
Soft Skills
Good analytical skills.Strong communication skills - oral and verbalAbility to work with various stakeholders across various geography.Excellent Team player, with the ability to build & sustain teamsShould 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 feedbackWorking Hours
General Shift – 12 PM to 9 PM
Will be required to extend as per project release needs