Senior Data Analyst

Crb - Cary, NC

Full-time - Mid Level

Cary, NC

1,001-5,000 employees

Machinery Manufacturing

About the position

The Senior Data Analyst at CRB is responsible for driving data and business intelligence initiatives within the organization. This role requires a proactive and organized individual with advanced knowledge of data reporting and analytics tools. The analyst will work on multiple projects, collaborating with stakeholders to develop metrics, reports, and dashboards, while ensuring data accuracy and compliance with regulations. Additionally, the position involves mentoring junior analysts and exploring new data technologies to enhance business insights.

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

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

Nice-to-haves

• Experience with other languages, such as C#, VB, PowerShell, Python
• Familiarity with D365 ERP modules (e.g., Finance and Operations, Customer Engagement)
• Understanding of D365 data structures, entities, and integration points
• Experience with accounting terms and concepts
• Experience with R language

Benefits

• Complete and competitive benefit package designed to meet individual and family needs