Role: Sr. SQL Data Analyst
Location: Philadelphia, PA
Hybrid- 3 Days Onsite
Key Skills Required:
Strong and Extensive SQL Experience
Data Profiling
Data Migration
EDW
The Role –
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. Candidates should be
local to the office.
Key responsibilities:
Data Extraction and Transformation:
Data Analysis and Visualization:
Data Modeling:
o Develop data models to represent and structure Salesforce data for analysis.
o Utilize Salesforce data architecture best practices to design efficient data models.
Data Integration:
Data Quality Management
Data Security and Compliance
OMNISTAR EEO:
The equal employment opportunity policy of the OMNISTAR Solutions LLC., provides for a fair and equal employment opportunity for all associates and job applicants regardless of race, color, religious creed, national origin, ancestry, age, gender, pregnancy, sexual orientation, gender identity, marital status, familial status, disability or genetic information, in compliance with applicable federal, state and local law. OMNISTAR Solutions LLC., hires and promotes individuals solely on the basis of their qualifications for the job to be filled.
OMNISTAR Solutions LLC. does not tolerate an atmosphere of intimidation or harassment. We expect and require the cooperation of all associates in maintaining an atmosphere free from discrimination and harassment with mutual respect by and for all associates and applicants.
