Data Warehouse Developer - (OBIEE, ETL, SQL, BI/XML, AIX)

Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things. • This is an exempt position. Salary commensurate with experience • Overview: We are seeking a Data Warehouse Developer who will support our client. The ideal candidate will be skilled in the design and development of enterprise data warehouse solutions, including dimensional data models, complex ETL processes, and database objects to support business intelligence needs. This role will be responsible for creating comprehensive OBIEE analytics including dashboards, reports, and repository development while ensuring data security, quality, and optimal performance across the data warehouse environment. Duties • Design and develop data warehouse solutions using star schema and relational data modeling methodologies • Write complex SQL queries and build ETL processes to extract, transform, and load data from source systems • Develop and maintain the OBIEE repository (RPD), including physical layer objects, business model mappings, and data joins • Create interactive dashboards, scorecards, and analytical reports in the OBIEE presentation layer • Develop formatted reports using BI/XML Publisher for standardized business reporting • Implement Oracle security frameworks using roles, privileges, and policies to control data access • Write Unix/Linux shell scripts to automate ETL jobs, scheduling, and data warehouse operations • Optimize data warehouse performance and ensure data quality and integrity across systems Mandatory Qualifications • 5+ years of development experience in data warehouse – including data modeling, writing complex SQL, and development of export, transform and load (ETL) processes. • 5+ years of experience in database design and modeling for data warehouse and business intelligence applications, including relational database structures, normal forms, and star schema data modeling. • 5+ years of experience modeling data, creating objects, and building joins in the physical and business model mapping layers of the OBIEE RPD. • 5+ years of experience developing user interfaces in the OBIEE presentation layer – including building dashboards, scorecards, and analyses, as well as changing OBIEE page layouts and styles. • 5+ years of experience developing OBIEE reports in BI/XML Publisher. Desirable Qualifications: • Experience architecting and implementing Oracle Security using users, roles, object and system privileges, application contexts, Virtual Private Database and associated policies. • Experience using OWB to create complex ETL processes. • Experience programming using Unix or LINUX korn shell scripting language, preferably using IBM AIX or RHEL. • Experience performing ETL development using Attunity Compose. • Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws. AI-Assisted Resume Evaluation Notice Cloud and Things – Talent Management Notice to Candidates Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals. How AI Is Used Our AI tools assist by: • Analyzing resumes against job requirements • Supporting our recruiters in candidate data evaluation • Ensuring consistent review standards across all applications Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation. Your Data and Privacy Cloud And Things Data Handling • Your information is processed securely and used exclusively for recruitment purposes • Cloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunities • You may opt out of long-term ATS storage by emailing your name and your request to opt out of storing your resume in the ATS to: security@cloudandthings.com • All personal information is handled confidentially in accordance with our privacy policy AI Tool Data Processing • AI processing data is retained for a maximum of 90 days, after which it is deleted • All data sent to AI tools is encrypted in transit and at rest • AI tools comply with applicable privacy laws including GDPR and CCPA • Personal data is anonymized or minimized wherever possible during AI processing Your Participation By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration.