Note: The job is a remote job and is open to candidates in USA. RJIT Solutions is an information technology and bioscience company providing biomedical research, data science, software engineering, and project management solutions to healthcare and research organizations. The company is seeking a Senior Tableau Analytics Engineer to lead visualization, evidence, reporting, semantic modeling, dashboard development, data pipeline support, analytics governance, agency onboarding, and compliance for a statewide anomaly detection and decision intelligence platform.
Responsibilities
- Design, build, and maintain the full role-based dashboard portfolio, including executive views providing enterprise anomaly summaries and agency comparison, agency-level views scoped to a single agency's data, cross-agency comparative analysis restricted to OCIG users, and transaction-level evidence panels supporting investigative drill-down
- Implement row-level security and permission structures so that an agency Inspector General sees that agency's data and nothing further unless explicitly authorized, enforced consistently at both the data source and workbook level
- Build governed, published data sources and extract refresh strategies against the curated Gold layer, applying appropriate extract, live connection, and incremental refresh patterns for performance and reproducibility
- Develop calculated fields, level-of-detail expressions, parameters, and actions that support the drill path from an aggregate risk indicator to the individual transaction and its contributing fields
- Meet the solicitation's performance thresholds: dashboard page loads under five seconds, filter response under two seconds, and export operations under ten seconds, evidenced through instrumented performance testing rather than demonstration
- Establish a standardized reporting template library for PDF and Excel outputs with consistent headers, footers, metadata, State branding, and reproducibility indicators covering timestamp, data source, rule version, and data slice
- Ensure every export preserves the filter context active at the time of generation, so that a report can be regenerated later and produce an identical result for audit and legal review
- Work within an Azure Government tenant using Azure Data Lake Storage Gen2 and Databricks, developing and validating the curated Gold layer models that serve the visualization layer
- Support the Raw, Silver, and Gold medallion architecture, including slowly changing dimension versioning, canonical conformance, and reproducibility guarantees across layers
- Build and troubleshoot ingestion and transformation logic across multiple pathways, including flat file formats such as CSV, JSON, XML, and Parquet, secure file transfer, structured drop locations, REST and SOAP interfaces, direct data lake connections, and managed file transfer
- Write SQL and Python for data transformation, rule implementation, validation, and reconciliation between source system counts and processed records
- Support development of Power BI content where the client directs, as the solicitation identifies Power BI workspaces among the State-provided environments
- Maintain all workbooks, data sources, semantic models, and supporting code in version control, in editable and non-proprietary formats suitable for handover
- Translate Florida statutory requirements, procurement thresholds, and agency policy into analytical logic and supporting visualizations, working alongside the oversight domain team
- Support development and validation of business rules addressing vendor preference and vendor concentration, procurements clustered below competitive thresholds, sole-source and emergency procurement frequency, awards lacking documentation, vendor identity inconsistencies across systems, and unusual award timing or contract modification patterns
- Build the evidence presentation so that each flagged record displays its source tables, row counts, date ranges, systems of origin, thresholds applied, rule version, and a plain-language explanation of why it was flagged
- Surface composite risk scores and entity-level rollups to vendor, contract, purchase order, cost center, and agency in a form that supports Inspector General investigative workflow
- Define and present value realization measures, including potential cost avoidance, potential recoveries, risk exposure identified, investigative referrals generated, and oversight efficiencies achieved
- Support onboarding of state agencies through discovery, data mapping, access coordination, ingestion setup, validation, user acceptance testing, and training, refining the onboarding playbook between waves
- Author and execute user acceptance test scripts for dashboards and evidence panels with OCIG and agency Inspector General participants, and remediate defects to closure ahead of acceptance
- Deliver hands-on training to agency oversight staff covering dashboards, evidence panels, and case support features, using reusable materials the State retains
- Package workbooks, data sources, test datasets, and configuration so that OCIG staff can independently reproduce any reported result, and demonstrate that OCIG can author and promote a dashboard without vendor assistance
- Produce visualization and reporting documentation in fully editable, non-proprietary formats sufficient for a third party to assume operational control
- Apply role-based access control aligned to least privilege, multifactor authentication requirements, and periodic access review across the visualization environment
- Build all dashboards, reports, and exports to comply with Section 508 of the Rehabilitation Act as amended, 29 U.S.C. 794(d), and 36 C.F.R. Part 1194, consistent with s. 282.601(1), Florida Statutes, verified through automated scanning and manual keyboard and screen-reader testing
- Work within Rule 60GG-2, Florida Administrative Code, applicable NIST SP 800-53 and SP 800-171 controls, and s. 282.318, Florida Statutes
- Maintain audit logging and traceability standards sufficient to support legal, audit, and investigative workflows
Skills
- Certified Tableau expertise is a mandatory requirement for this position
- Direct experience delivering analytics for a Florida state agency, and familiarity with Florida procurement and financial systems, is required
- MANDATORY: Current Tableau certification at a senior level. Acceptable certifications include Tableau Certified Data Analyst, Tableau Desktop Certified Professional, Tableau Server Certified Associate or Professional, or Tableau Certified Architect. Candidates without an active Tableau certification will not be considered
- REQUIRED: Demonstrated experience delivering analytics or data visualization for a State government agency. Direct experience with a Florida state agency is required
- Bachelor's degree in data science, computer science, information systems, statistics, business analytics, accounting, or a related discipline. Equivalent professional experience will be considered in place of the degree requirement
- A minimum of eight years of professional experience in data visualization, business intelligence, or analytics engineering, including at least five years of hands-on Tableau development at enterprise scale
- Demonstrated experience implementing row-level security and multi-tenant permission models where separate organizations view only their own data within a shared platform
- Hands-on experience building or consuming a layered data architecture on a major cloud platform, with comparable Spark-based platforms considered
- Advanced SQL, including window functions, common table expressions, and query performance tuning against large fact tables. Working proficiency in Python for data transformation and validation
- Experience producing analytical outputs that were reviewed, reproduced, or challenged by an independent party such as an auditor, assessor, or inspector general, and that survived that review
- Experience with procurement, contract, payment, or vendor master data structures, and with the reconciliation problems that arise when those systems disagree
- Must be located within the United States
- Required Software and Tools:
- Tableau Desktop, Tableau Server or Tableau Cloud, and Tableau Prep, including published data sources, extract strategies, and permission and row-level security administration
- Azure Government, Azure Data Lake Storage Gen2, and Azure Data Factory or equivalent orchestration
- Databricks, including Spark, Delta Lake, and notebook-based development
- SQL Server, Azure SQL, or comparable relational platforms, and Python for transformation and validation
- Power BI, including semantic models and row-level security
- Git-based version control for workbooks, data sources, transformation code, and configuration
- Section 508 accessibility scanning and manual assistive technology testing
- Microsoft Office Suite, including Excel at an advanced level for reconciliation and analysis
- Ability to design a dashboard around the decision it supports rather than around the data available, and to defend that design to an oversight audience
- Disciplined evidence practice, meaning every figure on a screen traces to a named source table, a row count, a date range, and a rule version
- Fluency in performance tuning at the visualization layer, including extract design, aggregation strategy, and query reduction
- Comfort building for handover rather than for personal use, since the State will own and extend everything produced under this program
- Strong written communication, including the ability to document a dashboard, a data source, and a calculation in language a non-technical reviewer can evaluate
- Experience working under acceptance-gated delivery, where a deliverable is incomplete until its documentation and evidence are accepted
- Collaborative working style across a prime contractor, a subcontractor, and multiple government stakeholders who do not report to one another
- Sound judgment about data limitations, including the willingness to record an assumption as a constraint rather than presenting it as fact
- Remote work within the United States is authorized. Periodic travel to Tallahassee, Florida may be required for client meetings, agency onboarding, and user acceptance testing
- All work must be performed within the United States. Offshore work is prohibited under this contract
- Familiarity with Florida enterprise systems including MFMP, FACTS, FLAIR, PALM, the Vendor Information Portal, or the DFS Data Warehouse is strongly preferred
- A master's degree is preferred
- Azure Data Lake Storage Gen2 and Databricks strongly preferred
- Power BI development experience is preferred, as the solicitation identifies Power BI workspaces among the State-provided environments
- Working knowledge of the National Information Exchange Model or comparable standards-based information exchange is preferred
Benefits
- Remote work within the United States is authorized.
Company Overview