| Need BI ARCHITECT local to NJ.NY ONLY at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=432908&uid= From: Kapil, Intime Infotech [email protected] Reply to: [email protected] Job Title BI ARCHITECT Location Fairfield (Hybrid Onsite Role) NJ Duration 6 months /Contract JOB DESCRIPTION MODE OF INTERVIEW PHONE THEN SKYPE ANY VISA HYBRID Architecture work for BI, 2-3 projects done from the scratch which includes ETL work, Database structure design for BI (staging/fact tables/Cube-summary tables and Reporting layers) -- this is must have. Database experience (should be able to create Tables/PL SQL procedure/package/Functions and very good with queries) Must have ERP system experience Data warehouse build with ERP system -- A Huge plus, If you find someone with ERP experience, that would be a big win If not ERP, we would like to see some Financial system experience (Banking/Retail/Manufacturing) where GL/AR/AP is used for BI data extract. Power BI / Tableau knowledge -- Plus Really like to see some bigger projects, lot of resumes have 2 months, 6 months projects. I really dont count those. These candidates need to have at least 3-5 full project experience in full process BI Architecture. We need STRONG Architecture experience, they will NOT be managing any resources but they will be managing THE full architecture process. **Skillset is below: SQL Server, SSMS (SSIS, SSRS, SSAS), ORACLE ERP (HUGE BONUS) Major Duties and Responsibilities + Enhance and support current end-to-end data warehouse and analytics platform, develop short and long-term roadmaps, design and implement in accordance with defined roadmaps and plans. + Combine and maintain ERP transactional data with data from additional source systems in the ERP ecosystem. + Structure, cleanse and transform data from multiple data sources for optimal presentation, access, performance, integration, and security. + Develop security and authentication standards for BI solutions for object and row level security. + Implement semantic models and perspectives for different subject areas that serve the analytical needs of various business personas and functions. + Cross-reference diverse requirements from different business units into a standard scalable enterprise catalog of metrics, and BI models and solutions. + Work in conjunction with Master Data to document the metadata and data dictionary. + Identify, design, and implement internal process improvements, including re-designing infrastructure for greater scalability, optimizing data delivery, automating manual processes, and improving data reliability, architectural integrity, and quality. + Document and store source code using standard tools and processes. + Be a self-service analytics champion across the enterprise. + Develop and assist with the development of visuals, dashboards, and reports. + Maintain current knowledge of the technology industry, including leading tools and best practices. + Coordinate any 3rd party development and support vendors, perform functional review of 3rd party development work, and elicit user feedback throughout the development life cycle. + Create and maintain technical documentation. + Provide regular status updates regarding status, issues, or risks. + Respond to service requests and service desk ticket escalations. + Review and validate operational policies and ensure they are being met. + Develop and maintain productive relationships with business users, IT members, and management. Qualifications Required: + At least 10 years of hands-on experience with full life cycle data warehouse technical design (star schemas, cubes, datamarts) and development including ETL, logical and physical data modeling, data mapping from various data sources, loading data warehouse objects including dimensions, hierarchies, fact tables and aggregates, metadata definitions, and report development. + At least 5 years of hands-on experience in architecture design and implementation of business intelligence and predictive analytics on cloud-based Data Warehouses. + At least 5 years of experience with application development, database management and operations including in depth experience with DB object design (Tables/Partitioning/Indexing) and writing highly efficient SQL queries, stored procedures, triggers, functions, and packages. + At least 5 years of experience working closely with business areas to identify business and analytics needs. + At least 5 years of experience translating business requirements into data requests, reports, and dashboards. + At least 5+ years of ERP functional experience particularly with finance and sales modules. + At least 3+ years of using DevOps tool chains and processes. + Proven ability to work independently in converting business and functional requirements into complex reports, data visualizations and dashboards. + Experience with user experience design such as layout, content placement, aesthetics, navigation planning, and usability. + Experience working with Agile methodologies. + Strong communication, collaboration, and diplomatic skills to deliver exceptional service and guide, influence and convince others to adopt change. + Strong written and verbal communication skills for both internal technical members and external business stakeholders with the ability to communicate ideas in both technical and user-friendly terms. + Strong listening and interpersonal skills with a keen attention to detail. + Strong customer service orientation who advocates for providing outstanding customer service. + Ability to forge strong working partnerships within Information Technology and business partners. + Ability to clearly articulate the vision and details for solving business and technical problems that meet or exceed user needs and expectations. + Ability to work effectively within a collaborative team and as an individual contributor, assumes responsibility for project deliverables, works effectively within deadlines and provides overall status of solution readiness. + Highly self-motivated and adept at handling multiple assignments in a timely manner. + Excellent organizational, analytical, time management, prioritization, and task follow-up skills. + BS in a related field, and/or extensive work experience. + Attendance at Kyoceras headquarters office in Fairfield, NJ per current work policies is required. + Company paid relocation is not provided to the Fairfield, NJ office. The candidate must self-relocate. Preferred: + MS in Computer Science or in a related field. + Experience with Microsoft PowerBI, SQL Server (SSIS, SSRS, SSAS, BI Server), Azure Data Factory, and Oracle EBS, EBS Accelerator, Oracle Database, Oracle BI, Tableau. + Knowledge of financial and accounting concepts + Knowledge of sales reporting and planning + Demonstrated project management skills. + BI and Data warehousing Certifications Regards, Kapil Singhal Sr. Technical Resource Specialist InTime Infotech Inc time matters 39962 Cedar Blvd., Ste 185, Newark CA 94560 Contact# : 302-401-6677 x 314 Direct : 302-401-6590 Fax : 510-201-2367 Keywords: business intelligence database information technology microsoft procedural language Arkansas California New Jersey http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=432908&uid= |
| [email protected] View All |
| 02:16 AM 21-Jul-23 |