Senior Oracle Developer

Job Title: Senior Oracle Developer

Job Type: Full-Time

Location: Remote

Compensation/Salary: $$97,500 - $102,500

Authorization Status: Must be Authorized to Work in the U.S.

Clearance Requirements: Must be eligible to pass and maintain a Moderate Risk Public Trust Background Check (HSPD-12)

About Aleto

Aleto specializes in federal property management, space planning, and facility management. Aleto primarily supports federal government agencies to create realty solutions, provide facility and space planning support services, and enhance strategic communications. 

We are looking to hire motivated people who are excited to grow with us. You'll have the potential to help improve processes and help identify solutions for our government, supporting the organizations that serve American citizens across the country. We offer the opportunity to work directly with clients to have a real impact on the day-to-day operations of federal agencies.

We are a growing company that stands firm on our core values: Accountability, Ingenuity, Reliability, Service, and Stewardship. This is what sets us apart from our competitors. 

Our Mission, Vision, and Purpose:

• Aleto is committed to helping federal agencies improve their workspaces. 
• We aspire to be trusted advisors to senior executives for federal leasing and facilities operations decision-making. 
• Our purpose is to enhance your workspaces with our innovations while maintaining your trust with dependable, responsible, and high-quality service. 

We work hand-in-hand with our partners, from start to finish, to ensure we're identifying and delivering the best solutions based on their business needs.

We offer paid vacation, sick time, paid federal holidays, parental leave, full medical/dental/vision, and a 401(k) with employer match. 

We are proud to employ a group of experts from diverse backgrounds. We recognize that recent studies show those from underrepresented groups are less likely to apply to roles if they don't meet 100% of the qualifications. We are committed to building an inclusive culture, and encourage you to leap with confidence and apply--you may be exactly who we've been looking for!

Aleto is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, or veteran status. 

What we are looking for:

Aleto Inc. is seeking a Senior Oracle Developer for a remote position supporting our government client in Washington, DC. The Oracle Developer will assist our federal client by managing and analyzing complex data sets to provide them with accurate and critical information to both internal and external users in a timely fashion.

Interview Process

If you are selected for an interview, Aleto will contact you by email to arrange an interview via an online platform, such as Google Meets, or by telephone. The entire interview process can average around 3 weeks from the time you are initially contacted to interview. After all candidates are interviewed, Aleto will notify you of your application status. 

If an offer is extended, the start date is determined based on factors such as availability and the amount of time it takes for the government background clearance process (depending on the client). 

Visit our website at www.aletoconsulting.com to learn more about Aleto, Inc. 

ESSENTIAL JOB DUTIES

Duties include the following.  Other duties may be assigned.

• Develop and execute database queries and conduct analyses.
• Technical Project Management documentation and collecting requirements.
• Automate business requirements into SAS programs and support ad hoc requests.
• Optimize existing SAS/SQL code - Troubleshoot and automate SAS and/or Python jobs and code.
• Create visualizations, Dashboard, user stories, and reports for requested projects.
• Develop and update technical documentation.
• Maintain/modify SAS/SQL program and/or configuration file changes based on documented requirements.
• Work with project teams to maintain and enhance source SAS code and process flows.
• Perform QA checks to ensure data integrity of reporting and dashboard solutions.
• Support complex Data Analytics and Business Intelligence projects in a federal government environment.
• Assist in the design, development, and maintenance of a one-stop service center for scheduled and ad-hoc Geocoding requests.
• Facilitate the Automation and Execution of scheduled Data processes.
• Create and generate Data products and summary tabulations from multiple data sources.
• Help prepare Data Requirements, Standard Operating Procedures (SOP), and other technical documentation.
• Support modernization of program scripts for data manipulation and visualization.
• Participate in continuous data quality improvement and process streamlining efforts.

ALETO JOB DUTIES

• Compliance with all Aleto processes, standards, and guidelines including utilizing the employee and intranet platforms, clocking in and/or entering time daily, submitting expense reports, providing monthly progress reports, etc.
• Participate in recurring performance development meetings with your Aleto Team Lead to discuss current job tasks, promote open dialog/feedback, recognize and celebrate wins, and review positive and purposeful approaches for meeting work-related and professional development goals.
• Attend team meetings, tri-annual company All-Hands Meetings, and other company-sponsored team-building events to foster and support Aleto's core values, vision, and culture. 

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. 

