Business Architect at Vodafone managing product delivery and requirements in a hybrid model. Collaborating with teams using tools like JIRA, Azure DevOps, and Figma in Pune.
About the role
- Data Architect designing ETL workflows and data models for BI solutions leveraging Snowflake. Collaborating with stakeholders and maintaining data quality in reporting systems.
Responsibilities
- Work with business users and other stakeholders to understand business processes. Ability to design and implement Dimensional and Fact tables
- Identify and implement data transformation/cleansing requirements
- Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse
- Develop conceptual, logical and physical data models with associated metadata including data lineage and technical data definitions
- Design, develop and maintain ETL workflows and mappings using the appropriate data load technique Provide research, high-level design and estimates for data transformation and data integration from source applications to end-user BI solutions.
- Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use.
- Analyze and resolve problems and provide technical assistance as necessary. Partner with the BI team to evaluate, design, develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality.
- Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.
- Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract, and transform into reporting & analytics.
- Build transformation Jobs on SnowFlake to transform source data to target schema used in BI tools.
- Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, quality issues, and continuously validate reports, dashboards and suggest improvements.
- Train business end-users, IT analysts, and developers.
Requirements
- Bachelor’s degree in Computer Science or similar field or equivalent work experience.
- Experience with Snowflake warehouse and developing applications on Snowflake, SnowSQL, Snowpipe, Javascript UDF & Stored procedures is must have.
- Strong in SQL is must have.
- Hands on experience with Big Data, Python.
- SnoeflakePro certification (mandate)
- Knowledge of Data ingestion and Engineering Platforms is must have
- Good understanding and experience on Data Warehousing or Data Integration projects is must have.
- Good knowledge of at least one ETL tool and experience of creating data pipelines is must have.
- IICS/Informatica knowledge is a good to have
- Knowledge of the Insurance domain is good to have.
- Expert with data warehousing standards, strategies and tools.
- Expert with SDLC processes.
- Strong knowledge of relational databases preferably ORACLE and SQL Server.
- Knowledge of Python UNIX/LINUX shell scripting is must
- Strong problem-solving, multitasking and organizational skills.
- Good written and verbal communication skills.
- Demonstrated experience of leading a team spread across multiple locations.
- Migration experience from On Premise Source to Snowflake
- Experience with Data Ingestion into SnowFlake such as Snowpipe, Bulk Copy Commands
- Experience in data modeling techniques such as de-normalized, star and snowflake schemas.
Benefits
- Health insurance
- Professional development opportunities
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Data Platforms Expert responsible for supporting data platform architecture at IQVIA. Collaborating on strategies to enhance deployment, operations, and user satisfaction with data platforms.
Product Architect delivering digital solutions for NC and Quality Management at Airbus. Collaborating with teams and leading architectural direction in Toulouse, France.
IT Architect ensuring agile and scalable deployments, designing optimal architectures while leading cloud and on - premise technology implementations. Involves collaboration and continuous integration.
As a Software Architect at Assecor, you will drive technical quality in customer projects. Engage with stakeholders, mentor teams, and develop software architectures.
Senior Software Architect designing scalable microservices and cloud - based solutions for Deutsche WertpapierService Bank AG. Involves team collaboration, knowledge transfer, and architecture reviews.
Infrastructure operation Architect in Vodafone focused on building infrastructure solutions with technology teams for service enhancement.
Test Architect in Nokia's R&D team focusing on functional testing for CNCS. Leading test strategy and improvements in Telco - grade products.
Senior Lead Architect in SAP BTP, working on innovative solutions for Swiss SMEs. Engage with clients through architectural oversight and implementation tasks in a team - focused environment.
Lead Business Architect working with Enterprise Technology to enhance financial processes and systems. Collaborating with stakeholders to drive operational efficiency in Source to Pay and Travel.