Software Developer - Seattle, WA, United States - Oracle Corporation

Description

Job Description Overview At Oracle Cloud Infrastructure (OCI), we build the future of the cloud for Enterprises as a diverse team of fellow creators and inventors
We act with the speed and attitude of a start-up, with the scale and customer-focus of the leading enterprise software company in the world
Values are OCI's foundation and how we deliver excellence
We strive for equity, inclusion, and respect for all
We are committed to the greater good in our products and our actions
We are constantly learning and taking opportunities to grow our careers and ourselves
We challenge each other to stretch beyond our past to build our future
Job Description The Oracle National Security Realms (ONSR) is currently in need of a developer with experience in the world of Business Intelligence/Data Analytics to help us develop, deliver, and maintain a distributed system of analytics infrastructure to support operations, customers, and Oracle decision makers
This is a new team with exciting opportunities to help us shape Analytics and Business Intelligence for OCI's portfolio of restricted realm business
In this role you will be responsible for enabling data warehouses, optimizing existing databases for efficient analysis, creating table schema using ETL
You will collaborate with your fellow data engineers for the development and delivery of front-end visualization and dashboard systems in both classified and unclassified environments
Duties will include

• Create and review complex SQL queries, views, and various mathematical functions
• Perform unit testing to validate accuracy and validity of reports and data integrity
• Develop and optimize visualizations linking multiple data systems and service APIs into a cohesive, centralized analytics framework
• Analyze and develop frameworks to maximize system uptime, service metrics, performance, and deployment automation
• Create actionable business intelligence tools, dashboards, and reports
• Troubleshoot and resolve data integrity and performance issues
• Work closely with intake and business teams to gather and define requirement
• Provide business / user training in BI reporting tools and reports as needed
• Perform tasks and duties related to ad hoc report analysis, design, and processing
• Develop data infrastructure to use data for advanced analytics & data science algorithms
• Orchestrate & maintain meaningful operational and service metrics and dashboards
• Develop automation solutions for movement of data from one kind of storage to anotherBasic Qualifications
• US Citizenship and possess active TS/SCI Security Clearance with the ability to obtain Poly required; active Poly preferred
• 3+ years experience with scripting and compiled languages, preferably Python, bash and RESTful API experience
• Experience with report design and delivery using OBIEE/Tableau/Power BI/Looker ML or other professional visualization suites
• 3+ years experience in building and maintaining full stack data infrastructures.
• 1+Experience with any of visualization tools like Tableau, Microstrategy, OAC etc.
• Proficiency in SQL / PL SQL
• Prior experience developing and maintaining ETLs from various disparate systems
• Excellent judgment in influence for product roadmap direction, features, and priorities
• Bachelors degree in Computer Science, Information Technology, or related fieldPreferred Qualifications
• Experience with cloud services, networking, or SaaS products
• Experienced development skills using Oracle PL/SQL, Oracle Cloud ADW, Oracle Cloud Big Data, and/or Oracle Analytics CloudExperience working in the US Government cleared space
• Strong understanding of dimensional modeling and data granularity
• A background as an engineer supporting operations for a cloud/large IT environment
• High ownership with a strong bias for action
• Highly analytical, technically proficient, and able to learn new tools and software quickly
• Demonstrated ability to effectively communicate (oral and written) at different levels in the org
• Experience using agile software development practices and associated tooling
• Masters degree in Computer Science, Information Technology, or related field

About Us Innovation starts with inclusion at Oracle
We are committed to creating a workplace where all kinds of people can be themselves and do their best work
It's when everyone's voice is heard and valued, that we are inspired to go beyond what's been done before
That's why we need people with diverse backgrounds, beliefs, and abilities to help us create the future, and are proud to be an affirmative-action equal opportunity employer
Oracle is an Equal Employment Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans status, age, or any other characteristic protected by law
Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law
Responsibilities Duties will include

• Create and review complex SQL queries, views, and various mathematical functions
• Perform unit testing to validate accuracy and validity of reports and data integrity
• Develop and optimize visualizations linking multiple data systems and service APIs into a cohesive, centralized analytics framework
• Analyze and develop frameworks to maximize system uptime, service metrics, performance, and deployment automation
• Create actionable business intelligence tools, dashboards, and reports
• Troubleshoot and resolve data integrity and performance issues
• Work closely with intake and business teams to gather and define requirement
• Provide business / user training in BI reporting tools and reports as needed
• Perform tasks and duties related to ad hoc report analysis, design, and processing
• Develop data infrastructure to use data for advanced analytics & data science algorithms
• Orchestrate & maintain meaningful operational and service metrics and dashboards
• Develop automation solutions for movement of data from one kind of storage to another