Reporting Analyst

• Write scripts for Microsoft SQL databases using T-SQL to extract and analyze data

• Format data for meaningful ad-hoc analysis and reporting

• Create reports and/or dashboards for business users using Excel, Power BI, and/or other applicable reporting tools

• Work directly with Sales, Operations, and Marketing to analyze data for current and prospective clients

• Assist and coordinate with IT developers as an SME to transfer analyses into scheduled reports

• Maintain a knowledge repository of critical tables, queries, fields, and relationships

• Assist in Research Projects and gathering data to improve internal processes

• Analyzing complex data sets from potentially multiple internal and external sources

• Documenting data elements, data flow, and data relationships/dependencies

• Ability to interpret data findings, conduct root cause analysis of business problems, and accordingly suggest potential process improvement changes

• Understanding of Microsoft stack of technologies and the .NET framework can be helpful

• Commiment to Tria's mission and vision statments, core values, motto and handbook 

Qualifications

• Working knowledge of data and reporting, as well as relational database theory and practice

• Ability to work independently in a dynamic environment

• Experience and/or curiosity with reporting tools such as Power BI

• Expertise with the Microsoft Office suite, particularly Excel

• Working knowledge of Microsoft SQL Server databases and scripting, or similar database management systems

• Strong problem solving and troubleshooting skills

• Focused, detail-oriented approach to analysis

• Excellent communication skills, oral, and written

• Ability to independently manage time and prioritize projects to meet deadlines

Success Factors:

• Highly motivated, self-starter with a strong sense of duty

• Communicates technical concepts clearly to a diverse range of stakeholders

• Exhibits critical thinking, analytical, and problem-solving skills with the ability to troubleshoot programs, code, queries, reports, and devise a course of corrective action

• Highly organized and efficient with the ability to multitask, prioritizes tasks appropriately

• Goes above and beyond to create outstanding customer experiences

• Productive without sacrificing quality, maintainability, accessibility, or performance; perform duties at a high degree of accuracy

• Encourage giving & receiving feedback, while handling such in a positive and  graceful fashion

Education/Experience

• Bachelor’s degree from a four-year college or university in Business, Finance, Economics, Statistics, Information Technology, or a related field

AND/OR 

• 2+ years of relevant work experience as a report-writer or analyst

Physical Demands and Work Environment

The physical demands and work environment described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Physical Demands: While performing the duties of this job, the individual is regularly required to stand, bend, kneel, sit, walk, and use hands to finger, handle, or feel objects; reach with hands and arms; talk and hear. The vision requirements include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust focus. Individual must occasionally lift and/or move up to 5 pounds.

• Work Environment: This job operates in a professional office environment where standard office equipment such as computer, phones, copiers, filing cabinets and printers are utilized. The noise level in the work environment is usually minimal.

• Work Schedule: 40-hour workweek, Monday - Friday

• Location: Tria Health is in Kansas City, MO (Crossroads area). This is not a remote job, but a hybrid schedule can be offered after training.

*This job description should not be considered an all-inclusive listing of work requirements and may be changed at any time.