DBT Data Modeller

Role-Data Modeller

Location- Noida/Gurgaon/Bangalore/Hyderabad (Remote)

Experience- 7 to 10 years

About Straive:

Straive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains.

Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the companys long-term vision. The company is a specialized solutions provider to business information providers in finance, insurance, legal, real estate, life sciences and logistics. Straive continues to be the leading content services provider to research and education publishers.

Data Analytics & Al Services: Our Data Solutions business has become critical to our client's success. We use technology and Al with human experts-in loop to create data assets that our clients use to power their data products and their end customers' workflows.

As our clients expect us to become their future-fit Analytics and Al partner, they look to us for help in building data analytics and Al enterprise capabilities for them.

With a client-base scoping 30 countries worldwide, Straives multi-geographical resource pool is strategically located in eight countries - India, Philippines, USA, Nicaragua, Vietnam, United Kingdom, and the company headquarters in Singapore.

Website: Linkedin

Straive is an equal opportunity employer. We commit to celebrate diversity, equity and inclusion in the workplace.

Overview /Objective:

About the Role

In this role, you will play a critical part in building and maintaining the data infrastructure that powers key business decisions across various domains., depending on assignment. You will work closely with BI developers, analysts, data engineers, business owners, and architects to translate business requirements into robust and scalable data solutions.

You are an experienced data professional, who can work with minimal oversight, manage multiple tasks and projects simultaneously and take ownership of deliverables end-to-end. Critical to the success of this role is your ability to work with large volumes of data, bring simplicity to complex situations, work effectively as part of a cross-functional team, think strategically, and communicate findings in a clear and compelling way.

Roles and Responsibilities:

Data Modeling & Transformation:

• Develop and maintain data models and pipelines using dbt used for reporting and analytics.
• Support and champion the use of a unified semantic layer for metric delivery.
• Ensure data quality, accuracy, and consistency throughout the data lifecycle.
• Implement data validation and testing procedures to identify and address data anomalies.

Data Warehousing & BI

• Collaborate with data analysts and BI developers to design data models that support interactive dashboards and reports in Power BI at scale.
• Optimize data warehouse performance and scalability to support growing data volumes and user demands.

Data Infrastructure & Tools

• Maintain and improve existing data pipelines and infrastructure.
• Evaluate and implement new data technologies and tools to enhance data capabilities.
• Contribute to the development and documentation of data standards and best practices.

Collaboration & Communication

• Work closely with cross-functional teams to understand business requirements and translate them into technical solutions.
• Communicate complex technical concepts to both technical and non-technical audiences
• Proactively identify and address potential data challenges and risks.

Project Management

• Manage and prioritize multiple projects simultaneously, ensuring timely delivery of high-quality results.
• Utilize project management tools like Jira to track progress, manage dependencies, and communicate effectively with stakeholders.

Required Skill Sets:

Technical Skills

• Bachelors degree in computer science, statistics, mathematics, engineering, or related field.
• years' experience as an analytics engineer, data engineer, or a similar role
• Strong proficiency with data querying and data modeling using SQL and data warehousing concepts
• Strong proficiency with dbt for data modeling, transformation, and documentation
• Experience with cloud data platforms (e.g., AWS, GCP, Azure)
• Proficiency in modern data visualization tools such as Tableau, PowerBI, and/or Looker
• Experience with data quality and validation tools (i.e., Monte Carlo, etc.)
• Experience working in an Agile development environment and management tools (i.e., Jira)
• Confidence in dealing with technical and non-technical stakeholders

Other Key Attributes / Characteristics:

• Superior communication skills both oral and written
• Strong analytics and critical thinking ability
• Strong attention to detail, you cross all the t's and dot all the i's
• Strong ability to effectively gather information from multiple sources