Staff Software Engineer

About the RoleIn this role, you will design highly scalable and high performing technology solutions in an Agile work environment and produce and deliver code and/or test cases using wide-ranging experience, professional concepts, company objectives and Agile practices. You will collaborate closely with key business support teams, product managers, architecture to assist in resolving complex critical cross-team and cross-domain production issues to help simplify and improve business processes through the latest in technology and automation. You are a technical expert and will lead through the requirements gathering, design, development, deployment, and support phases of a product. You will leverage your comprehensive knowledge of domain and core programming technologies or packages to mentor and advise team members.What You'll Do

• Must have Strong knowledge on Power BI, SQL, SSIS, ADF, Cubes and Azure Data Bricks.
• Should have Strong knowledge on Designing technical solutions
• Should have good experience on planning, analyzing, designing, implementing, testing, and maintaining software
• Understands the Current or future systems landscape, Business Requirements and provides technical advice and contribute to technical decision-making 
• Must have strong knowledge on Stored procedures, designing data models and ETL processes using ADF or Azure Data Bricks
• Should have real time work experience on MSBI (SSIS), Azure Data Factory Service (ADF), Data bricks.
• Will be responsible for hands-on design and development on ADF, ADB and SQL server database.
• Should have expert knowledge in writing SQL commands, queries and stored procedures. Ability to improve SQL performance: analyzing SQL joins and table structures.
• Analyze and benchmark reporting and ETL performance; Evaluate and improve existing BI systems.
• Having knowledge on Azure cloud with experience on Azure SQL DB and Azure analysis server is preferred.
• BI development background and coding experience in Azure stack - Migrate to Azure / Work with Azure services
• Understand Agile Best practices and creates tech backlog, story grooming and estimation
• Test programs and systems for bugs and errors, and perform maintenance and troubleshooting tasks
• Candidate should be able to design, build and deploy BI Solutions
• Understand software security best practices, common vulnerabilities, and methods to mitigate them
• Good Communication skills & Capability to work in a distributed team environment with minimal supervision is required

Who You Are

• 8 – 12 years of experience with ETL Processes, Power BI and Cloud technologies in software industry
• CS degree or equivalent experience