Business Intelligence Developer

Asian Hires; Vadodara; Hybrid; INR 800,000 - 1,000,000; Full time

Job summary

A tech solutions firm is seeking a qualified BI Analyst to join their team in Vadodara, India. This hybrid role involves designing and implementing business intelligence solutions, utilizing advanced SQL, Power BI, and data integration methodologies. The successful candidate will work closely with various departments to improve data-driven decision-making processes. Ideal candidates should have a Bachelor's degree in a relevant field and at least 6 years of experience in analytics and data visualization tools.

Qualifications

• 6+ years of experience working with SQL Server and Oracle.
• Experience with data modeling, creating, and operating databases.
• Hands-on experience with Power BI Service and its premium features.

Responsibilities

• Design and develop reporting solutions using SQL Server and Power BI.
• Implement data automation workflows through Power Automate.
• Analyze existing data repositories for ETL mapping.

Skills

Advanced SQL knowledge

Expert level proficiency in DAX & Power Query

Experience in reporting and analytics tools

Proficiency in SSIS

Building and maintaining Power Automate flows

Optimizing Power BI reports

Familiarity with cloud development

Excellent management and communication skills

Analytical and problem-solving skills

Education

Bachelor’s degree in Information Technology, Business, Finance or related field

Tools

Power BI

Tableau

SSRS

SQL Server

Oracle

SSIS

Power Automate

Azure

AWS

GCP

Job description

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.

• Advanced SQL knowledge with 6+ years of experience working with multiple platforms (SQL Server, Oracle etc.) including modeling, creating, and operating a database.
• Expert level proficiency in DAX & Power Query with experience building efficient data models and
• Experience in reporting and analytics tools such as Power BI, Tableau, and SSRS.
• Proficiency in systems integration tools such as SSIS is preferred.
• Hands‑on experience with building and maintaining Power Automate flows and premium features on Power BI Service such as data flows.
• Expertise in optimizing Power BI reports and queries for improved performance and faster response times.
• Familiarity with cloud development such as Azure, AWS and GCP. Azure experience is preferred.
• Excellent management and communication skills. Have a desire for continuous process improvement, optimization, and automation. Excellent analytical and problem‑solving skills.
• Comfortable and highly proficient in working with large sets of data in spreadsheets and other information systems.
• Ability to take loose or incompletely defined requirements and use knowledge and experience to create a finished product.
• Bachelor’s degree in Information Technology, Business, Finance or related field.
• Ability to give effective training and presentations to senior management and other groups.
• Strong analytical and multi‑tasking skills.