Data Engineer

4 months ago

Franklin, 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 GEIs partnership model, including a team environment, building rapport and relationships.

We are GEI.

Some of the worlds 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 GEIs career site here.

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

  • Data Engineer

    1 week ago

    Franklin, Tennessee, United States Two95 International Inc. Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Two95 International Inc. in Franklin, TN. As a Data Engineer, you will be responsible for designing, developing, and maintaining large-scale data systems.Key Responsibilities:Develop software using object-oriented or functional programming languages with 5+ years of...

  • Director, Data Engineering Solutions

    1 month ago

    Franklin, United States Mars Full time

    Job Description:Are you passionate about Data and Analytics (D&A) and excited about how it can completely transform the way an enterprise works? Do you have the strategic vision, technical expertise, and leadership skills to drive data-driven solutions? Do you want to work in a dynamic, fast-growing category? If so, you might be the ideal candidate for the...

  • Engineering Data Industrialization- Development Engineer

    1 month ago

    Franklin, United States Schneider Electric Full time

    The Engineering Data Industrialization Development Engineer will be responsible for enabling rapid prototyping of initiatives for the Power Systems NAM cluster. This role will join a team focused on utilizing ETO Order Data, AI, ML, and AR/VR to enable Quality, Productivity, and Capacity improvements across the business. Responsibilities: Create automation...

  • Data Engineer

    2 weeks ago

    Franklin, Tennessee, United States Two95 International Inc. Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Two95 International Inc. as a key member of our technology department.Key ResponsibilitiesDesign, develop, and maintain large-scale data processing systems using object-oriented or functional programming languages.Develop and implement data pipelines using Apache Nifi, Spark,...

  • Data Integration Director

    2 weeks ago

    Franklin, Tennessee, United States TEKsystems Full time

    About the RoleWe are seeking a highly experienced Data Integration Director to join our team at TEKsystems. As a key member of our organization, you will be responsible for leading the development and implementation of data integration strategies that drive business growth and innovation.Key ResponsibilitiesStrategy Development: Create, implement, and manage...

  • Senior Data Scientist Machine Learning Engineer

    3 months ago

    Franklin Township, United States Terumo Medical Corporation Full time

    Job Summary:This Senior Data Scientist, Machine Learning Engineer will leverage cloud computing technologies to develop, deploy, and manage predictive models that support decision-making processes across the Terumo organization. The role demands a strategic approach to ownership, involving collecting, cleaning, and preprocessing large datasets, designing and...

  • Data Integration Director

    2 days ago

    Franklin, Tennessee, United States TEKsystems Full time

    Data Integration Director Job DescriptionWe are seeking a highly skilled Data Integration Director to lead our team in developing and implementing data integration strategies that drive business growth and improve operational efficiency.Key Responsibilities:Develop and implement data integration strategies that align with business objectivesLead a team of...

  • Data Analyst Internship Opportunity

    1 week ago

    Franklin, Tennessee, United States Nissan Motor Co., Ltd. Full time

    Job OverviewNissan is seeking a highly motivated and detail-oriented Data & Analytics Intern to join our team in Franklin, TN. As a Data & Analytics Intern, you will play a critical role in shaping the future of mobility at Nissan by analyzing and interpreting complex data sets to drive business decisions.ResponsibilitiesInterpret and analyze data using...

  • Data Analyst Internship Opportunity

    1 week ago

    Franklin, Tennessee, United States Nissan Motor Co., Ltd. Full time

    About Nissan Motor Co., Ltd.Nissan is a global leader in the automotive industry, revolutionizing mobility and shaping the future of transportation. Our company is built on a heritage of innovation, and we're committed to enriching people's lives through our products and services.Job SummaryWe're seeking a highly skilled Data & Analytics Intern to join our...

  • Director, Data Architecture

    1 month ago

    Franklin, United States Mars Full time

    Job Description:Are you passionate about Data and Analytics (D&A) and excited about how it can completely transform the way an enterprise works? Do you have the strategic vision, technical expertise, and leadership skills to drive data-driven solutions? Do you want to work in a dynamic, fast-growing category? If so, you might be the ideal candidate for the...

  • Civil Engineer

    2 months ago

    Franklin, United States Actalent Full time

    Seeking a Civil Engineer in the Middle TN area! Job Description We seek a skilled Civil Engineer to join our team and contribute to various engineering and project documentation tasks. You will assist in preparing due diligence reports, construction documents, drainage reports, specifications, and construction schedules/estimating. Utilize reports, maps,...

  • Civil Engineer

    1 month ago

    Franklin, United States Actalent Full time

    Seeking a Civil Engineer in the Middle TN area! Job Description We seek a skilled Civil Engineer to join our team and contribute to various engineering and project documentation tasks. You will assist in preparing due diligence reports, construction documents, drainage reports, specifications, and construction schedules/estimating. Utilize reports, maps,...

  • Senior Director, Data Science COE

    4 weeks ago

    Franklin, United States Mars Full time

    Job Description:Are you passionate about Data Science and excited about its potential to transform the way an enterprise works? Do you have the strategic vision, technical expertise, and leadership skills to drive data-driven solutions? Do you want to work in a dynamic, fast-growing category? If so, you might be the ideal candidate for the role of Senior...

  • Process Engineer

    2 months ago

    Franklin, United States Kosmos Corp Full time

    Job DescriptionJob DescriptionGrowing Manufacturing firm in the Franklin, NJ has a need for a Process Engineer.Essential Duties and Responsibilities include the following. Other duties may be assigned.Studies functional statements, organization charts, and project information to determine functions and responsibilities of workers and work units and to...

  • Senior Systems Architect, Data Centers

    2 months ago

    Franklin, United States Schneider Electric Full time

    - Main mission• ELECTRA program, a common initiative from Power Products and Power Systems Divisions intended to shape the future of electrical power distribution architectures in strategic segments (XL Data Center, Marine & Ports, Semiconductor fab, Mobility, New Energy Landscape, E&C, Mining, Motor management, Healthcare, CIB).• The role of the Senior...

  • Manufacturing Process Optimization Engineer

    2 weeks ago

    Franklin, Wisconsin, United States API Heat Transfer Full time

    Job DescriptionAs a global leader in the design and manufacture of a wide range of specialty heat exchangers and heat transfer solutions, API Heat Transfer has a legacy of industry-leading performance that can be traced back more than 130 years. Throughout our history, we have built a corporate culture based on reliability and superior performance – from...

  • Engineering Intern

    4 weeks ago

    Franklin, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...

  • Process Improvement Engineer

    3 weeks ago

    Franklin, Wisconsin, United States API Heat Transfer Full time

    Job OverviewAs a prominent player in the design and production of a diverse array of specialized heat exchangers and thermal management solutions, API Heat Transfer boasts a rich history of exceptional performance spanning over 130 years. Our corporate culture is rooted in reliability and excellence, driven by innovative technologies and the talented...

  • Structural Engineering Specialist

    4 weeks ago

    Franklin, Tennessee, United States Actalent Full time

    Position OverviewWe are seeking a talented Civil Engineer to contribute to a variety of engineering projects and documentation efforts. This role involves assisting in the preparation of essential reports and documents necessary for construction and project development.Key ResponsibilitiesAssist in the creation of due diligence reports, construction...

  • Mechanical Engineer

    1 month ago

    Franklin, United States Rhino Tool House Full time $65,000 - $80,000

    Job DescriptionJob DescriptionMechanical Engineer (Hovair Automotive)Job Tasks, Duties and ResponsibilitiesSummary:· Develop creative and innovative engineered material handling solutions that meet or exceed customer expectations.· Review and study customer specifications, engineering schematics and other data to determine the design procedures needed to...