Business Intelligence Specialist

Job Description

Company Description Advaiya Solutions, Inc. is a technology consulting and implementation services company specializing in customized digital transformation solutions. As a Microsoft Solutions Partner since 2005, we have extensive expertise across the entire Microsoft technology stack. Our focus on business applications and analytics, powered by Peripheral Automation, allows us to offer robust, world-class application infrastructure and strategic advantage to our clients. Role Description This is a full-time hybrid role for a Business Intelligence Specialist at Advaiya Solutions, Inc. The role will be located in Udaipur with some opportunities. The Business Intelligence Specialist will be responsible for tasks related to data analytics, data warehousing, ETL processes, data modeling, and analytical skills. Job Responsibilities: Accountable for timely completion and quality execution of projects assigned whether as a lead or a substantial contributor. Performs all required tasks including: o Envisioning and planning, monitoring project progress and team members' contributions and conducting project meetings, o Research (gathering, validating, organizing and analyzing information), o Identifying appropriate templates or approach for the deliverables and projects, o Contributing to analytics deliverables (reports, dashboards, data marts, data warehouse, marketing or training documentation (such as technical specifications, use cases, user guides, technical presentations, communication for decision makers etc.), o Validating deliverables against requirements, o Conducting software testing, o Assisting and guiding other team members for executing deliverable tasks, o Communicating detailed deliverable status to stakeholders, and o Ensuring compliance to standards and best practices. • Holds responsibility of one to three (four stretch) projects simultaneously. Contributes to pre-sales by high level requirement understanding, approach design, estimations and building proposals. Technical skills • Has experience of successfully managing and contributing to a fair number of software development projects (preferably leading a team or a part of it). Has in-depth knowledge in database design, SSIS, SSAS, reporting tools. • Fair knowledge of cloud services like SQL Azure, Dataverse, SQL Datawarehouse • Has capability to gather solution requirements, build detailed specifications (functional and/or technical) and work with the customers/users. • BE/BTech/MCA or equivalent formal education/ training with above average scores. Interest and broad understanding in a number of advanced topics like data modelling, analytics architecture and relevant business contexts (functional processes, sales, marketing etc.) and technology trends (competing products and their strengths, new versions and their advantages etc.) 5+ years of experience into process management. Managerial • Capability to mentor other team members to build work ethic, process awareness and sensitivity to Advaiya value proposition. • Should be able to train and guide other team members on technology, business applications and process topics. • Proven ability to effectively plan and monitor project execution through work breakdown, clear assignments and active monitoring. • Has understanding and appreciation of management reporting (including concepts like team utilization, quality scores, project variance etc.). Ability to build deeper working relationship and mutual trust with team members beyond one's group and location and also current and prospective clients. Communication • Capability to proactively and clearly communicating about technical, project and team related matters through appropriate medium. • Has good command on spoken and written (American) English. • Should be able to create presentations and documents that explain complex technical or strategic concepts (like whitepapers, compete guidance, presentations for decision makers). Has good presentation skills and can conduct technology workshops. Show more Show less