Digital Insights Consultant I Job in Valorem Reply

GENERAL DESCRIPTION & RESPONSIBILITIES:Valorem is seeking a Data & Analytics professional with a passion for utilizing the Microsoft BI Stack to provide value and insights to a business. The Digital Insights Consultant has experience building and contributing to the design of database systems, both normalized transactional systems and dimensional reporting systems. Experience with SQL Server as a database engine, as well as Microsoft Azure Analytics stack is required. Successful candidates will have experience and skill in providing solutions for storing, retrieving, transforming and aggregating data to support line of business applications as well as reporting systems.The Digital Insights Consultant will work to deliver solutions utilizing strong business, technical and data modeling skills. This position may work collaboratively across all Valorems sales, service delivery and account management organizations in service to Valorems customers. This position will represent Valorems approach to data visualization and information delivery solutions and as such must demonstrate proficiency with Power BI and Azure Data Services. This position will require an understanding of how analytics are positioned to meet business objectives, how analytics relates to business and enterprise architectures, and how to implement data visualization solutions through people, process and technology.
Additionally:Strong collaboration skills, works well with ambiguity, works well across roles and groups Ability and willingness to take the initiative to facilitate teamwork and serve the client needs firstAbility to engage directly with the customer and end usersUnderstanding of and familiarity with Agile delivery methodologiesAbility to prioritize and manage time effectivelyAbility to collaborate with other members of the Valorem Reply team, including Project Managers, Software Engineers and Business Analysts
PLACEMENT CRITERIA & REQUIREMENTS:
Minimum Qualifications:3+ years of experience with Microsoft SQL Server (2014/2016/2019) and proficiency in T-SQL 3+years of analytics development and implementation experience3+year of experience with Power BI or competitive technologies3+years of experience with Azure Data Factory, Azure SQL Proficiency in MDX and / or DAX queries Experience in PowerShell scripting Knowledge on Azure Dev ops preferred Bachelor's Degree in Computer Science, Computer Engineering, MIS, or related fieldTechnical Skills:
Requiredo General architecture Being able to interpret business requirements into functional and then technical requirements Understanding of and experience designing and implementing workflow/process-based systems Cloud based data architecture and reporting solutionso Information architecture Data Modeling principles for relational and dimensional data structures Data Warehouse design principles (e.g. Kimball, Inmon) Source to target mapping (ETL, ELT)o Microsoft SQL Server technologies: SQL Server 2014/2016/2019 (SQL, T-SQL, Structure/Index/SQL-Tuning)o Microsoft Azure Azure SQL Azure Data Factory (ADF)o Microsoft Power BI
Desiredo Information architecture Taxonomies, Metadata Management and Master Data Management principles Data Stewardship, Ownership and Quality Management principleso Big Data Technologies Languages: R, Python, Spark, Scala Databricks, MLFlow, Delta Lake HDFS, MapReduce, Pig, Hive Platforms: R Studio, Azure ML Studio, etc.o General DBMS experience RDBMS - Oracle, DB2, MySQL, etc. NoSQL Hbase, Casandra, DataStax, MongoDB, CouchDB, etc. Microsoft Azure Serviceso Microsoft Technologies Azure Data Lake Logic Apps ADO Azure Databricks Power Platform Azure Data explorer or KQLo General Reporting capabilities Power BI (M & DAX), Power Automate, Power Apps Qlik, Cognos, MicroStrategy, Tableau, etc.