Overall Purpose
This position will interact on a consistent basis with other developers, architects, data product owners and source systems. This position requires multifaceted candidates who have experience in data analysis, visualization, good hands-on experience with BI Tools and relational databases, experience in data warehouse architecture (traditional and cloud).
Key Roles and Responsibilities
- Develop, understand, and enhance code in traditional data warehouse environments, data lake, and cloud environments like Snowflake, Azure, Databricks
- Build new end-to-end business intelligence solutions. This includes data extraction, ETL processes applied on data to derive useful business insights, and best representing this data through dashboards.
- Write complex SQL queries used to transform data using Python/Unix shell scripting
- Understand business requirements and create visual reports and dashboards using Power BI or Tableau.
- Upskill to different technologies, understand existing products and programs in place
- Work with other development and operations teams.
- Flexible with shifts and occasional weekend support.
Key Competencies
- Full life-cycle experience on enterprise software development projects.
- Experience in relational databases/ data marts/data warehouses and complex SQL programming.
- Extensive experience in ETL, shell or python scripting, data modelling, analysis, and preparation
- Experience in Unix/Linux system, files systems, shell scripting.
- Good to have knowledge on any cloud platforms like AWS, Azure, Snowflake, etc.
- Good to have experience in BI Reporting tools – Power BI or Tableau
- Good problem-solving and analytical skills used to resolve technical problems.
- Must possess a good understanding of business requirements and IT strategies.
- Ability to work independently but must be a team player. Should be able to drive business decisions and take ownership of their work.
- Experience in presentation design, development, delivery, and good communication skills to present analytical results and recommendations for action-oriented data driven decisions and associated operational and financial impacts.
Required/Desired Skills
- RDBMS and Data Warehousing (Required 9-11 Years)
- SQL Programming and ETL (Required 9-11 Years)
- Unix/Linux shell scripting (Required 6-8 years)
- Power BI / Tableau (Desired 3 years)
- Python or any other programming language (Desired 4 years)
- Cloud Platforms - Azure, Snowflake, Databricks, Deltalake (Required 3-4 years)
Education & Qualifications
University Degree in Computer Science and/or Analytics
Minimum Experience required: 9-11 years in relational database design & development, ETL development
Time Type:
Bangalore, Karnataka, India
11/28/2024