Junior Database and Automation Engineer

Alpha Omega • Arlington, VA

2d • Hybrid

About The Position

Alpha Omega is looking for a Solutions Architect to join our team to support one of our government customers. The Junior Database and Automation Engineer will transform raw data into clear, actionable insights and automate business workflows across our organization. This role requires a unique blend of technical expertise, analytical thinking, and design sensibility to build visually compelling dashboards and efficient automation solutions that support decision-making and operational efficiency.

Requirements

• 3+ years of experience with Power BI, including DAX, data modeling, and dashboard development.
• 3+ years of hands-on experience with Power Automate for workflow automation and integration.
• Strong understanding of data visualization best practices and design thinking.
• Proficiency with data querying languages (e.g., SQL, M, DAX).
• Exceptional analytical and problem-solving skills with keen attention to detail.
• Ability to communicate technical concepts clearly to non-technical stakeholders.
• Ability to work in a team-oriented environment for a matrixed organization.
• Experience with Agile and SCRUM processes and methodologies.
• Familiarity with Government Processes, including Federal Acquisition & Finance
• Knowledge of software development life cycle (SDLC) practices, principles, and techniques as they apply to Agile development process.
• Ability to effectively collaborate with internal and external customers.
• Proven ability to communicate technical details to a non-technical audience.
• DHS Public Trust EOD, US Citizen (Secret Clearance or above preferred)
• Applicant must be based within a commutable distance (1-2 hours) within the DMV

Nice To Haves

• Bachelor’s degree or relevant experience.
• Knowledge of SQL Databases and Query creation.
• Knowledge of the Federal Acquisition Lifecycle or commercial contracting.
• Knowledge of Federal financial systems or commercial accounting.
• Ability to develop training materials and conduct end-user training sessions.
• Experience with Federal government contracting and/or program office organizations business processes.
• Experience with RPA and AI/ML technologies.
• Certifications that show the desire for learning and continued education (e.g., IBM or Tableau certifications).

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports for stakeholders across various departments.
• Create automated workflows using Power Automate (formerly Microsoft Flow) to streamline repetitive tasks and integrate systems.
• Collect, clean, model, and analyze data from multiple sources (SQL, Excel, SharePoint, APIs, etc.).
• Collaborate with business and technical teams to understand reporting requirements and translate them into effective solutions.
• Optimize data models and performance of reports and workflows for scalability and speed.
• Apply UX/UI design principles to ensure dashboards are intuitive, visually appealing, and easy to interpret.
• Monitor and maintain existing Power BI and Power Automate solutions, troubleshooting and enhancing as needed.
• Train and support end users on best practices for interacting with dashboards and automation tools.
• Improve existing reporting and analytics by gathering user feedback to re-design, improve, merge, or add new content into existing BI reports.
• Maintain and support existing Power Apps applications (CPM, ORA).
• Deliver routine feature requests and bug fixes from the backlog.
• Support DHS ICE Systems Engineering Lifecycle (SELC) tasks and technical documentation.
• Assist with testing and deployment.
• Handle ad hoc client requests for existing systems.

Benefits

• 15 days PTO including paid parental, military, and bereavement leave
• Eleven (11) paid Federal holidays, five of which are floating holidays (as designated by the company’s holiday schedule each year)
• Health and Dental Insurance (including 100% employer paid premiums for employee coverage under the HDHP health plan)
• Life Insurance, STD/LTD term disability coverage, with employer paid premiums
• 401 (k) plan with a match that is 100% vested after you complete two years of service
• FSA/DFSA/HSA flexible benefit plans
• Annual Tuition & Professional Development Reimbursement benefit

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Associate degree