Data Engineer

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

This role is for a Data Engineer focusing on data strategy, transformation, integration, and modeling. The individual will be responsible for developing data pipelines, performing data quality checks, and creating logical and physical data models for data warehouses and marts. The position requires strong coding skills to develop solutions and application features, translating business problems into data-driven or mathematical solutions. Additionally, the role involves applying business acumen to provide recommendations and manage data governance practices.

Key Responsibilities:

• Apply principles of defined data strategy to routine business problems involving a single function.
• Extract data from identified databases and create data pipelines to transform data into relevant structures.
• Identify suitable data sources and perform initial data quality checks on extracted data.
• Analyze complex data elements, systems, data flows, dependencies, and relationships to contribute to conceptual, physical, and logical data models.
• Develop Logical Data Models and Physical Data Models, including data warehouse and data mart designs.
• Define relational tables, primary and foreign keys, and stored procedures.
• Write code to develop required solutions and application features, leveraging business, technical, and data requirements.
• Create test cases, proofs of concept, and test/deploy software to production servers.
• Translate business problems within one's discipline to data-related or mathematical solutions, identifying appropriate methods like analytics and big data analytics.
• Provide recommendations to business stakeholders, develop business cases, and align projects to overall business strategy.
• Establish, modify, and document data governance projects and recommendations, implementing practices in partnership with stakeholders.
• Interpret company and regulatory policies on data and educate others on data governance processes.

Required Skills:

• Strong understanding and application of Data Strategy principles.
• Proficiency in Data Transformation and Integration, including data extraction and pipeline creation.
• Expertise in Data Source Identification and performing initial data quality checks.
• Advanced skills in Data Modeling, covering conceptual, physical, and logical data models, data warehouse, and data mart designs.
• Ability to define relational tables, primary and foreign keys, and stored procedures.
• Competence in Code Development and Testing, including writing code, creating test cases, and deploying software.
• Aptitude for Problem Formulation, translating business problems into data-related or mathematical solutions.
• Demonstrated Applied Business Acumen for providing recommendations and translating business requirements.
• Experience with Data Governance, including establishing, modifying, and implementing practices.

Qualifications:

• No specific years of experience, certifications, or educational requirements were explicitly stated.

Preferred Skills:

• No specific preferred skills were explicitly stated.