Data Engineer: Pipelines, Modeling & Governance

Prophecy Technologies Corp; Northern (KY); On-site; USD 90,000 - 140,000; Full time

Job summary

Prophecy Technologies Corp is seeking a Data Engineer focused on data strategy, transformation, integration, and modeling. You will develop data pipelines, perform data quality checks, and create logical and physical data models for data warehouses and data marts.

The role requires strong coding skills to translate business problems into data-driven solutions and to apply governance practices in collaboration with stakeholders.

Qualifications

• Strong understanding of data strategy principles and data governance practices.
• Experience transforming and integrating data from multiple sources.
• Advanced data modeling for conceptual, logical, and physical models.

Responsibilities

• Apply data strategy to routine problems within a single function.
• Extract data and build pipelines to transform data into usable structures.
• Perform initial data quality checks on extracted data to ensure accuracy.
• Analyze data flows and design conceptual, physical, and logical models for warehouses and marts.
• Develop logical and physical data models including data warehouse/data mart designs.
• Define relational tables, keys, and stored procedures.
• Write code to develop data solutions and deploy features to production.

Skills

Data strategy

Data transformation

Data integration

Data modeling

SQL

Data governance

Requirements translation

Troubleshooting data issues

Job description

Prophecy Technologies Corp is seeking a Data Engineer focused on data strategy, transformation, integration, and modeling. You will develop data pipelines, perform data quality checks, and create logical and physical data models for data warehouses and data marts.

The role requires strong coding skills to translate business problems into data-driven solutions and to apply governance practices in collaboration with stakeholders.