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 <ul> <li>ETL of data from a wide variety of sources </li><li>Database and Data Warehouse design/expansion/backup & recovery </li><li>Index management and optimization </li><li>Support data sources for Tableau Server, Power BI, and ArcGIS </li><li>Stored procedure development and maintenance </li><li>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 </li><li>Develop and optimize ETL/SSIS packages to facilitate data transfer between FTP, remote data loggers, Azure, and on-premises databases </li><li>Troubleshoot SSIS package permission issues related to execute-as/data source read/write access </li><li>SQL Agent Job development and monitoring </li><li>Develop data reporting and visualizations as specified by clients using Tableau, SSRS, etc </li><li>Perform DML and DDL via tsql/stored procedures executed directly within SSMS and remotely via SSIS </li><li>Develop test plans, implementation plans, and project timelines for various data engineering projects </li><li>Define, prioritize, communicate, and foster shared understanding of project objectives and scope </li><li>Coordinate the development of standard operating procedures (SOPs), technical training programs, and QA/QC procedures for staff and work product </li><li>Team with all staff necessary to complete assignments </li><li>Collaborate with technical team members to ensure the solution design satisfies project objectives and business requirements </li><li>Other duties as assigned </li> </ul>Minimum Qualifications <ul> <li>3+ years of experience in a position performing similar data engineering tasks </li><li>Proven record of ability to design, manage, and support MS SQL Server and Azure databases </li><li>Ability to work with the following programming/mark-up/scripting languages preferred: VB.net, python, XML, javascript, and R </li><li>Bachelor's Degree, from an accredited college or university </li><li>MS SQL Server/Azure certification preferred </li><li>Ability to develop project plans and meet deadlines </li><li>Self-starter with attention to detail and stakeholder needs </li><li>Able to critically analyze and solve problems of a complex nature </li><li>Excellent Communication skills </li><li>Able to work on multiple projects of moderate complexity simultaneously and independently </li><li>Proficient in organization and time management skills </li><li>Familiarity with engineering, environmental science, and/or chemistry subject matter preferred. </li><li>Able to work effectively in GEIs partnership model, including a team environment, building rapport and relationships. </li></ul> 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 <ul> <li>Market-Competitive Compensation, including Eligibility for an Annual Performance Bonus </li><li>Pay Range For This Position: $33.65-72.11/hour </li><li>Comprehensive Benefits Program, including Medical, Dental, Vision, Life, Disability and More </li><li>Well-Being Program and Paid Parental Leave </li><li>Commuter Benefits </li><li>Hybrid Work Schedules and Cell Phone Stipends </li><li>GEI University (GEIU) with Continuing Education Assistance and Tuition Reimbursement </li><li>Connecting Conversation Program with a Focus on Professional Development and Opportunities for Advancement </li><li>Support and Financial Rewards for Publication Awards, Professional Dues, and Professional Licenses </li><li>Paid Holidays and Generous Paid Time Off Program </li><li>Rewards and Recognition </li><li>GEI-Funded Profit Sharing and 401(k) </li><li>Opportunity to be an Owner and Shareholder (Learn more here) </li><li>A Vibrant Culture that is Focused on Partnership, Sustainability, Giving Back to Our Communities and Diversity, Equity and Inclusion </li><li>And More </li></ul> 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.

