Data Engineer

2 months ago

Ithaca, United States GEI Consultants Full time
Description

Your role at GEI.

GEI Consultants has an opening in our Operational Development Team for a qualified Data Engineer to support a variety of systems and data engineering tasks focused on data flow activities. The majority of our systems are based in MS SQL Server, Tableau Server, Azure, and FastField Forms. This person will primarily work closely with members of the Operational Development Team and with members of our IT staff. The ideal candidate will be focused, detail-oriented, and driven to attain and maintain very high standards for efficiency and accuracy in data acquisition and integration into our systems. The ideal candidate will have more than 3 years of data engineering experience in the AEC industry or in similar science and/or engineering environments. GEI seeks a committed, self-motivated, organized and detail-oriented individual who anticipates issues and thrives on creative, independent problem solving within a rapid, deadline-driven environment.

Essential Responsibilities & Duties
  • ETL of data from a wide variety of sources
  • Database and Data Warehouse design/expansion/backup & recovery
  • Index management and optimization
  • Support data sources for Tableau Server, Power BI, and ArcGIS
  • Stored procedure development and maintenance
  • Identify new opportunities within GEI where existing business approaches to data can be replaced with a more efficient/automated data flow and presentation of data for analysis
  • Develop and optimize ETL/SSIS packages to facilitate data transfer between FTP, remote data loggers, Azure, and on-premises databases
  • Troubleshoot SSIS package permission issues related to execute-as/data source read/write access
  • SQL Agent Job development and monitoring
  • Develop data reporting and visualizations as specified by clients using Tableau, SSRS, etc
  • Perform DML and DDL via tsql/stored procedures executed directly within SSMS and remotely via SSIS
  • Develop test plans, implementation plans, and project timelines for various data engineering projects
  • Define, prioritize, communicate, and foster shared understanding of project objectives and scope
  • Coordinate the development of standard operating procedures (SOPs), technical training programs, and QA/QC procedures for staff and work product
  • Team with all staff necessary to complete assignments
  • Collaborate with technical team members to ensure the solution design satisfies project objectives and business requirements
  • Other duties as assigned
Minimum Qualifications
  • 3+ years of experience in a position performing similar data engineering tasks
  • Proven record of ability to design, manage, and support MS SQL Server and Azure databases
  • Ability to work with the following programming/mark-up/scripting languages preferred: VB.net, python, XML, javascript, and R
  • Bachelor's Degree, from an accredited college or university
  • MS SQL Server/Azure certification preferred
  • Ability to develop project plans and meet deadlines
  • Self-starter with attention to detail and stakeholder needs
  • Able to critically analyze and solve problems of a complex nature
  • Excellent Communication skills
  • Able to work on multiple projects of moderate complexity simultaneously and independently
  • Proficient in organization and time management skills
  • Familiarity with engineering, environmental science, and/or chemistry subject matter preferred.
  • Able to work effectively in GEI's partnership model, including a team environment, building rapport and relationships.
We are GEI.

Some of the world's most pressing problems - from climate change to sustainable development, to critical infrastructure and the future of our energy supply - need our brightest and diverse minds working together to create safer, more resilient communities for tomorrow.

We are technical experts, collaborators, and entrepreneurs who draw from diverse backgrounds to solve our clients' most complex challenges.

With nearly 60 offices across North America, we offer a range of engineering, science, and technical consulting services. Our range of expertise, project types, and culture make us the choice for top talent in the AEC industry.

Employee-owned. Employee-focused.

As a 100% employee-owned company, our employees support our flat leadership structure, have a say in how our business operates and benefit from our financial success. We are committed to employee growth with career development opportunities, competitive total rewards, a well-being program, flexible work arrangements and more. Our company culture is driven by our 4 Cs - we are Client-Centered, Curious, Collaborative, and Community Minded - which support our focus on sustainability, safety, diversity, equity and inclusion. Get to know us better by visiting GEI's career site here .

GEI's Total Rewards Package
  • Market-Competitive Compensation, including Eligibility for an Annual Performance Bonus
  • Pay Range For This Position: $33.65-72.11/hour
  • Comprehensive Benefits Program, including Medical, Dental, Vision, Life, Disability and More
  • Well-Being Program and Paid Parental Leave
  • Commuter Benefits
  • Hybrid Work Schedules and Cell Phone Stipends
  • GEI University (GEIU) with Continuing Education Assistance and Tuition Reimbursement
  • Connecting Conversation Program with a Focus on Professional Development and Opportunities for Advancement
  • Support and Financial Rewards for Publication Awards, Professional Dues, and Professional Licenses
  • Paid Holidays and Generous Paid Time Off Program
  • Rewards and Recognition
  • GEI-Funded Profit Sharing and 401(k)
  • Opportunity to be an Owner and Shareholder (Learn more here )
  • A Vibrant Culture that is Focused on Partnership, Sustainability, Giving Back to Our Communities and Diversity, Equity and Inclusion
  • And More...

