Data Warehouse Analyst

3 weeks ago


Philadelphia, United States Contemporary Staffing Solutions Full time
Job DescriptionJob Description

Role: Data Warehousing Analyst
Type: Contract, high potential to convert to perm
Location: HYBRID - Center City, Philadelphia (3 days per week on-site) - must be local to Philly area in PA, NJ, DE to be considered.
*W2 only. We cannot work with third-party vendors for this position

Overview:
Our client a national health care insurance company is looking for a Data Warehousing Analyst This role sits on the EIM Data Warehouse team and requires experience in creating Business Requirement Documents, Functional Requirement Documents, and Mapping documents for the development of ETL applications. This role requires extensive SQL experience in writing complex queries across multiple tables, data analysis and profiling skills for the creation of the mapping documents and further discussion with data modelers for the necessary table designs.

The ideal candidate should have all of the above skills at expert level along with strong verbal and written communication skills to work with various stakeholders, gather and formulate business requirements and translate the same to the technical team.

Other preferred experience includes Source-to-Target mapping, health insurance knowledge and general data warehousing. The candidate will also be comfortable enough to support testing, production readiness verification and ensuring accuracy after the deployments. This might include weekend and off-hours support.

Skill/Experience/Education

  • Looking for experience supporting data warehouse projects (amid a data warehouse migration is a plus)
  • Strong Data Profiling and Analysis skills
  • MUST have strong SQL knowledge: writing complex queries, joins, and aggregate functions)
  • Strong Data Mapping skills (source-to-target mapping)
  • Strong functional and business requirements documentation skills
  • Strong verbal, writing, and active listening skills.
  • Data warehousing knowledge
  • Healthcare experience is nice to have
