Junior QA Tester/Data Warehousing Specialist

Job Title: Junior Data Warehousing Specialist/QA Tester

Job Type: Full-Time/Exempt

Location: Remote

Compensation/Salary: $80,000-90,000

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.

What we are looking for 

Aleto Inc. is looking to hire a Data Warehousing Specialist for a Government Client site in Washington, DC. This role involves managing and analyzing complex data sets to deliver timely and accurate information to both internal and external users. The Specialist will be essential in software development for our federal client, ensuring that applications operate as intended and meet specified requirements. Key responsibilities include verifying that each software feature functions correctly according to system specifications and reviewing those specifications to fully understand software requirements.

Interview Process

If you are selected for an interview, you’ll be contacted for an interview through Google Meet or by telephone. The process averages 3 weeks from initial contact 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 by availability and the amount of time it takes for the government background clearance process (depending on the client). 

Essential Job Duties of the Data Warehousing Specialist

The following duties are essential for the role; additional responsibilities may be assigned as needed:

• Develop and execute database queries and perform analyses.
• Automate business requirements into SAS programs and assist with ad hoc requests.
• Optimize existing SAS/SQL code, including troubleshooting and automating SAS and/or Python jobs.
• Create visualizations, dashboards, user stories, and reports for various projects.
• Develop and update technical documentation.
• Maintain and modify SAS/SQL programs and configuration files based on documented requirements.
• Collaborate with project teams to enhance and maintain source SAS code and process flows.
• Perform quality assurance checks to ensure data integrity in reporting and dashboard solutions.
• Support complex data analytics and business intelligence projects within a federal government environment.
• Assist in designing, developing, and maintaining a centralized 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 (SOPs), and other technical documentation.
• Support the modernization of program scripts for data manipulation and visualization.
• Engage in continuous data quality improvement and process optimization efforts.
• Conduct system testing activities, including test case design, data setup, and execution, while adhering to agile methodologies.
• Perform various levels of testing, including functional, integration, system, browser, and user acceptance testing (UAT).
• Interpret test results, compare them to established specifications, and make recommendations regarding data release suitability.
• Communicate test status reports to project managers, team leaders, and end users.
• Participate in meetings with stakeholders to gather requirements and review deliverables.
• Contribute to sprint planning and grooming sessions.
• Provide technical support to application users and troubleshoot application-related issues.

Data Warehousing Specialist’s 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 6 years experience in a technical support role with demonstrated execution of tasks and projects relevant to Data Analytics, Data Science, and Business Intelligence.
• Experience in translating business requirements into a technical design for data products and Business Intelligence solutions.
• Knowledge of software development methodologies (Agile and Waterfall).
• Familiarity with testing tools and frameworks, such as Selenium and JUnit.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Prior experience with housing Data is a plus.

Technological Skills:

• Knowledge of programming languages, databases, and networking concepts.
• Familiarity with testing methodologies, tools, and frameworks.
• Ability to analyze system specifications and identify potential issues.
• Ability to identify defects and collaborate with the development team to resolve them.
• Proficient in SAS required, Certifications in SAS 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 is a plus.
• Experience in Tableau and Power BI is a plus.
• Knowledge of STATA and Geocoding 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. 
• Excellent verbal and written communication skills. 
• Production support experience with troubleshooting, identification of root cause, and issue resolution.
• Experience with unit testing, release procedures, and documentation protocol
• Experience with reviewing findings from vulnerability scan assessments
• Ability to work well under pressure, maintain composure during stressful situations, and exercise good judgment when faced with complex decisions.
• Ability to handle shifting and multiple priorities and demonstrate effective time management and organizational skills.
• Ability to foster teamwork, working cooperatively and effectively with others to resolve problems.
• Highly developed interpersonal and customer relationship management skills.
• Professional demeanor, strong work ethic, discrete, resourceful, and able to maintain confidential information

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:

Single, single-plus-one-dependent, or family medical, vision, and dental insurance 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]