What are the responsibilities and job description for the Data Analyst position at Pivotal Solutions, Inc.?
Job Summary
The IT Data Analyst position is an exciting opportunity to work on multiple applications and is responsible for multiple technologies and interfaces within the organization. Many of our systems are third-party business systems with some smaller applications written in house. This position is an expert on the system architecture and assists the vendor with technical information for the changes, working with the vendor to coordinate changes or has the ability to write an in-house solution for smaller internal applications. The IT Data Analyst works with both business partners and other IT team members to determine the future direction of all applications based on our requirements.
The IT Data Analyst position is an exciting opportunity to work on multiple applications and is responsible for multiple technologies and interfaces within the organization. Many of our systems are third-party business systems with some smaller applications written in house. This position is an expert on the system architecture and assists the vendor with technical information for the changes, working with the vendor to coordinate changes or has the ability to write an in-house solution for smaller internal applications. The IT Data Analyst works with both business partners and other IT team members to determine the future direction of all applications based on our requirements.
Responsibilities
- Applies advanced knowledge of professional concepts and company objectives to resolve a wide range of issues in creative and effective ways
- Subject matter expert in more than one area of responsibility; represents team within and outside own department. Become technical owner of multiple third-party and in house applications. This includes utilizing the full project lifecycle including requirements, development, testing and implementation.
- Conduct product research, evaluate new software products against requirements.
- Oversees Data Warehouse operations, troubleshoots and fixes issues
- Assists with project planning; provides technical expertise to team members and/or vendors
- Has significant autonomy over completion of day-to-day work and receives general instructions on new projects or assignments
- Defines, develops, communicates, and implements standards, processes, and procedures for the team or department
- Establishes, maintains, and fosters relationships both within and outside the team, department and our vendors
- Monitors key performance metrics to ensure compliance of established standards, processes, and procedures
- Understands and translates business requirements to software designs that align with overall business and technology vision
- Defines, creates, and evaluates processes; identifies and recommends process improvements; designs solutions using knowledge of business strategy, security, technologies, and architectural methods
- Collaborates with vendors on the direction for the development of solutions or enhancements
- Maintains knowledge of emerging architectural methods and technologies for application to the environment
- Listens to and evaluates customer needs to determine, provide, and identify high quality solutions that align with customer expectations
- Provides instruction and guidance to less senior team members on new tasks and assignments; ensures deadlines are met
- Perform other miscellaneous duties as required by management.
Education
MINIMUM QUALIFICATIONS
- Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, or related field
Experience
- Requires 5 or more years of experience in data analysis, problem solving, script writing, reporting and data warehouse.
- Requires 3 or more years previous development experience
- 3 or more years of SQL query development
Preferred
- Previous experience in Power Apps, Power BI and Powershell, SSRS
Knowledge, Skills And Abilities
- Extensive knowledge with Office 365 products including SharePoint online and Excel
- Excellent analytical skills with the ability to use data for effective presentation of information
- Proven leadership, results orientation, and self-motivation traits
- Superb communication skills -- both written and verbal with the ability to engage an audience across a broad range of technical expertise and/or business acumen
- Proficient knowledge of project management concepts, from planning and inception, through implementation and support
- Must demonstrate flexibility and agility related to critical thinking and making decisions with complex considerations as it relates to business implications
- Proven experience developing strategies for solutions that solve business problems, are scalable and sustainable, are secure, and meet internal long-term goals of IT and the business
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.