Company DescriptionContemporary Staffing Solutions (CSS) is a company that exudes unwavering results with urgency, honesty, and integrity. CSS has been a leading provider of contract, temporary, and direct hire solutions. Nationally supporting Salesforce Projects & Managed Services and staffing solutions with a focus in Accounting & Finance, Human Resources, Sales & Marketing, Information Technology, Salesforce, and Call Center & Office. Everyone at CSS operates with pro-active pipelines, the highest business ethics, a winning spirit in our approach, and a team-oriented workflow with real cross-training. The CSS team coaches you with current business intelligence so that we can timely deliver solutions to meet your expectations. Our testimonials on our website tell the story from our clients and candidates—check them outCompany DescriptionContemporary Staffing Solutions (CSS) is a company that exudes unwavering results with urgency, honesty, and integrity. CSS has been a leading provider of contract, temporary, and direct hire solutions. Nationally supporting Salesforce Projects & Managed Services and staffing solutions with a focus in Accounting & Finance, Human Resources, Sales & Marketing, Information Technology, Salesforce, and Call Center & Office. Everyone at CSS operates with pro-active pipelines, the highest business ethics, a winning spirit in our approach, and a team-oriented workflow with real cross-training. The CSS team coaches you with current business intelligence so that we can timely deliver solutions to meet your expectations. Our testimonials on our website tell the story from our clients and candidates—check them out

  • Philadelphia, United States IntePros Full time

    Business System Analyst OverviewThe Senior Business Systems Analyst determines business requirements by working with business clients and recommends appropriate business system applicationsRecommends systems criteria and project scopeIdentifies potential problems, performs analysis and implements system enhancements, modifications and upgradesPlans and...


  • Philadelphia, United States IntePros Full time

    Business System Analyst OverviewThe Senior Business Systems Analyst determines business requirements by working with business clients and recommends appropriate business system applicationsRecommends systems criteria and project scopeIdentifies potential problems, performs analysis and implements system enhancements, modifications and upgradesPlans and...


  • Philadelphia, United States IntePros Full time

    Business System Analyst OverviewThe Senior Business Systems Analyst determines business requirements by working with business clients and recommends appropriate business system applicationsRecommends systems criteria and project scopeIdentifies potential problems, performs analysis and implements system enhancements, modifications and upgradesPlans and...


  • Philadelphia, United States Canopy One Solutions Full time

    Job DescriptionJob DescriptionGreetings from Canopy One Solutions, Hope your day is treating you well! Please glance the requirement & respond me back with your finest consultant Resumes & Contact Details.Project Details: Role:Business Systems Analyst w/ Data Warehouse Location:Philadelphia, PA / Hybrid (1-3 days onsite) Duration:6+ months/longterm Type:W2...


  • Philadelphia, United States Philadelphia Streets Full time

    **Data Warehouse Quality Assurance Analyst** * 1601 Market St, Philadelphia, PA 19102, USA * Full-time **Company Description** Who We Are A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons...

  • Data Analyst

    2 weeks ago


    Philadelphia, United States DiamondPick Private Limited Full time

    Job Overview: **Job Title: C2H - BSA/Data Analyst** **Hybrid Role**:Onsite and Remote. Expected to come onsite as needed during contract period. Once converted to FTE, may need to be onsite 1-3 days a week. **Work Address**:Philadelphia, PA 19103 - **This is a BSA/Data Analyst with strong Data Warehouse and advanced SQL experience.**: - **SQL - Must be...


  • Philadelphia, United States HealthVerity Full time

    Position: Data Integrations Analyst Reporting to: Director, Healthcare Data Transformation Location: Philadelphia, PA How you will help *You'll be embarking on a hands-on role, from ingestion up to making all data available in the warehouse layer, in standardized form, and ready to use. You'll investigate and map the data, assess data quality, and QA the...


  • Philadelphia, United States HexaQuEST Global, Inc. Full time

    Looking for a Business Data Analyst who is proficient with SQL Scripting along with good experience of SSIS, SSRS, Tableau along with Data Warehousing tools. The Candidate must have a prior Health-Care Experience.Skill Set•Business process modeling, data modeling and database design, Documentation and report writing•Microsoft Office Suite, SQL, Visio,...


  • Philadelphia, United States KLS Logistics Full time

    **WMS Analyst I** Are you a tech-savvy problem solver with a passion for optimizing warehouse management systems? Do you love analyzing data and collaborating with cross-functional teams to deliver top-notch results? If you're nodding your head "yes" to these questions, then we want YOU! As our WMS Analyst II, you'll be our go-to guru for implementing and...


  • Philadelphia, United States HexaQuEST Global, Inc. Full time

    Looking for a Business Data Analyst who is proficient with SQL Scripting along with good experience of SSIS, SSRS, Tableau along with Data Warehousing tools. The Candidate must have a prior Health-Care Experience. Skill Set • Business process modeling, data modeling and database design, Documentation and report writing • Microsoft Office Suite, SQL,...

  • Data Analyst

    3 weeks ago


    Philadelphia, United States The School District Of Philadelphia Full time

    **Data Analyst** **-** **(**50021606**)** **Description** - Note: This position is not represented by a union. The salary range for this pos_ition is $55,449 - $_74,671_ The School District of Philadelphia is the cornerstone provider of public education in Philadelphia. Over 131,000 students entrusted to the District arrive at school every day with an...

  • Data Analyst

    1 week ago


    Philadelphia, United States IntePros Consulting Full time

    IntePros is seeking a Data Analyst for one of our client's, a leader in the health insurance industry. This role will have onsite responsibilities in Philadelphia, PA. Job Title: Data Analyst Job Description: The Data Analyst will work closely with cross-functional teams to identify data and analytical needs, gather necessary data, conduct detailed...

  • Data Analyst

    2 months ago


    Philadelphia, United States Drexel University Full time

    **Job no**: 503044 **Work type**: Part-Time **Location**: Hybrid/Flexible Work Arrangement, Other - Philadelphia, PA **Categories**: Drexel University, Dornsife School of Public Health **Job Summary** The Dornsife School of Public Health is seeking a biostatistics Data Analyst for the Chinese Immigrant Enclave/Neighborhood study. The analyst will work...


  • Philadelphia, United States Capital One Financial Corp Full time

    Center 1 (19052), United States of America, McLean, Virginia Principal Data Analyst At Capital One, data is at the center of everything we do. When we launched as a startup we disrupted the credit card industry by individually personalizing every credit card offer using statistical modeling and the relational database, cutting edge technology in 1988!...


  • Philadelphia, United States Aramark Uniform Services Full time

    ** Business Systems Analyst - Warehouse Management Systems** **Job Category****:** IT-Systems Admin **Requisition Number****:** BUSIN13406 Showing 1 location **Job Details** **Description** **Aramark Uniform Services is Currently Hiring for a Business Systems Analyst Warehouse Management Systems in Lawrenceville, GA.** **Position Description:** ARAMARK is...


  • Philadelphia, United States American Heritage Credit Union Full time

    Job DescriptionJob DescriptionAmerican Heritage Credit Union, a $4.6+ billion credit union, has an immediate opening for a Data Warehouse Administrator. This position will implement the Advanced Reporting for Credit Unions (ARCU) data warehouse and manage the operation of the system. Take and handle new requests from the end user community for new queries...


  • Philadelphia, United States American Heritage Federal Credit Union Full time

    American Heritage Credit Union, a $4.6+ billion credit union, has an immediate opening for a Data Warehouse Administrator. This position will implement the Advanced Reporting for Credit Unions (ARCU) data warehouse and manage the operation of the system. Take and handle new requests from the end user community for new queries and reports. Add additional data...


  • Philadelphia, United States American Heritage Credit Union Full time

    Job DescriptionJob DescriptionAmerican Heritage Credit Union, a $4.6+ billion credit union, has an immediate opening for a Data Warehouse Administrator. This position will implement the Advanced Reporting for Credit Unions (ARCU) data warehouse and manage the operation of the system. Take and handle new requests from the end user community for new queries...


  • Philadelphia, United States American Heritage Federal Credit Union Full time

    American Heritage Credit Union, a $4.6+ billion credit union, has an immediate opening for a Data Warehouse Administrator. This position will implement the Advanced Reporting for Credit Unions (ARCU) data warehouse and manage the operation of the system. Take and handle new requests from the end user community for new queries and reports. Add additional data...


  • Philadelphia, United States American Heritage Federal Credit Union Full time

    American Heritage Credit Union, a $4.6+ billion credit union, has an immediate opening for a Data Warehouse Administrator. This position will implement the Advanced Reporting for Credit Unions (ARCU) data warehouse and manage the operation of the system. Take and handle new requests from the end user community for new queries and reports. Add additional data...