Data and Analytics - Architect

Key Responsibilities

• Data Modeling & Expansion:
• Design new data models or expand existing ones based on business feedback.
• Collaborate with global and regional data integration teams to acquire expanded data from source systems.
• Develop and implement databases, data collection systems, data analytics, and other strategies to optimize statistical efficiency and quality.
• Acquire data from primary or secondary data sources and maintain databases.
• 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.
• Data Quality & Governance:
• Work with the larger Growth Technology Systems team to develop and uphold data governance policies and procedures.
• Ensure standardized data naming, 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.
• Data Analysis & Reporting:
• Develop and implement data analyses and other strategies that optimize statistical efficiency and quality.
• Interpret data and analyze results using statistical techniques.
• Develop or assist in the development of SSRS, Excel, Tableau, and Power BI reports.
• Documentation & Compliance:Develop required process documentation and adhere to security compliance.

Essential Functions

• DW solutioning
• Understanding business requirements, sourcing data, and designing data models.
• Assessing Data Quality, Data Integration, Migration & Modeling.
• Handling end-to-end development.
• Frequent client interaction.

Qualifications

Primary Skills

• Good business analytical skills.
• Deep understanding of dimensional modeling, OLTP, and OLAP database designs and implementation strategies.
• Data Warehousing concepts, architecture, and schemas.
• Familiarity with ETL tools such as Microsoft SSIS/DTS, Data Stage, Informatica Power Center, Informatica Cloud.
• Experience in providing solutions for BI & DW environments.
• Strong knowledge of and experience with reporting packages (e.g., Business Objects), databases (e.g., SQL), and programming (XML, Javascript, or ETL frameworks).
• Knowledge of statistics and experience using statistical packages for analyzing datasets (e.g., Excel, SPSS, SAS).
• 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 the Manufacturing sector.
• Familiarity with Agile methodologies such as Scrum.

Preferred Knowledge

• Exposure to data visualization/BI.
• AWS