Lead Engineer, ITThe Lead Engineer, IT builds and maintains our data pipelines. They utilize modern data warehouse modeling and tools, particularly Talend, Azure data warehouse, and SQL. Additionally, the ideal candidate will have SQL Server or Azure SQL and Azure Cloud experience.
The Lead Engineer, IT will report to the Manager of Business Intelligence and works closely with other IT staff, business users, and the Applications Development team to deliver business tools.Required Skills: Data Warehouse; Data Modeling; SQL; AzureJob Duties:Design, develop, and maintain ETL processes using Talend, SQL, Python, and other toolsWork autonomously while still delivering expected resultsAnalyze and reverse engineer existing solutions when required, and re-develop using industry-standard best practicesWrite and optimize SQL queries and stored procedures for data transformation and analysisWork with Azure cloud services such as Azure SQL Database to design and implement modern data warehouse architecturesCollaborate with data analysts and business users to understand data requirements and assist in data modelingEnsure the quality and integrity of data through testing and debugging of ETL processesDocument ETL processes and maintain EDW documentationValidate ETL jobs are working as intended prior to releasing to the business for useResolve user support issues for BI pipelines via Orchid’s ticketing systemStay informed on data technology trends and provide recommendations for future actionsServe as a technology liaison and provide expert evaluation regarding potential external data tools and applications for considerationTravel occasionally to Orchid locations as necessaryParticipate in after-hours support for the production environment, including on-call support. This will include supporting upgrades or troubleshooting activities that must take place outside business hoursMaintain and review security policiesJob Requirements:Experience with cloud systems, data modeling, and data warehousingETL design experienceSQL optimization experienceSQL Server or Azure SQLAzure cloudTalendPythonExcellent documentation skillsExcellent written/verbal communication skills