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 skillsFTE position, onsite in Chicago (1 day remote) Contract position- 100% remote from anywhere--------------------------------------------------------------------Core Technical SkillsMEDITECH Expanse Database (MAT/NPR) Experience Advanced SQL (TSQL)- Post GRES SQLJoins, subqueries, CTEs, window functionsAggregations, parameterized queriesPerformance-aware query writingSQL Server Reporting ToolsSSRS (legacy/onprem) and/or Power BI Report BuilderBuilding datasets, data sources, and report parametersPaginated reports (for operational reporting) Data Modeling FundamentalsUnderstanding star/snowflake schemasWorking with views, stored procedures, and curated reporting tablesKnowledge of metrics definitions and business logic layeringETL/Query Performance AwarenenessIndex awareness, query tuning basicsRecognizing inefficient report queriesUnderstanding how data refresh/processing impacts reportingReporting & Self-Service Design SkillsSemantic Layer DesignCreating reusable, business-friendly datasets (gold layer) Standardizing calculations and definitions to avoid “metric drift\"Self-Service EnablementDesigning reports that are intuitive for non-technical usersBuilding filters, slicers, and parameter-driven reportsStructuring data for ad hoc exploration (not just static reports) Data Visualization & StorytellingChoosing the right chart types and layoutsTranslating data into actionable insightsClarity, simplicity, and usability over complexityTeam Player & Ability to Lead