> Markdown version of [/jobs/ext/2119048-data-analyst-revenue-analytics](https://www.wearedevelopers.com/jobs/ext/2119048-data-analyst-revenue-analytics). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst, Revenue Analytics - **Company:** LTD Global - **Location:** The Colony, TX, United States - **Salary:** $75,000.0 - $78,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Artificial Intelligence, Data Analysis, Data Transmissions, Data Dictionary, Extract Transform Load (ETL), Data Normalization, Data Structures, Data Warehousing, Relational Databases, Database Queries, Microsoft Visual Studio, Microsoft SQL Server, Pivot Tables, Microsoft PowerPoint, Power BI, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Data Streaming, Transact-SQL, Information Technology, Star Schema, Data Management, SQL Server Management Studio (SSMS), Databricks, Data Generation - **Published:** August 19, 2026 - **Apply:** https://www.techcareers.com/job.asp?id=3359613902&tx=YT606CYT&pt=1&aff=0B19D771-A501-4A5E-8338-2A822B784D54&utm_source=Job%20Feed&utm_medium=textkernel&utm_campaign=DE&utm_term=0B19D771-A501-4A5E-8338-2A822B784D54 ## About the Role * Ability to design and implement discussion-ready, Excel-based dashboards. * Intermediate level of knowledge and experience with sourcing datasets from SQL and a general understanding of data structures and relational schemas. * Basic understanding of Star Schema data model design as it relates to data warehouse and relational database interactions. * Microsoft SQL (SSMS) - Adept knowledge in writing basic to complex T-SQL queries, stored procedures, and views to retrieve data from relational databases or a data warehouse. * Microsoft SQL (SSRS) - Familiarity with MS Visual Studio and knowledge of SSRS package creation, file generation and transmission, and addition of error handlers to assist with troubleshooting. * Databricks - Entry level knowledge of the Databricks Platform/Lakehouse and its integration with Microsoft SQL to facilitate data transfer and data warehousing, and data management. * AI Tools - Entry level knowledge of appropriate, ethical, and responsible usage of AI Tools such as MS Copilot and the like to solve everyday business problems. * Experience in data aggregation, normalization, and data modeling from multiple sources. * Strong quantitative/analytical skills; strong innovation, problem solving, and conceptual thinking abilities. * Ability to solve ambiguous problems and suggest practical ways to solve them. * A working knowledge of the healthcare industry, insurance billing and third-party reimbursement is strongly preferred., * Bachelor's degree in business, Computer Science, Healthcare Management, or related field from an accredited college or university. * 3-5 years of experience working in a business intelligence (BI) related position. Healthcare revenue cycle experience preferred but not required. * Strong experience developing business-friendly decision models that source multiple data sources, formula-based measure creation, and ties aggregations to detailed data. * 1-2 years of experience writing T-SQL queries in SQL Server Management Studio (SSMS). * Proficient with MS Excel, specifically including creation and dynamic use of Pivot Tables and formulaic metrics to analyze data and produce reports. * Entry level knowledge of MS Power BI application and its basic functions. ## Description The Data Analyst, Revenue Analytics will support business-case and technical requirements of the Revenue Analytics department by capturing business requirements, developing ad-hoc queries/procedures, and constructing data models to build reports and dashboards. This position will compile data relating to revenue cycle, accounting and finance operations, weekly operational dashboards, cash flow, strategic pricing, and profitability. This position will be capable of translating end-user requirements into a structured, logical data sourcing plan and developing business-friendly reports, analyses, and impact models. This position will work directly with source database queries, schemas, and routine stored procedures across multiple platforms, including patient accounting systems, clinical systems, and data warehouses while utilizing SSMS, T-SQL, MS Excel, Power BI, and MS PowerPoint. Finally, this position will perform all duties and responsibilities in a manner consistent with GMR's mission, values, and professional standards., * Extract, aggregate, and organize data from SQL databases that house revenue cycle data from separate front-end billing applications. * Routinely evaluate data for accuracy and ensure reporting integrity. Troubleshoot irregular data issues (e.g., Correct non-conforming data relationships or unmapped new data elements). * Gather business and technical requirements from revenue cycle leadership and translate requests into functional operational reports and dashboards using Power BI and Excel. * Provide analytical support through advanced data compilation and predictive modeling for revenue operations, finance, and accounting. * Process EOM reporting package for operational leadership teams. * Generate routine and ad-hoc queries/analysis as requested. * Create SOPs and process flow diagrams as required. * Monitor daily ETL results to ensure source data is loaded in an accurate and timely manner. Troubleshoot and resolve issues, as necessary. * Maintain, repair, and optimize SSIS/SSRS packages, SQL stored procedures and all other related processes as assigned. * Assist with development and maintenance of data dictionaries, business glossaries, and documentation of data flows/lineage. * Utilize Excel Master Data Services (MDS) and other similar tools to correct mapping errors, remedy duplicates, input missing information, and otherwise ensure consistency and completeness of data related to Payors, Bases/Base Codes, Denial Codes, and the like. * Travel on occasion to revenue cycle operations center in West Plains, MO to interact with management team. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Cutting LLM Costs Without Cutting Quality: How to Beat Proprietary LLMs with Fine-Tuned Open Source](https://www.wearedevelopers.com/videos/100151-cutting-llm-costs-without-cutting-quality-how-to-beat-proprietary-llms-with-fine-tuned-open-source) - [Enabling intelligent logistics automation: home-grown Industrial IoT platform at Austrian Post](https://www.wearedevelopers.com/videos/2018-enabling-intelligent-logistics-automation-home-grown-industrial-iot-platform-at-austrian-post) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [OLTP in the Lakehouse: Redefining Data for AI Workloads](https://www.wearedevelopers.com/videos/2038-oltp-in-the-lakehouse-redefining-data-for-ai-workloads) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)