Database Architect

Database Architect

Clearance Level: Must be able to obtain an Active Secret Clearance - Must be US Citizen

Location:

This position is HYBRID . Must live within 100 miles from Lexington, MA

At Aquila Technology, you will see our team’s passion every day, whether we are building a robust, policy-compliant IT system or stress-testing a system to identify gaps and security vulnerabilities. To own the advantage, we ensure our team owns results and gets the work done right the first time by deploying smart, purposeful solutions that work. Aquila is the right people with the right skills driving the right outcomes. We call this the Aquila Advantage.

About the Role:

Aquila Technology is seeking a Database Architect to support one of the nation's premier defense research organizations.

The Database Architect will work in with a group that responsible for providing Finance, Travel, and Property services where and when it matters most to support world-class research and development. The team is undergoing some changes to their accounting practices that require additional resources to support both system application and policy changes.

Must Have

• 5 years - Analyze Model and Measurement Data
• 5 years - Business Intelligence Tools such as Domo/Tableau/Looker/SAP/PowerBI Cloud Platforms
• 5 years - Conceptual, Logical, and Physical Modeling, especially for Rationalizing Data Objects
• 5 years - Data Architectures
• 5 years - Databases and Data Engineering for Big Data
• 5 years - Design Patterns, Data Structures, Functional Programming Principles
• 2 years - Experience developing on the Microsoft Power Platform: Power Apps, Power Automate, PowerFx, Power BI
• 2 years - Government Cloud operating within FedRamp guidelines
• 2 years - AI application development (generative AI, ML, and NLP)
• 5 years - Experience with Application Lifecycle Managment (ALM)
• 3 years - Azure and AWS platforms
• 2 years - Experience with SharePoint Online features

Nice to Have

• Certification -Microsoft Certified Power Apps and Dynamics 365 Solution Architect Expert
• Microsoft Certified Power Platform Solution Architect Expert
• Degree Level: Bachelor's Degree

Responsibilities:

• The developer will actively advise and participate in the architecture and hands-on development of application using Power Platform
• The developer will be expected to lead all aspects of design and development of the new application, which is expected to be flexible and scalable
• The developer will also be expected to create system documentation and enterprise-level Standard Operating Procedures documents
• Developing applications from the ground up utilizing skills including object-oriented programming Power Apps, Power Automate, SharePoint, databases (SQL), and Power BI
• Designing, developing, and configuring scalable web applications
• Creating system documentation and standard operating procedures for enterprise web development
• Collaborating with the team in translating user stories and requirements into functional code
• Identifying critical dependencies and gaps, solving technical challenges, and implementing new enhancements
• Supporting the deployment process including post-deployment review of logs for errors
• Collaborating with other team members to support estimation and requirements finalization efforts
• Defining and developing methods for robust system monitoring and troubleshooting
• Working and Training staff on how to troubleshoot and build solutions
• Following all best practices for version control, CI / CD, and development management of the system

Qualifications:

• The candidate should have extensive hands-on PowerApps, Power Automate, and Power BI development experience and be well-versed in SDLC, the complete MS Solutions stack, and application security.
• 5+ years of IT systems development experience, with primary focus in the Microsoft solution stack and Cloud technologies
• 5+ Years of experience and in-depth understanding of the capabilities in Power Apps, Power Automate, and Data Verse
• 2+ years of experience in developing both Model-driven and Canvas Apps
• Knowledge of using PowerFx with PowerApps
• 2+ years of experience and knowledge of SharePoint Online features for collaboration and business process automation
• 3+ years of experience building solutions for the Power Platform
• Demonstrated experience designing and delivering enterprise technology solutions within secured research environment, including working within mission-driven governance, cybersecurity, data-handling, and organizational constraints. FedRamp experience required.
• Hands-on experience architecting and implementing production-oriented generative AI, intelligent automation, and low-code solutions, including integration of AI capabilities into enterprise workflows, applications, and business processes.
• Architect-level experience across Microsoft Azure and AWS, including CI/CD, DevSecOps, application and integration architecture, combined with product ownership experience translating business and mission requirements into technical roadmaps and delivered capabilities.
• Excellent communication skills (oral and written)
• A strong applied knowledge of Microsoft Power Platform services, including an in-depth understanding of its capabilities, boundaries, and constraints
• Experience with Data Visualization, Business Intelligence tools inside of Power BI
• A basic understanding of authentication, security, and application lifecycle management (ALM) practices for the Microsoft Power Platform.
• Strong analytical and problem-solving abilities
• Strong technical leadership and attention to detail

