Data Warehousing Manager jobs in District of Columbia

About Aleto

Aleto is a startup company specializing in Federal property management.

Aleto is looking to hire someone who will grow with the company. Aleto offers paid vacation, full medical, vision, and dental insurance, and a 401(K) plan.

Aleto is an Equal Opportunity Employer.

What we are looking for

Aleto Inc. is seeking to hire a Data Warehousing Specialist at one of its Government Client sites in Washington, DC who will assist the 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.

Selection Process

If you are selected for an interview, Aleto will contact you to arrange for a meeting via an online platform, such as Google Meets. After all candidates are interviewed, Aleto will notify you of your status. The start date is immediate.

Data Warehousing Specialist’s Essential Job Duties

Duties include the following. Other duties may be assigned.

• Develop and execute database queries and conduct analyses.
• Automate business requirements into SAS programs and support ad hoc requests.
• Optimize existing SAS/SQL code - Troubleshooting and automation of 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 designing, developing, and maintaining 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.

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.
• Prior experience with housing Data is a plus.

Technological Skills:

• Proficient in SAS required, Certifications in SAS 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.
• 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.

What we offer

Aleto is working for you.

Our company offers comprehensive benefits to employees who work 30 hours or more each week. A summary of benefits offered:

• Medical, Vision, and Dental Insurance:

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

• Disability Insurance:

Aleto offers company-paid short-term and long-term disability insurance.

• Life Insurance:

Aleto offers company-paid life insurance coverage.

• Paid Time Off:

Aleto’s paid time off includes eleven federal holidays. Full-time employees accrue PTO at the rate of 5 hours per pay period (120 hours per year).

• Retirement Plan:

Aleto offers full-time employees a 401(k) qualified retirement plan. Employees who have worked at least three months will be eligible to enroll in the plan on the 15th day of the month of the quarter following their hire anniversary date. The company will match 100% on 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.

Environment and Physical Conditions

The environmental factors and/or physical requirements of this position include the following: While performing the duties of this job, the employee is required to have ordinary ambulatory skills sufficient to visit other locations; and the ability to stand, walk, stoop, kneel, crouch, and manipulate (lift, carry, move) medium weights of at least 20 pounds. Requires arm, hand, and finger dexterity, including the ability to grasp, and visual acuity to use a keyboard. The employee frequently is required to be in one position for long periods of screen use, reach with hands and arms, and talk and hear both in person and over devices. The employee interacts in close spaces and frequently with other workers, vendors, and clients. May be in situations that require conflict resolution. The position works 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.

Pay: $90,000 - $100,000 per year