Pantheon Data
Data Integration Engineer - DATA05,DATA11
Pantheon Data, Charlotte, North Carolina, United States, 28245
Company Overview
Pantheon Data (a Kenific Holding company) is a private, small business based in the Washington, DC, area. Pantheon Data was founded in 2011, initially providing acquisition and supply chain management services to the US Coast Guard. Our service offerings have grown in the past ten years, including infrastructure resiliency, contact center operations, information technology, software engineering, program management, strategic communications, engineering, and cybersecurity. We have also grown our customer base to include commercial clients. The company has used this experience to expand our service offerings to other agencies within the Department of Homeland Security (DHS), the Department of Defense (DoD), and other Federal Civilian Agencies.
Position Overview
The Data Integration Engineer will design and implement solutions for integrating data from various sources into cloud-based systems. This role focuses on ensuring data consistency, accuracy, and accessibility.
Responsibilities
Lead data integration efforts; design, develop and deploy complex data integration solutions.
Developing integrated data solutions, modernizing, consolidating, and coordinating business needs across several applications.
Integrate data from various sources into cloud-based systems.
Work to 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.
Building and testing new/updated data flows and ensuring the data meets the business needs.
Support Data Analyst and Business Stakeholder 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.
Required Skills and Experience
Experience in data integration and ETL processes.
Understanding of data Schema modeling (Dimensions, Measures, Slowly Changing Dimension).
10 or more years proven hands-on experience as a Data Integration engineer in Integration Space.
8 years of experience across SQL, Oracle, DB2, Amazon Redshift, Postgres database systems.
2+ years' experience with data wrangling (R, Python for data processing).
Expertise 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.
Education
Bachelor's Degree in Computer Science, Information Technology, or a related field.
Clearance Requirements
U.S. Citizenship with the ability to obtain and maintain a DoD Secret clearance.
Work Location
United States - Remote
Compensation
The salary range for this position is $105,600 - $132,000. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.
Benefits Overview
We are always looking for good people! Pantheon Data is committed to providing its employees with competitive salaries and benefits in order to increase employee satisfaction and productivity. In addition to our benefits, we also offer SmartBenefits through the Washington Metro Area Transportation Authority, where you specify an amount of your pre-tax wages be paid directly to your SmarTrip account. In some cases, tuition assistance may be available for continuing education expenses and certifications related to their position. Additional details may be found at https://pantheon-data.com/careers/
Security Alert to our Candidates
- Recruiting emails received from any email address other than @pantheon-data.com is a phishing attempt. These emails are designed to look like emails from trusted sources but are actually an attempt to steal your personal information. We encourage you to stay vigilant and follow best practices for online security.
Pantheon Data is an Equal Employment Opportunity Employer
Pantheon Data is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity and Affirmative Action Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class.
Equal opportunity legal notices can be viewed on the following PDF: Know Your Rights: Workplace Discrimination is Illegal. You may also view the OFCCP's Pay Transparency Nondiscrimination Provision.
If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to our Talent Team at Recruiting@pantheon-data.com or by phone (571) 363-4020.
This company uses E-Verify to confirm each employee's work authorization. For more information, click here E-Verify Participation Poster
Pantheon Data (a Kenific Holding company) is a private, small business based in the Washington, DC, area. Pantheon Data was founded in 2011, initially providing acquisition and supply chain management services to the US Coast Guard. Our service offerings have grown in the past ten years, including infrastructure resiliency, contact center operations, information technology, software engineering, program management, strategic communications, engineering, and cybersecurity. We have also grown our customer base to include commercial clients. The company has used this experience to expand our service offerings to other agencies within the Department of Homeland Security (DHS), the Department of Defense (DoD), and other Federal Civilian Agencies.
Position Overview
The Data Integration Engineer will design and implement solutions for integrating data from various sources into cloud-based systems. This role focuses on ensuring data consistency, accuracy, and accessibility.
Responsibilities
Lead data integration efforts; design, develop and deploy complex data integration solutions.
Developing integrated data solutions, modernizing, consolidating, and coordinating business needs across several applications.
Integrate data from various sources into cloud-based systems.
Work to 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.
Building and testing new/updated data flows and ensuring the data meets the business needs.
Support Data Analyst and Business Stakeholder 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.
Required Skills and Experience
Experience in data integration and ETL processes.
Understanding of data Schema modeling (Dimensions, Measures, Slowly Changing Dimension).
10 or more years proven hands-on experience as a Data Integration engineer in Integration Space.
8 years of experience across SQL, Oracle, DB2, Amazon Redshift, Postgres database systems.
2+ years' experience with data wrangling (R, Python for data processing).
Expertise 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.
Education
Bachelor's Degree in Computer Science, Information Technology, or a related field.
Clearance Requirements
U.S. Citizenship with the ability to obtain and maintain a DoD Secret clearance.
Work Location
United States - Remote
Compensation
The salary range for this position is $105,600 - $132,000. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.
Benefits Overview
We are always looking for good people! Pantheon Data is committed to providing its employees with competitive salaries and benefits in order to increase employee satisfaction and productivity. In addition to our benefits, we also offer SmartBenefits through the Washington Metro Area Transportation Authority, where you specify an amount of your pre-tax wages be paid directly to your SmarTrip account. In some cases, tuition assistance may be available for continuing education expenses and certifications related to their position. Additional details may be found at https://pantheon-data.com/careers/
Security Alert to our Candidates
- Recruiting emails received from any email address other than @pantheon-data.com is a phishing attempt. These emails are designed to look like emails from trusted sources but are actually an attempt to steal your personal information. We encourage you to stay vigilant and follow best practices for online security.
Pantheon Data is an Equal Employment Opportunity Employer
Pantheon Data is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity and Affirmative Action Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class.
Equal opportunity legal notices can be viewed on the following PDF: Know Your Rights: Workplace Discrimination is Illegal. You may also view the OFCCP's Pay Transparency Nondiscrimination Provision.
If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to our Talent Team at Recruiting@pantheon-data.com or by phone (571) 363-4020.
This company uses E-Verify to confirm each employee's work authorization. For more information, click here E-Verify Participation Poster