Physical Job Requirements

Sedentary

X

Light

Medium

Other

Activity Level Throughout Workday

Physical Activity Requirements

Occasional

(0-35% of day)

Frequent

(33-66% of day)

Continuous

(67-100% of day)

Not Applicable

Sitting

X

Standing

X

Walking

X

Climbing

X

Lifting (floor to waist level) (in pounds)

X

Lifting (waist level and above) (in pounds)

X

Carrying objects

X

Push/pull

X

Twisting

X

Bending

X

Reaching forward

X

Reaching overhead

X

Squat/kneel/crawl

X

Wrist position deviation

X

Pinching/fine motor skills

X

Keyboard use/repetitive motion

X

Taste or smell (taste=never)

X

Talk or hear

X

Accurate 20/40

Very Accurate 20/20

Not Applicable

Near Vision

X

Far Vision

X

Yes

No

Not Applicable

Color Vision (ability to identify and distinguish colors)

X

Sensory Requirements

Minimal

Moderate

Accurate

Not Applicable

Depth perception

X

Hearing

X

Environmental Requirements

Occupational Exposure Risk Potential

Reasonably Anticipated

Not Anticipated

Blood borne pathogens

X

Chemical

X

Airborne communicable diseases

X

Extreme temperatures

X

Radiation

X

Uneven surfaces or elevations

X

Extreme noise levels

X

Dust/particular matter

X

Other (exposure risks):

Usual workday hours:

X

8

10

12

Other work hours

