BI & Automation Architect
Wood · Gurugram, Haryana, India
- On site
- Full-time
- $120,000 / year
- Gurugram, Haryana, India
Job highlights
- Architect and implement RPA solutions for efficiency.
- Develop interactive BI dashboards and financial reports.
- Promote digitalisation and automation adoption.
- Manage data models, lakes, and warehouses.
- Leverage expertise in Microsoft BI and Power Platform.
About the role
Responsibilities
Automation Experience
- Implement and manage Robotic Process Automation (RPA) solutions to automate repetitive tasks and improve operational efficiency.
- Integrate RPA with existing BI tools to enhance data analysis and reporting capabilities.
- Contribute to initiatives to streamline processes through advanced automation techniques.
Digitalisation and Technology Adoption
- Assist with the promotion of digitalisation and adoption of automation across GFS, wider Finance community and other functions where appropriate e.g. Supply Chain.
- Stay at the forefront of emerging BI trends and technologies, ensuring the organisation remains competitive.
BI Dashboard Reporting and Report Development
- Develop real-time interactive dashboards using Power BI.
- Design and validate comprehensive financial reports to support strategic decision-making.
Standardisation, Simplification, and Data Management
- Work under the guidance of the Line Manager to ensure architectural alignment, standards adherence, and consistent solution delivery
- Support the Manager in continuous improvement by identifying technical enhancement opportunities.
- Define and maintain naming conventions and user-friendly explanations to ensure clarity and consistency.
- Implement and monitor robust controls to ensure data integrity and accuracy.
Advanced Data Analysis and Data Management
- Analyse and interpret complex data to identify trends and provide actionable insights for business stakeholders.
- Demonstrate a thorough understanding of data management concepts, including Data Lakes, Data Warehouses, and Data Marts.
- Apply knowledge of these concepts to optimise data storage, retrieval, and analysis processes.
- Ensure effective integration of data management solutions to support comprehensive business intelligence and reporting needs.
This role requires a deep understanding of BI tools, data analysis, business intelligence solutions, and enterprise automation technologies, including Robotic Process Automation (RPA). The individual should demonstrate the ability to identify, design, and implement automation opportunities that improve data flows, reporting efficiency, and business processes. They must be able to work both independently and collaboratively with a wide range of stakeholders, applying strong analytical and problem-solving skills to complex data and process challenges. A commitment to continuous improvement, automation-led efficiency, and adherence to best practices is essential. Additionally, experience in leading automation-enabled projects, governing automated solutions, and mentoring junior team members in analytics and automation techniques is highly desirable.
Qualifications
Qualifications and Certifications
- Degree educated, preferably in a Finance‑related discipline, due to the need for understanding core financial processes.
- Preferred Certifications: Automation Anywhere Bot Developer Certification, MS Power Platform Developer Associate, MS Fabric Data Engineer Associate, MS Power BI Data Analyst Associate.
- 3–5 years’ proven experience architecting and delivering data analytics and automation solutions within complex, global business environments, underpinned by strong finance domain expertise.
- Automation Anywhere RPA Bot development experience and associated accreditation is desirable.
- Deep expertise across the Microsoft BI and Power Platform stack: Power BI (advanced modelling, DAX, visualisation), Power Automate, Excel (Power Query, Power Pivot), SQL Server Integration Services (SSIS).
- The role requires strong data engineering capabilities within a finance data environment, ideally with hands-on experience of Python and PySpark, along with proven CI/CD practices, to support and scale solutions aligned with the Microsoft Fabric roadmap.
- Strong skills in DAX, SQL and HTML for developing innovative BI solutions and custom visuals.
- Proficient with SharePoint for document and data management.
- Experience with ERP/financial systems and an understanding of finance domain processes.
- Strong knowledge of data modelling, integration patterns, and automation tooling.
Work Experience
Technical Skills
- Automation Anywhere RPA Bot development experience and associated accreditation is desirable.
- Deep expertise across the Microsoft BI and Power Platform stack: Power BI (advanced modelling, DAX, visualisation), Power Automate, Excel (Power Query, Power Pivot), SQL Server Integration Services (SSIS).
- The role requires strong data engineering capabilities within a finance data environment, ideally with hands-on experience of Python and PySpark, along with proven CI/CD practices, to support and scale solutions aligned with the Microsoft Fabric roadmap.
- Strong skills in DAX, SQL and HTML for developing innovative BI solutions and custom visuals.
- Proficient with SharePoint for document and data management.
- Experience with ERP/financial systems and an understanding of finance domain processes.
- Strong knowledge of data modelling, integration patterns, and automation tooling.
- Understanding of data governance concepts and designing solutions that support governance.
About Us
Wood is a global leader in consulting and engineering, helping to unlock solutions to critical challenges in energy and materials markets. We provide consulting, projects and operations solutions in 45 countries, employing around 25,000 people. www.woodplc.com
Diversity Statement
We are an equal opportunity employer that recognises the value of a diverse workforce. All suitably qualified applicants will receive consideration for employment on the basis of objective criteria and without regard to the following (which is a non-exhaustive list): race, colour, age, religion, gender, national origin, disability, sexual orientation, gender identity, protected veteran status, or other characteristics in accordance with the relevant governing laws.
Key skills/competency
- BI Tools
- RPA
- Power BI
- Data Analysis
- Automation
- Data Management
- SQL
- Python
- Data Engineering
- Finance Domain Expertise
Skills & topics
- BI Architect
- Automation Architect
- Robotic Process Automation
- RPA
- Power BI
- Data Analysis
- Business Intelligence
- Microsoft BI
- Data Management
- Finance Domain Expertise
How to get hired
- Tailor your resume: Highlight your 3-5 years of experience in data analytics, automation solutions, and finance domain expertise, emphasizing skills in Power BI, RPA, and SQL.
- Showcase technical skills: Clearly list your proficiency with the Microsoft BI stack (Power BI, Power Automate, Excel) and any RPA tools like Automation Anywhere.
- Demonstrate problem-solving: Prepare examples of how you've identified, designed, and implemented automation opportunities to improve business processes and data flows.
- Highlight collaboration: Emphasize your ability to work independently and collaboratively with diverse stakeholders, including mentoring junior team members.
- Understand the company: Research Wood's global operations and commitment to digitalization and automation to align your application with their mission.
Technical preparation
Master Power BI advanced modelling and DAX.,Gain experience with Automation Anywhere RPA.,Practice SQL, Python, and PySpark for data engineering.,Understand Data Lakes and Data Warehouses.
Behavioral questions
Describe a complex automation project you led.,How do you promote technology adoption to stakeholders?,Give an example of improving data integrity.,How do you handle challenges in data analysis?
Frequently asked questions
- What is the primary focus of the BI & Automation Architect role at Wood?
- The BI & Automation Architect role at Wood focuses on designing and implementing solutions that leverage Robotic Process Automation (RPA) and advanced Business Intelligence (BI) tools, particularly within a finance domain. This includes developing interactive dashboards, automating repetitive tasks, and promoting the adoption of digitalization and automation across the organization.
- What are the key technical skills required for this BI & Automation Architect position?
- Key technical skills include deep expertise in the Microsoft BI and Power Platform stack (Power BI, Power Automate, Excel, SSIS), experience with Automation Anywhere RPA, strong DAX, SQL, and HTML skills, and knowledge of data engineering concepts like Data Lakes and Data Warehouses. Experience with Python, PySpark, and CI/CD practices is also highly valued.
- What type of experience is Wood looking for in a BI & Automation Architect candidate?
- Wood is seeking candidates with 3-5 years of proven experience architecting and delivering data analytics and automation solutions in complex, global business environments. A strong finance domain background is preferred, along with experience in leading automation projects and mentoring junior team members.
- What are the preferred certifications for the BI & Automation Architect role?
- Preferred certifications include Automation Anywhere Bot Developer, MS Power Platform Developer Associate, MS Fabric Data Engineer Associate, and MS Power BI Data Analyst Associate. Having these demonstrates a strong foundation in the key technologies used for this role.
- How does this role contribute to Wood's overall goals?
- This role contributes to Wood's goals by driving operational efficiency and strategic decision-making through advanced automation and insightful BI. By promoting digitalization and staying ahead of BI trends, the architect helps maintain Wood's competitive edge in the energy and materials markets.
- What is the work arrangement for the BI & Automation Architect position at Wood?
- The job description does not explicitly state the work arrangement (on-site, hybrid, or remote). However, given the global nature of Wood's operations and the common practices for such roles, it is likely to be a hybrid or potentially remote position, depending on the specific team and location.
- What is the expected educational background for this role?
- A degree is required, preferably in a Finance-related discipline, to ensure a solid understanding of core financial processes. This academic background, combined with practical experience, is essential for success in this role.