Data Engineer, IT

Orchid Orthopedic Solutions
Mason, MI
Job Type
Junior, Senior level

Job Description


No Shift ($0) (United States of America)

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.


  • 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


  • Associates (Required)


  • 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)


  • 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


  • 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


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


  • 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


  • 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.

Ref #
21 days ago
Last updated 18 days ago

Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.