Data Engineer

3 weeks ago

Rockville, 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.

  • Data Engineer

    4 weeks ago

    Rockville, United States Tential Full time

    We are looking for a Senior Data Engineer to join the Public offering review system team in Business, Legal, and Enterprise Systems. As the data engineer on the team, you are responsible for building the new database and reporting infrastructure by working with the engineering team, business users, product management, and the cross functional partners. You...

  • Data Engineer

    1 day ago

    Rockville, Maryland, United States GEI Consultants Full time

    Job SummaryWe are seeking a highly skilled Data Engineer to join our Operational Development Team at GEI Consultants. This role will involve supporting a variety of systems and data engineering tasks focused on data flow activities, working closely with members of the Operational Development Team and IT staff.

  • Data Engineering Specialist

    1 day ago

    Rockville, Maryland, United States GEI Consultants Full time

    We are seeking a highly skilled Data Engineer to join our team at GEI Consultants. As a Data Engineer, you will play a crucial role in designing, managing, and supporting MS SQL Server and Azure databases.About the RoleThis is an exciting opportunity to work on a variety of systems and data engineering tasks focused on data flow activities. You will...

  • Palantir Data Engineer

    4 weeks ago

    Rockville, United States Razor Talent Full time

    Palantir Data Engineer Clearance Requirement: Secret Clearance or the ability to obtain one. Preference given to candidates who have previously held a clearance and are eligible to reinstate it. Citizenship Requirement: U.S. Citizenship (USC) required. Job Description: Razor is seeking a highly skilled Palantir Data Engineer to join our team working on...

  • Security Engineer for Cyber Threat Detection

    3 weeks ago

    Rockville, Maryland, United States NTT DATA Full time

    We are seeking a highly motivated Security Engineer to join our team in Rockville, Maryland. As a key member of our cybersecurity team, you will be responsible for performing assessments of systems and networks within the network environment to identify vulnerabilities and measure the effectiveness of defense-in-depth architecture.Key responsibilities...

  • Data Engineer for Big Data Solutions

    3 weeks ago

    Rockville, Maryland, United States ASCENDING Full time

    Job OverviewWe are seeking a skilled Data Engineer to join our team at ASCENDING. The ideal candidate will have 3+ years of experience in big data environments run on AWS Cloud.

  • Data Analytics Engineer

    1 day ago

    Rockville, Maryland, United States JobRialto Full time

    Job OverviewAt JobRialto, we are seeking a highly skilled Data Analytics Engineer to join our team. This role is ideal for individuals who possess extensive experience with cloud-based Big Data technologies and have a strong background in database management.About the RoleWe are looking for an experienced professional to design, develop, and optimize...

  • Data Engineer Expert

    3 days ago

    Rockville, Maryland, United States Tential Full time

    We are seeking a highly skilled Senior Data Engineer to join the Public Offering Review System team in Business, Legal, and Enterprise Systems at Tential. This is a senior role that requires building the new database and reporting infrastructure by working with the engineering team, business users, product management, and cross-functional partners.Estimated...

  • Data Engineer Leader

    7 days ago

    Rockville, Maryland, United States BioSpace, Inc. Full time

    The U.S. Pharmacopeial Convention (USP) is a leading scientific organization that collaborates with top health and science authorities to develop quality standards for medicines, dietary supplements, and food ingredients.Job SummaryWe value inclusivity and recognize the importance of building a culture with meaningful opportunities for mentorship and...

  • Azure Data Engineer

    3 days ago

    Rockville, Maryland, United States Diverse Lynx Full time

    At Diverse Lynx LLC, we offer a competitive salary of $120,000 per year for the role of Azure Data Engineer. This position requires expertise in Azure Data Lake Gen1/Gen2, Azure Data factory, Azure Data bricks, Azure DWH, Azure Synapse, Key vault, and Azure Active directory.We are looking for an experienced professional with knowledge of data brick services,...

  • Cloud Data Engineer Role

    3 days ago

    Rockville, Maryland, United States ASCENDING LLC Full time

    Job Overview: ASCENDING LLC is looking for a skilled Big Data Engineer to support an internal business stakeholder. The ideal candidate will have experience working in a true big data environment on the AWS Cloud and possess top-notch Python coding and SQL querying skills.Estimated Salary: $110,000 - $150,000 per yearThis is a long-term contract position...

  • Cloud Data Engineering Professional

    1 week ago

    Rockville, Maryland, United States ASCENDING LLC Full time

    Job Title:Big Data Engineer (Hybrid in Rockville, MD)About the JobWe are seeking a highly skilled Big Data Engineer to support an internal business stakeholder with their big data capabilities. The ideal candidate will have 5+ years of experience and expertise in Python coding, SQL querying, and Big Data Technologies.Key ResponsibilitiesDesign and implement...

  • Summer Internship Data Engineer

    3 days ago

    Rockville, Maryland, United States Randstad Full time

    Do you want to gain hands-on experience in data engineering and contribute to a real-world project? We are seeking a motivated intern to join our team and work on our UDX project, a Python-based solution for processing and analyzing assay data from laboratory information systems (LIMS).As a Summer Intern, you will be responsible for:Code analysis and...

  • Senior Data Engineer

    3 weeks ago

    Rockville, Maryland, United States Software Guidance and Assistance, Inc. Full time

    Software Guidance & Assistance, Inc. is seeking a Senior Data Engineer for a CONTRACT assignment with one of our premier Regulatory Clients in the Rockville, MD area.About the RoleWe are looking for an experienced Data Engineer to join our team and work on the public offering review system in Business, Legal, and Enterprise Systems. As the Data Engineer on...

  • Data Engineer

    2 weeks ago

    Rockville, United States Axle Full time

    Job DescriptionJob Description(ID: 2024-6798)Axle is a bioscience and information technology company that offers advancements in translational research, biomedical informatics, and data science applications to research centers and healthcare organizations nationally and abroad. With experts in biomedical science, software engineering, and program management,...

  • Data Engineering Expert for AWS Environment

    3 weeks ago

    Rockville, Minnesota, United States ASCENDING Full time

    Job OverviewWe are seeking a highly skilled Data Engineer to join our team at ASCENDING, working on internal technical initiatives in data engineering and software integration.

  • ETL Data Engineer

    1 month ago

    Rockville, United States Skyward IT Solutions Full time

    **This position is contingent on contract award**We are Skyward.That is, a love for people, for improvement, for human advancement through information technology. We are a people-centered business with a desire to serve others. We are diverse and unified; creative and collaborative; a collection of complementary, not competing talents. And though on the...

  • Director of Data Engineering and Governance

    2 weeks ago

    Rockville, United States QTC Management, Inc. Full time

    Leidos QTC Health Services seeks a Director of Data Engineering & Governance  Leidos QTC Health Services is undergoing a significant modernization effort in the way it builds software by moving away from monolithic applications towards microservices, automation, and elastic infrastructure. As the Data Engineering & Governance Director, you will help Leidos...

  • Data Engineer for Scalable Clinical Data Solutions

    3 weeks ago

    Rockville, Minnesota, United States Axle Full time

    Company OverviewAxle is a bioscience and information technology company that offers advancements in translational research, biomedical informatics, and data science applications to research centers and healthcare organizations nationally and abroad.We focus on developing and applying research tools and techniques to empower decision-making and accelerate...

  • Big Data Engineer(Hybrid in Rockville,MD)

    3 weeks ago

    Rockville, United States ASCENDING LLC Full time

    Title: Big Data Engineer Location: Hybrid(1 day onsite 4 days remote in Rockville, MD) Term: Long Term Contract to hire Available for W2 or 1099, No C2CJob Description: Our client is looking for a rock star Big Data Engineer to support an internal business stakeholder with their big data capabilities, being responsible for supporting technical initiatives in...