Senior Data Engineer

Jobtailor; Alabama; On-site; USD 90,000 - 130,000; Full time

Job summary

Jobtailor is hiring a data engineer in the United States to design and build scalable data solutions. You will develop pipelines using SQL, Informatica, IICS, and Snowflake, and create reliable data preparation routines for reporting datasets.

You will model data, optimize queries for Snowflake and Oracle, and work with XML/JSON data in AWS. Strong security, governance, and collaboration with stakeholders are essential.

Qualifications

• Bachelor’s degree or equivalent work experience in a technical field.
• 5+ years of data engineering or database development experience.
• Strong expertise in SQL development and query tuning.
• Proven ETL/data integration experience using Informatica and IICS.
• Experience with Snowflake data warehouse architecture and development.
• Proficiency with Oracle database systems.
• Power BI for data visualization and reporting enablement.
• Solid data modeling, normalization, and relational design.
• Experience handling XML/JSON data structures.
• Building data solutions in AWS cloud environments.
• Strong problem-solving skills and ability to work independently on complex technical challenges.
• Deep understanding of data security, governance and compliance practices.

Responsibilities

• Design and develop data solutions.
• Build, maintain, and optimize data pipelines and workflows for reporting, analytics, and business applications using SQL, Informatica, IICS, and Snowflake.
• Develop and manage data preparation routines for extracts, transformations, and reporting datasets.
• Create and maintain logical and physical data models following normalization best practices.
• Tune queries for performance across Snowflake and Oracle.
• Work with XML/JSON data formats and AWS cloud frameworks for scalable data integration.
• Ensure data security policies and best practices are followed.
• Collaborate with data analysts, developers, and stakeholders to define data requirements for reporting tools like Power BI.
• Recommend improvements to data architecture, workflows, and governance.
• Mentor junior team members and promote continuous learning.

Skills

SQL development

Informatica

IICS

Snowflake

Oracle

Power BI

Data modeling

Normalization

ETL

Data integration

XML/JSON handling

AWS cloud

Data security

Governance

Independent work

Leadership

Education

Bachelor’s degree in Computer Science/Information Systems

Tools

Informatica

IICS

Snowflake

Oracle

Power BI

SQL

Job description

Responsibilities

• Design and develop data solutions.
• Build, maintain, and optimize data pipelines and workflows that support reporting, analytics, and business applications using SQL, Informatica, IICS, and Snowflake.
• Develop and manage data preparation routines for extracts, transformations, and reporting datasets, ensuring reliability and performance.
• Create and maintain logical and physical data models following normalization principles and best practices.
• Tune queries for optimal performance across Snowflake and Oracle environments.
• Work with various structured and semi-structured data formats (XML, JSON) and leverage AWS cloud frameworks for scalable data integration and processing.
• Ensure compliance with data security policies and implement best practices for data protection, integrity, and confidentiality.
• Partner with data analysts, developers, and business stakeholders to define data requirements, streamline processes, and improve data accessibility for reporting tools such as Power BI.
• Recommend and implement improvements to data architecture, workflows, and governance processes.
• Serve as a mentor to junior team members and promote a culture of curiosity and continuous learning.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or a related field; equivalent work experience considered.
• 5+ years of experience in data engineering or database development.
• Demonstrated expertise in SQL development and query tuning.
• Demonstrated expertise in Informatica and IICS for ETL and data integration.
• Demonstrated expertise in Snowflake data warehouse architecture and development.
• Demonstrated expertise in Oracle database systems.
• Demonstrated expertise in Power BI for data visualization and reporting enablement.
• Demonstrated expertise in data modeling, normalization, and relational design.
• Demonstrated expertise in handling and transforming XML and JSON data structures.
• Demonstrated expertise in building data solutions in an AWS cloud environment.
• Strong problem‑solving abilities and the capacity to work independently on complex technical challenges.
• Deep understanding of data security, governance, and compliance best practices.
• High degree of self‑motivation, intellectual curiosity, and commitment to continuous improvement.

Hard Skills

• SQL
• Informatica
• IICS
• Snowflake
• Oracle
• Data modeling
• Normalization
• ETL
• Data integration
• Data visualization

Soft Skills

• Problem‑solving
• Independence
• Curiosity
• Continuous improvement
• Collaboration
• Leadership
• Mentoring
• Communication
• Stakeholder engagement
• Process improvement