Data Analyst

Langan provides expert land development engineering and environmental consulting services for major developers, renewable energy producers, energy companies, corporations, healthcare systems, colleges/universities, and large infrastructure programs throughout the U.S. and around the world. Our employees collaborate seamlessly among 40+ offices and gain valuable hands-on experience that fosters career growth. Langan culture is entrepreneurial from advancing innovative technical solutions, to participating in robust training and knowledge sharing, to making progressive change within the communities we live and work.

Consistently ranked among the top ten “Best Firms to Work For” and Engineering News-Record’s top 50 firms worldwide, Langan attracts and retains the best talent in the industry. Employees thrive at Langan, a firm that fosters an inclusive and supportive work environment for all; prioritizes wellbeing, health, and safety; encourages volunteerism and philanthropy; offers workplace flexibility, along with carbon-neutral office spaces; and empowers individuals to contribute their skills and knowledge to make impactful contributions.

Job Summary

Langan is seeking a Data Analyst to join its collaborative team in Chicago, IL. This individual will serve a key function in providing technical support to field sampling teams, the collection of and configuration of large datasets and the development of and utilization of data validation tools to identify quality issues. In this role, you will have the opportunity to partner cross-functionally as part of a growing national team.

Job Responsibilities

• Develop and utilize data validation tools in Excel, Access and SQL to identify data quality issues;
• Collect and configure large datasets to meet project specifications;
• Document work processes, compose training documents and conduct training sessions;
• Implement, configure and test commercial-off-the-shelf data management related software to meet project specifications;
• Provide technical support to field sampling teams and act as a liaison between the project staff, analytical laboratory, data validator and GIS analysts;
• Provide reporting support by generating and formatting tables, charts or graphs;
• Research state and federal regulations necessary to manage action levels or clean-up criteria; and
• Perform other duties as requested.

Qualifications

• Bachelor’s degree in Science, Engineering, or Information Technology required;
• 1+ years of experience in the environmental field with emphasis on environmental data management;
• Experience with enterprise database software: EarthSoft EQuIS, MS SQL Server, Oracle, and MS Access;
• Experience with Power BI;
• Experience using MS Excel to manipulate and organize data sets for import into a database and for final reporting;
• Experience in the planning, design, and implementation of mobile applications for field data collection a plus;
• Knowledge of state regulations, CERCLA, and RCRA a plus;
• Strong attention to detail with excellent analytical, judgment, and problem solving capabilities;
• High initiative, superior interpersonal skills, and ability to work with minimal supervision and to manage multiple tasks simultaneously;
• Ability to work under pressure within tight schedules;
• Possess a valid driver’s license in good standing with reliable transportation; and
• Availability to occasionally travel to other offices.

Langan provides a rich array of programs and benefits to help its employees advance their careers and enhance the quality of their lives. Our comprehensive compensation package includes: full-time employment company paid medical, dental, and vision coverage; life insurance, short- and long-term disability insurance, and paid pregnancy disability leave; 401(k)/Roth with company match; paid time off including parental and military leave; employee referral and professional license bonuses; and educational reimbursement.

Langan offers employee resource groups; flexible work schedules; extensive training; wellness programs; buddy and mentoring programs; and much more!

Langan is committed to providing equal employment opportunities to all qualified applicants and employees, including individuals with disabilities and protected veterans. We believe that an inclusive workplace is essential for the well-being and success of our employees.

Certain US jurisdictions require Langan to include an estimate of salary or hourly ranges. The estimated range for this role is: $52,500- $65,000. Actual compensation may vary based on factors such as related work experience, location, market conditions, education/training, certifications and other credentials, as well as applicable knowledge and skills. Certain roles may be eligible for overtime and participation in the firm's annual bonus and performance review program. Bonuses are discretionary and based on individual job performance and the profitability of the firm. Employees are also eligible to receive up to 20 days of paid vacation time, 10 days of paid sick time and 10 paid holidays throughout the year. Eligibility and actual paid time off may vary based on local law and factors such as hours worked, related work experience and level.