Constellation Inc

Business Intelligence Developer

• Build, maintain, and automate dashboards, reports, and data models using Power BI and other visualization tools
• Design, build, and maintain data ETL pipelines from SQL databases, SharePoint, Excel, and other sources
• Optimize and refine existing SQL queries and dashboards
• Maintain accurate documentation for client dashboards and associated SQL queries
• Collaborate with clients and technical resources to gather and integrate business requirements into effective data visualizations
• Translate complex data findings into clear, digestible insights for stakeholders
• Ensure data accuracy, consistency, and integrity across reports and dashboards
• Coordinate with other developers on data extraction, transformation, and loading
• Present technical solutions and business value to non-technical stakeholders

Full-stack Engineer

• Translate complex data requirements into intuitive, high-performance user interfaces with analysts and stakeholders
• Build and maintain responsive React web applications integrated with backend services and APIs
• Support backend logic and data services using Java/Spring or equivalent frameworks
• Participate in sprint planning, code reviews, and technical design sessions
• Write unit tests and participate in CI/CD workflows to ensure production code reliability
• Support mission-critical applications integrating data collection, operational reporting, and intelligent automation for national security objectives
• Collaborate with analysts, engineers, and stakeholders to deliver mission-focused capabilities across multiple workstreams

Software Engineer

Program Manager

• Serve as the primary interface with the FEMA Contracting Officer and Contracting Officer's Representative.
• Provide executive leadership, technical direction, and overall accountability for contract performance.
• Direct, organize, coordinate, and oversee planning, execution, quality assurance, and delivery of task order activities.
• Lead multidisciplinary acquisition support teams across FEMA Headquarters and Regional Offices.
• Manage acquisition planning, strategy, market research, cost and price analysis, solicitation and source selection support, contract administration, and closeout.
• Develop and monitor Integrated Master Schedules, project plans, performance metrics, quality objectives, and risk registers.
• Oversee acquisition documentation, including SOWs, SOOs, PWSs, PRSs, QASPs, IGCEs, solicitation packages, modifications, and closeout documentation.
• Provide executive oversight of acquisition policy analysis, guidance development, stakeholder coordination, regulatory implementation, and responses to oversight inquiries.
• Direct acquisition coaching, awareness, and workforce training initiatives.
• Lead acquisition data analytics, dashboard development, automation, visualization, business intelligence reporting, trend analysis, and executive briefings.
• Manage onboarding, knowledge transfer, transition planning, and transition-out activities.
• Identify risks, implement mitigation strategies, resolve technical and operational issues, and recommend process improvements.
• Manage program financial performance through forecasting, budgeting, expenditure tracking, variance analysis, resource planning, and corrective actions.

Federal Program Manager

Business Analyst

• Drafting position descriptions, policies, SOPs, decision trees, and process workflows.
• Maintaining SharePoint sites, ensuring secure file management and up-to-date content.
• Editing recorded training videos and producing transcripts using Camtasia and Microsoft Stream.
• Compiling reports, editing transcripts, and maintaining accurate records to support knowledge sharing.
• Managing communication channels and distribution lists for efficient information sharing.
• Collaborating across teams to support projects and administrative initiatives.
• Facilitating client meetings, capturing technical notes, and documenting lessons learned.
• Developing and maintaining tracking tools, executive presentations, and communication materials using Excel, PowerPoint, and Adobe InDesign.
• Creating project timelines, tracking dependencies, and supporting project execution.
• Developing organizational communication products, including executive briefs, handbooks, training decks, and one-pagers.
• Conducting skills gap analyses and supporting workforce succession planning with senior leadership.
• Supporting data governance, taxonomy, and document management standards across digital platforms.

Management Analyst

• The primary responsibility of this role is PowerApps development.
• Candidates must have strong hands-on experience and be highly confident in developing PowerApps solutions.
• Design, develop, and maintain PowerApps applications to automate workflows and enhance operational processes.
• Build, maintain, and optimize dashboards, reports, and data models using Power BI, Tableau, Qlik, or other visualization tools.
• Collaborate with end users and technical resources to understand and integrate data outputs into visualizations effectively.
• Translate complex data findings into clear, digestible insights for stakeholders to support data-driven decision-making.
• Ensure data accuracy, consistency, and integrity across reports and dashboards.
• Identify data attributes (e.g. financial, biometric, personnel-based) critical for performance analysis and trend identification.
• Conduct training sessions as necessary for CBP and contractor personnel on data analysis tools and methodologies.

PowerApps Developer

IT Support

• Serve as the primary point of contact for the Government COR and designated program officials on all contract matters.
• Manage and oversee all contractor personnel supporting Form I-9 audit and worksite enforcement activities across multiple field locations.
• Provide leadership, supervision, and performance management for Junior Compliance Officers and other assigned contract staff.
• Perform resource planning, workforce management, recruiting coordination, onboarding, and staffing activities to ensure uninterrupted contract performance.
• Develop and maintain operational knowledge of HSI Worksite Enforcement programs, policies, procedures, and investigative support requirements.
• Provide management and technical oversight for all contract activities to ensure quality, consistency, and compliance with established standards and best practices.
• Conduct quality assurance reviews of work products, reports, audit documentation, staffing actions, and deliverables to ensure accuracy and timeliness.
• Monitor contract performance metrics, identify risks, develop mitigation strategies, and provide regular status updates to Government stakeholders.
• Support HSI personnel conducting employment eligibility verification audits and investigations involving Forms I-9, business records, and related compliance documentation.
• Assist with preparation and delivery of briefings, presentations, training sessions, status reports, and program reviews.
• Provide recommendations to improve operational efficiency, resource utilization, workflow management, and alignment with Government strategic objectives.
• Oversee preparation and submission of required deliverables including staffing plans, activity reports, quality control documentation, training certifications, personnel security documentation, and contract status reports.
• Ensure compliance with DHS, ICE, HSI, privacy, records management, personnel security, and information security requirements.
• Support transition planning, workforce continuity efforts, and surge staffing requirements as directed by the Government.
• Maintain accountability for contract performance, customer satisfaction, personnel management, and mission support outcomes.

Business Intelligence Developer

Software Engineer

Federal Program Manager

Management Analyst

PowerApps Developer

I-9 Audit Manager