Alpha Business Solutions Pte Ltd - Philadelphia, PA

posted 2 months ago

Full-time - Mid Level
Philadelphia, PA
Professional, Scientific, and Technical Services

About the position

This position is for a Data Architect in a Business Systems Analyst (BSA) capacity, located in Philadelphia, PA. The role is hybrid, requiring both in-office and remote work, and is structured as a 6-month contract-to-hire (CTH). The primary focus of this role is to leverage extensive SQL experience to write complex queries that span multiple tables. Candidates will be responsible for data analysis and profiling, which are critical for the creation of mapping documents. These documents will serve as a foundation for further discussions with data modelers regarding the necessary table designs. The ideal candidate will possess expert-level skills in SQL and data analysis, complemented by strong verbal and written communication abilities. This is essential for effectively collaborating with various stakeholders to gather and formulate business requirements, which must then be translated into technical specifications for the development team. The role also requires familiarity with Source-to-Target mapping, health insurance knowledge, and general data warehousing principles. In addition to the primary responsibilities, the candidate will be expected to support testing and production readiness verification. Ensuring accuracy post-deployment is a critical aspect of the role, which may involve providing support during weekends and off-hours. Candidates should be local to the Philadelphia office to facilitate this hybrid work arrangement.

Responsibilities

  • Write complex SQL queries across multiple tables.
  • Conduct data analysis and profiling for mapping document creation.
  • Collaborate with data modelers to discuss necessary table designs.
  • Gather and formulate business requirements from stakeholders.
  • Translate business requirements into technical specifications for the technical team.
  • Support testing and production readiness verification.
  • Ensure accuracy after deployments, including weekend and off-hours support.

Requirements

  • Extensive experience in SQL with the ability to write complex queries.
  • Expertise in data analysis and profiling.
  • Strong verbal and written communication skills.
  • Experience with Source-to-Target mapping.
  • Knowledge of health insurance and general data warehousing principles.

Nice-to-haves

  • Experience in supporting testing and production readiness verification.
  • Comfortable providing off-hours support.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service