Business Intelligence Reporting Analyst I Developer
**This posting is for pipelining purposes in anticipation of an award**
If you are seeking a position with a strong team, focused on doing great things every day, with the opportunity to sell a wide array of technology solutions from the desktop to the data center, then join our team at ATS! We are looking for talented, creative individuals to help our customers solve problems.
Applied Technology Services (ATS) is an IT systems integrator and has been a trusted partner to customers in the Mid-Atlantic region for 20 years. We have core competencies in Enterprise Modernization, Infrastructure Services, End User Computing, Workforce Optimization, Cyber Security Solutions and IT Staffing. ATS provides a wide array of professional and managed services from the data center to the desktop. ATS holds minority certifications in Delaware, Maryland, the District of Columbia, Pennsylvania and Virginia and is a Third-Party Certified Women Owned Small Business (WOSB)
Applied Technology Services (ATS) seeking a Business Intelligence Reporting Analyst I Developer. The ideal candidate must possess the following:
- Thorough knowledge of the principles and practices of software development best practices.
- At least five years of experience in Cognos methodologies and development.
- Degree from an accredited college with a bachelor's degree in Computer Science, Information Technology, Management Information Services, Business Management, Engineering, Project Management, Business or Public Administration, Communications, or a related field. May be substituted with relevant software development experience of 5 or more years.
Responsibilities:
- Develop and maintain Bl dashboards, reports and cubes based on business and technology requirements and industry standard best practices.
- Plan and coordinate data migrations between systems
- Follows all required software development standards, change control procedures, and security requirements.
- Develop high quality deliverables.
- Ensure that the deliverables meet organization and performance requirements.
- Assists in the formulation of business and testing requirements.
- Coordinates and performs required unit, system, and performance testing. Works with other team members on User Acceptance testing and issue resolution.
- Ability to work both independently and participate as a member of a cross-functional team.
- Ability to build relationships with project sponsors, stakeholders, other technical staff, vendors, and end users.
- Participates in continuous improvement activities by identifying and analyzing the effectiveness and efficiency of existing processes and develops strategies for improvements.
- Produces status reports and communications on a regular basis.
- Provides requested information to the business clients utilizing advanced reporting tools.
- Leverages analysis techniques to develop comprehensive reporting solutions.
- Designs Data Warehouse components for solutions that take into consideration the value of performance, scalability, operability, flexibility, affordability, and ability to be audited.
- Devises and builds data processing jobs for the creation and maintenance of tables, views, and data marts.
- Designs Data Warehouse components for solutions that take into consideration the value of performance, scalability, operability, flexibility, affordability, and ability to be audited.
- Designs and develops dimensional data models, ETL/ELT frameworks and processing, metadata management, operational data integration.
Required Skills:
- Working knowledge or experience with SQL Server 2016+, SSAS, SSRS, and SSIS.
- Working knowledge or experience with Business Objects XI, Business Objects Web Intelligence.
- Working knowledge or experience with Tableau.
- Experience with Data Visualization.
- Skill in relational modeling.
- Devises and builds data processing jobs for the creation and maintenance of tables, views, and data marts.
- Manages the logical and physical design of a Bl data warehouse, including the creation of tables, views, procedures, packages and other database objects in support of OLAP cubes for analytics and system dashboards and reporting.
- Skill in the operation of computers and peripheral equipment.
- Skill in creative and analytic problem solving.
- Understanding of Data Warehousing principals, concepts, and architecture
- Ability to manage multiple priorities and meet project delivery dates
- Ability to effectively analyze and manage requirements
- Ability to visualize complex issues.
- Knowledge of personal computers, Microsoft Office suite of tools including; Word, Excel, PowerPoint, Visio and MS Project.
- Knowledge of programming concepts and the Software Development Lifecycle (SDLC).
- Ability to coordinate the work of a team with the work of other units within the
- Department of Research, Assessment and Accountability and other BCPS offices and departments.
- Ability to effectively communicate with all levels of users and team members.
Full-Time Employee Benefits:
- Competitive compensation
- Health benefits including Medical, Dental and Vision
- Vacation and Personal Days
- 401K
- Employee Assistance Plan
- Continuous education and learning opportunities.