Energizer Senior Data Engineer in Saint Louis, Missouri
This is Energizer Holdings, Inc.
Energizer Holdings responsibly creates products to make lives easier and more enjoyable. To do this, we lean into our culture as an organization – we win together, while serving each other, with a willingness to act boldly, all while doing right. Our colleagues hail from all backgrounds, nationalities and walks of life, but our shared mission and purpose make us one team. Because we’re a global organization, you will always have opportunities to learn, grow and develop in your career. We support flexible working arrangements wherever possible.
The Senior Data Engineer is a key role to advance Energizer’s analytics-driven business strategy. The role requires a highly motivated developer who thrives on learning new skills and developing value-add data products for business partners, data scientists and analysts. The Senior Data Engineer will be responsible for the design, technical build and support for data pipelines (ETL/ELT), curated data zones, data models and published data sets. The position will collaborate closely with data architects, business analysts and data scientists to gather requirements, acquire new datasets and build transformations to support a variety of projects, enhancements and functional areas. Ensuring data for solutions are highly available, consistent and optimized for delivery to data consumers will also be a key part of the role.
70% - Reporting, Analytics, and Data Engineering: Key member of a team that develops and supports Energizer’s analytics suite of reports, dashboards, and data engineering applications.
15% - Program Management: Participates in aligning program resources and priorities. Serves on project teams representing the data engineering function, ensuring consulting partners follow development guidelines and report status items.
5% - Communication: Develops and presents to multiple levels of departmental leadership, cross-functional groups, peers, and functional groups of associates in support of projects and initiatives.
5% - Coaching and Development: Communicates effectively as a team member to develop technical skills and competencies on the team and at Energizer overall.
5% - Strategic Planning: Participates in the development and maintenance of mid to long-range strategic road maps.
Gather requirements, build, test and deploy solutions that require:
Acquisition of data from various internal and external sources
Storage and staging of data through various stages of transformation
Modeling of data to meet various business needs in line with overall data strategy
Delivery of data to satisfy reporting, analytics and data science requirements
Work with data analytics/science colleagues and project teams to operationalize ML models and deploy into the production landscape.
Build and deploy pipelines, transformations and data flows that are reliable, optimized and can be rerun quickly and efficiently as required
Perform root cause analysis on external and internal processes and data to identify opportunities for improvement and respond to inquires on data
Work closely with subject matter experts and business stakeholders to identify, design, and develop efficient and high-quality data pipelines and models.
Participate in the development of strategy and continuous improvement of data engineering solutions that enable high quality certified data sets, curated zones of data for analytics, and published data to other business consumers.
Build processes that support data transformation, workload management, data structures, dependency and metadata
Follow and leverage CI/CD processes and proper release management of new features and capabilities.
Follow established change management practices to ensure availability, performance and reliability of systems impacted by the change
Ensure data engineering deliverables are operational per predefined SLAs.
Required Skills and Experience
5+ years of experience in database/SQL development and performance tuning, with strong expertise in Microsoft SQL Server (on-prem or cloud) and related products (SSIS, SSAS, SSRS, PowerBI).
5+ years of relevant experience with detailed knowledge of data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools.
2+ years of experience developing data analytics/engineering solution in cloud-based platforms (Azure, Google or AWS)
Experience working on CI/CD processes such as Azure DevOps, Jenkins, etc. and source control tools such as GitHub, etc.
Bachelor's Degree in Computer Science, Engineering, or equivalent work experience.
Preferred Skills and Experience
Microsoft Azure experience (Azure Synapse, Azure Data Factory)
Strong experience (both knowledge and skills) in coding languages like Python
Experience working with Big Data file formats (such as: Parquet, Avro, or Delta Lake)
Experience working in Big Data Distributed ecosystems (such as: Hadoop, SPARK, Hive or Delta Lake)
Experience building solutions in PowerBI
Strong business understanding (sales, supply chain, operations, and/or finance)
Strong understanding of database technologies and management systems.
Strong understanding of data structures and algorithms
Working Relationships & Environment
- Key relationships internally will include business partners, analysts, architects and PowerBI developers as well as other members of the Enterprise Data and Analytics team.
Come Join Us!
Energizer offers a competitive total rewards package which includes a range of health, well-being and retirement savings coverage, paid time off and holidays, and many opportunities to learn, develop and grow. At Energizer, you’ll have the opportunity to contribute and make an impact every single day.