Data Engineer

Job Title: Data Engineer Location: Tallahassee, FL (From day one onsite) Client: State of FL Duration: Long Term Visa: H1B, Citizen Experience: 12

Job Description: 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.
Collaborates with data scientists and analysts to optimize models and algorithms for data quality, security, and governance.
Monitors and tunes data systems, identifies and resolves performance bottlenecks, and implements caching and indexing strategies to enhance query performance.
Transforms raw data into a usable format by applying data cleansing, aggregation, filtering, and enrichment techniques.
Establishes 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):
3-5 years experience in data engineering with Alteryx Designer, including designing and implementing data pipelines and ETL processes.
Proficiency with Alteryx Designer. (Proficiency level 4)
Proficiency in programming languages such as Python and SQL. (Proficiency level 3)
Strong analytical and problem-solving skills, with the ability to analyze complex datasets and extract actionable insights. (Proficiency level 3)
Knowledge of relational database design and data modeling. (Proficiency level 3)
Ability to establish and maintain effective working relationships with others. (Proficiency level 3)
Ability to work independently. (Proficiency level 3)
Ability to determine work priorities and ensure proper completion of work assignments. (Proficiency level 3)

Office of Technology & Information Services Information Technology Staff Augmentation Services Appendix B: Position Tasks and Qualifications 37ITC090
Page | 2 Updated: 03.26.2024
Ability to communicate effectively, both verbally and in writing. (Proficiency level 3)
Preferred Knowledge, Skills & Abilities (KSAs):
Familiarity with environmental science, water quality, or related fields.
Experience with implementing data warehouses, data lakes, or data lake houses.
Experience with business intelligence tools such as Qlik Sense.