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.