Salesforce Data Architect

Salesforce Data Architect

02 Mar 2024
Ohio, Cleveland, 44106 Cleveland USA

Salesforce Data Architect

Vacancy expired!

Blue5green expertise in Management Consulting and Information Technology has made a valuable asset to our clients in the public and private sectors. Please review our latest open position below and apply with your updated resume if you are interested.
Please note that this is a W2 contract role (No C2C) so U.S. Citizens and those authorized to work in the U.S without sponsorship are encouraged to apply.

Salesforce Data Architect
Cleveland
No
W-2
6 months


Blue5green expertise in Management Consulting and Information Technology has made a valuable asset to our clients in the public and private sectors. Please review our latest open position below and apply with your updated resume if you are interested.
Please note that this is a W2 contract role (No C2C), so U.S. Citizens and those authorized to work in the U.S without sponsorship are encouraged to apply. General Duties

  • Lead data management and migration projects
  • Develop, maintain, and review data processes and architecture for both on-premise and cloud-based data systems
  • Conduct team reviews and recommend data modeling, administrative, and design improvements
  • Demonstrate ability to learn and research advanced data technologies and concepts, learning new skills and software as necessary
  • Work closely with team members to optimize database queries.
  • Demonstrate high-level knowledge of enterprise IT organizational, business, and technical environments
  • Produce highly detailed document artifacts and maintain them for the duration of projects
  • Assess all risks and offer mitigation strategies, communicating impacts to the project across multiple channels
  • Interpret client functional and informational needs and turn them into data requirements, process models, and active systems
  • Support assigned systems throughout transition periods
Skills & Experience
  • Possess a client-focused attitude through conversations and documentation
  • Demonstrate deep data integration and/or migration experience with Salesforce.com and other cloud-enabled tools
  • Demonstrate expertise in complex SQL statements and RDBMS systems such as Oracle, Microsoft SQL Server, PostGres
  • Experience with master data management, data governance, data security, data quality, and related tools desired.
  • Demonstrate experience with complex coding through ETL tools such as Informatica, SSIS, Pentaho, and Talend
  • Demonstrate strong verbal and written communication skills across multiple levels of the organization
  • Coordinate management activities with others on the team
  • Experience with full-fledged data warehouse or data mart models
  • Experience with both dimensional and 3rd normal form data modeling, data integration, and reporting
  • Hands-on ability to set up reporting tools and build reports and ad hoc functionality
  • Experience with reporting / BI tools such as Business Objects, Cognos, or SSRS
  • Strong written and spoken communication skills
  • Related certifications in Informatica and Salesforce a plus
  • Experience with industry standards and frameworks such as TOGAF and DMBOK a plus
  • Previous experience in consulting is a plus.
  • Bachelor's degree required.
  • Must be authorized to work for any U.S. employer
  • Willingness to travel up to 50%