Description Your role at GEI. The Jr. Web Application Data Engineer position is responsible for the development and support of web applications that are highly data centric. This position goes beyond the typical web programmer and will design and support objects within Microsoft SQL Server. The person hired for this position will work with a team of Web programmers, Data Engineers, Data Architects, GISPs, Power BI designers, and subject-matter experts that are located on the east coast. Required Qualifications <ul> <li>Practical experience with .Net framework for web development, C#, ASP.net, jquery, HTML/ razer, Linq, javaScript, and git or other version control management software. </li><li>Expertise in SDLC. </li><li>Ability to provide off-hour deployments and support for bug-fixes. </li><li>Major in computer-related field (computer science/engineering) </li><li>Able to work during east coast schedule. </li></ul>Preferred Qualifications <ul> <li>Experience using Entity Framework Core </li><li>Experience with Microsoft SQL Server via SSMS - DDL and DML, relationships, indexing, view, and stored procedure development. </li><li>Knowledge of .Net Core </li><li>Azure authentication </li><li>Azure Blob storage integration </li><li>Power BI cloud service </li><li>Experience with VB.net for desktop applications, XML, XSD for supporting non-web applications. </li></ul>Essential Duties <ul> <li>Design, program, test, deploy, and document web applications. </li><li>Design and build SQL Server schema. </li><li>Collaborate with data architects and data engineers. </li><li>Develop a strong understanding of the subject matter for each application to assist with troubleshooting. </li><li>Provide programming and data engineering assistance for desktop applications. </li></ul>Soft Skills <ul> <li>Applicant should be self-motivated, detail-oriented, and organized. </li><li>Must be a quick learner. </li><li>Work well in a team environment but be self-directed and be able to work independently. </li><li>Experience in providing high quality deliverables on time. </li><li>Provide clear concise documentation for developed applications. </li><li>Ability to research coding solutions and best practices via websites or the resources. </li></ul>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 Includes <ul> <li>Market-Competitive Compensation, including Eligibility for an Annual Performance Bonus </li><li>Pay Range For This Position: $25.00-32.00/hour dependent upon experience </li><li>Comprehensive Benefits Program, including Medical, Dental, Vision, Life, Disability and More </li><li>Well-Being Program and Paid Parental Leave </li><li>Commuter Benefits </li><li>Hybrid Work Schedules and Cell Phone Stipends </li><li>GEI University (GEIU) with Continuing Education Assistance and Tuition Reimbursement </li><li>Connecting Conversation Program with a Focus on Professional Development and Opportunities for Advancement </li><li>Support and Financial Rewards for Publication Awards, Professional Dues, and Professional Licenses </li><li>Paid Holidays and Generous Paid Time Off Program </li><li>Rewards and Recognition </li><li>GEI-Funded Profit Sharing and 401(k) </li><li>Opportunity to be an Owner and Shareholder (Learn more here ) </li><li>A Vibrant Culture that is Focused on Partnership, Sustainability, Giving Back to Our Communities and Diversity, Equity and Inclusion </li><li>And More... </li> </ul>

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 (tastenever) 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.

