Summary
Seeking an experienced Data Engineer responsible for designing, developing, and maintaining data pipelines that support business intelligence, reporting, and analytics initiatives across the organization. The ideal candidate will have a strong background in SQL development, Oracle databases, ETL/ELT processes, and data warehousing. This position will work closely with business intelligence teams, analysts, and internal stakeholders to ensure data is accurate, reliable, and accessible for reporting and business decision-making.
Responsibilities
- Design, develop, and maintain ETL/ELT processes to extract, transform, and load data from multiple source systems into a centralized data warehouse.
- Build and optimize data pipelines to improve performance, reliability, and scalability.
- Develop, troubleshoot, and optimize complex SQL queries, stored procedures, and database scripts.
- Monitor existing ETL jobs and data loads, identifying and resolving failures, performance issues, and data discrepancies.
- Collaborate with BI developers, analysts, and business stakeholders to translate reporting and data requirements into technical solutions.
- Maintain data quality, integrity, and consistency through validation, error handling, and logging.
- Support data warehouse architecture, data integration, and dimensional modeling initiatives.
- Document data flows, transformation logic, and technical processes.
- Participate in code reviews and follow established development, testing, and change management practices.
- Identify opportunities to improve data processing efficiency and overall data reliability.
Qualifications
- 5+ years of experience in data engineering, ETL development, database development, or a related role.
- Strong hands-on experience writing, optimizing, and troubleshooting complex SQL queries.
- Professional experience working with Oracle databases.
- Solid understanding of ETL/ELT methodologies, data warehousing concepts, and data integration best practices.
- Experience developing and maintaining reliable data pipelines across multiple source systems.
- Ability to independently troubleshoot data discrepancies, performance issues, and pipeline failures.
- Strong analytical, problem-solving, and communication skills with attention to data accuracy and quality.
- Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent professional experience.
- Experience with WhereScape RED or TimeXtender is highly preferred.
- Experience with Microsoft Dynamics 365 Finance & Operations (F&O), Microsoft Fabric, Lakehouse architecture, or Dataverse is a plus.
- Database administration (DBA) experience is a plus.
- Familiarity with dimensional data modeling, including star and snowflake schemas.
- Experience with ETL and data integration tools such as SSIS or Informatica.
- Exposure to Power BI or similar business intelligence platforms.
- Previous experience in manufacturing, industrial, or related environments is preferred.