BI Analyst

REPORTING RELATIONSHIP

POSITION REPORTS TO : LEAD SQL DEVELOPER

DEPARTMENT : INFORMATION TECHNOLOGY

POSITION LOCATION : VADODARA, INDIA (Hybrid)

Budget : 8,00,000 -10,00,000 PA.

POSITION SUMMARY

The BI Analyst is responsible for the technical implementation of BI solutions by leveraging knowledge of data warehouse models, data visualization, data analysis, and software development methodologies. Additionally, this position will work with the Manager of Business Intelligence and Analytics, Archer Senior Leadership, Business Operations, and other pertinent parties to define, prioritize and develop business intelligence and analytics solutions.

JOB RESPONSIBILITIES

• Design and development of reporting solutions utilizing SQL Server, Power BI, and Data flows.
• Implement data automation workflows using Power Automate to streamline data processes and business operations.
• Design and development of data integrations utilizing SQL and SSIS
• Develop, document, and maintain Power BI dashboards utilizing best practices and industry standards.
• Analyze the existing transactional data repositories to identify and create data mapping and business rules for ETL, based on business needs.
• Contribute to and partner with Product and Development teams in creation of procedural automation and associated project lifecycle including but not limited to concept delivery, user testing, and deployment.
• Establish regular validation processes to ensure data integrity and recommend new reports, feeds, and processes to support the business model.
• Provide technical guidance to other members of the development team.
• Identify and implement potential enhancements in collaboration with stakeholders.

KNOWLEDGE, SKILLS AND ABILITIES

The BI Analyst will be able to design a solution from scratch as well as understand data needs necessary to drive business decisions including forecasting, KPIs and operational excellence. This role is expected to collaborate closely with multiple teams inside and outside of the IT department and effectively influence on behalf of analytics and data driven thinking.

performing complex queries.

information systems.

Skills Required

Ssrs, Power Bi, Power Automate, Sql Server, Tableau, Ssis, Power Query, Sql, Gcp, Javascript, Dax, Azure, Python, Aws