TPC Group ยท 1 day ago
Jr. Analyst, Technical Applications
TPC Group is seeking a technically capable and detail-oriented Jr. Analyst, Technical Applications to join their IT team. The role involves managing data operations, supporting application development, and ensuring accurate reporting processes across Oracle-based systems, with a clear path for career growth in data integration and business intelligence.
Responsibilities
Extract, transform, and load (ETL) data from multiple source systems into the Oracle data warehouse using native SQL and Oracle Data Integrator (ODI)
Assist in maintaining and developing ODI data flows, including sources, mappings, packages, and scenarios
Participate in the administration and performance monitoring of Oracle-based data warehouse environments
Develop and maintain an understanding of ERP (Oracle EBS) and related supporting systems to ensure accurate and efficient data provisioning
Support and enhance Oracle APEX applications, including report and form development, user interface improvements, and data integration
Build and maintain Power BI, Oracle Enterprise Command Center, and Microsoft Report Builder reports and dashboards
Collaborate with business stakeholders to define reporting requirements and deliver effective, data-driven solutions
Ensure reporting accuracy and consistency across all supported systems
Provide technical support for existing applications, integrations, and reporting solutions
Troubleshoot and resolve data and reporting issues to maintain reliability and performance
Document configurations, mappings, and data flow processes
Progressively expand into primary ODI administration and advanced data warehousing responsibilities
Contribute to process optimization, automation, and data quality initiatives
Qualification
Required
3+ years of experience working across diverse IT systems, combining application development (Oracle APEX), data integration (SQL/PLSQL), and system support (Service Manager), with a focus on building and maintaining data-driven business solutions
Proficiency in SQL and PL/SQL; comfortable working with both Oracle and Microsoft SQL Server (Transact-SQL)
Working knowledge of Oracle APEX application development (minimum 1 year experience)
Strong understanding of relational database structures, including tables, views, packages, and stored procedures
Exposure to data warehousing concepts, including staging, transformation, and fact/dimension modeling
Experience with ETL processes, either through scripting or ETL tools
Experience using Power BI and Microsoft Report Builder, or similar reporting platforms
Excellent communication and collaboration skills across both technical and business teams
Strong analytical thinking and practical problem-solving ability
Bachelor's degree in Information Systems, Computer Science, Data Analytics, or other degree with relevant Information Systems professional experience
All applicants must be eligible to work for any U.S. employer without any company immigration sponsorship
Preferred
Familiarity with Oracle Data Integrator (ODI) or similar ETL platforms
Understanding of Oracle E-Business Suite data structures
Experience or interest in Python, PowerShell, HTML/XML, JavaScript or similar scripting languages for data automation and enhancement
Awareness of data governance, data quality, and metadata management principles
Company
TPC Group
TPC Group is a chemicals company providing highly specialized lines of chemical products to major chemical & petroleum-based companies.
Funding
Current Stage
Late StageTotal Funding
unknown2012-08-27Private Equity
2012-08-27Acquired
Recent News
2025-02-05
Business Journals
2024-05-27
Company data provided by crunchbase