Clairvoyant is a global technology consulting, services, and product company. We help organizations build innovative products and solutions using enterprise stack, big data, analytics, and the cloud. Our global team consists of experienced professionals, with backgrounds in design, software engineering, analytics, and data science. Each member of our team is highly energetic and committed to helping our clients achieve their goals.
Role: Data Architect
Number of open positions: 5
Location: Pune / HYD / Any
Education: Bachelor’s degree or equivalent experience, Masters’s Degree Preferred
Must Have
- 6-10 years of Data Architect / Data Modelling
- Experience using major data modeling tools (examples: ERwin, ER/Studio, PowerDesigner, etc.).
- 3-5 years of management & consulting experience required.
- Design and develop conceptual/logical/physical data models for building large-scale data lake and data warehouse solutions.
- Understanding of data integration processes (batch or real-time) using tools such as Informatica PowerCenter and/or Cloud, Microsoft SSIS, MuleSoft, DataStage, Sqoop, etc
- Experience with major database platforms (e.g. Oracle, SQL Server, Teradata, etc.)
- Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.).
- Experience in data analysis and profiling.
- Strong data warehousing and OLTP systems from a modeling and integration perspective.
- Strong understanding of data integration best practices and concepts.
- Strong development experience under Unix and/or Windows environments.
- Strong SQL skills required scripting (e.g., PL/SQL) preferred.
- Strong Knowledge of all phases of the system development life cycle.
- Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, and Big Data.
- Understanding of on-premises and cloud infrastructure architectures (e.g. Azure, AWS, Google Cloud).
- Can effectively utilize SQL and/or available BI tools to validate/elaborate business rules.
- Ability to run conceptual data modeling sessions to accurately define business processes, independently of data structures and then combines the two together.
- Demonstrates an understanding of EDM architectures and applies this knowledge in collaborating with the team to design effective solutions to business problems/issues.
- Understands and leverages a multi-layer semantic model to ensure scalability, durability, and supportability of the analytic solution.
- Understands modern data warehouse concepts (real-time, cloud, Big Data) and how to enable such capabilities from a reporting and analytic standpoint.
- Demonstrated ability to serve as a trusted advisor that builds influence with client management beyond simply EDM.
Role & Responsibilities:
- Comprehensive understanding of relational databases and technical documentation.
- Ability to analyze business requirements as they relate to the data movement and transformation processes, research, evaluation, and recommendation of alternative solutions.
- Ability to transform business requirements into technical requirement documents.
- Ability to run conceptual data modeling sessions to accurately define business processes, independently of data structures and then combines the two together.
- Can create documentation and presentations such that they stand on their own.
- Demonstrates ability to create new and innovative solutions to problems that have previously not been encountered.
- Ability to work independently on projects as well as collaborate effectively across teams
- Must excel in a fast-paced, agile environment where critical thinking and strong problem-solving skills are required for success.
- Strong team building, interpersonal, analytical, problem identification, and resolution skills.
- Experience working with multi-level business communities.
Job Summary
The Data Architect will provide technical expertise in the analysis, design, development, rollout, and maintenance of enterprise data models and solutions. Provides technical expertise in needs identification, data modeling, data movement, and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective. Provides data understanding and coordinates data-related activities with other data management groups such as master data management, data governance, and metadata management. Leadership is not only in the conventional sense but also within a team we expect people to be leaders. The candidate should elicit leadership qualities such as innovation, critical thinking, optimism/positivity, communication, time management, collaboration, problem-solving, acting independently, knowledge sharing, and approachability.
