Business Systems Analyst - Data Warehousing

Business Systems Analyst - Data Warehousing

100% Remote (EST or CST candidates are preferred)

No Visa/No C2C/No 3rd party candidates. This person must work directly on our hourly W2 payroll as a Contractor.

12-months contract (ongoing renewable)

Send resume to asim dot ghosh at insourcenow dot com

Working in an enterprise Data Warehouse team, the BSA will create BRDs, FRDs 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 BSA will use strong verbal and written communication skills to work with various stakeholders, gather and formulate business requirements and translate the same to the technical team. The BSA will also perform Source-to-Target mapping.

50% of the day will be spent in SQL, researching data. The other 50% will be spent working with the business teams.

QUALIFICATIONS

Candidate must have 6- 8 years of experience as a BSA/Technical BA.

Mandatory Skills:

• Very strong SQL experience (writing complex queries, multiple table joins)
• Primary Keys, Foreign Keys, etc.
• Data mapping
• Writing Business and Functional requirement documents.
• Strong data profiling and analysis

Other Skills:

• Experience working with Agile/Waterfall/Kanban methodologies.
• Good understanding of ETL concepts and tools (SSIS, DataStage, etc.)
• Health Insurance background would be highly preferred, but it’s not required.
• Experience working in a data warehouse environment.
• Understanding how to read data models, preferably working with a data modeling team.
• Any experience with any Cloud technology (AWS, Google, Azure, etc.).