Devoir Software Solutions - Lead Data Warehouse Developer - ETL

Description :

Role Summary :

The Data Warehouse and ETL Developer is responsible for the architecture, development, and maintenance of the enterprise data warehouse. This role focuses on building high-performance data pipelines using Talend, optimizing MS SQL Server environments, and ensuring seamless data flow between QAD (ERP) and Salesforce (CRM) using Open Query and API-driven integrations.

Key Technical Responsibilities :

Data Warehousing & Modeling :

- Warehouse Architecture : Design and maintain scalable data warehouse structures (Star and Snowflake schemas) to support company-wide analytics.

- SQL Development : Write and optimize advanced T-SQL, including complex window functions and CTEs, to transform raw ERP data into actionable insights.

- Database Optimization : Manage indexing, partitioning, and execution plan analysis to ensure the data warehouse performs efficiently as data volume grows.

- Legacy Connectivity : Expertly utilize Open Query to extract data from Progress-based QAD/Mfg./Pro environments into SQL Server.

ETL & Integration Development :

- Talend Pipelines : Design, develop, and deploy Talend ETL jobs to automate the extraction, transformation, and loading of data from disparate sources.

- System Synchronization : Build and monitor critical integrations between QAD and Salesforce, ensuring customer, order, and inventory data remains synchronized.

- API Integration : Develop Talend workflows that utilize REST/SOAP APIs to push and pull data from cloud-based platforms like Salesforce.

- Error Handling : Implement robust logging and alerting frameworks within Talend to proactively identify and resolve data discrepancies.

Data Governance & Quality :

- Data Cleansing : Develop automated scripts to identify and correct "dirty" data, ensuring high-quality inputs for Power BI dashboards.

- Documentation : Maintain detailed data lineage documentation, mapping source-to-target transformations for compliance and audit purposes.

- Core Stack : 6+ years of experience with MS SQL Server and Talend (Open Studio or Data Management Platform).

- ERP/CRM Expertise : Strong functional understanding of QAD (Mfg /Pro) and Salesforce objects/tables.

- Technical : High proficiency in T-SQL, Open Query, Linked Servers, and JSON/XML data parsing.

- Environment : Experience working in a Medical Device or manufacturing environment is highly preferred.

- Problem Solving : Ability to troubleshoot complex data bottlenecks in a fast-paced, production-critical environment.

Education and Experience :

- Bachelors degree in computer science, Data Science, or Information Technology.

- 5-7+ years of dedicated experience in ETL development and Data Warehousing.