Senior BI Consultant(Python scripting, 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.
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
