Senior Analytics Architect & Power BI Lead

International Logic Systems, Inc.; Fairfax (VA); Hybrid; USD 120,000 - 155,000; Full time

Job summary

International Logic Systems, Inc. (ILS) seeks a Senior Data Analytics Consultant to lead data profiling, integration, automation, storage, analytical modeling, Power BI development, and the design of an extensible analytics framework.

The consultant must work independently, engaging with business and technical stakeholders to translate evolving goals into documented requirements and usable analytics products.

Responsibilities

• Work independently with business users to understand oversight and investigative goals, current processes, pain points, desired decisions, and expected analytical outcomes.
• Plan and facilitate stakeholder interviews, working sessions, and iterative product discussions with business users, Client CIO team members, application teams, and external agencies.
• Translate high-level or evolving needs into clear business, functional, data, analytical, technical, security, access, and operational requirements, with documented assumptions, decisions, dependencies, and open questions.
• Help stakeholders refine risk indicators and investigative use cases, and translate them into data elements, source mappings, analytical rules, measures, visualizations, and reporting needs.
• Identify and evaluate relevant internal and external data sources based on approved priorities, including source owners, points of contact, availability, acquisition procedures, privacy considerations, and approved read only access methods.
• Coordinate with each responsible application team or external data provider to obtain the required data without introducing unapproved APIs, service accounts, direct database connections, infrastructure, or changes to systems.
• Profile, clean, prepare, reconcile, transform, and validate data for storage and analytical use; document data limitations and quality concerns that could affect results.
• Design and implement a modular analytics framework that separates data acquisition, processing, storage, analytical logic, and presentation so data sources and rules can be added or modified over time.
• Configure and manage approved data acquisition and automation processes, including full or partial automation for the priority data sources selected with the Task Monitor.
• Develop and maintain data models, interfaces, reports, dashboards, visualizations, and business intelligence products using Power BI and other approved tools.
• Support the customization and configuration of the Investigative Entity Search Tool and the development of the Investigative Red Flag Indicator Tool based on available data and stakeholder-defined metrics.
• Use approved querying, programming, and automation capabilities as appropriate, including SQL, Python, R, PowerShell, Power Apps, Power Automate, and the client-supported orchestration capabilities.
• Contribute to an iterative architecture and phased setup plan for the lean analytics environment, including data storage, databases, analytics tools, system access, and interfaces within the client environment.
• Ensure solutions, scripts, data handling, storage, and analytical practices comply with the client’s cybersecurity, privacy, IT governance, and Authorization to Operate requirements when applicable.
• Recognize when a proposed capability changes the agreed technical boundary or creates a new connection, software, security, operational, or infrastructure dependency, and elevate it for CIO review.
• Deliver exploratory data analysis, data mining, statistical analysis, ad hoc reports, and other emerging analytical work as prioritized by the Task Monitor.
• Prepare comprehensive, maintainable documentation covering requirements, data acquisition, data automation, infrastructure, system access, analytical logic, Entity Search, Red Flag Indicators, and delivered products.
• Provide iterative product-based training and knowledge transfer to business stakeholders and relevant partners, and incorporate user feedback into subsequent releases.
• Manage assigned work, schedules, risks, dependencies, blockers, and status communications; support weekly project meetings and monthly reporting as required.
• Produce clear, defensible analytical outputs suitable for audiences.
• Demonstrated senior-level experience independently leading data analytics, business analysis, data engineering, business intelligence, or comparable data-intensive initiatives.
• Ability to engage business users directly, understand goals rather than only stated solutions, navigate ambiguity, ask effective questions, and convert evolving needs into actionable requirements and analytical deliverables.
• Demonstrated experience eliciting, analyzing, documenting, validating, and communicating business, functional, data, and technical requirements to both business and technical audiences.
• Hands-on experience identifying data sources, mapping required data elements to business needs, coordinating access with source system teams, and documenting acquisition procedures and dependencies.
• Strong technical understanding of data acquisition, integration, transformation, storage, data quality, data modeling, automation, and analytical solution delivery.
• Hands-on experience designing and delivering Power BI dashboards, reports, visualizations, semantic models, or interfaces to approved enterprise data sources.
• Proficiency with SQL and demonstrated ability to analyze structured data, define transformations, validate results, and support repeatable data processing.
• Experience designing modular or extensible data and analytics solutions that can accommodate new or changed data sources, business rules, risk indicators, and reporting requirements.
• Ability to collaborate effectively with application teams, infrastructure and security personnel, data owners, external agencies, and business stakeholders while retaining ownership of assigned outcomes.
• Strong written communication skills, including the ability to produce precise requirements, process and data documentation, technical plans, architecture content, status reports, and user guidance.
• Strong verbal communication and facilitation skills, with the ability to explain technical findings, data limitations, tradeoffs, and proposed solutions clearly to nontechnical users.
• Ability to manage priorities, dependencies, risks, and blockers in an iterative environment while working productively as part of a small, complementary two person team.
• Demonstrated attention to cybersecurity, privacy, access controls, approved software and services, and governance requirements when working with sensitive or investigative data.

Job description

International Logic Systems, Inc. (ILS) seeks a Senior Data Analytics Consultant to lead data profiling, integration, automation, storage, analytical modeling, Power BI development, and the design of an extensible analytics framework.

The consultant must work independently, engaging with business and technical stakeholders to translate evolving goals into documented requirements and usable analytics products.