Job Description
PURPOSE/SUMMARY:
MS SSRS Report Write position is responsible for delivering full life-cycle reporting solutions using industry standard business intelligence tools to expose data and KPI's to executive management. As a BI Report Writer you are responsible for the design, development, testing and maintenance of complex reports. The BI Analyst/Developer will also assist in identifying any need for further data sources or content. This role requires you to be a leader in quality control and highly knowledgeable about report-writing and business intelligence best practices.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
- Work closely with other departments to gather and document functional technical report requirements for new reports and translate those changes to reporting solutions using database structures (tables, stored procedures, views, etc.)
- Manage the data warehouse to ensure accuracy and reliability
- Create complex reports using MS SSSR
- Access MS Dynamics to pull the Data to generate reports using SSRS
- Develop and design web-based dash-boarding
- Create documentation of report logic and processes
- Work with QA team to ensure accurate and complete testing
SKILLS/KNOWLEDGE/ABILITIES:
- Bachelor's degree in a relevant field required
- Minimum 3-5 years' experience of SQL programming/business intelligence report writing, report development tool usage and business requirements gathering
- Must possess the ability to manage multiple concurrent projects and assignments
- Proven experience in effectively partnering with business teams to deliver their goals and outcomes by designing user-friendly reports
- Experience in C# .Net Development
- Experience in MS SQL
- In-depth understanding of underlying data, data structures, and business uses to ensure reports meet business needs
- Knowledge of Microsoft SQL Reporting, Analysis, & Integration Services strongly preferred.
- Knowledge and experience with ETL tools also preferred.
- Critical thinking, problem solving, and decision making skills
- Previous experience with ERP systems; Microsoft NAV a plus
Skills Required
- Bachelor's degree in a relevant field
- 3-5 years SQL programming and business intelligence report writing experience
- Experience creating complex reports using Microsoft SSRS
- Experience accessing Microsoft Dynamics to pull data for reports
- Experience with C# .NET development
- Experience with MS SQL and database structures (tables, stored procedures, views)
- Ability to manage multiple concurrent projects and assignments
- Proven experience partnering with business teams to design user-friendly reports
- In-depth understanding of data, data structures, and business use cases
- Manage and ensure accuracy/reliability of the data warehouse
- Develop and design web-based dashboarding
- Knowledge of Microsoft SQL Reporting, Analysis, and Integration Services (SSRS, SSAS, SSIS)
- Knowledge and experience with ETL tools
- Previous experience with ERP systems; Microsoft NAV a plus
- Critical thinking, problem solving, and decision making skills
What We Do
Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.
.jpg)
