Country: India
Position Location: Bengaluru
Contract Type: Permanent
Work Pattern: Full Time
Sector: Corporate services
Discipline: Information technology
Job Ref: 2192
Recruiter Contact: Supriya Yadavalli
We are seeking an experienced Power BI Developer who is passionate about designing and developing Power BI reports and dashboards. You must have proficiency in Data Analysis Expressions (DAX).
This role is based within the central IT department of Mott MacDonald and involves working closely with SMEs within the wider IT team.
You will be expected to capture and document the requirements to a high standard, to develop the solution to top quality standards, and to provide support on it once in Production. Longer term, the role will involve working with business analysts and an established team of ETL developers to move the operational data into a data warehouse for long term strategic reporting.
To be successful in this role, you must have the ability to think creatively and should always be seeking new and more efficient ways to improve systems. You must be detail orientated and have the desire to work to a very high standard. You should be able to manage your own time, work to clearly defined targets and be able to communicate clearly and effectively.
Key Duties And Responsibilities Include
- Working with SME(s) to create clear requirements documentation for sign-off.
- Designing Power BI reports based around IT operational data, that are robust, secure and follow clear design principles.
- Build Data Analysis Expressions (DAX) functions (where it makes sense to build these in Power BI rather than in the data model).
- Work with ETL developers to plan the future strategic development of these operational reports, which may involve migrating the data into our data warehouse at a later time.
- Provide expert advice on dashboard/report design and design principles
- Data querying using SQL on different platforms, such as using SQL within Power BI or SSMS
- Carry out peer reviews of other developers work.
- Define and execute test cases as part of developer QA.
- Provide clear complexity estimates during agile scrum sprint planning meetings
- Provide daily progress updates during stand-ups.
- Provide third line support on dashboards/reports, for issues escalated via the Service Desk
Essential
Candidate Specification:
- Proven experience designing, developing, implementing and supporting Microsoft Power BI (Power Query)
- Proficiency in Data Analysis Expressions (DAX) with demonstrable capabilities in this area.
- Skilled in querying data using SQL in Microsoft SQL Server databases.
- Performance Tuning in Power BI
- Data security
- Writing business friendly documentation
Desirable
- University degree (or similar qualification) in the field of Computer Science or Information Systems (Highly desirable)
- Experience writing and executing test cases.
- Azure development experience (Azure Data Factory, Azure SQL server databases)
- Full software development lifecycle experience
Personal Attributes
- Passionate about technology and learning.
- Ability to balance demands and priorities and think clearly under pressure.
- Attention to detail and a focus on quality.
- Excellent conflict resolution, communication, and collaboration skills.
- Logical and analytical approach to solving problems.
We Can Offer (subject To Company's Policy)
- Agile and safe working environment
- Competitive annual leave and sick leaves
- Group incentive scheme
- Group term life insurance, Workmen's compensation and Group medical insurance coverage
- Short and Long-term Global employment opportunities
- Global collaboration and knowledge sharing
- Digital Innovation and Transformation
Equality, diversity and inclusion
We put equality, diversity and inclusion at the heart of our business, seeking to promote fair employment procedures and practices to ensure equal opportunities for all. We encourage individual expression in our workplace and are committed to creating an inclusive environment where everyone feels they have the opportunity to contribute.
Agile working
At Mott MacDonald, we believe it makes business sense for you and your manager to choose how you can work most effectively to meet your client, team and personal commitments. We embrace agility, flexibility and trust.
