Senior Data Engineer - Enterprise Analytics & Pipelines

Company Description CRB's over 1,100 expert professionals drive innovative, life-changing and life-saving solutions for manufacturers in the life sciences and food and beverage industries. Our mission, vision, and core values put client satisfaction and employee experience at the center of everything we do. As an AEC Firm we proudly specialize in industries that inherently carry important social responsibility - we recognize our impact and influence in the communities we serve and pursue corporate responsibility through the lens of people, community, and planet. From oncology and rare disorders to COVID-19 or alternative proteins, our design and construction projects are pioneering solutions addressing important issues such as food scarcity and global health. 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 toassistin delivering on our internal data and business intelligence initiatives. The successful candidate mustpossessthe skillsrequiredto 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,largeor long duration projects. In addition to project work, this individual will work with peers toassistin 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 tofacilitatewarehousing 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 datateambest practicesregardingdocumentation, access, and security. Participate in disciplinerelatedinternal 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 andparticipatein 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 adoptnew technologiesand 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 complianceofdata protection regulations and ensure confidentiality of sensitive information. Mentor junior data engineers and contribute to their professional growth within the organization. Travel asrequiredfor 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. Experienceleveragingmedallion architecture design patterns. Proficiencyusing Azure Gen2 Storage, Synapse, Fabric, Spark Notebooks, REST API’s, Databricks and related technologies. Expertproficiencyin Data Warehousing methodologies and concepts to store and model the data (Kimball). Expertproficiencyauthoring SQL queries, tables, views, stored procedures, and functions. Experience using software development management tools such as Azure DevOps. Experience using Python and PowerShellrequired. 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 ofD365 data structures, entities, and integration points preferred. Experience with R language preferred. Extreme attention to detail and accuracya must. Excellent verbal/written communication skillsrequired. Comfortable working and collaborating within a fully remote team. Microsoft DP-203 Certification is a plus. Additional Information All your information will be kept confidential according to EEO guidelines. CRB is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity Employer and it is our policy to provide equal opportunity to all people without regard to race, color, religion, national origin, ancestry, marital status, veteran status, age, disability, pregnancy, genetic information, citizenship status, sex, sexual orientation, gender identity or any other legally protected category. Employment is contingent on background screening. CRB does not accept unsolicited resumes from search firms or agencies. Any resume submitted to any employee of CRB without a prior written search agreement will be considered unsolicited and the property of CRB. Please, no phone calls or emails. CRB offers a complete and competitive benefit package designed to meet individual and family needs. If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process. #J-18808-Ljbffr