Data Engineer

6 months ago

Mt Laurel, 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.

  • Lead Data Engineer with PySpark

    1 week ago

    Mt Laurel, United States Infinity Outsourcing Full time

    About the job Lead Data Engineer with PySpark Requisition Title :Lead Data Engineer with PySpark ( 1 Day Onsite) Locations Mt Laurel, NJ & Charlotte, NC Visa Status: GC/USC/H4 EAD Client : TD Bank Duration: Full Time /C2H Salary pay rate to candidates : $49-$56/hr W2 Experience : 12+ YearsPrimary Tech skills = Pyspark, Databricks (Hands-on experience...

  • Data Engineer with Data Bricks

    1 week ago

    Mt Laurel, United States Futran Tech Solutions Pvt. Ltd. Full time

    Azure Senior DevOps Engineer MOUNT LAUREL, New Jersey Job Description:Key Responsibilities: As a Azure Senior DevOps Engineer is responsible for building, deploying, maintain and automating our software development pipeline from source control through production. Design and development of an organization's infrastructure is one of the key responsibilities...

  • Data Engineer

    1 week ago

    Laurel, Mississippi, United States TechnoGen Full time

    Data Engineer Role at TechnoGenWe are seeking a Data Engineer to join our team at TechnoGen. The successful candidate will be responsible for designing, implementing, and maintaining large-scale data systems.Key Responsibilities:Design and implement data warehouses and lakes to support business intelligence and analytics.Develop and maintain ETL processes...

  • Data Engineer

    1 week ago

    Laurel, United States Booz Allen Hamilton Full time

    Job Number: R0207012Software and Data EngineerThe Opportunity:As a Software and Data Engineer, you‘re excited at the prospect of unlocking the secrets held by a data set, and you‘re fascinated by the possibilities presented by IoT, quantum computing, machine learning, and artificial intelligence. If you care about moving a mission forward as much as...

  • "Data Engineer"

    1 week ago

    Laurel, United States TechnoGen Full time

    Title: Data Engineer Client: University of Maryland Global Campus Duration: 1 Year Any visa is fine Work Location: Hybrid. 3 days and 2 days remote. Local resources are highly preferred. Address: University of Maryland Global Campus 3501 University Boulevard East Adelphi, Maryland 20783 • Must have experience with AWS, Python, APIs, and other ETL tools •...

  • "Data Engineer"

    1 week ago

    Laurel, United States TechnoGen Full time

    Title: Data Engineer Client: University of Maryland Global Campus Duration: 1 Year Any visa is fine Work Location: Hybrid. 3 days and 2 days remote. Local resources are highly preferred. Address: University of Maryland Global Campus 3501 University Boulevard East Adelphi, Maryland 20783 •Must have experience with AWS, Python, APIs, and other ETL tools...

  • "Data Engineer"

    1 week ago

    Laurel, United States TechnoGen Full time

    Title: Data Engineer Client: University of Maryland Global Campus Duration: 1 Year Any visa is fine Work Location: Hybrid. 3 days and 2 days remote. Local resources are highly preferred. Address: University of Maryland Global Campus 3501 University Boulevard East Adelphi, Maryland 20783 •Must have experience with AWS, Python, APIs, and other ETL tools...

  • Senior Data Engineer

    1 week ago

    Laurel, United States Delmock Technologies Full time

    About Our Company: Delmock Technologies, Inc. (DTI), is a leading HUBZone business in Baltimore, known for delivering sophisticated IT (Information Technology) and Health solutions with a commitment to ethics, expertise, and superior service. Actively engaged in the local community, DTI creates opportunities for talented residents while maintaining a stellar...

  • Senior Data Engineer

    1 week ago

    Laurel, United States Delmock Technologies Full time

    About Our Company: Delmock Technologies, Inc. (DTI), is a leading HUBZone business in Baltimore, known for delivering sophisticated IT (Information Technology) and Health solutions with a commitment to ethics, expertise, and superior service. Actively engaged in the local community, DTI creates opportunities for talented residents while maintaining a stellar...

  • Data Scientist

    1 week ago

    Mt Laurel, United States Innovative Defense Technologies Full time

    Description Background Information: Innovative Defense Technologies (IDT), provider of automated software testing, data analysis, and cybersecurity solutions for complex defense systems, is currently accepting applications for a Data Scientist role in support of its efforts implementing Artificial Intelligence and Data Analytics solutions for a variety of...

  • Data Scientist

    1 month ago

    Mt Laurel, United States Innovative Defense Technologies Full time

    Description Background Information: Innovative Defense Technologies (IDT), provider of automated software testing, data analysis, and cybersecurity solutions for complex defense systems, is currently accepting applications for a Data Scientist role in support of its efforts implementing Artificial Intelligence and Data Analytics solutions for a variety of...

  • Data Scientist

    1 week ago

    Mt Laurel, United States Innovative Defense Technologies Full time

    Description Background Information: Innovative Defense Technologies (IDT), provider of automated software testing, data analysis, and cybersecurity solutions for complex defense systems, is currently accepting applications for a Data Scientist role in support of its efforts implementing Artificial Intelligence and Data Analytics solutions for a variety of...

  • Senior Data Engineer

    1 week ago

    Laurel, United States Rubix Solutions LLC Full time

    Responsibilities: Design, develop, and implement scalable data solutions to support analytics and reporting needs. Creating, optimizing, and managing data pipelines to efficiently move and transform data across the Azure ecosystem. Responsible for setting up and managing data lakes to store large volumes of structured and unstructured data, ensuring high...

  • Senior Data Engineer

    1 week ago

    Laurel, United States Rubix Solutions LLC Full time

    Responsibilities: Design, develop, and implement scalable data solutions to support analytics and reporting needs. Creating, optimizing, and managing data pipelines to efficiently move and transform data across the Azure ecosystem. Responsible for setting up and managing data lakes to store large volumes of structured and unstructured data, ensuring high...

  • Senior Data Engineer

    1 week ago

    Laurel, United States Rubix Solutions LLC Full time

    Responsibilities: Design, develop, and implement scalable data solutions to support analytics and reporting needs. Creating, optimizing, and managing data pipelines to efficiently move and transform data across the Azure ecosystem. Responsible for setting up and managing data lakes to store large volumes of structured and unstructured data, ensuring high...

  • Data Engineer

    6 days ago

    Mt Rainier, United States Knowesis Full time

    Position: Data Engineer Location: Washington D.C. Metropolitan Area Work Environment: Remote Clearance Required: Secret Knowesis is seeking a skilled Data Engineer to join our team, supporting the Department of Defense (DoD) Office of Inspector General (OIG). The candidate will be responsible for designing, building, and maintaining the infrastructure that...

  • Senior Data Modeler

    1 week ago

    Mt Laurel, United States Futran Tech Solutions Pvt. Ltd. Full time

    Role: Senior Data Modeler Location: Mount Laurel, NJ Type of work: Hybrid 3 days onsite client location) Duration: Contract Job Description: We are seeking a skilled Sr. Data Modeler to join our team and contribute to the design and implementation of scalable and efficient data models. The ideal candidate will have experience with Data Vault techniques,...

  • Data Analyst/Systems Engineer

    2 days ago

    Laurel, United States The Johns Hopkins University Applied Physics Laboratory Full time

    DescriptionAre you passionate about defending our nation against challenging real-world air and missile threats? Are you searching for an opportunity to apply your engineering background in an engaging, inquisitive environment? If so, we're looking for someone like you to join our team at APL! Our dedicated team is passionate about providing high-impact...

  • Data Analyst/Systems Engineer

    2 days ago

    Laurel, United States Johns Hopkins Applied Physics Laboratory (APL) Full time

    DescriptionAre you passionate about defending our nation against challenging real-world air and missile threats? Are you searching for an opportunity to apply your engineering background in an engaging, inquisitive environment? If so, we're looking for someone like you to join our team at APL! Our dedicated team is passionate about providing high-impact...

  • Data Analyst/Systems Engineer

    1 month ago

    Laurel, United States The Johns Hopkins University Applied Physics Laboratory Full time

    DescriptionAre you passionate about defending our nation against challenging real-world air and missile threats? Are you searching for an opportunity to apply your engineering background in an engaging, inquisitive environment? If so, we're looking for someone like you to join our team at APL! Our dedicated team is passionate about providing high-impact...