SHIFTNo Shift ($0) (United States of America)
A BRIEF OVERVIEW
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. The Lead Engineer, IT will reports to the Manager of Business Intelligence and works closely with other IT staff, business users, and the Applications Development team to deliver business tools.
WHAT YOU WILL DO
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 re-develop using industry-standard 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 Orchid's 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 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 hours.
Maintain and review security policies
EDUCATION QUALIFICATIONS
Associates (Required)
EXPERIENCE QUALIFICATIONS
2+ years of experience in ETL development, with a strong focus on modern data warehouse modeling solutions (Required)
Experience with cloud systems, data modeling, and data warehousing (Required)
Experience using ERP software (Preferred)
Experience with SaaS systems such as: Salesforce, WorkDay, OneStream, EtQ, QMS, or ComplianceWIre (Preferred)
Familiarity with agile development methodologies and tools (e.g. Jira) (Preferred)
KNOWLEDGE & SKILLS THAT ENABLE SUCCESS
Managing Multiple Priorities - Working Experience
IT Industry: Trends & Directions - Working Experience
Interpersonal Communication - Basic Knowledge
Programming - Extensive Experience
Problem Solving - Working Experience
Communication - Basic Knowledge
Decision Making and Critical Thinking - Working Experience
Accuracy and Attention to Detail - Working Experience
Statistical Analysis and Measurement - Working Experience
IT Servers and Networks - Basic Knowledge
IT Standards, Procedures, & Policies - Working Experience
PHYSICAL DEMANDS
Must be able to remain in a stationary position - Constantly
Must be able to communicate and exchange information with others - Frequently
Must be able to distinguish and detect information such as writing and defects - Constantly
PAY RATE
For positions located in California, pay for this job type falls within the following range and varies based on scope and complexity of job responsibilities.$83,700.00 - $125,600.00
WHAT WE OFFER
Opportunity to work in a growing company
Ability to help people live a longer, more active life
Comprehensive benefit package
Ability to work in an organization that values:
Integrity First: We do the right thing
Teamwork: We are one Orchid
Results: Our results matter
ADDITIONAL REQUIREMENTS
Candidates offered employment may be required to submit to a pre-employment background check and pre-employment drug-screening based on position requirements
Candidates must be able to provide proof of eligibility to work in the United States through eVerify
At Orchid, we fully support a diverse and inclusive workplace and we are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to, among other things, race, color, religion, sex, sexual orientation, gender identity, national origin, hair type, age, status as a protected veteran, or disability.
Orchid Orthopedic Solutions only pays fees for solicited presentations of job seekers submitted through our preferred vendor job board by recruiters, employment agencies, or other parties.
EOE, including disability/vets.