GEI Consultants Inc Data Engineer in Woburn, Massachusetts
GEI Consultants Inc Data Engineer Woburn, MA 01801
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
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
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 more than 40 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.
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 (https://www.geiconsultants.com/careers/) .
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
Hybrid Work Schedules and Home Office 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 (https://www.geiconsultants.com/wp-content/uploads/2022/08/651_US-Brochure-v08-print.pdf) )
A Vibrant Culture that is Focused on Partnership, Sustainability, Giving Back to Our Communities and Diversity, Equity and Inclusion
Physical Job Requirements
Activity Level Throughout Workday
Physical Activity Requirements
(0-35% of day)Frequent
(33-66% of day)
(67-100% of day)Not Applicable
Lifting (floor to waist level) (in pounds)X
Lifting (waist level and above) (in pounds)X
Wrist position deviationX
Pinching/fine motor skillsX
Keyboard use/repetitive motionX
Taste or smell (taste=never)X
Talk or hearX
Accurate 20/40Very Accurate 20/20
Color Vision (ability to identify and distinguish colors)
Occupational Exposure Risk Potential
Blood borne pathogens
Airborne communicable diseases
Uneven surfaces or elevations
Extreme noise levels
Other (exposure risks):
Usual workday hours:
Other work hours
GEI is an AA/equal opportunity employer, including disabled and veterans.
Accessibility: If you need an accommodation as part of the employment process please contact Talent Acquisition at Email: TalentAcquisition@geiconsultants.com Equal Opportunity Employer, including disabled and veterans. If you want to view the Know Your Rights: Workplace Discrimination is Illegal poster, please choose your language: English (https://www.eeoc.gov/know-your-rights-workplace-discrimination-illegal) – Spanish (https://www.eeoc.gov/es/conozca-sus-derechos-la-discriminacion-en-el-lugar-de-trabajo-es-ilegal-0) – Arabic (https://www.eeoc.gov/ar/arf-hqwqk-altmyyz-fy-mkan-alml-ghyr-qanwny) - Chinese (https://www.eeoc.gov/zh-hans/lejienindequanli-zhichangqishishiweifade) English – Spanish (https://www.eeoc.gov/sites/default/files/migrated_files/employers/eeoc_gina_supplement_spanish.pdf) – Chinese (https://www.eeoc.gov/sites/default/files/migrated_files/employers/eeoc_gina_supplement_chinese.pdf) If you want to view the Pay Transparency Policy Statement, please click the link: English (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_English_unformattedESQA508c.pdf)