Job description :

Accountable for timely completion and quality execution of projects assigned whether as a lead or a substantial contributor.

Performs all required tasks including :

- Translate business needs related to insights into technical specifications.

- Ensure to use accurate and secure methods to extract data.

- Use data visualization techniques to present information.

- Interpret data, analyze results using statistical techniques and provide ongoing reports.

- Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality including structured and unstructured data.

- Identify, analyze, and interpret trends or patterns in complex data sets.

- Filter and clean data by reviewing business needs and performance indicators to locate and correct problems.

- Locate and define new process improvement opportunities.

- Aggregate data from multiple sources in an efficient data warehouse.

- Define and create ETL or ELT process.

- Managing and designing the reporting environment, including data sources, security, and metadata.

- Providing technical expertise in data storage structures, data mining, and data cleansing activities.

- Prepare analytical models using SSAS or Azure Analysis services Envisioning and planning, monitoring project progress and team members' contributions and conducting project meetings with end customer.

- Identifying appropriate templates or approach for the deliverables and projects,.

- 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.),

- Assisting and guiding other team members for executing deliverable tasks and doing deliverable breakdown.

- Communicating detailed deliverable status to stakeholders and 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 :

- Must have skills include creating data pipelines using SSIS/ dataflow / Azure Data Factory and creating a central data warehouse, creating analytical models using SSAS / Azure Analysis service / Fabric.

- Experience of implementing end-to-end projects using Microsoft Fabric will be advantage.

- Has experience of successfully managing and contributing to a fair number of data analytics projects (preferably leading a team or a part of it).

- Has in-depth knowledge in database design, ETL and reporting tools (Power BI).

- Good 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.