Oracle Business Intelligence Reporting Software Developer
Auriga Corporation
Full-time
On-site
Los Angeles, California, United States
$100,000 - $120,000 USD yearly
Software Development
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
(Auriga Website: www.aurigacorp.com)
Auriga Corporation was established in 1990, to provide high-quality design, engineering and project management services for Electric Power, Telecommunication and Information Technology systems. Auriga’s cliental includes: investor owned and municipal utilities, rail and transit agencies, federal, state and local government agencies, and international public and private sector organizations.
Auriga Corporation is looking for an experienced, talented and self motivated individual to join our team to help us provide our customers with innovative and cost effective solutions and services. An ideal candidate will be excited to be part of a company that moves quickly on a constant flow of ideas, is able to wear multiple hats as needed, and has the drive to succeed.
Auriga Corporation currently has following vacancies in the Los Angeles, California Office:
Oracle Business Intelligence Reporting Software Developer
Job Responsibilities:
- Work with Business Depts. and ITS team members to build insightful Reports and Dashboards catering to the various business departments.
- Work on Power BI, Oracle Transaction BI and other reporting tools to build reports and dashboards on Oracle Financial data, Oracle HCM data, Hexagon EAMS data.
- Work on orchestration ETLs to extract data from various to ingest into a Central Data Warehouse. Develop detailed documentation for custom ETL data maps.
- Assist in Data Governance effort, mainly in the areas of Data Cataloging and Data Quality Management.
- Produce detailed technical design documents to match the solution design specifications.
- Closely involved in all BI development efforts and provide quality assurance efforts for BI/Power BI configurations, platforms and gateways.
- Participates and lead, when needed, BI Project meetings with the customer to gather requirements (functional and technical).
- Provides quality reviews during development of BI solution designs through multiple project stages to ensure consistency.
- Provides knowledge transfer to Metro ITS staff as required throughout contractual term.
- Provide direction and advice ITS PM on the usage of predictive analytics using Data Sciences and Machine learning.
- Assist ITS PM with scoping and planning major business-driven BI Project activities and engagements.
- Providing functional and technical content for project deliverables.
- Advising ITS Executive Management on BI emerging trends and industry best practices.
- Participate in the design of data architectures.
- Designs, configures and builds databases that are used in relation to data architectures.
- Maps data elements and translates data so that it can be shared among various application systems.
- Assists in the development of strategies for data archive/recovery, database implementation and data acquisition
Minimum Qualifications:
- Bachelor’s degree in a related field.
- Minimum 5 years experience Microsoft Power BI (Desktop & Service), Power Query, DAX scripting, Fabric and Azure Data Factory.
- Minimum 5 years experience Oracle Transaction Business Intelligence, Oracle Analytics Cloud, Oracle Data Integrator/Informatica, SQL and PL/SQL.
- Minimum 5 years of experience with Cloud ETL tools.
- Experience with Tableau.
- Familiarity with Oracle EBusiness Suite data structure, tables, and reports is a plus.
- Experience working with NoSQL databases is a plus.
- Deep understanding of dimensional modeling (Star Schema, Snowflake Schema).
- Strong grasp of data extraction techniques, data transformation rules (cleansing, aggregation, standardization), and efficient data loading strategies.
- Understanding of data quality frameworks, master data management (MDM) principles, and data lineage.
- Knowledge of effective data visualization principles, dashboard design, and storytelling with data.
- Knowledge of data sciences and machine learning is a plus.
- Experience using Microsoft Suite of Products (Office, SharePoint, Visio).
- Experience gathering requirements and architecting technical solutions.
- Ability to make presentations to technical teams and business users.
Auriga is an Equal Opportunity Employer. Auriga provides compensation and benefits commensurate with the qualifications and experience.
Compensation: $100,000.00 - $120,000.00 per year
About Us
Auriga Corporation is a privately held company established in 1990 to provide high-quality Consulting Services. For over 30 years Auriga has successfully provided services in Project Management, Electrical Engineering, Fare and Payment Collection, Information Technology, Construction Management and Systems Engineering.
Auriga Corporation continues to provide Consulting Services to the Rail and Transit Systems, Municipal Utilities, United States Federal Government, The State of California, International Governments and International Public and Private Sector Organizations.
Auriga was established with the vision to be a Premier Provider of Consulting and Engineering Services in the US and across the world. Auriga’s mission is to provide valuable and cost effective professional engineering services to our customers. Auriga’s business model is based on the Four pillars – Honesty, Integrity, Excellence and Commitment. The ultimate goal at Auriga is to Increase Customer Satisfaction, Ensure Employee Satisfaction, Promote a healthy work Environment and create value for the society at large.
Careers
Auriga Corporation is a privately held company that provides high-quality consulting services for Electric Power, Telecommunications, and Information Technology systems. We have been in successful operation for more than 20 years. We need talented individuals to join our team to help us to provide our customers with innovative products and services. An ideal candidate will be excited to be in a company that moves quickly on a constant flow of ideas, be able to wear multiple hats as needed, and have the drive to exceed expectations.