Lead ETL Engineer

2 weeks ago

Mason, United States Procom Full time

Our client is adding a Lead ETL Engineer that will build and maintain the corporate data pipelines. This role will utilize modern data warehouse modeling and tools, particularly Talend, Azure data warehouse, and SQL. The Lead ETL Engineer will report to the Manager of Business Intelligence and work closely with other IT staff, business users, and the Applications Development team to deliver business tools and accurate, efficient data flows.

Day to day duties

  • Design, develop, and maintain ETL processes using Talend, SQL, Python, and other tools
  • Work autonomously while still delivering on timeline and quality
  • Analyze and reverse engineer existing solutions, and re-develop using industry-standard best practices
  • Write and optimize SQL queries (hand written) 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 users
  • Resolve user support issues for BI pipelines
  • Serve as a technology liaison remaining informed on data technology trends and provide expert evaluation regarding potential external data tools and applications for consideration
  • Participate in after-hours support (2 days a month) 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
Must have skill/experience:
  • 2+ years of experience in ETL development, with a strong focus on modern data warehouse modeling solutions
  • Experience with Azure cloud systems including Azure Data Factory, strong data modeling and data warehousing experience.
  • Experience\u00A0with Talend and SQL including handwritten queries and stored\u00A0procedures
  • Experience/exposure using and directing data flows to/from ERP software and 3rd party systems to API level.
  • Experience with SaaS systems such as: Salesforce, WorkDay, OneStream, EtQ, QMS, ComplianceWIre or other SaaS systems for data processing
  • Familiarity with agile development methodologies and tools (e.g. Jira)
