Sr. Data Analyst / Data Warehouse Consultant in Onsite San Jose, CA Locals Only USC and GC Onsite Interview at Remote, Remote, USA |
Email: [email protected] |
Title: Sr. Data Analyst / Data Warehouse Consultant Location: Onsite (San Jose, CA) - LOCAL REQUIRED ONLY!! work onsite 3x per week Visa: USC and GC Only Duration: 12 Months+ Interview mode: Onsite Interview/Offer.. This is a hybrid opportunity that requires the consultant to work onsite 3x per week. Candidate must have an updated LinkedIn ID with a picture (REQUIRED!!) Mandatory Requirements: 3+ years' experience in Relational Database Modeling (conceptual, logical, and physical) 6+ years' experience with Microsoft Visual Studio, Microsoft SQL Server, Azure SQL Server, SSIS, SSRS, Power BI Report Server, Power BI Service, SSMS 1+ years' experience with Quest Erwin or similar data modeling tool Dimension Database Modeling Data Vault 2.0 methodology and architecture Desired Qualifications: Tools: Microsoft Azure Storage, ADLS GEN 2, Power Automate, Azure Logic Apps, Azure AI Document Intelligence Tools: Oracle RDBMS Objective: This Resource will support data engineer and data analysis work for the Integrated Justice System and BI Platform Modernization projects. Typical Deliverables : Required Skills & Abilities : Creation of IT data models (e.g., conceptual, logical, physical, canonical); Implementation of data design and transformation procedures. Creation of frameworks for representing data elements. Resolution of conflicts between data models. Design, creation, and maintenance of relational and dimensional databases and data systems. Recommendation and implementation of data reliability, efficiency, and quality improvements. Enhancements to existing database systems to increase operating efficiency or adapt to newer requirements. Recommendation and implementation of data reliability, efficiency and quality improvements. Adherence and contribution to work plan timelines, managing workflows to meet project timeframes. Design and creation of data processing systems that combine core data sources into data repositories Map documentation of data elements from UI screens to database, mapping between 2 databases. Data conversions, imports, and exports of data within and between internal and external systems. Develop data migration scripts for loading data from old system to new target system(s). Develop data transformation and automation processes supporting business systems and data flows. Maintain data repositories quality by adding, modifying, and deleting data as needed and as requested. Troubleshoot data issues and data processing tools, systems, and software. Identify and resolve problems related to database management systems. Develop and maintain a query library to support recurring data requests. Maintain data dictionaries and other related data processing metadata. Implement statistical models to identify trends, correlations, and patterns in data sets. Catalog data sources. Perform data cleansing and filtering. Design analytical dashboards and reports. Mine and analyze multiple data sets (Dimensional) for trends, insights, problems, etc; Document models, solutions, data mapping, technical specifications, data dictionaries, test cases, etc. Relational Database Modeling (conceptual, logical, and physical): 3+ years experience; Tools: Microsoft Visual Studio, Microsoft SQL Server, Azure SQL Server, SSIS, SSRS, Power BI Report Server, Power BI Service, SSMS: 6-7 years experience. Tools: Quest Erwin or similar data modeling tool 1 year experience Education: Bachelors degree higher in a quantitative field (i.e. Computer Science, Statistics, Engineering) or equivalent work experience Kind Regards, Kartik Bhardwaj | Absolute IT | Recruitment Manager 116 Village Blvd Suite 200 Princeton New Jersey 08540 Direct: 609-639 9618 Office: 201-228-3009 EXT 127 [email protected] www.absoluting.com In case there is any urgency or my absence, please feel free to reach Bharat Goyal ( [email protected] ). The information contained in, or attached to this e-mail, contains confidential information, is intended solely for the use of the individual or entity to which they are addressed, and is subject to legal privilege. If you have received this e-mail in error you should notify the sender immediately, delete the message and notify your system manager. The views or opinions presented in this e-mail are solely those of the sender and do not necessarily represent those of the company. The company accepts no liability, legal or otherwise, for any damage caused, directly or indirectly. Please consider the environment before printing this e-mail -- Keywords: artificial intelligence user interface business intelligence information technology green card California Idaho Sr. Data Analyst / Data Warehouse Consultant in Onsite San Jose, CA Locals Only USC and GC Onsite Interview [email protected] |
[email protected] View all |
Wed Aug 14 23:47:00 UTC 2024 |