Senior Data Solutions Architect - ETL & Data Warehousing

Krasan Consulting Services; United States; On-site; USD 80,000 - 100,000; Full time

Job summary

A consulting firm in the United States seeks a Data Systems Analyst to design, maintain, and optimize enterprise data systems. The ideal candidate will have strong analytical skills and proficiency in SQL and ETL tools such as Informatica. Responsibilities include developing data integration workflows and ensuring compliance with data standards. A Bachelor's degree and experience in data warehousing and database development are essential. Preferred qualifications include familiarity with healthcare provider enrollment data environments and modern cloud ETL tools.

Qualifications

• Hands-on experience in data integration, data warehousing, and database development.
• Proficiency in SQL with complex queries and optimization techniques.
• Strong understanding of data handling principles and metadata management.

Responsibilities

• Design and maintain data integration workflows using ETL tools.
• Collaborate with business and IT teams to define data requirements.
• Optimize SQL interface files and data validation scripts.

Skills

Data handling

SQL interfaces

ETL tools like Informatica

Analytical skills

Data quality standards

Database design

System integration

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica PowerCenter

SQL Server

Job description

A consulting firm in the United States seeks a Data Systems Analyst to design, maintain, and optimize enterprise data systems. The ideal candidate will have strong analytical skills and proficiency in SQL and ETL tools such as Informatica. Responsibilities include developing data integration workflows and ensuring compliance with data standards. A Bachelor's degree and experience in data warehousing and database development are essential. Preferred qualifications include familiarity with healthcare provider enrollment data environments and modern cloud ETL tools.