Data Modeler, Intermediate at Advanced Systems Design Tallahassee, FL

Advanced Systems Design; Tallahassee (FL); On-site; USD 75,000 - 110,000; Full time

Benefits offered by this job

Comprehensive Health Insurance

401(k) Plan with Employer Match

Paid Time Off

Tuition Assistance

Professional Certification Incentive

Employee Referral Plan

Technology Exposure

Job summary

Advanced Systems Design in Tallahassee, FL is seeking a Data Modeler at an intermediate to advanced level to design, implement, and maintain robust data pipelines and data models using Alteryx Designer and Oracle SQL Developer Data Modeler.

You will read, write, and transform data, support data quality initiatives, and collaborate with data scientists to optimize models while adhering to privacy and security standards.

Qualifications

• 3-5 years’ experience in data engineering with Alteryx Designer, 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.

Responsibilities

• 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 an ETL code repository.
• Perform ad hoc data cleansing of data sets as needed.
• Develop and implement data quality control procedures to ensure 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.
• 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.

Skills

Python

SQL

Analytical thinking

Problem solving

Data quality

Education

Bachelor's or Master’s degree in Data Science / Computer Science / Information Systems / IT

Tools

Alteryx Designer

Oracle SQL Developer Data Modeler

Job description

Data Modeler, Intermediate – Advanced Systems Design – Tallahassee, FL.

Job Overview

• 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 an 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.
• 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 Qualifications

• 3-5 years’ experience in data engineering with Alteryx Designer, 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. (Proficiency level – 3)

Preferred Qualifications

• 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.

Education

• Bachelor’s or master’s degree in Data Science, Computer Science, Information Systems, or other Information Technology major, or equivalent work experience.

Benefits

• Are eligible for wide-ranging benefits and perks, including but not limited to:
  • Comprehensive Health Insurance with PPO and HDHP/HSA options
  • Dental Insurance
  • Vision Insurance
  • Short/Long-Term Disability
  • Group Life Insurance - Company Paid
  • Voluntary Life Insurance
  • 401(k) Plan with Employer Match
  • Paid Time Off (Vacation/Sick)
  • Holiday Pay - Company Paid Federal Holidays
  • Tuition Assistance
  • Professional Certification Incentive Plan
  • Employee Referral Plan
  • Technology Exposure

Equal Opportunity Employment

Advanced Systems Design is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.