DATA ENGINEER

Company: Fayetteville Public Works Commission
Location: Fayetteville
Posted on: January 25, 2023

Job Description:

THIS POSITION IS AVIALABLE FOR FULL REMOTE OPPORTUNITY SUMMARY OF RESPONSIBILITIES: This class is responsible for creating, maintaining, and evolving the organization's strategy for data storing, transformation, and distribution to ensure data quality and value for analytics, to include translating business requirements into conceptual, logical, and physical data models that will support data analysis/visualization and decision-making across all divisions.Responsibilities will include, but not be limited to:cleaning and transforming enterprise data into a useful statecreating, extending, and maintaining logical entity relationship models and diagrams using data modeling tools, technologies and frameworksmaintain workflows that ensure data integrity, synchronization, quality and consistency.create and maintain data dictionary (metadata) to document what technology manages the data, the schema, the size, how the data is secured, the source of the data, definitions, business owners, format, structure of databases, and the relationship between field elements to control access to and manipulation of the databasesgather data requirements, such as how long the data needs to be stored, how it will be used, and what people and systems need access to the datastore the data, using specialized technologies that are optimized for the particular use of the data, such as Sisense and/or a relational database, a NoSQL database, etc.support special initiatives and projects requiring complex data analysis and other supportcollaborate with data analytics teams and other staff to build the right solutionslead data model walk-throughs to ensure clear understanding across all stakeholders and address any issues that ariseanalyze and debug performance issues on data modelscreate, document and store scripts and case scenarios required for testingwrite and execute ad-hoc and complex queries to perform data analysisperform data profiling on source system data to ensure that source system data can be integrated and represented properly in data models.Operating under general supervision of the Data and Analytics Manager, work is performed in accordance with established policies and procedures, with leeway allowed for the exercise of independent judgment in carrying out the details of the work.KNOWLEDGE, SKILLS, AND ABILITIES:Thorough knowledge of ingestion, processing frameworks and storage enginesThorough knowledge architecting distributed systems, creating reliable pipelines, combining data sources, architecting data storesThorough knowledge of batch and stream processingThorough knowledge of Linux and command line tools such as grep, awk, etc.Thorough knowledge of SQL and programming such as Java, Python, Scala, R, etc.Thorough knowledge and holistic understanding of data as an assetThorough knowledge of safety rules/regulations/procedures, as applicableThorough knowledge in operating computers and applicable software including Microsoft Office toolsThorough knowledge of Oracle applications, data and business processesThorough knowledge of math concepts and formulas required for data analysis and reportingAbility to design and implement data modelsAbility to unlock additional value from data through completion of feasibility studies for assigned use casesAbility to use SQL for queries and report buildingAbility to translate logical models into physical models, adding appropriate physical objects to create the objects within the data store (e.g., indexes, sequences, etc.)Ability to interpret complex business requirements and create data models across multiple applications that support business goalsAbility to solve problems independently and provide recommendations for continuous improvementAbility to ensure quality control in all work products/outputsAbility to work as part of a cross functional teamAbility to use strong analytics skills in interpreting and visualizing dataAbility to create and maintain reports/records, spreadsheets, documents, tables, etc.MINIMUM QUALIFICATIONS:Graduation from a four (4) year accredited university/college with Bachelor's Degree in business, technology, data management, or related field and a minimum of four (4) years of experience developing or leading data management initiatives for small teams.Graduation from a two (2) year accredited university/college or technical institute with a degree/certification in business, technology, data management, or related field and a minimum of six (6) years' experience developing or leading data management initiatives for small teams; An equivalent combination of education, training, and/or experience as defined above.EMPLOYER'S RIGHTS: This job description is general and illustrative of the kind of duties required of this position. It is not exhaustive and does not contain a detailed description of all the duties that may be assigned to the incumbent occupying this position.

Keywords: Fayetteville Public Works Commission, Fayetteville , DATA ENGINEER, Engineering , Fayetteville, North Carolina