Senior Data and Analytics Consultant Location: Dayton, OHEmployment Type: Full TimeAbout KiZANWe make technology personal!KiZAN is an Industry leading Microsoft Professional Services and Managed Services Provider supporting Regional, National and Global clients. We personalize technology by sparking passion, fueling purpose, and building connections.Here at KiZAN, we are one team, we support each other, and take the initiative to solve problems. We are fully committed to the direction chosen and always support our Mission. Being a part of KiZAN means that we win together, we create an inclusive atmosphere where everyone feels accepted, a sense of purpose, and we embrace collaboration.KiZAN Technologies has an immediate need for an exceptional individual to join our family as a Senior 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.
ResponsibilitiesThe Senior Consultant works closely with clients to define and deliver business intelligence and analytics solutions using Microsoft Fabric, 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, Azure Data Factory, Databricks, or similar ETL tools
- 3+ years using SSRS, Power BI, or similar reporting tools
- 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 Open AI and ML is a plus
- Knowledge of C# or VB.NET
- Work experience in a consultant capacity
- Knowledge of Agile/SCRUM SDLC Methodologies
EEO/AA Employer