Job Title: Junior Data Warehousing Specialist/QA Tester
Job Type: Full-Time/Exempt
Location: Remote
Compensation/Salary: $80,000-90,000 DOE.
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.
- Create visualizations, dashboards, user stories, and reports for various projects.
- Develop and update technical documentation.
- 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 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.
The option to enroll in an HSA or FSA depending on elected medical insurance coverage. Dependent Care FSAs are also available.
