Digital Insights Consultant

Kansas City, MO
Submit Resume

GENERAL DESCRIPTION & RESPONSIBILITIES

Responsible for building, implementing and supporting all Microsoft Business Intelligence Solutions. Utilize experience in all stages of Business Development project work (requirements and logical design, physical design, implementation, testing and deployment). Perform SQL Queries & Data Analysis. Translate user requirements into applications based on .Net along with back-end database design. Enterprise Reporting Solutions using MS, BI Stack SSIS, SSAS and SSRS. Learn and understand existing business processes and identify areas for optimization.

Analyze user requirements, procedures, and problems to automate or improve existing systems and review computer system capabilities, workflow, and scheduling limitations. Design Extract Transform and Load (ETL) strategies for data transfer between databases. Define programming requirement; formulate a detailed plan outlining steps to develop programs, using structured analysis and design. Write detailed requirements of user needs, program functions, and steps required to develop or enhance system functionality. Document the program development process, logic, coding and corrections. Create Test Plans and test data. Conduct and evaluate Unit Testing to verify correct implementation of program/Module Specification. Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT).

REQUIREMENTS

The requirements for the position are a Master’s degree in Computer Science; Information Technology; Computer Engineering; or related field, plus two years of experience in Business Intelligence implementation methodologies; database design or integration experience with SQL Server databases; knowledge of project management methodologies and best practices; ability to gather data, research and analyze problems to develop insightful solutions to address user needs and ability to create written materials to communicate effectively and summarize findings and support recommendations. Specific technical skills include: Relational Database and SQL Language; Extraction, Transformation and Loading (ETL) (Microsoft SSIS); Solution Design; Dimensional Modeling (Kimball Methodology); Analytics/OLAP Cube Development (Microsoft SSAS and MDX); Report Development (Microsoft SSRS);

VALOREM EXPECTATIONS

These are the traits that we hold in the same regard for all employees, also viewed as performance indicators.  Each employee should uphold these attributes as a part of their employment with Valorem.

 

Communication and Interpersonal Skills

        • All employees are expected to exhibit exemplary customer service skills, to all people, regardless of level inside or outside of the company 
        • Written and verbal communication skills should be professional, concise and effective

Collaboration and Teamwork

        • Build alliances to solve problems and achieve objectives by sharing knowledge and information
        • Work cooperatively and respectively with co-workers
        • Strong collaboration skills, works well with ambiguity, works well across roles and groups
        • Openly and actively participates in the direction of our Company
        • Exercise confidentiality concerning the affairs of the business

Personal Ownership and Responsibility 

        • “Own” your work – take initiative, be proactive, anticipate and complete projects in a comprehensive manner while still remembering the details
        • Be here to enhance and promote Valorem  
        • Exhibit a willingness to learn, willingness to problem solve and willingness to step in to help others 
        • Creativity, capacity and a conviction to innovate and deliver best-in-class solutions

Customer Focus

        • Always put the clients’ needs first, thinking proactively from their vantage point, not your own
        • Follow through with all client expectations and accountabilities Time Management and Productivity
        • Meet your timelines and goals 
        • When you say you are going to do something, it is your responsibility to perform within the timeframe

 

PHYSICAL DEMANDS 

While performing the duties of this position the employee is regularly required to sit and talk and hear. The employee is frequently required to use hands to finger, handle or feel and reach with hands and arms.  The employee is occasionally required to stand, walk and drive or ride in a motor vehicle.  The employee must occasionally lift and/or move up to 25 lbs.  Must have the ability to travel, sometimes with short notice.

 

Submit resume via email to CAREERS@VALOREM.COM

 

Submit your resume for this job

Kansas City, MO

Digital Insights Consultant