Job Description
About Aleto
Aleto is a company specializing in Federal property management, space planning, and design.
We are looking to hire someone who will grow with the company. We offer paid vacation, sick leave, full medical, vision, and dental insurance, Life and disability insurance, and a 401(K) plan.
What we are looking for
Aleto Inc. is seeking to hire a Junior SAS/Oracle Specialist to support our Government Client in Washington, DC remotely. The Junior SAS/Oracle Specialist 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.
*This position does require eligibility to pass a Public Trust background investigation, and eligibility to work in the U.S. *
Junior SAS/Oracle Programmer Specialist’s 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.
Qualifications/Capabilities/Software Knowledge:
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.
Qualifications/Education/Experience:
- Must be authorized to work in the United States
- Must be able to obtain a Public Trust Security Clearance
- Minimum of 3 years experience with a bachelor’s degree or minimum of 3-5 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:
- Proficient in SQL and PS/SQL.
- Proficient 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, 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 is a plus.
- Experience in Tableau and Power BI is a plus.
- 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.
REMOTE Opportunity for anyone located in the Eastern or Central Standard Time zone.
*Preference for local applicants in the DC, MD, and VA Regions. *
Salary Range: $80,000-$100,000K
Powered by JazzHR
hyG6JOJPQJ