Report Writer

HCEW MANAGEMENT SERVICES LLC; California (MO); On-site; USD 65,000 - 75,000; Full time

Job summary

HCEW MANAGEMENT SERVICES LLC is seeking a Jr Report Writer to support our data team by maintaining existing Power BI reports and handling new requests. The role blends on-prem and cloud data sources, focusing on data modeling concepts, report accuracy, and clear end-user communication.

You will monitor 70+ report assets, apply governance, and document reporting standards while collaborating with developers.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, Data Science, or a related field.
• 1-2+ years of relevant experience in report writing, dashboards, Power BI and/or Tableau, and data architecture fundamentals.
• Familiarity with Microsoft Office products.
• Demonstrated troubleshooting and problem-solving skills.
• Ability to communicate effectively with end users, tell data-driven stories, and translate technical concepts into clear, accessible language.

Responsibilities

• Assist with monitoring more than 70 Power BI report assets and help ensure successful daily refreshes.
• Perform requested modifications or improvements to reports.
• Manage ticket queue for reported issues and/or new report requests.
• Assist in migrating existing reporting to match current report theme standards and ensure consistency.
• Work with developers to update existing reports based on newly modeled or cleaned data tables.
• Assist with assigning access to reporting audiences when needed.
• Gather reporting requirements from end users to clarify report objectives.
• Validate report results to ensure consistency and identify data inconsistencies or missing information.
• Apply data quality standards to support accurate and consistent reporting.
• Maintain report inventory including, report logic, business rules, refresh schedules and related documentation.
• Assist with Power BI workspace organization to support governance standards.
• Develop end user documentation for Power BI best practices within the organization.
• Provide basic end user-training on Power BI fundamentals.
• Assist with testing new or modified reports using end-user input.

Skills

Power BI

DAX

Tableau

Excel

Communication

Education

Bachelor's degree in IT/CS/Data Analytics

Tools

Microsoft Office

Dynamics 365 F&O ERP

Power Apps

Dataverse

Job description

We are looking for a Jr Report Writer to assist our data team in maintaining existing reports and supporting new reporting requests. This role is responsible for helping maintain Power BI reports with a mix of on-prem and cloud data sources. The ideal candidate will have foundational technical skills, an understanding of data concepts, and strong communication skills to work professionally with end users. Experience with Power BI, Microsoft products, and data modeling concepts is preferred.

Key Responsibilities:

• Assist with monitoring more than 70 Power BI report assets and help ensure successful daily refreshes.
• Perform requested modifications or improvements to reports.
• Manage ticket queue for reported issues and/or new report requests.
• Assist in migrating existing reporting to match current report theme standards and ensure consistency.
• Work with developers to update existing reports based on newly modeled or cleaned data tables.
• Assist with assigning access to reporting audiences when needed.
• Gather reporting requirements from end users to clarify report objectives.
• Validate report results to ensure consistency and identify data inconsistencies or missing information.
• Apply data quality standards to support accurate and consistent reporting.
• Maintain report inventory including, report logic, business rules, refresh schedules and related documentation.
• Assist with Power BI workspace organization to support governance standards.
• Develop end user documentation for Power BI best practices within the organization.
• Provide basic end user-training on Power BI fundamentals.
• Assist with testing new or modified reports using end-user input.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, Data Science, or a related field required; industry certifications, such as Microsoft Certified: Power BI Data Analyst Associate or equivalent, are preferred.
• Working knowledge of DAX, Power BI and/or Tableau reporting platforms, Excel, or equivalent tools.
• 1-2+ years of relevant experience in report writing, dashboards, Power BI and/or Tableau, and data architecture fundamentals.
• Familiarity with Microsoft Office products.
• Demonstrated troubleshooting and problem-solving skills.
• Ability to communicate effectively with end users, tell data-driven stories, and translate technical concepts into clear, accessible language.

Preferred Qualifications

• Strong understanding of relational database concepts such as data relationships and table joins.
• Ability to write and understand Power Query formulas, DAX, filter data, and perform table joins in Power BI.
• Understanding of data types such as date, datetime, etc.
• Knowledge of basic SQL and simple SELECT statements.
• Familiarity with data modeling concepts such as star schema.
• Familiarity with Dynamics 365 F&O ERP, Microsoft CE, Power Apps, and Dataverse data sources.

Reasoning Ability

Ability to analyze reporting issues, identify potential data inconsistencies, and help translate business processes into clear reporting requirements. Demonstrates sound judgment, attention to detail, and the ability to support technical problem-solving in a production reporting environment.

Physical Demands

The physical demands 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. While performing the essential functions of this job, the employee is regularly required to talk or hear. The employee is frequently required to sit; use hands and fingers to handle, feel or reach with hands and arms. The employe is occasionally required to stand and walk. The employee is occasionally required to lift 10 lbs up to 25 lbs. Specific vision abilities required for this job include close vision.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.

Compensation

• Salary Range: $80,000 to $90,000 annually
• Non-Exempt Position. We offer medical, dental, vision, profit sharing, life insurance, voluntary spouse life insurance, voluntary dependent life insurance, FSA, DCA, long term disability, accident insurance and more!

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.