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 Valorem’s sales, service delivery and account management organizations in service to Valorem’s customers.
This position will represent Valorem’s 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.
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 first
Ability to engage directly with the customer and end users
Understanding of and familiarity with Agile delivery methodologies
Ability to prioritize and manage time effectively
Ability to collaborate with other members of the Valorem Reply team, including Project Managers, Software Engineers and Business Analysts
PLACEMENT CRITERIA & REQUIREMENTS:
· 3+ years of experience with Microsoft SQL Server (2014/2016/2019) and proficiency in T-SQL
· 3+years of analytics development and implementation experience
· 3+year of experience with Power BI or competitive technologies
· 3+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 field
o 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 solutions
o 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
o Information architecture
§ Taxonomies, Metadata Management and Master Data Management principles
§ Data Stewardship, Ownership and Quality Management principles
o 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 Services
o Microsoft Technologies
§ Azure Data Lake
§ Logic Apps
§ Azure Databricks
§ Power Platform
§ Azure Data explorer or KQL
o General Reporting capabilities
§ Power BI (M & DAX), Power Automate, Power Apps
§ Qlik, Cognos, MicroStrategy, Tableau, etc.