Qualifications / Education / Experience:

• Must be authorized to work in the United States
• Must be able to obtain a Public Trust Security Clearance
• Minimum of 5 years experience with a bachelor’s degree or minimum of 7 years experience in a technical support role with demonstrated execution of tasks and projects relevant to Data Analytics, Data Science, and Business Intelligence.
• Strong knowledge of PL/SQL, SQL, and Oracle database technologies
• Experience in translating business requirements into technical design for data products and Business Intelligence solutions.
• Prior experience with housing Data is a plus.

Technological Skills:

• Expert in SQL and PS/SQL.
• Expert in SAS required.
• Experience in data analysis and data modeling.
• Design and develop technical solutions to pre-defined requirements.
• Experience in Analytical and Problem-Solving skills.
• Certifications in ORACLE/SAS Programming Desired. 
• Experience with SAS EG and familiarity with SAS Viya or SAS studio is a plus.
• Proficient in writing SQL Queries relational databases such as Oracle, MS SQL
• Proficient in Python.
• Experience in Tableau and Power BI is a plus.
• A basic understanding of UNIX is a plus.

Required Knowledge and Skills:

• Highly developed interpersonal and customer relationship management skills.
• Ability to work collaboratively in a team environment (remote).
• Proven problem-solving skills with the ability to analyze situations, identify existing or potential problems, and recommend solutions.
• Ability to handle shifting and multiple priorities and demonstrate effective time management and organizational skills.
• Professional demeanor, strong work ethic, discrete, resourceful, and able to maintain confidentiality.

What We Offer: Benefits and Perks

At Aleto, we recognize that our employees are our most valuable assets. We are proud to offer the following employee programs and benefits to enhance our employee’s well-being and total rewards package while practicing our core value of Stewardship. 

Below is a list of comprehensive benefits offered to employees who work 30 hours or more each week:  

• Medical, Vision and Dental Insurance:

Aleto employees are offered single, single-plus-one-dependent, or family medical, vision, and dental insurance plans. 

Aleto offers three medical plan options to employees. Aleto contributes 75% of the employee premium to the base medical plan and the option to “buy up” for the two additional plans. 

Aleto contributes 75% of the employee premium for the visions and dental plans.

• Pre-Tax Savings Accounts

The option to enroll in an HSA or FSA depending on elected medical insurance coverage. Dependent Care FSAs are also available. 

• Disability Insurance: 

Company-paid short-term and long-term disability insurance.

• Life Insurance:

Company-paid life insurance coverage. 

• Paid Time Off:

Paid time off includes eleven federal holidays. Full-time employees accrue PTO at the rate of 5 hours per pay period for a total of three weeks per year. In addition, employees are provided with a separate bank of 40 hours of paid sick leave per year. 

• Retirement Plan:

Aleto offers full-time employees a 401(k) qualified retirement plan. The company will match 100% of the first 3% of the employee contribution, then match 50% of the next one-percent match of their contribution to the plan for a total of a 4% employer contribution.

• Professional Development 

After 6 months of employment with Aleto, employees are eligible to apply for education reimbursement under Aleto’s Education Reimbursement Program. The program offers up to $5,250 of reimbursement per year for job-related training to help employees stay updated on key skills and competencies related to the demands of their industry and professions.

Environment and Physical Conditions 

While performing the duties of this job, the employee is required to have ambulatory skills sufficient to visit other locations; and the ability to remain in a stationary position at least 50% of the time, move inside and around an office, position themself to access items located in high or low areas, and transport items weighing up to 20 pounds across the office. Requires the constant operation of a computer and other office productivity machinery and the ability to observe details at a close range typically within a few feet of the observer.  The employee interacts frequently with other workers, vendors, and clients and will communicate information and ideas so others will understand and must be able to exchange accurate information in these situations. The position consistently requires work to be completed in an office environment with artificial light and air.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the position.

If you have questions or need additional assistance please contact us at [email protected]