Data Architect

Experience & Education: Around 8-12 years of experience

SUMMARY OF JOB:

1. Design data model or Expand existing data models with new features based on business feedback
2. Collaborate with the Global and Regional based data integration team to acquire expanded data from source systems
3. Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality
4. Acquiring data from primary or secondary data sources and maintaining databases
5. Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
6. 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
7. Filter and clean data by reviewing reports and performance indicators to locate and correct code problems
8. Analyze and improve performance on existing data models including query optimization, DAX optimization, and processing optimization (partitions).
9. Build and enhance SQL Server Analysis Services data models
10. Interpreting data, analyzing results using statistical techniques
11. Develop or assist in the development of SSRS, Excel, Tableau and Power BI reports
12. Develop required process documentation and adhere to security compliance


Primary Skills:
1. Good business analytical skills
2. Deep understanding of dimensional modeling, OLTP and OLAP database designs and implementation strategies
3. Data Warehousing concepts, architecture & schemas
4. Familiarity with ETL tools such as Microsoft SSIS/DTS, Data Stage, Informatica Power Center, Informatica Cloud
5. Experience in providing solutions for BI & DW environment
6. Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks)
7. Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc)
8. Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
9. Good communication skills both written and verbal
10. Experience in Manufacturing sector
11. Familiarity with Agile methodologies such as Scrum

Preferred Knowledge:
1. Exposure to data visualization/BI
2. AWS

ESSENTIAL FUNCTIONS:

1. DW solutioning
2. Understanding business requirements, source the data, data model design
3. Assess Data Quality, Data Integration, Migration & Modelling
4. Handle end to end development
5. Frequent client interaction

Requirements