V-Soft Consulting Group, Inc. is a recognized staffing company headquartered in Louisville, KY, and they are seeking a Business Intelligence/Data Analyst to support their client in Phoenix, Arizona. The role involves designing reports, data analysis, and utilizing various business intelligence tools to present findings to both technical and non-technical audiences.
Responsibilities:
- Designing reports requiring analysis, writing of SQL, data mining, and presentation to technical and non-technical audiences in a variety of technical platforms (Tableau, Excel, Power BI, Sales Force Marketing Cloud, UI Path, etc.) Create Journey’s in Sales Force Marketing Cloud for sending out ongoing electronic messages (email and SMS.)
- Prioritize business and operational needs
- Extract, import, clean, transform, and validate data
- Writing queries using SQL and MS Access
- Experience with DB2
- Identify, analyze, and interpret trends or patterns in complex data sets
- Create standard and ad-hoc reports including detail, summary, history, snapshots, drill down, and other reports
Requirements:
- Knowledge of Service Level Agreement (SLA); laws, rules, security policies, privacy, data confidentiality management
- Knowledge of multiple business intelligence software applications (SQL, SSIS, MS Visual Studio, Tableau, Visual Basic, MS Access, Sales Force Marketing Cloud, UI Path, etc.) and multidimensional and relational database design
- Knowledge of project management concepts, principles, and practices
- Skilled in the use of Business Intelligence (SQL, SSIS, Tableau, Visual Basic, MS Access, BI Software, and RPA.)
- Skilled in dimensional and relational database design
- Skilled in analysis, design review, troubleshooting, implementation, and integration for applications
- Knowledge of Engineering workflow, IT lifecycle and system design, performance tuning, and Business Intelligence tools and features
- Knowledge of Statistical and business analysis and research and analysis methodologies
- Skilled in keyboarding and use of Microsoft Office programs such as Excel, Word, Access, and PowerPoint and Google for gmail, calendar, chat, sheets, docs, forms, slides, etc
- Problem and negotiation skills to research and resolve issues
- Good time management and organizations skills with attention to detail
- Skilled in effective listening, oral and written communications skills to communicate technical and non-technical concepts to a variety of audiences
- Ability to write business and functional requirements and diagram business processes, translate into technical solutions and reports, query and view objects, and present them in a meaningful format
- Experience with DB2