Data Engineer II

Valorem Reply, part of Reply Ltd., is a business innovation firm made up of talented and intelligent people from around the world who love to solve modern business problems with custom Microsoft Cloud solutions. We work with bleeding-edge technology, wellknown clients and a diverse workforce to push the boundaries of technology and innovation and drive real-world impact for our customers and communities.
Data Engineer with experience building and contributing to the design of database systems, both normalized transactional systems and dimensional reporting systems. Strong experience with SQL Server as a database engine, as well as Microsoft and Open-Source technology experience implementing Big Data with Advanced Analytics solutions. 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 Data Engineer will work with customers to deliver solutions utilizing strong business, technical and data modelling skills. This position will 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. 

Key Responsibilities:

• Design and implement general architecture for complex data systems.
• Translate business requirements into functional and technical specifications.
• Design and implement workflow and process-based systems.
• Develop and manage cloud-based data architecture and reporting solutions.
• Create and manage information architecture strategies.
• Apply data modelling principles for relational and dimensional data structures.
• Design Data Warehouses following established principles (e.g., Kimball, Inmon).
• Create and manage source-to-target mappings for ETL/ELT processes

Minimum Qualifications

• Bachelor’s Degree in Computer Science, Computer Engineering, MIS, or related field.
• 5+ years of experience with Microsoft SQL Server and strong proficiency in TSQL.
• 5+ years of experience in consulting, with a focus on analytics and data solutions.
• 5+ years of experience in analytics development and implementation.
• 5+ years of experience with Power BI or other competitive technologies.
• 3+ years of experience with Azure Data Factory, and Azure SQL.
• Proficiency in MDX and/or DAX queries.
• Experience with open-source or dedicated analytics tools. o Expertise in Microsoft SQL Server technologies, including T-SQL, SQL performance tuning (Indexing, Structure, Query Optimization).
• Expertise in Microsoft Azure services, such as: o Azure SQL and Azure Data Factory (ADF) o Azure Data Warehouse (Synapse Analytics) o Azure Data Lake, Stream Analytics, and SQL Data Warehouse

Preferred Qualifications:

• Strong understanding of information architecture principles.
• Knowledge of taxonomies, metadata management, and master data management.
• Experience with Python and/or R for analytics and data manipulation.
• Familiarity with data stewardship, ownership, and data quality management.
• Expertise in Big Data technologies and tools: o Programming Languages: R, Python, PySpark, Scala. o Big Data Platforms: HDFS, MapReduce, Pig, Hive. o General DBMS experience with Oracle, DB2, MySQL, etc. o NoSQL databases such as HBase, Cassandra, DataStax, MongoDB, CouchDB, etc.
• Familiarity with Microsoft Azure Services: o Azure Data Lake, Logic Apps, Azure DevOps (ADO), Azure Databricks, Power Platform, Microsoft Fabric.
• Experience with reporting and BI tools: o Power BI (M, DAX), Power Automate, Power Apps, Qlik, Cognos, MicroStrategy, Tableau, etc.

Reply specializes in the design and implementation of solutions based on new communication channels and digital media. Reply is a network of highly specialized companies supporting global industrial groups operating in the telecom and media, industry and services, banking, insurance and public administration sectors in the definition and development of business models enabled for the new paradigms of AI, cloud computing, digital media and the Internet of Things. Reply services include Consulting, System Integration and Digital Services