Senior DW/BI Developer

Mobinnet Tehran

Posted a month ago

Job Description

• Interview stakeholders to gather business requirements and Creating concise, comprehensive, and level-appropriate reporting to analyze products, services, promotion, pricing, revenue, and customer trends for decision support or answer urgent senior management requests and presentations in a visualization tool (e.g., Tableau). • Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the data warehouse as needed. • Write Extract-Transform-Load (ETL) jobs to calculate business metrics and validating results with business representatives and Review and audit existing ETL jobs. • Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues. • Interpreting business requests and translating them into SQL. Build, maintain and automate complex SQL queries to research, compile performance data, investigate for any strategical analysis or build reports.

Requirements

• Bachelor’s Degree (required) with concentration/major in Computer Science, Information Science or Statistics (preferred) • 3+ years of experience in an analytical role (preferred) • Extensive experience working with Business Intelligence data visualization • Candidate needs to have 5+ years of proficiency in creating complex SQL and ETL in variety of databases in priority order: Oracle, SQL Server, PostgreSQL, MySQL and MongoDB • Extensive experience in database and SQL skills such as analyzing and improving table performance Analysis and tuning SQL queries • Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Objects - Tables, Views, Materialized Views Triggers, Sequences, Synonyms, etc. • Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers) • Scheduled complex cron jobs on UNIX platform using crontab format • Two years’ experience in reporting/analytics (Tableau is preferred) • Ability to leverage best practices for dashboards and data visualizations. • Strong communication skills to communicate analysis, findings and insights. • Experience in Customer Data Analysis, Predictive Analysis, Product and Price Analysis • Excellent skills in organization, prioritizing and managing time . • You are a Python enthusiast and build complex scripts with Python 3. You have a favorite Python built-in function. • Bonus if you have experience with or exposure to the PyData ecosystem (pandas, numpy, scipy, scikit-learn) or R programming. • Experience in telecom (preferred) • Must be self-motivated with the ability to work alone or with limited supervision . • Ability to organized and present information.

Job Category:

IT - Software & Web Development

Business & Data Analysis/ Economic Analysis

Employement type:

Full Time

Job Category:

IT - Software & Web Development

Business & Data Analysis/ Economic Analysis

Employement type:

Full Time

To see more jobs that fit your career