Senior Consultant - Business Intelligence and Analytics

KiZAN Technologies - Louisville, KY (30+ days ago)4.0

Location: Louisville, KY
Employment Type: Full Time

About KiZAN

For over 25 years, KiZAN has been on the lookout to hire the best and brightest talent. KiZAN promotes a culture that enables everyone to pursue what they love and has been named among the 100 Best Places to Work in Kentucky. As a family of information technology Rock Stars, KiZAN's consultants deliver solutions centered on Microsoft-based technologies that solve even the most complex business problems. As a team, we strive to create Raving Fans with every customer!

KiZAN was selected as Microsoft's first Solution Provider Partner of the Year in 1995 and continues as the 2016 Microsoft Partner of the Year for the Heartland District. Today, KiZAN is a Microsoft Gold Certified Partner with offices in both Louisville, KY, and Cincinnati, OH. KiZAN provides service throughout Kentucky, Ohio, Indiana, Michigan and Tennessee.

KiZAN has an immediate need for an exceptional individual to join our family as a Senior Consultant – Business Intelligence and Analytics. This opportunity is based out of our office in Louisville, KY. The ideal candidate has a passion for data analytics, strong communication skills, is a true team player with a commitment to excellence and will be able to thrive in a fast-paced, rapidly-changing environment.


The Senior Consultant works closely with clients to define and deliver business intelligence and analytics solutions using Microsoft SQL Server, Power BI, and Microsoft Azure technologies. The Senior Consultant provides vision, direction, as well as hands-on technical expertise in designing and building solutions that unlock the value of data for our clients. The Senior Consultant works both independently and as part of a project team on a variety of solutions, such as data warehousing, business intelligence, data visualization, big data analytics, predictive analytics, and others.

Responsibilities may include, but are not limited to:
Lead the development of data warehousing, reporting, business intelligence and analytics solutions
Apply knowledge of on-premises and cloud-based Microsoft technologies in the areas of database development, data warehousing, business intelligence, data visualization and analytics
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
Mentor fellow consultants and interns
As the client's trusted advisor, identify and pursue additional opportunities to provide value
Seek new business opportunities with existing clients or within the general market
Provide pre-sales technical support, conduct demonstrations, and prepare technical aspects of proposals/statements of work
Communicate with clients about project status, handle both routine and complex 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
5+ years building data warehousing, business intelligence and analytics solutions using Microsoft technologies
5+ years with SQL Server with strong T-SQL development skills
2+ years using SSAS, with proficiency in MDX and DAX
3+ years using SSIS
3+ years using SSRS
Proficiency in Power BI
Proficiency in Excel
Strong working knowledge and track record of Business Intelligence 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
Knowledge of dimensional modeling and database optimization techniques
Knowledge of ETL and report development best practices and optimization techniques
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
Knowledge of SharePoint and related BI technologies (Excel Services, Power Query, Power View, SSRS)
Knowledge of C# or VB.NET
Work experience in a consultant capacity
Knowledge of Agile/SCRUM SDLC Methodologies
Preferred Certifications: MCITP in Database Development or BI, MCSE for BI
EEO/AA Employer