OP
Looking for a detail-oriented Data Analyst with strong technical expertise and investigative abilities to document current data flows across our systems. Responsibilities include mapping data exchanges between applications, distinguishing between required and optional fields, defining data values, and assessing whether integrations operate in batch or real-time.
Responsibilities
Utilizing existing architecture diagrams and leveraging your skills in AWS, Redshift, and SQL, you will validate and enrich documentation efforts. This role is focused on analyzing data and system interactions to produce clear, precise, and comprehensive integration documentation, distinct from data architecture or engineering roles.
Roles and Responsibilities:
Review existing architecture diagrams to understand the high-level system and data flow design. Document as-is data flows between applications, including: Data sources and destinations. Data values, formats, and definitions Required vs. optional fields Data directionality (inbound, outbound, bidirectional) Integration method (batch vs. real-time) Validate and enhance documentation by exploring source and target systems. Use AWS services (e.g., S3, Redshift, RDS) to inspect data structures and sample records. Write SQL queries to investigate data movement, transformations, and integrity. Collaborate with application owners, developers, and business stakeholders to clarify unclear or undocumented data flows. Maintain organized and version-controlled documentation for reference by technical and business teams. Identify discrepancies between documented architecture and actual data behavior. Required Technical Skills:
Proven experience as a Data Analyst or similar role focused on data flow and data integration documentation. Strong SQL skills for data exploration and verification. Experience working with AWS services (especially S3, Redshift, RDS, Glue). Ability to interpret and validate existing architecture diagrams. Detail-oriented documentation skills, able to produce clear, structured flow maps and tables. Understanding of data integration concepts (batch processing, real-time streaming, APIs, ETL). Strong communication skills for working across technical and non-technical teams.
Preferred Skills:
Experience with data profiling and data quality assessment. Familiarity with BI tools (Tableau, Power BI, Looker) for ad-hoc exploration. Exposure to API data formats (JSON, XML) and file-based integrations (CSV, Parquet).
Benefits
401(k). Dental Insurance. Health insurance. Vision insurance. We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people. The salary will be determined based on several factors, including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.
Additional Responsibilities
Participate in OP monthly team meetings and participate in team-building efforts. Contribute to OP technical discussions, peer reviews, etc. Contribute content and collaborate via the OP-Wiki/Knowledge Base. Provide status reports to OP Account Management as requested.
About us
At OP, we help you harness the power of technology for maximum impact. A technology consulting and solutions company, we offer advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields including AI, cyber security, enterprise architecture, and beyond. For nearly two decades, we ve been challenging the status quo of the consulting industry serving up fresh, ingenious thinking through a radically lean structure. Together, this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward. Seniority level
Seniority level Entry level Employment type
Employment type Full-time Job function
Job function Information Technology Industries IT Services and IT Consulting Referrals increase your chances of interviewing at OP by 2x Sign in to set job alerts for “Data Analyst” roles.
Los Angeles, CA $60,000.00-$290,000.00 1 hour ago Los Angeles, CA $70,000.00-$90,000.00 3 weeks ago Long Beach, CA $87,000.00-$111,000.00 1 week ago Beverly Hills, CA $170,000.00-$190,000.00 3 days ago Assistant, Business Intelligence & Strategy
Los Angeles, CA $55,000.00-$65,000.00 3 weeks ago Los Angeles, CA $50,000.00-$80,000.00 4 weeks ago Los Angeles, CA $101,080.00-$168,888.00 2 weeks ago Burbank, CA $80,000.00-$105,000.00 3 weeks ago Los Angeles, CA $90,000.00-$110,000.00 1 month ago Rosemead, CA $72,000.00-$101,500.00 2 days ago Data Analyst- Junior- Full Time - Remote
Montebello, CA $75,000.00-$95,000.00 1 day ago Data Analyst Junior - Entry Level - Junior
Data Reporting and Analytics Consultant I
Los Angeles Metropolitan Area $105,000.00-$120,000.00 2 weeks ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Responsibilities
Utilizing existing architecture diagrams and leveraging your skills in AWS, Redshift, and SQL, you will validate and enrich documentation efforts. This role is focused on analyzing data and system interactions to produce clear, precise, and comprehensive integration documentation, distinct from data architecture or engineering roles.
Roles and Responsibilities:
Review existing architecture diagrams to understand the high-level system and data flow design. Document as-is data flows between applications, including: Data sources and destinations. Data values, formats, and definitions Required vs. optional fields Data directionality (inbound, outbound, bidirectional) Integration method (batch vs. real-time) Validate and enhance documentation by exploring source and target systems. Use AWS services (e.g., S3, Redshift, RDS) to inspect data structures and sample records. Write SQL queries to investigate data movement, transformations, and integrity. Collaborate with application owners, developers, and business stakeholders to clarify unclear or undocumented data flows. Maintain organized and version-controlled documentation for reference by technical and business teams. Identify discrepancies between documented architecture and actual data behavior. Required Technical Skills:
Proven experience as a Data Analyst or similar role focused on data flow and data integration documentation. Strong SQL skills for data exploration and verification. Experience working with AWS services (especially S3, Redshift, RDS, Glue). Ability to interpret and validate existing architecture diagrams. Detail-oriented documentation skills, able to produce clear, structured flow maps and tables. Understanding of data integration concepts (batch processing, real-time streaming, APIs, ETL). Strong communication skills for working across technical and non-technical teams.
Preferred Skills:
Experience with data profiling and data quality assessment. Familiarity with BI tools (Tableau, Power BI, Looker) for ad-hoc exploration. Exposure to API data formats (JSON, XML) and file-based integrations (CSV, Parquet).
Benefits
401(k). Dental Insurance. Health insurance. Vision insurance. We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people. The salary will be determined based on several factors, including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.
Additional Responsibilities
Participate in OP monthly team meetings and participate in team-building efforts. Contribute to OP technical discussions, peer reviews, etc. Contribute content and collaborate via the OP-Wiki/Knowledge Base. Provide status reports to OP Account Management as requested.
About us
At OP, we help you harness the power of technology for maximum impact. A technology consulting and solutions company, we offer advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields including AI, cyber security, enterprise architecture, and beyond. For nearly two decades, we ve been challenging the status quo of the consulting industry serving up fresh, ingenious thinking through a radically lean structure. Together, this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward. Seniority level
Seniority level Entry level Employment type
Employment type Full-time Job function
Job function Information Technology Industries IT Services and IT Consulting Referrals increase your chances of interviewing at OP by 2x Sign in to set job alerts for “Data Analyst” roles.
Los Angeles, CA $60,000.00-$290,000.00 1 hour ago Los Angeles, CA $70,000.00-$90,000.00 3 weeks ago Long Beach, CA $87,000.00-$111,000.00 1 week ago Beverly Hills, CA $170,000.00-$190,000.00 3 days ago Assistant, Business Intelligence & Strategy
Los Angeles, CA $55,000.00-$65,000.00 3 weeks ago Los Angeles, CA $50,000.00-$80,000.00 4 weeks ago Los Angeles, CA $101,080.00-$168,888.00 2 weeks ago Burbank, CA $80,000.00-$105,000.00 3 weeks ago Los Angeles, CA $90,000.00-$110,000.00 1 month ago Rosemead, CA $72,000.00-$101,500.00 2 days ago Data Analyst- Junior- Full Time - Remote
Montebello, CA $75,000.00-$95,000.00 1 day ago Data Analyst Junior - Entry Level - Junior
Data Reporting and Analytics Consultant I
Los Angeles Metropolitan Area $105,000.00-$120,000.00 2 weeks ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr