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

Position: – Senior BI Consultant

Years of Experience – 6+ Years

Qualifications –Any Graduate

Job Location: Pune, Baner

Job Summary

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.