Senior Data Analyst

‍About the Opportunity

We are looking for a Senior Data Analyst interested in data model design, data exploration, and data visualization. The Data Analyst will work closely with a diverse team of cloud architects, data engineers, and business analysts to help consult mid-market enterprise businesses create new data strategies.

This work will involve the development, implementation, and transition of analytical processes to a cloud-based data warehouse and/or data lake where the data will be made available to other analytics initiatives and BI platforms (Power BI, Looker, Qlik, etc.). The Data Analyst must be comfortable working closely with technical and less-technical business users in client settings, for the purpose of defining data and modelling requirements to enable use cases and client objectives.

The Data Analyst is responsible for identifying the existing relationships across enterprise-wide entities, crossing multiple disparate systems, and identifying the best approach for normalizing and denormalizing data into the data warehouse/data lake. The approach should balance performance, flexibility, and complexity in its design, and enable the data to be utilized in a variety of analytics initiatives, including but not limited to baseline reporting in BI platforms to advanced analytics.

‍

Responsibilities

• Design and lead the creation of enterprise-wide data models, identifying and mapping new relationship across systems;
• Prepare accurate data modeling design and architecture strategies for stakeholders and business functions;
• Create Entity-Relational Diagrams (ERDs) for systems that will be ingested into a cloud-based data warehouse and/or data lake;
• Aide in the development and implementation of an overall organizational data strategy that is in line with business processes. The strategy includes data model designs, data warehouse/data lake normalization / denormalization best practices, data governance, and management of data warehouses and data analytics (BI) systems;
• Determine the normalization and denormalization approaches for data being moved into data warehouse and/or data lake environments;
• Recommend solutions to improve new and existing data warehouse and data lake systems;
• Design models that reduce data redundancy, streamline data movements, and improve information management;
• Identifying data sources, both internal and external, and creating a plan for data management that is aligned with organizational data strategy;
• Coordinating and collaborating with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise-wide data warehousing/data lake initiative;
• Defining and managing the flow of data and dissemination of information within the organization; and,
• Conducting a continuous audit of analytics system performance, refining whenever required, and work to resolve these issues.
• Aiding in the creation of an end-to-end data architecture, from selecting the platform, designing the technical architecture, and testing and implementing the proposed analytics solution;
• Integrating data governance best practices including data accessibility, integrity, quality, and security;
• Acting as a data consultant, working directly with the client for requirements gathering, presentations, training and iterative feedback.
• Working closely with businesses to enable them to take more control over their analytics needs
• Prepare report wireframe/proof-of-concepts based on initial project requirements and branding guides
• Build operational dashboards as self-service tools to analyze and present data associated with customer experience, business operations, and strategic decision making. 
• Research and stay up to date on relevant industry standards and trends seen across tools in BA/BI

‍