IT Business Systems Analyst (Data and Reporting)
ExternalPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
Requirements
- Problem-solving mindset with confidence in working with data and troubleshooting issues.
- Ability to work independently, prioritize tasks, and take ownership of work.
- A proactive, hands-on approach and motivation to build and improve processes.
- Curiosity and willingness to learn, especially in understanding business applications and how data connects across systems.
- Strong communication skills to work with both technical and non-technical stakeholders.
- Fluency in English, both written and spoken.
- Your experience
- 2+ years of experience with business applications, SQL databases (e.g., SQL Server / SSMS) and Power BI (or similar BI tools), including writing queries and building dashboards.
- Solid understanding of data modelling and how data is structured for reporting.
- Experience working with data pipelines and centralized data environments (e.g., Data Warehouse or Data Lakehouse).
- Experience in working with ERP, CRM (Salesforce), or similar business applications is a plus.
Benefits
Additional Information
Love when everything just works? So do we. That's why we're looking for an IT Business Systems Analyst who's a natural problem solver, a strong collaborator, and someone who thrives on making things run smoothly behind the scenes. Your main focus will be building dashboards and reports based on data from our business applications. You'll ensure that data across systems is structured, reliable, and useful for reporting and decision-making. You'll support daily operations, improve existing solutions, and contribute to new implementations. The long-term goal - to become the go-to person for data and reporting within the team. In this role you will Be responsible for data and reporting across business applications (ERP, HR, and other systems). Manage and develop SQL views in the ERP system, supporting financial reporting and improving underlying data structures. Work with SOQL queries to extract and analyze data from Salesforce. Maintain and expand the Data Lakehouse, including integrations from ERP and other systems. Build and maintain Power BI dashboards, combining data from multiple sources into clear insights. Structure, clean, and integrate historical and legacy data into centralized models. Collaborate with teams across the company to understand needs and translate them into data solutions. Support implementation projects, define requirements, and ensure a data-driven approach. Test system changes and new functionalities to ensure data accuracy and consistency. Maintain and improve data integrations to ensure reliable data flow. Keep documentation and data logic clear, structured, and up to date.
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at outfit7? Share your experience