Technical Business Systems Analyst Jobot
Pasadena, CA4 days ago
- $110,000–$150,000 Per Year
Want to know if you’re a fit?
Upload your resume and let our AI show you.
Upload your resume and let our AI show you.
Skills
- Acceptance Testingunmatched
- Agile Programming Methodologiesunmatched
- Amazon Web Services (AWS)unmatched
- Analysis Skillsunmatched
- Business Skillsunmatched
- Business Solutionsunmatched
- Communication Skillsunmatched
- Data Analysisunmatched
- Data Mappingunmatched
- Data Martunmatched
- Data Processingunmatched
- Data Qualityunmatched
- Data Warehousingunmatched
- Database Extract Transform and Load (ETL)unmatched
- Documentationunmatched
- Functional Requirements Document (FRD)unmatched
- Identify Issuesunmatched
- Informaticaunmatched
- Master Data Management (MDM)unmatched
- Microsoft Windows Azureunmatched
- Problem Solving Skillsunmatched
- Query Analysisunmatched
- Query Optimizationunmatched
- Requirements Managementunmatched
- SQL (Structured Query Language)unmatched
- Scrum Project Management and Software Developmentunmatched
- Snowflake Schemaunmatched
- Star Schemaunmatched
- Systems Analysisunmatched
Description
Technical Business Systems Analyst
Location: Irvine, CA (Onsite + In-person interview)
Overview
We are seeking a Technical Business Systems Analyst (BSA) with strong data expertise to bridge the gap between business stakeholders and technical teams. The ideal candidate will have hands-on experience in data analysis, ETL processes, and data warehousing, along with the ability to translate business requirements into scalable technical solutions.
Key Responsibilities
Location: Irvine, CA (Onsite + In-person interview)
Overview
We are seeking a Technical Business Systems Analyst (BSA) with strong data expertise to bridge the gap between business stakeholders and technical teams. The ideal candidate will have hands-on experience in data analysis, ETL processes, and data warehousing, along with the ability to translate business requirements into scalable technical solutions.
Key Responsibilities
- Collaborate with business stakeholders to gather, analyze, and document requirements for data-driven initiatives.
- Translate business needs into functional and technical specifications for development teams.
- Work closely with data engineers and developers on data integration and ETL processes using Informatica.
- Write and optimize SQL queries for data analysis, validation, and troubleshooting.
- Support projects involving data warehouses, data marts, and Master Data Management (MDM).
- Perform data mapping, data lineage analysis, and impact assessments.
- Ensure data quality, integrity, and consistency across systems.
- Participate in UAT (User Acceptance Testing) and validate data outputs against business requirements.
- Act as a liaison between business users and technical teams to ensure smooth project delivery.
- Assist in creating documentation including BRDs, FRDs, and data dictionaries.
- Strong proficiency in SQL for querying and data analysis.
- Hands-on experience with Informatica PowerCenter or similar ETL tools.
- Solid understanding of data warehousing concepts (star/snowflake schemas, fact/dimension tables).
- Experience working on Master Data Management (MDM) initiatives.
- Proven experience in requirement gathering and stakeholder management.
- Strong analytical and problem-solving skills.
- Excellent communication skills with the ability to interact with both technical and non-technical stakeholders.
- Experience with modern data platforms (e.g., Snowflake, Azure, AWS).
- Familiarity with data governance and data quality frameworks.
- Experience working in Agile/Scrum environments.
Numbers & Facts
| Location | Irvine, CA |
| Industry | Computer/IT Services |
| Company Size | 100 to 499 employees |
| Year Founded | 2007 |
| Website | https://www.intersourcesinc.com/ |
About Company
It’s all about harnessing the real power of data. InterSources Inc was founded in 2007 providing intelligent data solutions to clients across industries and geographies.
Over the years, we have built products on Business Intelligence & Big Data platform simplifying and transforming the way business intelligence and real-time data analytics empower Corporations and end-users using Softwares like Tableau, Business Objects, MicroStrategy, etc.
In the process, we have enabled companies to use data analytics to help better understand, predict and influence consumer behavior, identify new market opportunities as they emerge, provide to users the data they need, alert the user when and why key business metrics have changed and enable them to make smart decisions.
Similar Jobs
- New!
IT Systems Analyst – POS & Application Support V-Soft Consulting Group Inc
Highland Park29 days ago- New!
Financial Systems Analyst Vaco LLC
Newport Beach, CA5 days ago- $45–$55 Per Hour
- New!
Systems Analyst Axelon
Aliso Viejo, CA2 days ago- $64–$65 Per Hour
Senior Business Intelligence Analyst System One
Irvine, CA7 days ago- $51.61 Per Hour
Financial Analyst II TSR Consulting
Hollywood, California9 days ago- $35–$38 Per Hour
- Temporary
- Contractor
- Full-time