Analytics India Magazine - Data Architect

Responsibilities

- Developing and implementing an overall organizational data strategy that is in line with business processes. The strategy includes data model designs, database development standards, implementation and management of data warehouses and data analytics systems.

- Identifying data sources, both internal and external, and working out a plan for data management that is aligned with organizational data strategy.

- Coordinating and collaborating with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise data system.

- Managing end-to-end data & BI architecture, from selecting the platform, designing the technical architecture, and developing the application to finally testing and implementing the proposed solution.

- Creating practices and standards on developing and perpetually maintaining business intelligence reporting/visualization (e.g., Dashboards, KPIs)

- Implement data Architecture to develop and implement an enterprise Data Warehouse Solution in support of the single source of truth. The data warehouse will serve as a centralized repository for multiple data sources from internal and external sources.

- Gather requirements from stakeholders, prepare Data Warehouse Requirements Document, and create Data Warehouse Design Document.

- Planning and execution of big data and data lake solutions using technologies like Hadoop, NoSQL, Spark, S3, Hybrid etc. In fact, the big data architect roles and responsibilities entail the complete life-cycle management of a such solutions.

- Integrating technical functionality, ensuring data accessibility, accuracy, and security.

- Conducting a continuous audit of data management system performance, refine whenever required, and report immediately any breach or loopholes to the stakeholders.

- Proactively identify business improvement and innovation opportunities through data and analyses

- Coordinating with business users to develop scripts, queries, or software code to accomplish specific requirements or tasks.

- Experience with Developing strategies for data acquisition, archive recovery, and implementation of a database

Skills and Qualifications Requirements :

- Overall 10+ years of experience in data

- 8+ years of Data Modeling experience; Delivering both logical models and physical designs. MPP technologies preferred.

- 8+ years of Advanced SQL Coding/Tuning Experience including hands-on management of PostgreSQL, Oracle, or IBM DB2, involving implementation of schemas, indexes, and query optimization

- 5+ years of experience in the insurance industry. Working with various internal and external stakeholders is strongly preferable.

- Effective communication and interpersonal skills

- Experience with SQL and stored procedures

- Understanding of Data Management/Metadata Management process and principles is essential.

- Helps develop data warehouse and strategic direction for the department.

- Experience with Cloud platforms for data warehousing

- Hands-on expertise in data warehousing and architecture, data modelling, master data, big data analytics, real-time analytics, and data visualization, and reporting

- Experience with advanced analytics languages like Python, R, NOSQL etc.

- Bachelor's Degree in Computer Science, Computer Engineering, Statistics, or related field; Master's Degree preferred