Title:  Data Architect

• Take ownership of the technical aspects of designing and optimizing conceptual and logical database models/schemas as well as transformation/validation rules for Domains
• Design Domain Data Platform(Finance, Customer,HR, Utilties).
• Implement data pipelines to automate the ingestion, transformation, and augmentation of both structured, unstructured, real time data, and provide best practices for pipeline operations
• Designing solutions to integrate data from various sources within the organization
• Analyze query performance, optimizing databases, and ensuring a sleek, frictionless data flow
• Define security and backup procedures
• Insight into the changing database storage and utilization requirements.
• Collaboration with business analysts, data scientists, and developers, to align data architecture with the organization’s overall objectives
• Comprehensive knowledge of Functional and technical impact analysis. Provide advice and ideas for technical solutions and improvements to data systems
• Leading the entire software lifecycle including hands-on development, code reviews, testing, deployment, and documentation for batch ETL's.
• Work directly with our internal product/technical teams to ensure that our technology infrastructure is seamlessly and effectively integrated
• Migrate current data applications & pipelines to Cloud leveraging technologies in future

We’re excited if you have:

• 7 to 10+ years of hands-on experience in SQL database design, data architecture, Data Warehousing, SQL Programming
• Designing and implementing ETL processes and workflows.
• Knowledge of ETL tools like Talend, Apache Nifi,Azure Databricks, Google CDF, Apache Kafka Airflow !
• Working knowledge of big data technologies like Hadoop, Spark, MapReduce
• Experience with data storage solutions like HBase, Cassandra, and MongoDB along with PostgreSQL, RDBMS, other NoSQL and columnar databases
• Implementing data encryption, masking, and auditing techniques.
• Experience building data solutions for Power BI and Web visualization applications
• Experience with Cloud is a plus
• Experience in managing multiple projects and stakeholders with excellent communication and interpersonal skills
• Ability to develop and organize high-quality documentation
• Superior analytical skills and a strong sense of ownership in your work
• Collaborate with data scientists on several projects. Contribute to development and support of analytics including AI/ML.
• Ability to thrive in a fast-paced environment, and to manage multiple, competing priorities simultaneously
• Prior Energy & Utilities industry experience is a big plus.
• Graduate with Engineering Degree (CS/Electronics/IT) / MCA / MCS or equivalent with substantial data engineering experience.