استخدام Senior BI Developer
شرح موقعیت شغلی
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.
• 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
• 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
مهارتهای مورد نیاز
- bi
- SQL
- Pl/sql
- oracle
- MongoDB
- ETL
حداقل سابقه کار
- سه تا شش سال
جنسیت
- مهم نیست
وضعیت نظام وظیفه
- معافیت دائم پایان خدمت