Looking for a Senior Database Reporting Analyst for a 5 month contract with probable extensions and or possible conversion to FTE of our client.
This role is for one or our best financial clients with offices in NYC, Southern New Jersey, Southern Maine and South Carolina.
Candidates can work remotely but will need to work EST hours and is is preferred they are located in the eastern half of the US.
location: Mount Laurel, New Jersey
job type: Contract
salary: $50.00 - 59.94 per hour
work hours: 8am to 4pm
education: No Degree Required
responsibilities:
CANDIDATE PROFILE DETAILS:
Degree/Certifications Required: Bachelor's or equivalent certification
Years of experience: 5yrs+
Reason for request/why opened: New projects
Summary and day to day
Description:
The candidate will work with the project team to map out data requirements against vendor supplied data feeds. Work with data stewards to address data governance and data management controls.
Comprehend proposed solution and communicate out any risks or data gaps. Work with various types of data feeds, e.g., mainframe, text delimited, etc. The ideal candidate will have experience working
with credit card and/or fraud data in a finance institution.
Other skills:
- Able to write advanced SQL to profile data and understand data concepts, entities, and relationships against data requirements
- Able to document a high-level system overview - dataflows and entity relationships
- Able to adapt quickly to an organization's processes and documentation needs
- Excellent communication skills - written and verbal
Must have :
Experience in SQL, Excel, Macros or VBA (SQL Server, MySQL, Access, Oracle)
Experience in profiling data to support functional requirements analysis
Experience in metadata management (data dictionary, data lineage)
2+ years' experience working with a data warehouse/operational data store
Nice to have :
Experience with reporting tools (Tableau, BO, OBIEE, etc.)
Logical data modeling (ERWin, SQL Modeler, Visio)
ETL (Alteryx, Informatica, Java, Python)
System & Data flow Diagramming (Visio)
Skills needed for submittals
Has this candidate worked as a former client Contractor via SOW? - Yes or no
Has your candidate worked at our client as a Full Time employee? - Yes or no
Datawarehouse experience- years
Experience with SQL, MS Access, Excel and VBA- Yes or no
Metadata- years
Review, analyze and evaluate detailed business and functional requirements-years
Diagramming System Flows and Process- years
ETL- years
Knowledge of Database Reporting Tools- years
qualifications:
- Experience level: Experienced
- Minimum 6 years of experience
- Education: No Degree Required
skills:
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.