Solution Architect

Country/Region: IN- Requisition ID: 16856- Work Model:
- Position Type:
- Salary Range:
- Location: INDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI**Title**:Solution Architect**:

- Description:

- About Birlasoft

Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run businesses with unmatched efficiency and innovation. As part of the CK Birla Group, a multibillion-dollar enterprise, we boast a 12,500+ professional team committed to upholding the Group's 162-year legacy. Our core values prioritize Diversity, Equity, and Inclusion (DEI) initiatives, along with Corporate Sustainable Responsibility (CSR) activities, demonstrating our dedication to building inclusive and sustainable communities. Join us in shaping a future where technology seamlessly aligns with purpose.

Job Title: Data Architect/Data Modeler
Experience: 11-14Years
Location: Mumbai, Pune, Noida

Key Role:
Data Modeler will be responsible for defining and managing critical data structures for current and future needs. The primary responsibilities are to gather business requirements and translate them into logical data models, and to create technical design specifications including source to target mapping documentation for ETL developers.
- Responsibilities:

- Create technical documents and provide technical support and training as needed
- Work closely with systems analysts, software developers, data managers and other team members to ensure successful production of analytical solutions
- Offer viable solutions for various systems and architectures to resolve a variety of business requirements
- Ensuring a seamless integration of new and existing systems to eliminate potential problems and maintain data structure and integrity
- Participate in gathering information from customers or business leaders to meet solution needs
- Collaborate with the development team to design and build the database model
- Develop entity relationships (ER models) for normalized and dimensional models Assist and guide existing Data Modelers and Data Architects
- Adjust access to the data and the reports as needed
- Work closely with the development team to implement data warehouse and reporting
- Experience establishing and maintaining an enterprise approach to logical data modeling.
- Advanced knowledge and experience in logical and physical data modeling
- Experience with SQL and data access layer design
- Help determine and manage data cleaning requirements
- Experience in leading complex large-scale analytical solution implementation
- Mandatory skills in Snowflake, SQL, ETL/ELT, Data Warehouse solutions and databases
- Proven ability to structure complex analysis and perform the analysis to drive insights
- Skills:

- Strong analytical, creative, problem-solving, and critical thinking skills
- Knowledge of relational databases and data architecture computer systems, including very strong in SQL
- Familiarity with or a bachelor’s degree in computer science, data science, information technology, or data modeling
- Knowledge of ER modeling, big data, enterprise data, and physical data models
- Detail-oriented team player who can consistently provide valuable suggestions and solutions in areas of analytical solutions
- Strong verbal and written communication as well as interpersonal skills
- Experience with modeling tools (such as ERWin and ER/Studio)
- Knowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL)
- Education:

- Bachelor or MS degree in Computer Science, Engineering, Information Systems, Information Technology, or equivalent experience
- Minimum 11 to 14 years of experience with data (ETL experience) - Relevant experience in Data Modelling minimum 5 years
- Experience in data curation/aggregation/preparation for use in any Visualization tool (i.e. Cognos, Tableau, Power BI)