Database Analyst

Job Summary:

·         Looking for database analysts with 7 years’ experience to grow the sales analytical and reporting team.

·         The Analyst will work in the Global Sales- Centralized Analytics and Reporting Ops team to provide on-going support of our business intelligence tools and applications.

·         The Database specialist will be focused on the backend database development in Databricks, Oracle, and SQL Server. The candidate must be able to develop/modify notebooks, procedures, packages, and functions in the database environment.

·         Should be able to create jobs in Databricks.

·         Knowledge of Python is desired.

·         Very strong skills in SQL, analytical queries, procedural processing.

·         Must have strong knowledge of ETL skills and transfer of data between multiple systems.

·         Must be able to independently handle ad hoc user data requests and handle production issues in the data warehouse and reporting environment

·         Good knowledge of Excel preferred.

·         Knowledge of PBI and DAX language preferred.

·         The candidate will focus on designing effective reporting solutions that are scalable, repeatable, meeting the needs of the business users.

·         Develop pipeline for data integration and aggregation; maintain documentation; and accommodating ad-hoc user requests. 

·         This role will align with cross-functional groups such as IT, Regional Distribution Team, Regional Sales Ops, Business Units, and Finance.

Responsibilities:

* Proficient in relational databases (Databricks, SQL Server, Oracle)

* Proficient in SQL and ability to modify procedures, notebooks in Databricks, Oracle, SQL Server

* Proficient in advanced Excel features.

* Ability to debug Power BI dashboards and modifying existing Power BI dashboards.

* Performing ad-hoc reporting to support the business and help in data-driven decision making.

* Excellent problem-solving abilities and communication skills

* Must be willing to work independently and be an excellent team player.

* Must be willing to support systems after regular work hours.