Position Overview
Analytica is seeking a highly experienced 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.
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
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:
- Oracle Database 12c or higher – Administration
- Oracle Database 12c or higher – Certified Master
- Informatica Data Engineering
- Informatica PowerCenter Data Integration Administrator
- Informatica PowerCenter Data Integration Certification
- Informatica Data Quality Administrator or Developer
- 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
Preferred Qualifications
Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related technical field.
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.
Top Skills
What We Do
Analytica is an award-winning consulting and technology services provider that supports public-sector health, civilian, and national security. We specialize in data-driven solutions, which have been recognized by organizations such as NYU’s Governance Lab for driving public sector modernization and innovation. Analytica is an SBA Certified 8(a), HUBZone that has been honored as one of the 250 fastest-growing businesses in the U.S. for three consecutive years by Inc.
For information on the company visit: www.analytica.net
For exciting career opportunities visit: careers.analytica.net
