Data Warehousing & Business Intelligence SME

Analytica is seeking a highly experienced Data Warehousing & Business Intelligence Subject Matter Expert (SME) to provide expert-level guidance and leadership in the design, development, and enhancement of Data Warehousing and Business Intelligence (BI) systems. This individual will serve as a trusted advisor to technical teams and stakeholders, delivering deep insights into tools, best practices, and architectures that drive data integration, quality, visualization, and analytics solutions. The SME will help ensure successful outcomes through both strategic direction and hands-on technical support, backed by certification and experience in industry-leading technologies. This will be hybrid with 1x a week in the office. Must be local to the DMV area. 

Key Responsibilities 

• Provide authoritative expertise in data warehousing architecture, ETL pipelines, and BI/reporting platforms. 
• Advise on system design, performance tuning, integration patterns, and best practices to ensure high-quality data delivery and insight generation. 
• Collaborate with cross-functional project teams including architects, developers, data analysts, and stakeholders to define and implement data solutions. 
• Review, assess, and validate technical designs, data models, integration workflows, and implementation strategies. 
• Lead solutioning for technical challenges and oversee prototyping, PoC development, and feasibility assessments. 
• Contribute to the development of enterprise data governance, metadata management, and data quality strategies. 
• Stay current with trends in cloud services, data science, visualization platforms, and enterprise analytics. 
• Provide mentoring and technical guidance to engineers and developers across data projects. 

Required Qualifications 

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related technical field. 
• Minimum 5 years of professional experience in Data Warehousing, Business Intelligence, or related technical domains, with demonstrable success in an SME or technical leadership role. 
• Strong understanding of data modeling, data integration, ETL/ELT design, analytics platforms, and data governance. 
• Hands-on experience with BI tools (e.g., Tableau), data platforms (e.g., Oracle, AWS, Databricks), and ETL tools (e.g., Informatica). 
• Proven ability to guide teams and shape enterprise data strategy and technical architecture. 
• At least one professional certification in one or more of the following: 
•  AWS Certified Solutions Architect – Professional 
•  AWS Certified DevOps Engineer – Professional 
• AWS Certified SysOps Administrator
• Databricks Certified Professional Data Scientist 
• Tableau Certified Professional – Desktop or Server 
• Must be US Citizen and eligible for DHS Public Trust Clearance or higher

Preferred Qualifications 

• Experience leading large-scale enterprise data platform implementations, cloud migrations, or digital transformation programs. 
• Expertise in cloud-based data platforms (e.g., AWS Redshift, Snowflake, Databricks, Oracle Cloud). 
• Experience with Agile project methodologies and working within multi-disciplinary DevSecOps teams. 
• Strong interpersonal, communication, and consulting skills with the ability to influence senior stakeholders. 

About ANALYTICA: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD, the company is an established SBA small business that has been recognized by Inc. Magazine each of the past three years as one of the 250 fastest-growing companies in the U.S.  Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI® Maturity Level 3 and is an ISO 9001:2008 certified provider. 

Analytica LLC is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or any other characteristic protected by applicable federal, state, or local law. As a federal contractor, we comply with the Vietnam Era Veterans' Readjustment Assistance Act (VEVRAA) and take affirmative action to employ and advance in employment qualified protected veterans. We ensure that all employment decisions are based on merit, qualifications, and business needs. We prohibit discrimination and harassment of any kind. Analytica LLC also provides reasonable accommodations to applicants and employees with disabilities, in accordance with applicable law.

To enhance efficiency, fairness, and accuracy, Analytica may use AI-assisted tools to support certain aspects of our hiring process.

• Application Review: AI tools may help identify skills and experiences relevant to the role.
• Interview Support: AI-powered notetaking tools may be used during interviews to document discussions and summarize key points.

These tools are used to assist our team. All hiring decisions are made by Analytica recruiters and hiring managers.

By submitting an application, you acknowledge that AI-assisted tools may be used to support parts of the application and interview process.

When receiving email communication from Analytica, please ensure that the email domain is analytica.net to verify its authenticity.

Powered by JazzHR