Legrand AV
Data Engineer
Legrand AV, Saint Paul, Minnesota, United States, 55199
Thank you for your interest in becoming part of the team at Legrand!GENERAL PURPOSE
Business Intelligence & Performance team at Legrand AV manages and delivers insights about company data so our executive-level stakeholders and businesses to make informed decisions. We are seeking a mid-senior level highly skilled and experienced Data Engineer to join our team. As a Data Engineer, you will play a critical role in developing and maintaining our data analytics infrastructure and data warehouse architecture. You will collaborate with cross-functional teams to design, build, and optimize data pipelines, ensuring the availability, reliability, and efficiency of our data ecosystem.Responsibilities
Act as the primary contact for everything related to the data integration and data warehouse.Design, develop, and maintain scalable and efficient data pipelines and ETL processes to extract, transform, and load data from various sources into our reporting database/data warehouse.Build a framework of repeatable solutions and playbooks enabling efficient and predictable data pipelines.Have hands-on development experience in the implementation of an agile, cloud centric data warehousing and reporting platform.Collaborate with stakeholders to understand data requirements and translate them into technical specifications and solutions.Implement data models, database schemas, and data transformation logic to support efficient data storage, retrieval, and analysis with proper data warehouse model and architecture.Perform data cleansing, data quality assurance, and data validation to ensure accuracy and reliability of the data and outcomes.Optimize data infrastructure, query performance, and data processing workflows to improve overall system efficiency and speed.Work closely with data analysts and BI developers to provide them with reliable data for ingestion, analysis, and reporting purposes.Ensure data security, privacy, and compliance with relevant regulations and best practices.Monitor and troubleshoot data pipeline issues, resolve data-related anomalies, and perform root cause analysis.Stay updated with industry trends, emerging technologies, and best practices in data engineering, data analytics, and data warehouse architecture.Maintain query performance and tuning to ensure cost optimization.Requirements
Proven experience as a Data Engineer, working with large-scale data pipelines, data warehouse architecture, and ETL processes.Solid understanding of data warehouse concepts, dimensional modeling, and schema design principles.Experience with Microsoft Azure cloud computing platforms and services.Experience with Azure data integration and orchestration tools, such as Data Factory, Databricks, or Synapse Analytics, for building end-to-end data pipelines or similar tools and technologies.Knowledge of Azure analytics services like Azure Analysis Services, Azure Machine Learning, or Azure Data Explorer for advanced data analytics and insights or similar tools and technologies.Familiarity with Azure DevOps or similar CI/CD tools for managing and deploying data integration code.Strong analytical and problem-solving skills with attention to detail.Excellent communication and collaboration skills to work effectively within cross-functional teams.Minimum Education And Experience Required
Bachelor's degree in Computer Science, Information Systems, or related field. Equivalent work experience will be considered.5+ years developing Data Pipelines / Flows using ETL/ELT tools and technologies.3+ years’ experience with a cloud data lake/warehouse solution (SQL Server, Snowflake, Databricks, Azure Data Warehouse, etc.). Hands-on experience working with data integration tools like SSIS, Data Factory, Matillion, and Informatica.3+ years building complex Analytics and Reporting solutions such as Power BI, Tableau, Looker, etc.Special Job Requirements
Must be available for extended, varied work hours at times.WORKING CONDITIONS/PHYSICAL DEMANDS
While performing the duties of this job, the employee is regularly required to sit and make coordinated movements of the fingers for data entry on a keyboard.General office environment.May require regular ground travel to other company facilities within local metropolitan area.Long-distance or air travel as needed – approximately 5% travel.Note: Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.Legrand is proud to be an Equal Opportunity Employer. You will be considered for this position based upon your experience and education, without regard to race, color, religion, age, sex, national origin, sexual orientation, ancestry; marital, disabled or veteran status. We are committed to creating and maintaining a workforce environment that is free from any form of discrimination or harassment.If you'd like to work in a fun, creative, business-casual environment that offers a comprehensive benefit package, we encourage you to apply!For California residents, please see the link for the Privacy Notice for Candidates. California law requires that we provide you this notice about the collection and use of your personal information.
#J-18808-Ljbffr
Business Intelligence & Performance team at Legrand AV manages and delivers insights about company data so our executive-level stakeholders and businesses to make informed decisions. We are seeking a mid-senior level highly skilled and experienced Data Engineer to join our team. As a Data Engineer, you will play a critical role in developing and maintaining our data analytics infrastructure and data warehouse architecture. You will collaborate with cross-functional teams to design, build, and optimize data pipelines, ensuring the availability, reliability, and efficiency of our data ecosystem.Responsibilities
Act as the primary contact for everything related to the data integration and data warehouse.Design, develop, and maintain scalable and efficient data pipelines and ETL processes to extract, transform, and load data from various sources into our reporting database/data warehouse.Build a framework of repeatable solutions and playbooks enabling efficient and predictable data pipelines.Have hands-on development experience in the implementation of an agile, cloud centric data warehousing and reporting platform.Collaborate with stakeholders to understand data requirements and translate them into technical specifications and solutions.Implement data models, database schemas, and data transformation logic to support efficient data storage, retrieval, and analysis with proper data warehouse model and architecture.Perform data cleansing, data quality assurance, and data validation to ensure accuracy and reliability of the data and outcomes.Optimize data infrastructure, query performance, and data processing workflows to improve overall system efficiency and speed.Work closely with data analysts and BI developers to provide them with reliable data for ingestion, analysis, and reporting purposes.Ensure data security, privacy, and compliance with relevant regulations and best practices.Monitor and troubleshoot data pipeline issues, resolve data-related anomalies, and perform root cause analysis.Stay updated with industry trends, emerging technologies, and best practices in data engineering, data analytics, and data warehouse architecture.Maintain query performance and tuning to ensure cost optimization.Requirements
Proven experience as a Data Engineer, working with large-scale data pipelines, data warehouse architecture, and ETL processes.Solid understanding of data warehouse concepts, dimensional modeling, and schema design principles.Experience with Microsoft Azure cloud computing platforms and services.Experience with Azure data integration and orchestration tools, such as Data Factory, Databricks, or Synapse Analytics, for building end-to-end data pipelines or similar tools and technologies.Knowledge of Azure analytics services like Azure Analysis Services, Azure Machine Learning, or Azure Data Explorer for advanced data analytics and insights or similar tools and technologies.Familiarity with Azure DevOps or similar CI/CD tools for managing and deploying data integration code.Strong analytical and problem-solving skills with attention to detail.Excellent communication and collaboration skills to work effectively within cross-functional teams.Minimum Education And Experience Required
Bachelor's degree in Computer Science, Information Systems, or related field. Equivalent work experience will be considered.5+ years developing Data Pipelines / Flows using ETL/ELT tools and technologies.3+ years’ experience with a cloud data lake/warehouse solution (SQL Server, Snowflake, Databricks, Azure Data Warehouse, etc.). Hands-on experience working with data integration tools like SSIS, Data Factory, Matillion, and Informatica.3+ years building complex Analytics and Reporting solutions such as Power BI, Tableau, Looker, etc.Special Job Requirements
Must be available for extended, varied work hours at times.WORKING CONDITIONS/PHYSICAL DEMANDS
While performing the duties of this job, the employee is regularly required to sit and make coordinated movements of the fingers for data entry on a keyboard.General office environment.May require regular ground travel to other company facilities within local metropolitan area.Long-distance or air travel as needed – approximately 5% travel.Note: Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.Legrand is proud to be an Equal Opportunity Employer. You will be considered for this position based upon your experience and education, without regard to race, color, religion, age, sex, national origin, sexual orientation, ancestry; marital, disabled or veteran status. We are committed to creating and maintaining a workforce environment that is free from any form of discrimination or harassment.If you'd like to work in a fun, creative, business-casual environment that offers a comprehensive benefit package, we encourage you to apply!For California residents, please see the link for the Privacy Notice for Candidates. California law requires that we provide you this notice about the collection and use of your personal information.
#J-18808-Ljbffr