Data Integration Engineer - DATAa09

$79,200 - $99,000/Yr

Pantheon Data Services - Charlotte, NC

Full-time - Mid Level

Remote - Charlotte, NC

About the position

The Data Integration Developer at Pantheon Data will be responsible for designing and implementing solutions that integrate data from various sources into cloud-based systems. This role emphasizes ensuring data consistency, accuracy, and accessibility while collaborating with stakeholders to meet business needs.

Responsibilities

• Develop integrated data solutions, modernizing, consolidating, and coordinating business needs across several applications.
• Integrate data from various sources into cloud-based systems.
• Build adaptors and APIs with multiple data sources.
• Performance tuning and optimization of all Data Ingestion and Data Integration processes, including Data Platform and databases.
• Build and test new/updated data flows and ensure the data meets business needs.
• Support Data Analyst and Business Stakeholders in analyzing and resolving any data issues as required.
• Ensure data consistency, accuracy, and accessibility.
• Troubleshoot and resolve data integration issues.
• Collaborate with stakeholders to define data integration requirements.

Requirements

• Experience in data integration and ETL processes.
• Understanding of data Schema modeling (Dimensions, Measures, Slowly Changing Dimension).
• 5 or more years proven hands-on experience as a Data Integration engineer in Integration Space.
• 5+ years of experience across SQL, Oracle, DB2, Amazon Redshift, Postgres database systems.
• 2+ years' experience with data wrangling (R, Python for data processing).
• Proficiency in data integration tools such as Informatica, Data Stage, Talend, or Microsoft SSIS.
• Experience with Cloud Data Platforms - Snowflake, Databricks, Cloudera etc.
• Experience with BI Analytical tools - Tableau, Power BI, MicroStrategy etc.
• Expert level knowledge in area of data modeling (e.g., keys, logical, subject areas, referential integrity).
• Ability to thrive in a fast-paced environment with minimal direction, extreme pressure, and tight deadlines.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.

Benefits

• Competitive salaries and benefits
• SmartBenefits through the Washington Metro Area Transportation Authority
• Tuition assistance for continuing education expenses and certifications related to the position