Social Media Manager

Title: BUSINESS INTELLIGENCE (BI) ANALYST

Location: Saint Paul, Minnesota

Note: This is full time and onsite position.

Job Description:

• Analyze and extract meaningful data from multiple spreadsheets, combine workbooks and develop essential data set reporting.
  
• Review data & reports (completeness of information, correct calculations, and proper execution).
  
• Assist analysts in obtaining/collecting all documents/information to complete assigned projects or tasks.
  
• Write procedures to document processes used by Business Intelligence staff.
  
• Perform data entry relevant to project or task.
  
• Interpret data as required by business lines (staffing analysis, business reports, forecasts), analyzing results using statistical techniques, creating clear reports with information displayed in a format useful to individuals without technical experience.
  
• Track data integrity within relational database (RDBMS) structures.
  
• Evaluate existing objects for impact of new development.
  
• Perform routine maintenance tasks on reporting database.
  
• Maintain report library with versioning (using GitHub).
  
• Collaborate with business line owners and propose appropriate analytics solutions to address critical business needs.
  
• Develop SSIS/ETL packages for SQL development.
  
• Manage incoming data pipeline (timing and data integration points).
  
• Backend Dashboard Data base Object builds.
  
• Source data staging.
  
• Build logical relational data stores.
  
• Build a solid and holistic understanding of how all the departments of the bank function.
  
• Support and contribute to the vision of the Business Intelligence department and work closely with team members and management to implement and support effective solutions.
  
• The work involve working with SQL based data sources, including Azure SQL and Microsoft SQL Server.
  
• Report data may also come from sources such as spreadsheets or APIs making the ability to work with and integrate diverse data essential.
  
• This position will not be responsible for creating or maintaining ETL processes but may need to have the ability to create basic views, stage data, build queries and stored procedures.
  
• This role will be responsible for working with various data objects and should demonstrate an understanding of basic concepts of data integrity and relational data stores.
  
• Analyst will work with business units within the organization to provide data and reports to higher level management.
  
• Role will include administration of system used by the organization including QuickBooks Time.
  

Required Skills:

• College degree in business or information technology or Data Sciences preferred.
  
• Two years of experience in information technology and/or data sciences preferred.
  
• Excellent analytical and problem-solving skills.
  
• Experience with relational and non-relational database structures preferred.
  
• Experience with statistical analysis preferred. Will be conducting practical statistical analysis of data sets.
  
• Advance understanding of SSIS/ETL package development for SQL
  
• Experience with Business Intelligence software preferred. Will be using Microsoft Power Platform.
  
• Superior skill set in the use of the following software applications: Microsoft Excel, Word, PowerPoint, Access, and Outlook.
  
• High integrity and ethics.
  
• Growth mindset (naturally curious strong learning agility).
  

About Us:

Tri-Force is one of the fastest growing companies in the Philadelphia region by receiving the award 5 times and 3 times (Ranked #) on In c. 5000 fastest growing companies in the USA. Tri-Force Consulting Services, In c. is an established consulting services firm offering innovative solutions to Government and Commercial sectors.

We specialize in building customized software applications solutions such as knowledge management systems, business intelligence, data analysis, database support and maintenance, data warehouse implementation and support, systems architecture and systems integration for our clients.

Our technical competencies are in Java,.NET, SharePoint, PHP, Business Intelligence (Cosign, Data Warehouse), mobile applications platforms (iPhone, iPad, Android, Blackberry), and various other technologies. We also specialize in providing resources to manage infrastructure projects.

Tri-Force is one of the fastest growing companies in the Philadelphia region by receiving the award 5 times and 2 times on In c. 5000 fastest growing companies in the USA.

Proven track record in providing technical project management, risk assessment, and agile delivery. Proven track record in delivery of on-time, on-budget projects with a high degree of user satisfaction and quality. Proven track record implementing varying principles and techniques of project management, including the ability to develop and track complex project plans, manage risks, manage scope, and manage resources. Experience applying technical project management skills to website or web application redesigns. Experience applying technical project management skills to the implementation, configuration, and roll-out of Web Content Management Systems. Knowledge of principles of web design, UX design, and product development. Proven track record of managing complex relationships among stakeholders on a project which has significant executive oversight. Proven track record of building coalitions among various stakeholders using excellent conflict resolution skills, where needed. Experienced at establishing and maintaining effective working relationships. Experienced with the principles of full life cycle systems design, development, testing, and deployment. Experienced with providing clear goals, and responsibilities, and providing measurable performance and feedback. Excellent analytical capabilities and the ability to break down complex ideas into manageable pieces. Excellent written and verbal communication skills, with both technical and non-technical audiences, including creating and presenting executive summaries to steering committees and other executive-level leadership. Experienced with MS Office applications including Word, Excel, Project, and Visio. Knowledge of digital government and digital government strategies. Ability to identify and evaluate alternative solutions, costs, and benefits. Ability to communicate effectively in English, orally and in writing.