Data Solution Architect - Data Warehousing (8-12 yrs)

Department : Supply Chain Analytics.

Job Role : Solution Architect.

Location : Bangalore.

Experience & Education : Around 8-12 years of experience.

SUMMARY OF JOB :

- Design data model or Expand existing data models with new features based on business feedback.

- Collaborate with the Global and Regional based data integration team to acquire expanded data from source systems.

- Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality.

- Acquiring data from primary or secondary data sources and maintaining databases.

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

- Work with the larger Growth Technology Systems team to help develop and uphold data governance policies and procedures to ensure standardized data naming, establish consistent data definitions and monitor overall data quality for assigned data entities.

- Filter and clean data by reviewing reports and performance indicators to locate and correct code problems.

- Analyze and improve performance on existing data models including query optimization, DAX optimization, and processing optimization (partitions).

- Build and enhance SQL Server Analysis Services data models.

- Interpreting data, analyzing results using statistical techniques.

- Develop or assist in the development of SSRS, Excel, Tableau and Power BI reports.

- Develop required process documentation and adhere to security compliance.

Primary Skills :

- Good business analytical skills.

- Deep understanding of dimensional modeling, OLTP and OLAP database designs and implementation strategies.

- Data Warehousing concepts, architecture & schemas.

- Familiarity with ETL tools such as Microsoft SSIS/DTS, Data Stage, Informatica Power Center, Informatica Cloud.

- Experience in providing solutions for BI & DW environment.

- Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks).

- Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc).

- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

- Good communication skills both written and verbal.

- Experience in Manufacturing sector.

- Familiarity with Agile methodologies such as Scrum.

Preferred Knowledge :

- Exposure to data visualization/BI.

- AWS.

ESSENTIAL FUNCTIONS :

- DW solutioning.

- Understanding business requirements, source the data, data model design.

- Assess Data Quality, Data Integration, Migration & Modelling.

- Handle end to end development.

- Frequent client interaction.