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
Click
here to apply!
|