Data Analyst

Pivotal Solutions, Inc.•Fenton, MO

15d

About The Position

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.

Requirements

Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, or related field
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
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

Nice To Haves

Previous experience in Power Apps, Power BI and Powershell, SSRS

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.