Nice to have skills:
  • SAP HANA and Data Warehouse experience\u00A0
  • Specific ERP Module experience (Finance, Supply chain etc)
  • API experience parsing JSON
  • Experience with Azure Data Vault and other IT security systems

  • Lead, Electrical Engineering

    6 days ago

    Mason, United States L3Harris Technologies Full time

    This Lead Electrical Engineering position will be responsible for leading a growing and diverse team of Engineers working on projects requiring architect receivers, transmitters, transceivers and transponders used on satellites, orbital vehicles, and Electrical Engineer, Design, Engineer, Electrical, Technology, Business Services

  • Lead, Systems Engineering

    3 weeks ago

    Mason, United States L3Harris Technologies Full time

    Job Title: Lead, Systems Engineering - Test Engineer Job Code: 780 Job Location:Mason, Ohio Schedule: 9/80 Schedule Lead, Systems Engineering (Test Engineer) About Space & Sensors: L3Harris Space & Sensors Division, headquartered in Mason, Ohio, designs, develops, and manufactures complex systems (electronic, avionics, transceivers, transmitters,...

  • Lead, Electrical Engineering

    4 days ago

    Mason, United States Harris Geospatial Solutions Full time

    Job Title: Lead, Electrical Engineering - RF Design Job Code: 10643 Job Location: Mason, OH Schedule: 9/80 About Defense Electronics: L3Harris Defense Electronics, located in Mason, Ohio, designs, develops, and manufactures complex systems (electronic, avionics, transceivers, transmitters, electro-optical, and electro-mechanical) for the defense, aerospace,...

  • Lead, Electrical Engineering

    5 days ago

    Mason, United States L3Harris Technologies Full time

    Job Title: Lead, Electrical Engineering - RF Design  Job Code: 10643 Job Location: Mason, OH Schedule: 9/80 About Defense Electronics: L3Harris Defense Electronics, located in Mason, Ohio, designs, develops, and manufactures complex systems (electronic, avionics, transceivers, transmitters, electro-optical, and electro-mechanical) for the defense,...

  • Lead, Project Engineering

    6 days ago

    Mason, United States L3Harris Technologies Full time

    Responsible for the day-to-day tactical duties for assigned programs. Oversees and coordinates the cost/schedule/technical aspects of ongoing engineering projects within the program guidelines set by the Program Manager and customer. Serves as single Project Engineer, Engineer, Project Management, Project Manager, Customer Experience, Development,...

  • Devops Lead

    2 weeks ago

    Mason, United States eTeam Full time

    The DevSecOps Engineer Lead will be a part of the DevSecOps Enablement team. The team is tasked with a variety of complex responsibilities, but chief to this position is the enablement of DevSecOps concepts and technology in the organization. This role is responsible for the delivery of critical DevSecOps concepts including but not limited to; cloud...

  • Devops Lead

    4 days ago

    Mason, United States eTeam Full time

    The DevSecOps Engineer Lead will be a part of the DevSecOps Enablement team. The team is tasked with a variety of complex responsibilities, but chief to this position is the enablement of DevSecOps concepts and technology in the organization. This role is responsible for the delivery of critical DevSecOps concepts including but not limited to; cloud...

  • Application Engineer

    2 weeks ago

    Mason, United States MBS Pro Staffing Full time

    Job DescriptionJob DescriptionMBS is hiring a Application Engineer in Mason, OH. This position is a full-time, contract to hire opportunity. FULL JOB DESCRIPTIONPRINCIPAL DUTIES & RESPONSIBILITIESPerform test cuts and machine demonstrations for aerospace type parts both structural and engine components.Provide applications engineering support to sales force...

  • Specialist, Quality Engineering

    3 weeks ago

    Mason, United States L3Harris Technologies Full time

    Job Description: As a Quality Engineer you will contribute to the ultimate success of the team and the business. In this role you will engage in data-driven improvement and sustainment initiatives. Additionally, you will design, write, implement, evaluate, and revise quality assurance procedures, statistical sampling techniques, quality plans,...

  • Proposal Engineer

    4 weeks ago

    Mason, United States Makino Full time

    Makino is a world leader in metal-cutting and machining technology. As a leader in advanced manufacturing machine tool technology, Makino enables its customers to realize the highest level of quality with the fastest time to market. When companies make the parts that matter for automotive, aerospace, medical, die-mold and other industries worldwide, they...

  • e-Commerce Database Architect

    2 weeks ago

    Mason, United States UST Global Full time

    Data Architect Architect II - Enterprise Solutions Who we are: Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world. UST is a mission-driven group...

  • e-Commerce Database Architect

    4 days ago

    Mason, United States UST Global Full time

    Data Architect Architect II - Enterprise Solutions Who we are: Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world. UST is a mission-driven group...

  • Sr. Specialist, Systems Engineering

    3 weeks ago

    Mason, United States L3Harris Technologies Full time

    Job Title: Sr. Specialist, Systems Engineering - Integration and Test Job Code: 103 Job Location: Mason, OH Schedule: 9/80 Sr. Specialist, Systems Engineering (Integration and Test) About Space & Sensors: L3Harris Space & Sensors Division, headquartered in Mason, Ohio, designs, develops, and manufactures complex systems (electronic,...

  • Sr. Specialist, Systems Engineering

    2 weeks ago

    Mason, United States L3Harris Technologies Full time

    Job Title: Sr. Specialist, Systems Engineering - Integration and Test Job Code: 103 Job Location: Mason, OH Schedule: 9/80 Sr. Specialist, Systems Engineering (Integration and Test) About Space & Sensors: L3Harris Space & Sensors Division, headquartered in Mason, Ohio, designs, develops, and manufactures complex systems (electronic, avionics, transceivers,...

  • Customer Engineer

    1 day ago

    Mason, United States Lantek Corporation Full time

    ABOUT USLantek is the global leader providing software systems and solutions to companies manufacturing parts with sheet metal, tubes, and structural steel. From small workshops to international multi-plant corporations, Lantek systems are present in every kind of industrial factory.Lantek has more than 35 years of experience and more than 350 professionals...

  • Sr. Specialist, Systems Engineering

    3 weeks ago

    Mason, United States Harris Geospatial Solutions Full time

    Job Title: Sr. Specialist, Systems Engineering - Integration and Test Job Code: 103 Job Location: Mason, OH Schedule: 9/80 Sr. Specialist, Systems Engineering (Integration and Test) About Space & Sensors: L3Harris Space & Sensors Division, headquartered in Mason, Ohio, designs, develops, and manufactures complex systems (electronic, avionics, transceivers,...

  • Customer Engineer

    1 month ago

    Mason, United States Lantek Full time

    ABOUT USLantek is the global leader providing software systems and solutions to companies manufacturing parts with sheet metal, tubes, and structural steel. From small workshops to international multi-plant corporations, Lantek systems are present in every kind of industrial factory.Lantek has more than 35 years of experience and more than 350 professionals...

  • Japanese Bilingual Account Manager

    3 weeks ago

    Mason, United States Pacific Advisory Service Full time

    Job DescriptionJob DescriptionEstablished for over 50 years, this company is a leading importer and distributor of quality CNC manufacturing machinery, including machine tools and injection molding machines. We service manufacturers in the automotive, aerospace, construction equipment, medical, and I.T. industries.We are seeking a highly motivated individual...

  • Plant Engineer

    2 weeks ago

    Mason City, United States Experis Full time

    Our client is seeking a Plant Engineer to join their team. As a Plant Engineer, you will be part of the Engineering team supporting maintenance department, and High Performing Manufacturing Organizations, and be open to being onsite which will align successfully in the organization.Job Title: Plant EngineerLocation: Mason City Iowa 50401Pay Range:$130-$150k...

  • Plant Engineer

    2 days ago

    Mason City, United States Experis Full time

    Our client is seeking a Plant Engineer to join their team. As a Plant Engineer, you will be part of the Engineering team supporting maintenance department, and High Performing Manufacturing Organizations, and be open to being onsite which will align successfully in the organization. Job Title: Plant Engineer Location: Mason City Iowa 50401 Pay...