Data Modeler

Data EngineerPrimary Work: Serve as Data Engineer for the Data & Analytics Office.Education: Bachelor's or master's degree in Data Science, Computer Science, Information Systems or other Information Technology major, or equivalent work experience.Required Tasks to be performed:Design, implement, and maintain robust data pipelines and architectures in Alteryx Designer.Create and maintain logical data models in Oracle SQL Developer Data Modeler.Read, write, and update data.Create and maintain ETL code repository.Perform ad hoc data cleansing of data sets as needed.Develop and implement data quality control procedures to ensure the accuracy, completeness, and consistency of environmental data.Define data quality standards and metrics.Execute procedures to monitor data quality.Identify data issues and propose remediation plans.Optimize data processing workflows and algorithms for efficiency, scalability, and reliability.Configure SAS Viya analytics platform as needed.Ensure compliance with data privacy regulations and security best practices in data handling, storage, and transmission.Stay current with emerging technologies, tools, and methodologies in data engineering and environmental science.Collaborate with data scientists and analysts to optimize models and algorithms for data quality, security, and governance.Monitor and tune data systems, identify and resolve performance bottlenecks, and implement caching and indexing strategies to enhance query performance.Transform raw data into a usable format by applying data cleansing, aggregation, filtering, and enrichment techniques.Establish the governance of data and algorithms used for analysis, analytical applications, and automated decision making.Provide leadership, guidance, and mentorship to junior staff members and colleagues, fostering a culture of continuous learning, innovation, and excellence in D&A practices.Required Knowledge, Skills & Abilities (KSAs):5-7 years' experience in data engineering, including designing and implementing data pipelines and ETL processes.Proficiency with Alteryx Designer.Proficiency in programming languages such as Python and SQL.Strong analytical and problem-solving skills, with the ability to analyze complex datasets and extract actionable insights.Knowledge of relational database design and data modeling.Ability to establish and maintain effective working relationships with others.Ability to work independently.Ability to determine work priorities and ensure proper completion of work assignments.Ability to communicate effectively, both verbally and in writing.Preferred Knowledge, Skills & Abilities (KSAs):Familiarity with environmental science, water quality, or related fields.Experience with implementing data warehouses, data lakes, or data lakehouses.Experience with business intelligence tools such as Qlik Sense.Spruce Technology, Inc. is a mid-size, award-winning technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing. Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process. All full-time employees are eligible for the following benefits: Medical, dental, vision health benefits Life Insurance and AD&D (paid by company) 401k, Flexible and Dependent Care Spending Account plans. Paid-time Off or Paid Sick Leave (amount dependent on position level and if required by state).