Enterprise Data Engineer
Coleto Brands, the parent company of Progress Lighting and Kichler, is seeking a highly skilled Enterprise Data Engineer with a passion for building robust data systems. This individual will have a deep understanding of data governance and analytics, playing a crucial role in shaping the future of our data infrastructure.
The ideal candidate is dedicated to delivering results on time and according to plan, ensuring seamless collaboration across teams.
Duties and Responsibilities:
* Designing, building, and maintaining the organization's data infrastructure.
* Developing and managing data pipelines, processes, and SAP Datasphere warehouse supplying the SAP Analytics Cloud platform.
* Collaborating with data analysts, technology, and business team members, reporting to the manager of Data Analytics to meet specific data needs across the enterprise.
* Participating in the full lifecycle of data analytics projects, from requirements gathering and design to development, testing, and deployment.
* Designing, developing, and maintaining data warehouses to store and organize large datasets for analysis and reporting.
* Architecting and building scalable data pipelines to move data between different systems, including data warehouses, cloud-based, and on-premises software applications, and analytics tools.
* Extracting data from diverse sources (databases, APIs, applications) and implementing efficient data ingestion processes (ETL processes and CDS views).
* Cleaning, standardizing, and transforming raw data into a usable format for analysis, including data validation and quality checks (ETL processes).
* Creating data models to represent relationships between data entities, ensuring data consistency and accessibility based on business requirements.
* Monitoring data quality, identifying, and resolving data inconsistencies, and implementing data quality checks throughout the pipeline.
* Monitoring and optimizing data pipelines for efficiency and performance, including query optimization and data compression.
* Ensuring enterprise compliance with data privacy regulations and implementing appropriate data security measures and access controls.
* Working closely with data analysts and business users to understand their data needs and translating them into technical requirements.
* Partnering and communicating effectively across departments, data stewards, business, and IT stakeholders' data governance objectives, policies, and practices.
* Collaborating with cross-functional teams to understand data needs, communicate data insights, and address data-related challenges.
* Staying updated on emerging data analytics tools, technologies, and SAP, recommending, and implementing new solutions to enhance data analysis capabilities.
* Performing other related duties necessary to conduct job objectives in an efficient and effective manner.
* Providing support for internal and external financial audits.
Skills and Experience:
* Strong proficiency in data warehousing technologies and creating ETL (Extract, Transform, Load) processes within Datasphere and CDS views for SAP Analytics Cloud.
* Deep understanding of data governance principles, data quality methodologies, data lifecycle management.
* Excellent ability to communicate complex data concepts to non-technical stakeholders, influence, and drive decision-making, as well as lead teams.
* Expertise in relational database management systems and capability to design and implement data models for efficient data storage and retrieval.
* An understanding of business processes and how data can be leveraged to meet financial, operational, and strategic goals.
* Proven experience in data management roles, with experience managing large, complex, and diverse datasets from multiple data sources, including real-time streaming data.
* 5+ years of experience in data governance, data management, or related fields.
* 3+ years of experience with cloud platforms such as SAP Analytics Cloud, Datasphere, S4/HANA (public cloud preferred), and BTP.
* Bachelor's degree in information management, data science, statistics, engineering, computer science, business administration, or similar field of study, or equivalent relevant work experience.
* Preferred qualifications include:
o Master's degree in business administration (MBA) with a concentration in data analytics, data science, or a master's degree in a related field.
o Certified Data Management professional (CDMP) and/or Certified Analytics Professional (CAP).
Travel requirements: 5% of time.
The applicant must be authorized to work for any employer in the U.S. Sponsorship of an employment Visa is not possible at this time.