Preferred:

• Microsoft Certified Power Platform Solution Architect Expert
• Microsoft Certified Power Apps and Dynamics 365 Solution Architect Expert

Must Have

• 5 years - Analyze Model and Measurement Data
• 5 years - Business Intelligence Tools such as Domo/Tableau/Looker/SAP/PowerBI Cloud Platforms
• 5 years - Conceptual, Logical, and Physical Modeling, especially for Rationalizing Data Objects
• 5 years - Data Architectures
• 5 years - Databases and Data Engineering for Big Data
• 5 years - Design Patterns, Data Structures, Functional Programming Principles
• 2 years - Experience developing on the Microsoft Power Platform: Power Apps, Power Automate, PowerFx, Power BI
• 2 years - Government Cloud operating within FedRamp guidelines
• 2 years - AI application development (generative AI, ML, and NLP)
• 5 years - Experience with Application Lifecycle Managment (ALM)
• 3 years - Azure and AWS platforms
• 2 years - Experience with SharePoint Online features

Nice to Have

• Certification -Microsoft Certified Power Apps and Dynamics 365 Solution Architect Expert
• Microsoft Certified Power Platform Solution Architect Expert
• Degree Level: Bachelor's Degree

Benefits and Perks:

Aquila team members experience the opportunity to be part of a fast-paced, customer-focused, and technically innovative work environment. Aquila strives to deliver the best of the best in technical services to our customers. Candidates that possess a love for technical challenges, a desire to constantly learn, and the desire to establish themselves as critical players within a team will enjoy calling Aquila Technology home.

PTO - 15 days (vacation/sick) 10 paid holidays - 6 standard (New Year’s, Memorial Day, Independence Day, Labor Day, Thanksgiving, and Christmas) - 4 floating holidays prorated based on your day of hire:

• 1.5 paid days, or 12 hours, for approved volunteer work
• 1 week of paid maternity/paternity LOA after 1 year of Full-time employment

Tuition & Training Reimbursement- 5K annually for pre-approved, Eligible full-time team members who have completed a minimum ofsix (6) months of employment may apply for tuition reimbursement for approved, job-related courses taken through an accredited college or university. Team members must achieve a grade of “B” or better to qualify for reimbursement.Aquila will reimburse up to $5,000 per fiscal year for tuition expenses only. Expenses related to training programs, certifications, books, materials, meals, transportation, or other non-tuition costs are not eligible under the Tuition Reimbursement Program. All tuition reimbursement requests must be submitted to and approved by the team member’s Manager prior to course registration. Reimbursement will be issued upon successful course completion and submission of final grades and proof of payment.

401K with Fidelity - Eligible to participate following 90 days of employment. Company match on employee contribution:

• $1/$1 up to 3%, then .50 cents / $1 for 4th and 5th %s
• Fully vested from day one
• Company match does not apply to catch-up contribution

Cell Phone & Internet Reimbursed up to $150 monthly to cover cell phone, data, and home internet expenses. Aquila Technology will reimburse team members who work from home ONLY for cell phone/mobile device fees for work-related communications and/or operations each month. Employees eligible for this benefit must work remote 2 days a week or more to qualify.

Buy Your Own Device (BYOD) -Team members are eligible for reimbursement of up to $1,500 every three (3) years for the purchase of electronic equipment used to access corporate services. To qualify for this benefit, employees must have completed a minimum of six (6) months of employment and must agree to and sign the Device Minimum Configuration Form prior to reimbursement. Electronic devices eligible under the Buy Your Own Device (BYOD) program are limited to cell phones, laptops, and tablets.

Location: This person should expect to be onsite 2-3 days per week to collaborate with the team.
Clearance Level: Interim clearance is sufficient for start.
Interview process: will be two rounds: Initial prescreening and then a second-round wider audience; preference for the second round interview to be IN PERSON but they will do Zoom if needed.

We are an Equal Opportunity Employer