Data and Analytics Consultant - #495203

KiZAN Technologies


Date: 10/14/2021 14:00 PM

City: Lexington, Kentucky

Contract type: Full Time

Work schedule: Full Day

Data and Analytics Consultant


Location: Lexington, KY


Type: Full Time


Remote applicants will be considered if they are accessible to our customers.


About KiZAN


KiZAN Technologies, a Microsoft Gold Partner for twenty-seven years, is always on the lookout for the best and brightest talent. As a gold-certified and managed Microsoft partner, KiZAN allows business leaders to focus on the vision, not the technology. We provide strategic planning, application, and infrastructure services for Healthcare, Manufacturing, Financial Services, Retail, Professional Services, helping companies identify and solve business problems and take advantage of opportunities using innovative technologies, demonstrated consulting expertise and proven project management. Our clients range from mid-sized organizations to enterprise corporations, and they represent a variety of industries. Combining world-class products with our commitment to excellence has enabled us to be the local and regional technology solution provider of choice.


As a company, we exist to enable everyone to follow their passion. We succeed by attracting, developing, empowering, and promoting quality people; we embrace, kaizen, and evangelize processes; and place high value on continuous learning, creativity and an entrepreneurial spirit. As a team, we strive to create Raving Fans with our clients, as well as our employees. KiZAN provides a family culture, has received the Alfred P. Sloan Award for Workplace Flexibility multiple years, and encourages a fun environment by providing "just because" events for our family to get together outside of the workplace.


KiZAN Technologies has an immediate need for an exceptional individual to join our family as a Data and Analytics Consultant. The ideal candidate will have strong communication skills, is a true team player with a commitment to success, has leadership skills, and will be able to thrive in a fast paced, rapidly-changing environment.


Responsibilities


As a Consultant on our Business Intelligence and Analytics team, you will work closely with clients to define and deliver business intelligence and analytics solutions using Microsoft SQL Server and Power BI technologies. The Consultant provides guidance and hands-on technical expertise in designing and building solutions that unlock the value of data for our clients. The Consultant works both independently and as part of a project team on a variety of solutions, such as database design, data integration, data warehousing, business intelligence, data visualization, and others.


Responsibilities may include, but are not limited to:



  • Implement data warehousing, reporting, business intelligence and analytics solutions
  • Design, deploy and administer business analytics solutions using Power BI
  • Create both paginated and interactive reports
  • Create dashboards and scorecards
  • Create ETL processes using SSIS, Azure Data Factory and similar tools
  • Design and implement relational databases
  • Assist in creating tabular models using Analysis Services and/or Power BI
  • Provide input in database design and review sessions
  • Troubleshoot existing BI solutions
  • Identify and strive to realize desired business outcomes from customer engagements
  • Manage successful completion of project initiatives on-time and within budget
  • Transfer knowledge to customers as part of the delivery of services and through classroom instruction
  • As the client's trusted advisor, identify and pursue additional opportunities to provide value
  • Communicate with clients about project status, handle customer concerns, involving Practice Lead or Project Manager as needed

Minimum Requirements



  • Bachelor's Degree in computer science, information systems, business, mathematics, engineering or equivalent work experience
  • 2+ years building data warehousing, business intelligence and analytics solutions using Microsoft technologies
  • Proficiency with Power BI (1+ years of work experience)
  • Proficiency with SQL Server or cloud-based databases services with strong T-SQL development skills (2+ years of work experience)
  • Proficiency with data integration tools, such as SSIS or Azure Data Factory (1+ years of work experience)
  • Proficiency with paginated report development using SSRS (1+ years of work experience)
  • Proficiency in Excel
  • Strong track record of Business Intelligence solution development
  • Ability to travel, overnight up to 25%
  • Ability to travel independently to client sites; if by car, a valid driver's license or reliable method of transportation is required
  • Authorization to work in the U.S. without sponsorship

Skills and Abilities



  • Strong analytical, design, data modeling and problem-solving skills
  • Ability to show initiative and work independently in a self-reliant manner with minimal supervision
  • Ability to quickly learn new technologies and apply appropriately to business situations
  • Strong team player who enjoys working in a fast-paced team atmosphere
  • Ability to balance team and individual responsibilities
  • Ability to work under pressure; meet strict deadlines
  • Ability to listen effectively and seek clarification
  • Excellent written and oral communication skills in English. Must be able to effectively and comfortably communicate with all types of individuals from the customer technical expert to the customer executive management

Preferred Experience, Skills and Abilities



  • Experience with Power BI adoption, administration and governance
  • Knowledge of dimensional modeling and database optimization techniques
  • Knowledge of ETL and report development best practices and optimization techniques
  • Experience with SSAS and proficiency in DAX and/or MDX
  • Experience with developing data and analytics solutions in Azure, using such technologies as Azure SQL Databases, Azure SQL Data Warehouse, Azure Data Lake, Azure Data Factory, Azure Stream Analytics, Azure HDInsight, Azure Machine Learning and others
  • Work experience in a consultant capacity
  • Knowledge of Agile/SCRUM SDLC Methodologies
  • Microsoft Certifications in Database Development, Database Administration, Business Intelligence, or related fields.

EEO/AA Employer

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume