Senior Data Engineer

Company Description

CRB is a leading provider of sustainable engineering, architecture, construction and consulting solutions to the global life sciences and food and beverage industries. Our more than 1,600 employees provide best-in-class solutions that drive success and positive change for our clients, our people and our communities. CRB is a privately held company with a rich history of serving clients throughout the world, consistently striving for the highest standard of technical knowledge, creativity and execution.

Job 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. In addition to project work, this individual will 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.

Remote work options may be considered

Responsibilities

· 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 API’s, 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