Data Manager/Database Programmer

Description

About You

You are an experienced Data Environmental Manager who is very comfortable with creating, implementing, and documenting extract, transform, load (ETL) procedures for loading into centralized database systems.  Through this work, you’ve also gained experience related to data model design and development and database programming.  You enjoy developing and testing innovative approaches to resolving complex data processing workflows. You are motivated and have a thirst for learning allowing you to grow intellectually and professionally. Collaborating with colleagues with diverse expertise is exciting for you, and you are also comfortable working independently. Quality management and integrity are among your strongest principles.

About Integral

Integral Consulting Inc. is a science and engineering firm delivering sound technical solutions to meet today's challenges in the health, environmental, and natural resource arenas. We are a values-driven collaborative team that is as passionate about company culture as we are about the work we do for our clients.  Since our founding 20 years ago, we have operated with a demonstrated commitment to the well-being, diversity, and professional development of our staff and an equal commitment to strong partnerships with our clients and teaming partners.  We are a company where people come to solve today’s toughest environmental challenges through innovative ideas, exceptional teamwork, and dedication to accuracy and technical quality.

About the Job

We are currently seeking an experienced environmental data manager/programmer. Candidates must be detail-oriented and able to support scientific and engineering analyses by ensuring the highest level of data quality, availability, and documentation. The successful candidate will have a strong background in database management, programming, and a passion for environmental sustainability. As a Data Manager / Database Programmer, you will play a crucial role in managing and optimizing our PostgreSQL and PL/SQL database systems. As part of our data management and analysis practice you will work closely with our multidisciplinary teams to transform raw environmental data into meaningful information and facilitate informed decision-making by ensuring data accuracy, availability, and performance. You will play a critical role in managing, analyzing, and visualizing environmental data to provide actionable insights for our clients and projects. This role offers a unique blend of technical expertise, strategic thinking, and hands-on database management and programming. The successful candidate will be passionate about environmental conservation and have strong data management, analysis, and visualization skills.

Responsibilities

As a Data Manager/Database Programmer, your job functions will include, but not be limited to:

• Acquiring, organizing, cleaning, restructuring, and loading data into relational databases using SQL and other languages and tools
• Managing data import, export, and transformation processes
• Summarizing data to support a variety of geospatial, statistical, engineering, and other analyses
• Collaborating with project teams to understand data requirements and objectives
• Performing data analysis, statistical modeling, and trend analysis
• Providing data-driven insights and recommendations to support client projects
• Ensuring data accuracy, quality, and compliance with Integral’s established standards and approaches
• Collaborating with cross-functional teams to gather data requirements and ensure data integrity
• Developing, testing, and maintaining database scripts, queries, stored procedures, and triggers
• Designing and implementing database models that support the organization's data needs
• Developing and maintaining documentation related to database systems and models

Qualifications

Candidates should hold an advanced degree in computer science, Information Technology, or a related field.

The ideal candidate will have:

• 5+ years of environmental data management experience
• Proven experience as a database programmer, modeler, or manager
• Strong proficiency in SQL and database management systems (e.g., SQL Server, PostgreSQL)
• Experience with data modeling tools and techniques
• Familiarity with database design principles and best practices
• Experience with environmental data including field sampling, analytical chemistry data, geospatial data, and GIS systems
• Experience with either R or Python programming
• Develop and optimize database queries, stored procedures, and triggers to support data analysis and reporting.
• Design, implement, and maintain complex database structures using PostgreSQL and PL/SQL is a plus
• Experience with cloud-based database services (e.g., AWS, Azure) is desirable
• Proficiency in data visualization tools such as Tableau, Power BI, or similar
• Create interactive data visualizations and dashboards to convey complex information effectively
• Excellent problem-solving and analytical skills
• Great attention to detail and a determination to achieve accuracy
• Excellent written and oral communication skills
• A desire to grow both intellectually and professionally
• Possess strong organizational abilities
• Ability to work independently and within a multidisciplinary team of scientists and engineers

Annual Salary Range: $80,000 - $100,000

An employee’s total compensation package includes annual salary, company-subsidized (employee and family) medical, dental, and vision insurance, 401(k) participation with a company-match of 1% to 4% of annual compensation, company-paid life and short- and long-term disability, paid sick leave (80 hours per year), paid vacation (15 days), paid holidays (9 days per year), and the potential for an annual discretionary bonus based on company performance. Paid time off will be pro-rated to reflect part-time scheduled hours, if applicable.

We are proud to be an equal employment opportunity employer and are committed to a proactive program of affirmative action and diversity development. Integral Consulting Inc. provides equal opportunity in all of our employment practices to all qualified employees and applicants without regard to race; color; religion; gender (including pregnancy, childbirth, or related medical conditions); national origin; age; sexual orientation; disability; marital status; military, veteran, or Vietnam Era Veterans’ Readjustment Assistance Act protected veteran status; gender identity or gender expression; or any other category protected by federal, state, and local laws.

All offers of employment are contingent on candidates successfully passing an employment history screening, degree verification, and a federal, state, and county criminal background and Watch List screening. Candidates will receive a written notice of this requirement. All screenings will be done in accordance with all local, state, and federal laws.

#LI-FT
#LI-Mid-Senior