Related jobs

  • Join the Cleveland Clinic team, where you will work alongside passionate caregivers and provide patient-first healthcare. Cleveland Clinic is recognized as one of the top hospitals in the nation. At Cleveland Clinic, you will work alongside passionate and dedicated caregivers, receive endless support and appreciation, and build a rewarding career with one of the most respected healthcare organizations in the world.

  • The Shared Data Platforms Solution Architect is a member of Shared Data Platform IT group and maintains the architecture (and related artifacts) for data centric applications and systems. The Solutions Architect is responsible for leading collaboration with Business and IT Stakeholders throughout the organization to design solution architectures that deliver the required business capabilities while being aligned to Sherwin-Williams business and technology strategies. This role specifically is responsible for the systems that handles the data including products, catalogs, suppliers, and customers.

  • Join Cleveland Clinic\'s Main Campus where research and surgery are advanced, technology is leading-edge, patient care is world-class, and caregivers are family. At Cleveland Clinic, you will work alongside passionate and dedicated caregivers, receive endless support and appreciation, and build a rewarding career with one of the most respected healthcare organizations in the world.

  • Job ID 12614 Location Case Main Campus Full/Part Time Full-Time Regular/Temporary Regular Job Description POSITION OBJECTIVE The Assistant Director of Facilities Data Management, Visualization and Analytics will provide leadership for establishment of a comprehensive suite of data analytics tools and resources for the facilities enterprise of Case Western Reserve University. This work will enable the Vice President for Campus Planning and Facilities Management and leadership across the campus including the President, Provost, Deans, facilities directors, and financial directors to assess facilities and space information systematically and efficiently. The assistant director will use extensive knowledge of Case Western Reserve University enterprise software systems to lead the development of automated processes for administrative functions of campus planning and facilities management to increase efficiency and accuracy. The assistant director will research and develop requirements for enhancements to existing database systems and data analytics software applications/visualizations, including improvements to data pipelines, data management, and data governance, to improve business efficiency and decision-making. The assistant director will also serve as the system administrator for the university-wide space management system (FM Systems), maintain space information, and provide ongoing support to campus users of the space management system through training, maintenance, and troubleshooting of the system. ESSENTIAL FUNCTIONS Provide vision and leadership in the development and implementation of the use of standardized data analytics tools to readily assess the productivity of the facilities enterprise of Case Western Reserve University for leadership at all levels. Utilizing extensive knowledge of resident data in university enterprise systems, such as PeopleSoft Financials, PeopleSoft HCM, PeopleSoft SIS, FM Systems, Asset Essentials (CMMS - computerized maintenance management system), and other project management software, to recommend analytics tools and dashboards to visualize and report on facility and space data. (20%) Responsible for implementing and maintaining a university-wide, space management system for various university constituencies including Campus Planning and Design, Facilities Services, Facilities Management (within individual schools/colleges), Controller\'s Office, Room Control, Registrar(s), Housing etc. This space management system will support an inventory of all university properties and facilities, and will provide the university with a well-organized, comprehensive, accurate database of spaces which identifies existing building square footage, use type, assignment of users, etc. (20%) Consult university leadership to capture data and analytics related requirements. Collaborate with members of campus planning and facilities management and the University Technology (computer services) team supporting research administration to provide continual improvement in business intelligence and systems landscape. Develop and create standardized reports for facilities leaders, university leadership, and the board of trustees that accurately documents facility and space information across the campus. Responsible for design, development, and maintenance of advanced analytics projects for campus planning and facilities management. Analyze and make recommendations on how to make data pipelines more efficient for end users. Combine challenging datasets, including large amounts of data to extract meaningful insights. Test and validate data models and visualizations in collaboration with business analysts and customers. Diagnose and correct problems with data visualizations, data pipelines, and data quality. (20%) Lead the space management coordinator/CAD technician who is responsible for maintaining all electronic and paper architectural an

  • data engineer lead (specialized).

  • Job ID 12539 Location Case Main Campus Full/Part Time Full-Time Regular/Temporary Regular Job Description POSITION OBJECTIVE Working independently with limited supervision, the Immigration Data Specialist will serve as a key member of the Visa and Immigration Services and Advisors (VISA) Office by acting as business/ project manager for one or more functional modules, balancing multiple projects and priorities within and also across modules and customers, both internal and external. Responsible for complete project life cycle of international systems, working independently and with emphasis on all customer-facing activities including implementing a strategic plan, including metrics and goals, in order to maximize the university\'s investment in Terra Dotta, Student Information System (SIS), and Student and Exchange Visitor System (SEVIS). The specialist is responsible for understanding the matriculation and immigration processes for international students and ensuring the accuracy of student records for all international students. The specialist will function independently to ensure systems meet the needs of the VISA office and enhance the customer service experience while facilitating compliance. Finally, the specialist will analyze data to identify trends and design and implement procedures and policies to meet growing needs. This position requires a familiarity with the university and its administrative and academic structure in addition to a working knowledge of U.S. Citizenship and Immigration Services (USCIS) and Department of State (DOS) F-1 and J-1 regulations and procedures. ESSENTIAL FUNCTIONS Ensure business systems solutions for the international student and scholar database (Terra Dotta) are functional and meet requirements. Serve as a liaison between Terra Dotta and users of Terra Dotta on campus, build and streamline systems, independently create appropriate processes and procedures to increase effectiveness, and analyze customer needs. Develop and implement testing scenarios. Maintain system requirements and/or specification documentation for the international student database. Analyze systems interface requirements, coordinate the exchange of data within and outside the university. Assure accuracy and integrity for the integration and migration of data between and among systems. Manage the Student and Exchange Visitor Information System (SEVIS) as a designated official. (30%) Analyze international student data to create pathways for systems growth and responsiveness. Mine and analyze historical data to improve efficiencies and customer service. (20%) Carefully monitor the interface and transfer of information from the university\'s Student Information System (SIS) to Terra Dotta and from Terra Dotta to SEVIS. Liaison with [U]Tech, researching and resolving any interface difficulties between systems. (20%) Serve as a Designated School Official (DSO) and Alternate Responsible Officer (ARO) for Case Western Reserve University. This role requires U.S. government adjudication and training and gives the SEVIS coordinator the independent authority to advise students on a case-by-case basis on their legal immigration status in the United States, when needed as backup for International Student Advisors and Immigration Specialists. Independently interpret complex U.S. regulations that require specific and ongoing training and expertise to help Case Western Reserve University remain compliant and keep international students in status. Recommend Case Western Reserve University immigration policies based on expertise with U.S. government regulations. (10%) Monitor data input and data reporting for departmental audits, university administrators, community organizations, and governmental agencies, including the annual Open Doors Report (International student statistics sent to the Institute of International Education). Design systems to track

  • Location: MetroHealth Old Brooklyn Campus

Job Details

  • ID
    JC10489019
  • State
  • City
  • Job type
    Contract
  • Salary
    N/A
  • Hiring Company
    Blue5Green LLC
  • Date
    2021-03-02
  • Deadline
    2021-05-01
  • Category

Jocancy Online Job Portal by jobSearchi.