Data Analyst (Data Integration & Mapping)

The Fountain Group LLC

Santa Clara, CA(remote)

JOB DETAILS
SALARY
$60–$66.67 Per Hour
SKILLS
Academic Background, Amazon Web Services (AWS), Analysis Skills, Architectural Services, Artificial Intelligence (AI), Best Practices, Business Intelligence, Business Intelligence Software, Cloud Computing, Communication Skills, Computer Science, Cross-Functional, Customer Relationship Management (CRM) Systems, Data Analysis, Data Cleaning, Data Mapping, Data Profiling, Data Quality, Data Sets, Data Structures, Data Visualization, Database Extract Transform and Load (ETL), Design Document, Detail Oriented, Enterprise Applications, Graphics, Information Technology & Information Systems, Leadership, Master Data Management (MDM), Metrics, Performance Metrics, Presentation/Verbal Skills, Problem Solving Skills, Quality Assurance, Relational Databases (RDBMS), Reporting Dashboards, Reporting Skills, Requirements Management, SQL (Structured Query Language), Salesforce.com, Short Messaging Service (SMS), Snowflake Schema, Source Code/Configuration Management (SCM), Standards Development, Statistics, Tableau, User Experience Design (UXD), User Interface Design, User Interface/Experience (UI/UX), Writing Skills
LOCATION
Santa Clara, CA
POSTED
8 days ago
100% Remote Role.
Pay: $60-$66.67/hour. W2 only.
Duration: 8 months with extensions based on client need and performance.
 
Job Title: Data Analyst (Data Integration & Mapping) 

Role Overview: 
We are seeking a detail-oriented Data Analyst to support our data consolidation initiatives. In this role, your primary focus will be mapping and analyzing complex data from disparate systems to build a reliable "single source of truth. " You will bridge the gap between raw data and business intelligence by ensuring our data architecture is clean, consolidated, and perfectly structured for downstream visualization in Tableau. 
 
 Duties & Responsibilities 
 Data Consolidation & Mapping: Extract, analyze, and consolidate data sets from multiple disparate sources (e.g., CRMs, ERPs, flat files) into a unified, centralized data repository. 
 
 Single Source of Truth Management: Design and document complex data mapping rules and transformations to establish definitive, standardized definitions for cross-functional business metrics. 
 
 Dashboard & Report Development: Design, build, and maintain interactive Tableau dashboards and automated reports that translate consolidated data into actionable insights for business stakeholders. Create reports in systems like Gainsight, Clarizen, and Salesforce. 
 
 KPI Tracking & Analytics: Collaborate with leadership to define key performance indicators (KPIs) and build intuitive reporting structures that monitor business health, trends, and performance. 
 
 Quality Assurance & Data Cleansing: Perform rigorous data profiling and validation to identify inconsistencies, resolve discrepancies, and ensure data integrity flows seamlessly from the backend systems to the front-end reports. 
 
 
 Required Skills 
 Data Visualization & Reporting: Hands-on experience building complex, interactive dashboards in Tableau (or similar BI tools) and translating business requirements into compelling visual data narratives is required. 
 
 Data Mapping & Integration: Deep expertise in master data management (MDM), data mapping, and ETL/ELT concepts is required. 
 
 Advanced SQL: High proficiency in writing complex SQL queries to extract, join, and manipulate large datasets across various relational databases is required. 
 
 Dashboard UI/UX Design: Strong understanding of dashboard design principles and best practices, focusing on end-user experience, optimal chart selection, and minimizing 
 cognitive load is also needed. 
 
 Analytical Problem Solving: Exceptional ability to untangle messy data structures, spot logical conflicts between systems, and formulate standardized business rules for accurate reporting. 
 
 Communication: Excellent written and verbal communication skills, with the ability to explain complex data trends and architectural concepts to non-technical stakeholders. 
 
 Education & Experience 
 Academic Background: Bachelor's degree in Data Analytics, Information Systems, Computer Science, Statistics, or a related quantitative field is required. 
 Professional Experience: 3+ years of dedicated experience in data analysis, data mapping, and hands-on BI reporting/dashboarding is required. 
 Project Experience: Proven track record of successfully contributing to data consolidation or "single source of truth " initiatives, followed by deploying dashboards on top of those datasets. 
 
 Systems Knowledge: Experience working with cloud data platforms (e.g., Snowflake, BigQuery, AWS) and standard enterprise software databases (e.g., Salesforce, Gainsight, Clarizen). 
 
By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy

About the Company

T

The Fountain Group LLC

The Fountain Group provides Contingent Labor, Statement-of-Work, and Contingent-to-Permanent resources to clients with an internal/external Contingent Labor Managed Service Program or Clients without a program. The Fountain Group is committed to the belief that we all share in the responsibility to conduct our businesses in a socially and environmentally responsible manner. We base this on the premise that a company is much more than the products it offers. The effect a company has on the environment, the people and the communities it serves reflects the company’s dedication to being not only a good business, but to being a good corporate citizen. The Fountain Group believes the key to servicing a client is to identify the client demand precisely. Therefore, The Fountain Group focused its efforts on building and developing a process, which can identify an exact match for our client’s needs. Our process utilizes modern technology combined with 30+ years of Talent Acquisition experience to deliver Precision resources. Financial strength is prominent among The Fountain Group’s corporate values. The future of our business will be built on the innovation, compassion, outstanding services and technology, but a solid financial foundation is required to carry us forward to meet our business goal and support our long term vision.

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
https://www.thefountaingroup.com/