Data Engineer

Opening / Selling Statement

The 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; Azure

Job Duties Design develop and maintain ETL processes using Talend SQL Python and other tools
Work autonomously while still delivering expected results
Analyze and reverse engineer existing solutions when required and redevelop using industrystandard best practices
Write and optimize SQL queries and stored procedures for data transformation and analysis
Work with Azure cloud services such as Azure SQL Database to design and implement modern data warehouse architectures
Collaborate with data analysts and business users to understand data requirements and assist in data modeling
Ensure the quality and integrity of data through testing and debugging of ETL processes
Document ETL processes and maintain EDW documentation
Validate ETL jobs are working as intended prior to releasing to the business for use
Resolve user support issues for BI pipelines via Orchids ticketing system
Stay informed on data technology trends and provide recommendations for future actions
Serve as a technology liaison and provide expert evaluation regarding potential external data tools and applications for consideration
Travel occasionally to Orchid locations as necessary.
Participate in afterhours support for the production environment including oncall support. This will include supporting upgrades or troubleshooting activities that must take place outside business hours.
Maintain and review security policies

Job Requirements Experience with cloud systems data modeling and data warehousing
ETL design experience
SQL optimization experience
SQL Server or Azure SQL
Azure cloud
Talend
Python
Excellent documentation skills
Excellent written/verbal communication skills

Desired Skills & Experience DBA experience
Experience using ERP software
Experience with SaaS systems such as: Salesforce WorkDay OneStream EtQ QMS or ComplianceWIre
Familiarity with agile development methodologies and tools (e.g. Jira)
Medical device manufacturing domain experience