Enterprise Report Writer/MEDITECH (FTE & Contract)

We're seeking an Enterprise Report Writer to assist with creating a self-service reporting environment:

Looking for an Enterprise Report Writer with Postgres and PLSQL skills

FTE position, onsite in Chicago (1 day remote)

Contract position- 100% remote from anywhere

------------------------------------------------------------------

--Core Technical Skills

MEDITECH Expanse Database (MAT/NPR)

Experience Advanced SQL (TSQL)- Post GRES SQL

• Joins, subqueries, CTEs, window functions
• Aggregations, parameterized queries
• Performance-aware query writing

SQL Server Reporting Tools

• SSRS (legacy/onprem) and/or Power BI Report Builder
• Building datasets, data sources, and report parameters
• Paginated reports (for operational reporting)

Data Modeling Fundamentals

• Understanding star/snowflake schemas
• Working with views, stored procedures, and curated reporting tables
• Knowledge of metrics definitions and business logic layering

ETL/Query Performance Awareneness

• Index awareness, query tuning basics
• Recognizing inefficient report queries
• Understanding how data refresh/processing impacts reporting

Reporting & Self-Service Design Skills

Semantic Layer Design

• Creating reusable, business-friendly datasets (gold layer)
• Standardizing calculations and definitions to avoid “metric drift"

Self-Service Enablement

• Designing reports that are intuitive for non-technical users
• Building filters, slicers, and parameter-driven reports
• Structuring data for ad hoc exploration (not just static reports)

Data Visualization & Storytelling

• Choosing the right chart types and layouts
• Translating data into actionable insights
• Clarity, simplicity, and usability over complexity

Team Player & Ability to Lead