Business Intelligence Developer - Work from home

The Sr BI Developer is responsible for design, development, configuration, testing, implementation, maintenance, security of reporting and associated applications supporting the core University systems and applications. This person will also serve as a backup report administrator for the primary application tools. The SR BI Developer utilizes software to generate metrics and develops actionable recommendations. The analyst provides support to research teams or management by collecting and analyzing data and reporting results based on the needs of end users and collaborates with various functional teams based on their area of focus, and IT to achieve business results.

Technical Proficiency :

• Work with users to understand and document reporting requirements. Assist in the translation of the business requirements into report objects with appropriate security comprehended. Develop and enable solutions (reports, visualizations) to support the University’s goals.
• Responsible for the design and development of executive reports as well as function specific reporting.
• Develop and enable reporting solutions to interact with cloud-based solutions.
• Writes adhoc queries and reports using various reporting / database tools to support research, financial, and executive initiatives.
• Analyzes and synthesizes complex and diverse information gathered from senior management and end users to develop new reports and reporting systems as needed.
• Design, develop and implement complex dashboard reports and visualizations for data warehouse and clarity.
• Participate in the development and maintenance our environments that support the applications used for report writing.
• Responsible for the development and support of strategies for warehouse implementation, data acquisitions and archive recovery.
• Responsible for SQL queries and modifications to facilitate problem resolution and reporting needs.

Project Proficiency :

• Participates in design sessions to capture requirements and data for report development.
• Develops report specifications and ensures those requirements are met across all functional areas (e.g. procurement, finance, student, executive / University-wide etc.)
• Translates business requirements into report objects with appropriate security comprehended.
• Delivers solutions (reports, visualizations) to support the University’s goals.

Operational Proficiency :

• Perform analysis activities and create / participate in the creation of the functional specification under the direction of more senior applications development staff.
• Develops and maintains security architecture, security administration and workflow automation within the applications suite.
• Prepares necessary paperwork and documentation to ensure conformance to departmental / university standards and procedures.
• Executes unit tests. Works with application testers on the preparation of test plans, test data and integrated unit testing
• Delivers executive reports as well as function specific reporting.
• Writes reports using cloud-based data sets.
• Writes adhoc queries and reports using various reporting / database tools to support research, financial, and executive initiatives.
• Designs, develops and implements dashboard reports and visualizations for data warehouse and clarity.
• Supports development and maintenance of environments that support the applications used for report writing.

Education & outreach :

• Supports the University’s communications outlets for reporting tools such as Upstate NY Tableau Users Group and Upstate NY IBM Cognos Users Group
• Coordinate with other resources (programmers, analysts) to achieve goals and collaborate for solutions.
• Maintains current knowledge of technology, equipment, and / or systems.
• Performs other related duties, including presentation of seminars, courses and instruction on computer services as required. Participate in on-call, responding to application issues as they occur. Perform miscellaneous job-related duties as assigned.
• Other duties as assigned
• Skills : *

Technical writing, Power bi, Crystal reports, Business intelligence, Tableau, Data, data warehouse, sql, Data analysis

• Top Skills Details : *

Technical writing,Power bi,Crystal reports,Business intelligence,Tableau,Data,data warehouse

• Additional Skills & Qualifications : *

This position will convert between $70k to $75k. Possibly a little flexibility on that.

On a day to day this candidate will work with users to understand and document reporting requirements. Assists in the translation of the business requirements into report objects with appropriate security comprehended. Develops and enables solutions (reports, visualizations) to support the University’s goals. Responsible for the design and development of executive reports as well as function specific reporting. Develops and enables simple reporting solutions to interact with cloud-based solutions. Writes simple adhoc queries and reports using various reporting / database tools to support research, financial, and executive initiatives. Analyzes and synthesizes diverse information gathered from senior management and end users to develop new reports and reporting systems as needed. Designs, develops and implements dashboard reports and visualizations for data warehouse and clarity. Participates in the development and maintenance our environments that support the applications used for report writing. Responsible for the development and support of strategies for warehouse implementation, data acquisitions and archive recovery. Responsible for running SQL queries and recommending modifications to facilitate problem resolution and reporting needs. Participates in design sessions to capture requirements and data for report development. Develops report specifications and ensures those requirements are met across all functional areas (e.g. procurement, finance, student, human resources, executive-wide etc.) Performs analysis activities and creates and participates in the creation of the functional specification under the direction of more senior applications development staff. Develops and maintains security architecture, security administration and workflow automation within the applications suite.

• Experience Level : *

Expert Level

About TEKsystems :

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.