Electronic Data Interchange Manager jobs in Orange, CA

About ETC

Electronic Transaction Consultants, LLC (ETC) is a leading provider of smart mobility solutions, including electronic tolling, related operations and maintenance services, and Intelligent Transportation Systems (ITS). ETC delivers innovative solutions to improve safety and operational efficiency. We push the boundaries with vision-based tracking, IoT devices, ML, and the use of cloud technologies. We are a recognized expert in the field of information systems for the transportation industry. We design intricate solutions and systems that deploy thousands of sensors in harsh conditions and send data in real time to a cloud system. From there, we clean, correlate, and price the sensor data outputs. Then we charge customers accounts, deal with violators, and provide customer service functions for the driving public. Our solutions process over two billion toll transactions per year at some of the leading agencies in the industry.

Why join a company like ETC? You get to work on complex projects all while working remotely and having a flexible work schedule. We offer an environment where you can make a real impact on what we do. Some employees who are now in technology leadership roles started their ETC journey in our intern programs. We pride ourselves on promoting and training from within. Do you think you can do it better than we already do it? Come and show us!

Job Description

We are seeking a highly motivated and eager candidate for an onsite Data Analyst position. The ideal candidate will have a strong understanding of data analysis, visualization, and interpretation, along with the ability to leverage advanced tools and techniques to drive actionable insights for our organization. The role involves working closely with cross-functional teams, understanding business requirements, and transforming raw data into meaningful reports and dashboards to support data-driven decision-making.

This Data Analyst position is part of the IT team and will interact directly with the customer and end users while researching data flow and reconciliation issues as well as providing results to frequent ad hoc requests for data in support of customer operations and transaction/financial reconciliation.

Growth can lead onto a Jr DBA or Data Architect role.
Experience and Skills:

Key Responsibilities:

• Data Analysis:
• Analyze large datasets to identify trends, patterns, and insights.
• Conduct quantitative and qualitative analysis to support business strategies.
• Clean, transform, and preprocess data for analysis purposes.
• Business Intelligence:
• Develop interactive dashboards and reports using BI tools, focusing on user experience and ease of understanding.
• Create data visualizations that effectively communicate complex concepts to stakeholders.
• Ensure data accuracy, consistency, and reliability in BI solutions.
• Oracle Analytics Cloud (OAC) or experience with other tools
• Utilize OAC tools and features to design, develop, and deploy analytics solutions.
• Configure and maintain OAC environments, ensuring optimal performance and security.
• Collaborate with IT teams to integrate OAC with other data sources and applications.
• Collaboration and Communication:
• Work closely with business users and stakeholders to gather and understand requirements.
• Present findings and insights to non-technical audiences clearly and persuasively.
• Collaborate with cross-functional teams to align data analysis efforts with organizational goals.
• Continuous Improvement:
• Stay updated with the latest developments in data analytics, BI, and OAC technologies.
• Recommend improvements to existing processes, tools, and methodologies.
• Provide training and support to team members as needed.




Qualifications:

• Bachelor’s degree in Information Technology, Computer Science, Statistics, Mathematics, or a related field.
• 3 years of strong SQL Query generation experience on Oracle RDBMS: knowledge of Oracle PL/SQL script writing is a plus
• 3 years of strong experience fulfilling customer ad-hoc data requests, producing structured/formatted reports
• Proven experience as a Data Analyst with a focus on Business Intelligence and OAC (Oracle Analytics Cloud).
• Proficiency in SQL, data visualization tools (such as Tableau, Power BI, and OAC technologies).
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication and interpersonal skills.
• Ability to work independently and collaborate effectively in a team environment.
• Relevant certifications in data analytics, business intelligence, or Oracle technologies are a plus.
Salary Range: $70-95K, DOE

Job Benefits:

Electronic Transaction Consultants offers a Total Rewards plan designed with you and your family’s health and wellness in mind that includes:

• Paid days off (vacation, sick days, wellness days, bereavement leave)
• Employer-paid health & dental plan
• Healthcare spending account
• 401K Program
• Employee and Family Assistance Program (EFAP)
• Employee referral program

From: Electronic Transaction Consultants