Functional Data Analyst

Role Description

We are looking for a data analyst who can help drive business intelligence efforts and support the growth of the Business Process and Finance teams. This role provides an opportunity to solve the company's most interesting problems and develop new business strategies.

• Regularly mine data from large SQL databases
• Build models that lead to better insights and business understanding.
• Design and maintain reports/dashboards and track and communicate key performance indicators.
• Assure quality and data integrity for revenue and business development.
• Build logical and physical data models with Facts and dimensions, aggregates in Snowflake.
• Interact with data source owners and participate in developing project plans.
• Provide original insights beyond the scope of supporting reactive requests.
• Support ongoing analysis of business performance trends and insights required to inform decisions.
• Design and build new dashboards to monitor performance metrics; maintain existing dashboards for accuracy and incorporate changes in the business.
• Build a strong relationship with data engineering to understand data availability, accuracy, and consistency; comfortable providing specifications for data tracking and data warehouse needs.
• Proactively perform data exploration to discover actionable insights.
• Present your research and insights to all levels of the company clearly and concisely.
• Collaborate with IT team and other cross-functional systems teams during design and support implementation of business solutions.
• Responsible for designing, monitoring, measuring, and improving the quality of master data.

Qualifications

• Experience in data architecture, data modelling, designing and data analysis with conceptual, logical, and physical modelling for OLAP and Snowflake data warehousing.
• Experience in Normalization of OLTP and denormalization of entities for Snowflake Data warehousing.
• Experience in Data governance and master data management.
• Experience in SQL, PL/SQL packages, functions, stored procedures, triggers.
• Experience in BI/DW solutions (ETL, Data mart, OLAP) and BI reporting tools like Tableau.
• Exposure to Oracle Fusion Cloud and SFDC functional areas.
• Exposure to Statistics, Econometrics, Data Science, and Machine Learning concepts and tools.
• Engineering/technical background analyzing large data sets.
• 5+ years of analytical experience and comfortable working with large data sets.
• Excellent programming logic with comprehension of at least one scripting language (i.e., Python, JavaScript, C++, R, etc.).
• Experience as an analyst in the following areas: finance, accounting, QTC and non-QTC.
• Extensive experience with SQL is critical; additional experience with BI & visualization tools is a strong plus (i.e., Qlik, Tableau, Looker).
• Comfortable working with MS Excel and MS PowerPoint.
• Must be intellectually curious, eager to learn, self-motivated, detail-oriented, and able to multi-task.
• Able to operate with openness and efficiency with one or more SDLC methodologies (e.g., Scrum).
• Strong communication skills and ability to work collaboratively with cross-functional teams.