Data Warehouse BSA

  • King of Prussia, PA
  • Posted 2 days ago | Updated 9 hours ago

Overview

On Site
$100000 - $135000 per annum
Contract - W2

Skills

SQL
ETL
Data Warehouse
Stakeholders

Job Details



Our client in King of Prussia, PA is seeking a Data Warehouse BSA for a contract to hire. This role will require 2-3 days a week onsite.


Key Responsibilities:



  • Collaborate with business stakeholders to gather and analyze data requirements for reporting and analytics.

  • Develop and maintain target mapping documents to define source-to-target data transformations.

  • Translate business requirements into functional and technical specifications for ETL and data warehouse development.

  • Support ETL development teams by providing clear mapping rules, validation scenarios, and edge case handling.

  • Perform data validation, reconciliation, and issue resolution across data sources and the warehouse.

  • Write and execute SQL queries to analyze data and validate ETL results.

  • Assist in the design of logical and physical data models for the data warehouse.


Qualifications:



  • 5+ years of experience as a Business Systems Analyst in data warehouse or BI projects.

  • Solid understanding of ETL processes and data integration tools (e.g., Informatica, Talend, SSIS).

  • Proficient in SQL for querying, profiling, and validating data.

  • Experience in creating source-to-target mapping (STM) or mapping specifications.

  • Knowledge of dimensional modeling and data warehouse concepts (e.g., facts, dimensions, star/snowflake schema).



Beacon Hill is an equal opportunity employer and individuals with disabilities and/or protected veterans are encouraged to apply.


California residents: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.


If you would like to complete our voluntary self-identification form, please or copy and paste the following link into an open window in your browser: ;/p>

Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.

Company Profile:

Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.

Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.

Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting .


Benefits Information:


Beacon Hill offers a robust benefit package including, but not limited to, medical, dental, vision, and federal and state leave programs as required by applicable agency regulations to those that meet eligibility. Upon successfully being hired, details will be provided related to our benefit offerings.




We look forward to working with you.

Beacon Hill. Employing the Future

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Beacon Hill