What We’re Seeking:
E.A. Sween Company is seeking an experienced Data Engineer II to enhance our data infrastructure and contribute to strategic data initiatives. As a Data Engineer II, you will play a pivotal role in designing, building, and maintaining advanced data pipelines and systems that support the growing needs of our organization. This role demands technical expertise and leadership qualities, as you will work closely with business and technology teams to create scalable and reliable data solutions. Experience with Power BI, SQL Server, Azure, and JD Edwards are essential to integrate and visualize data across the organization effectively.
What You’ll Do (Responsibilities):
- Lead the design, development, and optimization of large-scale data pipelines and data infrastructure.
- Collaborate with business intelligence, analytics, and engineering teams to define, implement, and provide training on data solutions.
- Develop and maintain ETL processes, ensuring high-quality data flow across systems and databases, including JD Edwards for ERP data integration.
- Implement data governance and security best practices to ensure data integrity and privacy.
- Automate data workflows and integrate new data sources and technologies into the existing architecture.
- Perform data profiling, validation, and cleaning to ensure the highest quality of data.
- Troubleshoot and resolve complex data-related issues, providing solutions and guidance to junior engineers.
- Leverage Power BI and other BI solutions to design and implement advanced reporting and dashboard solutions for internal stakeholders.
- Continuously optimize data pipelines to improve efficiency and reduce latency.
- Mentor and provide guidance to junior data engineers, offering technical expertise and support.
- Create and maintain technical documentation for processes, data models, and systems.
- Collaborate with data architects and senior engineers to ensure scalable and sustainable data infrastructure.
- Implement data validation techniques to ensure data quality and consistency across various sources and platforms.
- Collaborate across the IT team while providing support beyond core role-specific responsibilities, taking on tasks as needed to contribute to the broader success of team initiatives.
What You’ll Need (Qualifications):
- Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field (Master’s degree is a plus).
- At least 3-5 years of experience in data engineering or a related technical role.
- Strong proficiency in Python, Java, SQL, and other programming languages used in data engineering.
- Extensive experience with JD Edwards, particularly in extracting and transforming ERP data.
- Strong experience with Power BI for business intelligence, reporting, and dashboard development.
- Advanced knowledge of ETL processes, data integration, and pipeline automation.
- Experience with data warehousing, data lakes, and real-time data streaming.
- Proven track record of solving complex data problems and implementing scalable solutions.
- Excellent analytical and problem-solving skills with the ability to think critically.
- Strong communication and interpersonal skills to work across teams and manage expectations.
- Ability to mentor and guide junior team members, fostering a collaborative work environment.
Physical Aspects of the Job:
- Office setting with standard office equipment (computer, monitor, keyboard, mouse).
- Sitting for long periods while working at a desk or computer.
- Bending, stretching, or reaching to access office supplies or equipment.
- Prolonged periods of focusing on computer screens, requiring detailed analysis and problem-solving.
- Occasional travel for project collaboration, training, and conferences, with the ability to manage travel logistics and adapt to new work environments, up to 20%.
- Flexible work hours may be required to meet deadlines or address urgent data needs.
