Position Overview:
We are looking for an experienced and motivated Software Engineer with a strong background in Microsoft Business Intelligence (MS BI) tools and technologies to join our team. The ideal candidate will have hands-on experience with ETL/ELT frameworks, specifically using MS BI tools (SSIS, SSRS, SSAS) and Power BI, as well as a solid understanding of database concepts and SQL. The candidate should also have experience with DevOps practices, CI/CD pipelines, and working in an Agile environment. Knowledge of version control systems, such as Git, is essential for collaboration and code management.
Key Responsibilities:
- Develop, maintain, and optimize ETL/ELT processes using MS BI tools, particularly SSIS.
- Design and implement reports, dashboards, and analytical solutions using SSRS, SSAS, and Power BI.
- Build, test, and deploy data models, cubes, and interactive reporting solutions for business users.
- Collaborate with business analysts and stakeholders to gather requirements and transform them into scalable data solutions.
- Ensure the quality and integrity of data, ensuring consistency across systems and platforms.
- Utilize DevOps best practices to automate deployment pipelines and integrate them into CI/CD pipelines for continuous delivery.
- Participate in Agile development cycles, contributing to sprint planning, standups, and retrospectives using Scrum and Kanban methodologies.
- Leverage version control systems, particularly Git, for source code management and collaboration.
- Optimize SQL queries and database performance to ensure the efficiency of reports and data processes.
- Provide technical support for data solutions, ensuring they meet business needs and industry standards.
Required Skills & Qualifications:
- Hands-on experience with MS BI tools (SSIS, SSRS, SSAS) and Power BI for data integration, reporting, and analysis.
- Strong understanding of ETL/ELT frameworks and how to implement them effectively in data pipelines.
- Proficiency in SQL and a solid understanding of relational database concepts.
- Experience with DevOps principles, particularly around CI/CD pipeline implementation.
- Working knowledge of Agile methodologies, including experience with Scrum and Kanban.
- Familiarity with version control systems such as Git for managing and collaborating on code.
- Problem-solving skills with a focus on improving performance, data quality, and overall system efficiency.
- Excellent communication skills and the ability to work effectively in a collaborative, cross-functional team.
Preferred Skills & Qualifications:
- Experience with cloud-based data platforms (e.g., Azure Data Services, AWS Redshift).
- Knowledge of advanced data analytics tools and frameworks, such as machine learning models or big data processing tools.
- Familiarity with data governance, security, and compliance standards in a data-driven environment.
- Knowledge of additional BI tools, such as Tableau, or experience with Data Warehousing concepts.
- Experience with data automation or orchestration tools, such as Azure Data Factory.
Experience: 3 to 6 yrs;
Job Location: Hyderabad
Salary: upto 33 Lpa;
Mode of Interview: Virtual
Interview Level: 1 Level
Preferred: PWD (Physical with Disability)
