Senior Software Engineer

at Convera

Pune- WFH

• →Architect and Develop Data Architecture Solutions: Design and implement scalable and efficient data architecture solutions on enterprise data platform. Lead the end-to-end architecture, design and modeling using Snowflake, Tableau and AWS.
  
  
• →Collaborate and Design Data Models: Partner with stakeholders and business units to understand data requirements and business goals. Lead the architecture and designing the data models, schemas, data mappings, data transformations and metadata that align with business needs, analytical requirements, and industry standards. Ability to analyze the legacy data models within legacy platforms involving SQL Server, Oracle and Stored Procedures. Possess strong hands-on SQL and Python skills.
• →Data Integration, Governance and Security: Collaborate with internal and external teams to design, implement, and maintain data integration solutions, ensuring high data integrity, consistency, and accuracy. Ensure data security, integrity, and compliance with regulations. Oversee the integration of data from multiple sources into a unified system.
  
  
• →Business Intelligence and Reporting: Develop and implement semantic models to support business intelligence and reporting needs. Design and manage data models involving dimensions, facts, metrics, and measures to ensure accurate and efficient reporting. Work closely with business analysts and BI developers to create and maintain semantic layers that facilitate self-service reporting and analytics. Ensure the semantic models align with business requirements and support key performance indicators (KPIs) and metrics.
  
  
• →Implementation and Troubleshooting: Oversee the implementation of data solutions from initial concept through to production. Troubleshoot and resolve complex issues to ensure data pipeline stability and high performance. Monitor and optimize the performance of data systems and processes.
  
  
• →AI and ML Capabilities: Stay updated with industry trends and advancements in AI and ML and integrate these technologies into the data architecture to enhance data processing and analytics capabilities.
  
  
• →Documentation and Best Practices: Develop and maintain comprehensive documentation for data architecture, pipelines, and processes. Establish and enforce best practices for data engineering and quality assurance.

• Bachelor's degree or equivalent in Computer Science, Engineering, or a related field with proven experience as a Data Architect or in a similar role. in architecting, designing, deploying, and managing data models on cloud-based infrastructure, preferably for data platforms.

• Minimum of 10 years of experience in enterprise data architecture, data management and data governance, or a related field.
• Strong knowledge of database design, data modeling, and ETL processes. Experience in designing and implementing data models involving dimensions, facts, metrics, and measures.

• Hands-on experience with Snowflake and SQL. Proficiency with data modeling tools such as ER/Studio, Erwin Data Modeler, Lucidchart, MySQL Workbench, and Oracle SQL Developer Data Modeler. Possess strong hands-on SQL and Python skills.
• Strong experience with data architecture principles, including data modelling, ETL/ELT processes, and data management and hands on experience with Big Data technologies.

• Familiarity with database systems such as Snowflake, SQL Server, PostgreSQL, or NoSQL databases.
  
  
• Ability to translate business requirements into effective semantic models that support reporting and analytics using Tableau.
  
  
• Excellent problem-solving and analytical skills.
  
  
• Strong communication and collaboration abilities.

• Experience with regulatory compliance related to data management (e.g., GDPR, HIPAA).
• Knowledge of emerging technologies such as AI, machine learning, and data analytics.
• Certifications in cloud platforms (e.g., AWS).