Data Architect/Engineer

Active Consulting Services - Philadelphia, PA

Full-time

Philadelphia, PA

Religious, Grantmaking, Civic, Professional, and Similar Organizations

About the position

The Data Architect/Engineer role is a Business System Analyst position within the Enterprise Information Management (EIM) Data Warehouse team. This position involves creating essential documentation for ETL applications, conducting data analysis, and collaborating with data modelers to ensure effective data management. The role requires strong communication skills and the ability to work closely with stakeholders to translate business requirements into technical specifications.

Responsibilities

• Creating detailed Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), and Mapping Documents for ETL applications.
• Conducting data profiling and data analysis to create accurate mapping documents.
• Collaborating with data modelers on necessary table designs.
• Writing complex SQL queries across multiple tables for data analysis.
• Gathering and translating business requirements from stakeholders into actionable technical specifications.
• Performing Source-to-Target mapping and supporting testing and production readiness verification.
• Validating data accuracy post-deployment.
• Providing weekend and off-hours support if necessary.

Requirements

• Strong analytical skills in data profiling and analysis.
• Advanced expertise in SQL for complex queries.
• Experience in creating mapping and functional documents.
• Strong verbal, written, and active listening skills.

Nice-to-haves

• Experience with data warehousing concepts and architecture.
• Background in healthcare data management.