Description Your role at GEI. The Jr. Web Application Data Engineer position is responsible for the development and support of web applications that are highly data centric. This position goes beyond the typical web programmer and will design and support objects within Microsoft SQL Server. The person hired for this position will work with a team of Web programmers, Data Engineers, Data Architects, GISPs, Power BI designers, and subject-matter experts that are located on the east coast. Required Qualifications Practical experience with .Net framework for web development, C#, ASP.net, jquery, HTML/ razer, Linq, javaScript, and git or other version control management software. Expertise in SDLC. Ability to provide off-hour deployments and support for bug-fixes. Major in computer-related field (computer science/engineering) Able to work during east coast schedule. Preferred Qualifications Experience using Entity Framework Core Experience with Microsoft SQL Server via SSMS - DDL and DML, relationships, indexing, view, and stored procedure development. Knowledge of .Net Core Azure authentication Azure Blob storage integration Power BI cloud service Experience with VB.net for desktop applications, XML, XSD for supporting non-web applications. Essential Duties Design, program, test, deploy, and document web applications. Design and build SQL Server schema. Collaborate with data architects and data engineers. Develop a strong understanding of the subject matter for each application to assist with troubleshooting. Provide programming and data engineering assistance for desktop applications. Soft Skills Applicant should be self-motivated, detail-oriented, and organized. Must be a quick learner. Work well in a team environment but be self-directed and be able to work independently. Experience in providing high quality deliverables on time. Provide clear concise documentation for developed applications. Ability to research coding solutions and best practices via websites or the resources. 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 Includes Market-Competitive Compensation, including Eligibility for an Annual Performance Bonus Pay Range For This Position: $25.00-32.00/hour dependent upon experience 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

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 (tastenever) 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.

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 <ul> <li>ETL of data from a wide variety of sources </li><li>Database and Data Warehouse design/expansion/backup & recovery </li><li>Index management and optimization </li><li>Support data sources for Tableau Server, Power BI, and ArcGIS </li><li>Stored procedure development and maintenance </li><li>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 </li><li>Develop and optimize ETL/SSIS packages to facilitate data transfer between FTP, remote data loggers, Azure, and on-premises databases </li><li>Troubleshoot SSIS package permission issues related to execute-as/data source read/write access </li><li>SQL Agent Job development and monitoring </li><li>Develop data reporting and visualizations as specified by clients using Tableau, SSRS, etc </li><li>Perform DML and DDL via tsql/stored procedures executed directly within SSMS and remotely via SSIS </li><li>Develop test plans, implementation plans, and project timelines for various data engineering projects </li><li>Define, prioritize, communicate, and foster shared understanding of project objectives and scope </li><li>Coordinate the development of standard operating procedures (SOPs), technical training programs, and QA/QC procedures for staff and work product </li><li>Team with all staff necessary to complete assignments </li><li>Collaborate with technical team members to ensure the solution design satisfies project objectives and business requirements </li><li>Other duties as assigned </li> </ul>Minimum Qualifications <ul> <li>3+ years of experience in a position performing similar data engineering tasks </li><li>Proven record of ability to design, manage, and support MS SQL Server and Azure databases </li><li>Ability to work with the following programming/mark-up/scripting languages preferred: VB.net, python, XML, javascript, and R </li><li>Bachelor's Degree, from an accredited college or university </li><li>MS SQL Server/Azure certification preferred </li><li>Ability to develop project plans and meet deadlines </li><li>Self-starter with attention to detail and stakeholder needs </li><li>Able to critically analyze and solve problems of a complex nature </li><li>Excellent Communication skills </li><li>Able to work on multiple projects of moderate complexity simultaneously and independently </li><li>Proficient in organization and time management skills </li><li>Familiarity with engineering, environmental science, and/or chemistry subject matter preferred. </li><li>Able to work effectively in GEI's partnership model, including a team environment, building rapport and relationships. </li></ul>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 <ul> <li>Market-Competitive Compensation, including Eligibility for an Annual Performance Bonus </li><li>Pay Range For This Position: $33.65-72.11/hour </li><li>Comprehensive Benefits Program, including Medical, Dental, Vision, Life, Disability and More </li><li>Well-Being Program and Paid Parental Leave </li><li>Commuter Benefits </li><li>Hybrid Work Schedules and Cell Phone Stipends </li><li>GEI University (GEIU) with Continuing Education Assistance and Tuition Reimbursement </li><li>Connecting Conversation Program with a Focus on Professional Development and Opportunities for Advancement </li><li>Support and Financial Rewards for Publication Awards, Professional Dues, and Professional Licenses </li><li>Paid Holidays and Generous Paid Time Off Program </li><li>Rewards and Recognition </li><li>GEI-Funded Profit Sharing and 401(k) </li><li>Opportunity to be an Owner and Shareholder (Learn more here ) </li><li>A Vibrant Culture that is Focused on Partnership, Sustainability, Giving Back to Our Communities and Diversity, Equity and Inclusion </li><li>And More... </li></ul> 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 Gei Consultants Jobs

Data Engineer
December 19, 2024

Jr Web Application Data Engineer
December 19, 2024

Data Engineer
December 6, 2024

Jr Web Application Data Engineer
December 6, 2024

Data Engineer
December 5, 2024

Data Engineer
December 3, 2024

Data Engineer
November 30, 2024

Data Engineer
November 29, 2024

Quick filters

Top companies

Data Engineer Gei Consultants Jobs

Data EngineerDecember 19, 2024

Jr Web Application Data EngineerDecember 19, 2024

Data EngineerDecember 6, 2024

Jr Web Application Data EngineerDecember 6, 2024

Data EngineerDecember 5, 2024

Data EngineerDecember 3, 2024

Data EngineerNovember 30, 2024

Data EngineerNovember 29, 2024