GEI is an AA/equal opportunity employer, including disabled and veterans.

  • Energy Management Specialist

    3 days ago

    Ithaca, New York, United States ME Engineering Full time

    Job SummaryM/E Engineering is currently seeking an experienced Energy Manager to join our team at Cornell University in Ithaca, NY.About UsWe are a growing full-service MEP engineering firm dedicated to providing design and technology services that support a sustainable future. Our diverse workforce of nearly 200 engineers and design professionals work...

  • Administrative Assistant

    1 month ago

    Ithaca, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are seeking an Administrative Assistant to join our team in the engineering industry located in Ithaca, New York. In this role, you will be working closely with engineers, processing customer requests and maintaining accurate records. This role offers a long-term contract employment opportunity.Responsibilities:• Processing...

  • Senior Dairy Technology Specialist

    6 days ago

    Ithaca, New York, United States Cornell University Full time

    About the RoleWe are seeking a highly skilled and motivated Postdoctoral Associate to join our team at Cornell University's College of Agriculture and Life Sciences. The successful candidate will play a key role in advancing digital dairy management practices, leveraging cutting-edge research and technology to enhance productivity, sustainability, and animal...

  • Highly Experienced Embedded Systems Specialist

    2 days ago

    Ithaca, New York, United States Technology Navigators Full time

    About the RoleWe are seeking a highly skilled and experienced Senior Embedded Systems Engineer to join our technical team in Markle, Indiana. This is an exciting opportunity for you to be part of a revolutionary company that combines data analytics with artificial intelligence to transform the recycling industry.

  • Pre-Analytical Services Assistant 2

    6 days ago

    Ithaca, New York, United States Actalent Full time

    This role offers an exciting opportunity to join Actalent, a global leader in engineering and sciences services and talent solutions. As a Pre-Analytical Services Assistant 2 - Laboratory Operations Specialist, you will play a vital part in advancing the company's initiatives through specialized expertise.The successful candidate will be responsible for...

  • Pre-Analytical Services Coordinator

    4 days ago

    Ithaca, New York, United States Actalent Full time

    About the Role:We are seeking a skilled Laboratory Assistant Specialist to join our team at Actalent. As a Laboratory Assistant Specialist, you will play a critical role in providing Pre-Analytical Services in various accountabilities. This position is situated in a laboratory environment, requiring interaction with various technologies and equipment,...

  • Pre-Analytical Services Assistant 2

    1 week ago

    Ithaca, United States Actalent Full time

    Pre-Analytical Services Assistant 2 Job Description The main function of the pre-analytical services assistant is to assist the Supervisor, and provide Pre-Analytical Services in various accountabilities as required. Responsibilities * Enter data from standard and more complex VSK patient information forms and remanding material requiring further...

  • Pre-Analytical Services Assistant 2

    6 days ago

    Ithaca, United States Actalent Full time

    Pre-Analytical Services Assistant 2 Job Description The main function of the pre-analytical services assistant is to assist the Supervisor, and provide Pre-Analytical Services in various accountabilities as required. Responsibilities + Enter data from standard and more complex VSK patient information forms and remanding material requiring further...

  • Pre-Analytical Services Assistant 2

    6 days ago

    Ithaca, United States Actalent Full time

    Pre-Analytical Services Assistant 2 Job Description The main function of the pre-analytical services assistant is to assist the Supervisor, and provide Pre-Analytical Services in various accountabilities as required. Responsibilities * Enter data from standard and more complex VSK patient information forms and remanding material requiring further...

  • Pre-Analytical Services Assistant 2

    5 days ago

    Ithaca, United States Actalent Full time

    Pre-Analytical Services Assistant 2 If interested, please apply directly or email your resume to *sfitch@actalentservices.com* Job Description The main function of the pre-analytical services assistant is to assist the Supervisor, and provide Pre-Analytical Services in various accountabilities as required. Responsibilities + Enter data from standard...

  • Pre-Analytical Services Assistant 2

    6 days ago

    Ithaca, United States Actalent Full time

    Pre-Analytical Services Assistant 2 If interested, please apply directly or email your resume to *sfitch@actalentservices.com* Job Description The main function of the pre-analytical services assistant is to assist the Supervisor, and provide Pre-Analytical Services in various accountabilities as required. Responsibilities * Enter data from standard and...

  • Pre-Analytical Services Assistant 2

    1 week ago

    Ithaca, United States Actalent Full time

    Pre-Analytical Services Assistant 2 Job Description The main function of the pre-analytical services assistant is to assist the Supervisor, and provide Pre-Analytical Services in various accountabilities as required. Responsibilities + Enter data from standard and more complex VSK patient information forms and remanding material requiring further...

  • Pre-Analytical Services Team Member

    5 days ago

    Ithaca, New York, United States Actalent Full time

    We are seeking a highly skilled Pre-Analytical Services Team Member to join our laboratory team. In this role, you will play a critical part in ensuring the smooth operation of our laboratory services.Your responsibilities will include:Providing administrative support to the laboratory teamAssisting with data entry and quality control processesPerforming...

  • Pre-Analytical Services Assistant 2

    4 weeks ago

    Ithaca, United States Actalent Full time

    Job DescriptionJob DescriptionPre-Analytical Services Assistant 2Job DescriptionThe main function of the pre-analytical services assistant is to assist the Supervisor, and provide Pre-Analytical Services in various accountabilities as required.ResponsibilitiesEnter data from standard and more complex VSK patient information forms and remanding material...

  • Pre-Analytical Services Assistant 2

    4 weeks ago

    Ithaca, United States Actalent Full time

    Job DescriptionJob DescriptionPre-Analytical Services Assistant 2Job DescriptionThe main function of the pre-analytical services assistant is to assist the Supervisor, Pre-Analytical Services in various accountabilities as required.ResponsibilitiesEnter data from standard and more complex VSK patient information forms and remanding material requiring further...

  • Pre-Analytical Services Assistant 2

    3 weeks ago

    Ithaca, United States Actalent Full time

    Job DescriptionJob DescriptionPre-Analytical Services Assistant 2Job DescriptionThe main function of the pre-analytical services assistant is to assist the Supervisor, and provide Pre-Analytical Services in various accountabilities as required.ResponsibilitiesEnter data from standard and more complex VSK patient information forms and remanding material...

  • Pre-Analytical Services Assistant 2

    2 weeks ago

    Ithaca, United States Actalent Full time

    Job DescriptionJob DescriptionPre-Analytical Services Assistant 2Job DescriptionThe main function of the pre-analytical services assistant is to assist the Supervisor, and provide Pre-Analytical Services in various accountabilities as required.ResponsibilitiesEnter data from standard and more complex VSK patient information forms and remanding material...

  • Electrical Systems Integration Specialist

    7 days ago

    Ithaca, New York, United States Technology Navigators Full time

    About the RoleNo sponsorship available. No third-party candidates.Our client is a leading industry player that combines data analytics and artificial intelligence to revolutionize metal recycling technology, aiming to create a more sustainable future.This is an exciting opportunity to be part of a cutting-edge company with top-notch technology, excellent...

  • Construction Project Estimation Specialist

    2 days ago

    Ithaca, New York, United States ALH Building Systems Full time

    Job OverviewWe are seeking a meticulous and analytical individual to join our team as a Construction Project Estimation Specialist in the Midwest region. The perfect candidate will be tasked with accurately determining the necessary quantities of materials for various construction projects, such as trusses, wall panels, lumber, beams, and sheathing.Estimated...

  • Research Scientist

    6 days ago

    Ithaca, New York, United States Cornell University Full time

    Cornell University is a leading institution in research and education, and we are seeking a highly skilled Postdoctoral Associate to join our team. The successful candidate will work on a project using a model-experiment approach to explore the prospect of dormant-season plant nitrogen uptake in northern forests.About the PositionThis is a one-year...