[Hiring] Senior Data Engineer @CRB

Role Description

CRB is looking for an energetic, self-motivated, pro-active, organized, and well-rounded individual that has a good understanding of Microsoft’s data, reporting, and business intelligence tools to assist in delivering on our internal data and business intelligence initiatives.

• The successful candidate must possess the skills required to successfully execute project tasks, have a strong work ethic, and be a dynamic team player.
• This person will be expected to plan and execute multiple, simultaneous, large or long duration projects.
• Work with peers to assist in the identification, planning, and delivery of strategic infrastructure and analytical capabilities that will provide actionable information to the business.
• Elicit data related business requirements from stakeholders and develop or approve associated technical specifications.
• Design, implement, and maintain ETL processes to facilitate warehousing and systems integration needs.
• Develop and enhance data models to deliver value to the organization.
• Maintain, monitor, optimize, and troubleshoot/resolve issues with existing processes.
• Contribute to the development of standard methods and best practices for the transformation and preparation of data for reporting, analytics, and self-service activities.
• Contribute to reporting and visualization projects as needed.
• Apply data team best practices regarding documentation, access, and security.
• Participate in discipline related internal and external project communication and coordination.
• Implement data quality checks and validation processes.
• Incorporate data classification into ETL processes and data masking techniques to ensure model security.
• Elicit and participate in code reviews with other members of the team.
• Ensure the accuracy, completeness, and reliability of data used for analysis.
• Design and implement robust data architectures to support scalable and maintainable data pipelines.
• Research and adopt new technologies and methodologies to keep the data infrastructure modern and efficient.
• Develop strategies for integrating data from disparate sources into a cohesive and comprehensive data ecosystem.
• Automate data processes to improve efficiency and reduce manual intervention.
• Ensure compliance of data protection regulations and ensure confidentiality of sensitive information.
• Mentor junior data engineers and contribute to their professional growth within the organization.
• Travel as required for project development and execution.

Qualifications

• Bachelor’s Degree or equivalent experience.
• 7+ years of experience working with Microsoft SQL databases and warehousing tools, including SQL Server, Azure SQL, and Synapse SQL.
• 7+ years of experience developing ETL processes using Microsoft technologies, such as SSIS, Azure Data Factory, Azure Synapse Analytics, and Microsoft Fabric.
• 7+ years’ experience developing Microsoft Analysis Services Tabular, Power BI, or Fabric semantic data models.
• Experience leveraging medallion architecture design patterns.
• Proficiency using Azure Gen2 Storage, Synapse, Fabric, Spark Notebooks, REST APIs, Databricks and related 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.
• Experience using software development management tools such as Azure DevOps.
• Experience using Python and PowerShell required.
• Experience with provisioning data related resources and components in Azure preferred.
• Experience with Redgate Monitoring or Azure Log Analytics 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.
• Experience with R language preferred.
• Extreme attention to detail and accuracy a must.
• Excellent verbal/written communication skills required.
• Comfortable working and collaborating within a fully remote team.
• Microsoft DP-700 Certification is a plus.

Benefits

• CRB offers a complete and competitive benefit package designed to meet individual and family needs.