Job Description for BI Stack (Data Engineer and PBI developer)
Job Description
1. 4+ years’ experience in MS Data Lake and Reporting stack on Power BI, ADF, Data Model and Data bricks. Should be a hands-on professional with thorough knowledge of scripting, data source integration and visual development in Power BI. Any exposure to SAP domains is a plus
2. A deep understanding of data model, and ability to use and explain all aspects of, relational database design, multidimensional database design, OLTP, OLAP, KPIs, Scorecards, and Dashboards
3. Very good understanding of Data Modelling Techniques for Analytical Data (ie Facts, Dimensions, Measures)
4. Good understanding on the processes of data quality, data cleansing and data transformation
5. Connect to multiple datasets to bring all the relevant data together in one place and create reports that provide a consolidated view of the different sources.
6. Assemble large, complex data sets that meet functional / non-functional business requirements
7. Takeover the technical code from vendor/existing team and can support the software for any new changes or requirements.
8. Review UI/UX aspects with designers and provide feedback and feasibility details.
9. Ability and passion to learn new technologies and concepts.
10. Strong analytical problem-solving, and conceptual skills
11. Diagnose and fix bugs and performance bottlenecks for existing applications.
12. Understands and follows project and software development methodologies and processes, including Scrum and agile experience
13. Cultivate and disseminate knowledge of application development best practice
14. Internally motivated, able to work proficiently both independently and in a team environment
15. Manage modules and work assigned at their level smartly.
16. Ability and interest in learning new technologies and implement them for new requirements.
17. Knowledge on Retail and heavy machinery industry is an added advantage.
Technical Skills Required
1. Power BI, Data Bricks, Python, SQL Scripting
2. Good experience in designing and creating mappings, workflows.
3. Proficient in making DAX queries in Power BI desktop
4. Very good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP from design and analysis to implementation including the conceptual, logical, and physical data models
5. Experience with agile backlog tools like Zoho, Jira.
6. Experience and Knowledge in Sql Server and writing stored procedures
