Senior Data Analyst

Summary

Join CRB as a Data Analyst to assist in delivering internal data and business intelligence initiatives. The successful candidate will possess advanced understanding of Microsoft's data tools, strong work ethic, and be a dynamic team player.

Requirements

• Bachelor’s Degree or equivalent experience
• 7+ years’ experience designing Reports and Dashboards using reporting and/or analytical tools such as SSRS, Tableau, Power BI, etc
• 7+ years of experience working with MS SQL Server and Azure SQL Database
• 7+ years of experience developing ETL processes with data warehouses
• 7+ years of experience with Microsoft BI Stack (SSIS, SSRS and SSAS)
• 7+ years’ experience developing data models from OLTP, Data Warehouse, Data Mart, or Analysis Services solutions
• Proficiency using Azure Data Factory, Azure Data Lakes, and associated technologies
• Expert proficiency in Data Warehousing methodologies and concepts to store and model the data (Kimball)
• Expert proficiency authoring SQL queries, tables, views, stored procedures, and functions
• Advanced proficiency using Power BI Desktop, and advanced Microsoft Excel features including Power Query, M and DAX
• Experience using developer tools such as Azure DevOps, Git, TFS/TFVC
• Experience with other languages, such as C#, VB, PowerShell, Python is a plus
• Familiarity with D365 ERP modules (e.g., Finance and Operations, Customer Engagement) preferred
• Understanding of D365 data structures, entities, and integration points preferred
• Extreme attention to detail and accuracy a must
• Excellent verbal/written communication skills required
• Experience with accounting terms and concepts preferred
• Experience with R language preferred

Responsibilities

• Elicit data related business requirements from stakeholders and develop or approve associated technical specifications
• Contribute to the development of standard methods and best practices for the transformation and preparation of data for reporting, analytics, and self-service activities
• Apply advanced statistical techniques and predictive models to drive strategic decision-making
• Leverage and enhance the Enterprise Data Model to deliver value to the organization
• Develop and deliver secured, robust data models to business users
• Work with stakeholders to develop new metrics, KPIs, Reports, and Dashboards
• Provide advice to departments and stakeholders on the usage, interpretation, and analytic value of business data
• Lead cross-functional teams and collaborate with various departments to support data-driven initiatives
• Participate in discipline related internal and external project communication and coordination
• Ensure the accuracy, completeness, and reliability of data used for analysis
• Adhere to data protection regulations and ensure confidentiality of sensitive information
• Apply data team best practices regarding documentation, access, and security
• Mentor junior data analysts and contribute to their professional growth within the organization
• Explore and recommend new data technologies and analytical tools to enhance business insights
• Set and execute professional development goals to keep abreast of emerging technologies, services, and methods
• Travel as required for project development and execution