Job Summary :
We are seeking a highly skilled and experienced Analytics Engineer to join our data team. The ideal candidate will be a technical expert with a proven track record of designing, building, and optimizing data pipelines and analytical solutions. You will be instrumental in bridging the gap between data engineering and business intelligence, using your expertise in SQL, Python, and BI tools to transform raw data into actionable insights and compelling visualizations.
Key Responsibilities :
Data Transformation and Modeling :
- Design and implement scalable ETL processes to extract, transform, and load data from various sources into a centralized data warehouse.
- Develop and maintain robust data models that support complex analytical queries and business intelligence needs.
Business Intelligence and Visualization :
Build and maintain interactive dashboards and reports using enterprise BI tools (Power BI, Tableau, or similar, with a preference for Bold BI).Apply data visualization best practices to create clear, intuitive, and aesthetically pleasing dashboards.Data Connectivity and Querying :
Establish and manage connections to a variety of data sources, including SQL Server, MySQL, PostgreSQL, Oracle, MongoDB, and REST APIs.Write and optimize complex SQL queries for data extraction, manipulation, and performance tuning.Custom Development and Cloud Integration :
Use Python to develop custom scripts for data processing, automation, and advanced analytics.Leverage cloud environments (AWS, Azure, GCP) for application and database hosting, and to build robust data integration pipelines.Collaboration and Problem Solving :
Work closely with data engineers, data scientists, and business stakeholders to understand data requirements and deliver accurate solutions.Troubleshoot and resolve complex data-related issues, ensuring data quality and integrity.Core Experience :
6 to 10 years of proven experience in an Analytics or Business Intelligence focused role.BI Tools :
Strong background with enterprise BI tools (Power BI, Tableau, etc.), with hands-on experience in Bold BI preferred.Data & Database Expertise :
Expert-level proficiency in SQL for writing and optimizing complex queries.Strong experience in connecting to and working with various databases (SQL Server, MySQL, PostgreSQL, Oracle, MongoDB) and external data sources via REST APIs.Solid understanding of ETL processes and data integration strategies.Programming & Scripting :
Proficiency in Python programming for data processing, scripting, and custom visualizations.Cloud & Infrastructure :
Familiarity with cloud environments (AWS, Azure, GCP) for database management, data warehousing, and application hosting.Analytical Skills :
Strong problem-solving and analytical skills with a meticulous attention to detail.Nice-to-Have Skills :
Experience with Bold BI Server administration, including installations, updates, and configurations.Knowledge of ReactJS, JavaScript, or HTML / CSS for enhanced custom visualizations.Understanding of data security best practices in BI tool environments.Experience working within Agile / Scrum methodologies.(ref : hirist.tech)