Senior BI Consultant(Data Engineering ,Python.AWS services) with fast growing Software company, Baner, Pune.

Seventh Contact Hiring Solutions; Pune District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Seventh Contact Hiring Solutions seeks a Senior BI Consultant to design, build, and maintain scalable BI and data warehousing solutions in Pune. The role emphasizes Python/R scripting, AWS services (Lambda, S3, Redshift), and strong data governance to extract actionable insights and support data-driven decisions.

You will collaborate with data engineers and data scientists to deliver robust BI solutions, lead development efforts, and stay ahead of cloud and analytics trends in a dynamic

Qualifications

• 6+ years of experience in BI development, data engineering, or a related field.
• Strong expertise in Python/R for data processing and automation.
• Hands-on experience with AWS services: Lambda, S3, and Redshift.
• Proven experience in data warehousing design, implementation, and management.
• Proficiency in SQL for advanced query writing and optimization.
• Deep understanding of data governance principles, including data quality, security, and compliance.
• Experience with data visualization tools such as Power BI or similar.

Responsibilities

• Data Integration and Pipeline Development
• Design, implement, and optimize ETL/ELT pipelines to ingest, transform, and load data into AWS Redshift from various sources.
• Write efficient and reusable Python scripts to automate data processing workflows.
• Utilize AWS Lambda for serverless data processing and real-time data transformations.
• Data Science and Analytics
• Apply data science techniques to analyze large datasets, develop predictive models, and deliver actionable insights.
• Integrate machine learning models and statistical analysis into BI solutions.
• Conduct A/B testing and advanced analytics to support strategic business decisions
• Manage and monitor AWS S3 storage, ensuring data integrity, availability, and performance.
• Data Warehousing and Database Management
• Architect and maintain data warehouses and data marts to support reporting and analytical needs.
• Implement and enforce data modeling best practices to ensure scalability and performance.
• Data Governance and Security
• Establish and enforce data governance frameworks to ensure data quality, security, and compliance with industry standards.
• Collaborate with cross-functional teams to define data policies and implement robust access controls for sensitive data.
• Maintain data cataloging and documentation to ensure transparency and ease of access across the organization.
• Collaboration and Leadership:-
• Lead BI development efforts, mentor junior team members, and share best practices.
• Work closely with data engineers, data scientists, and business analysts to deliver end-toend solutions.
• Stay updated with emerging trends in data warehousing, BI, and cloud technologies to recommend innovative approaches.

Skills

BI development

Data engineering

Python/R scripting

SQL proficiency

Data governance

Power BI

Tools

AWS Lambda

AWS S3

AWS Redshift

Job description

We are seeking a highly skilled Senior BI Consultant with extensive experience in designing,

developing, and maintaining scalable Business Intelligence and data warehousing solutions. This role requires a strong background in Python scripting, AWS services (Lambda, S3, Redshift), and data science methodologies to extract actionable insights and support data-driven decision-making. The candidate will also be responsible for ensuring adherence to data governance standards and best practices while collaborating closely with stakeholders, data engineers, and data scientists to deliver robust BI solutions.

Key Responsibilities:

• Data Integration and Pipeline Development
• Design, implement, and optimize ETL/ELT pipelines to ingest, transform, and load data into AWS Redshift from various sources.
• Write efficient and reusable Python scripts to automate data processing workflows.
• Utilize AWS Lambda for serverless data processing and real-time data transformations.
• Data Science and Analytics
• Apply data science techniques to analyze large datasets, develop predictive models, and
• deliver actionable insights.
• Integrate machine learning models and statistical analysis into BI solutions.
• Conduct A/B testing and advanced analytics to support strategic business decisions
• Manage and monitor AWS S3 storage, ensuring data integrity, availability, and performance.
• Data Warehousing and Database Management
• Architect and maintain data warehouses and data marts to support reporting and analytical
• needs.
• Implement and enforce data modeling best practices to ensure scalability and performance.
• Data Governance and Security
• Establish and enforce data governance frameworks to ensure data quality, security, and
• compliance with industry standards.
• Collaborate with cross-functional teams to define data policies and implement robust access
• controls for sensitive data.
• Maintain data cataloging and documentation to ensure transparency and ease of access
• across the organization.
• Collaboration and Leadership:-
• Lead BI development efforts, mentor junior team members, and share best practices.
• Work closely with data engineers, data scientists, and business analysts to deliver end-toend solutions.
• Stay updated with emerging trends in data warehousing, BI, and cloud technologies to
• recommend innovative approaches.

Required Skills and Qualifications

• 6+ years of experience in BI development, data engineering, or a related field.
• Strong expertise in Python/R scripting for data processing and automation.
• Hands-on experience with AWS services: Lambda, S3, and Redshift.
• Proven experience in data warehousing design, implementation, and management.
• Proficiency in SQL for advanced query writing and optimization.
• Deep understanding of data governance principles, including data quality, security, and
• compliance.
• Experience with data visualization tools such as Power BI or similar.