Overview
Valorem Reply is looking for a Data Engineer with experience building and contributing to the design of database systems, both normalized transactional systems and dimensional repo
Full job description
Valorem Reply is looking for a 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 Databricks 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 represent Valorem's approach to data visualization and information delivery solutions and as such must demonstrate proficiency with Power BI and Azure Data Services.
Design and implement general architecture for complex data systems.
Translate business requirements into functional and technical specifications.
Design and implement lakehouse architecture.
Develop and manage cloud-based data architecture and reporting solutions.
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.
Mentor junior engineers and contribute to architectural decisions and code reviews.
Bachelor’s degree in computer science, Computer Engineering, MIS, or related field.
5+years of experience with Microsoft SQL Server and strong proficiency in T- SQL, SQL performance tuning (Indexing, Structure, Query Optimization).
5+years of experience in Microsoft data platform development and implementation.
5+years of experience with PowerBI or other competitive technologies.
3+years of experience in consulting, with a focus on analytics and data solutions.
2+ years of experience with Databricks, including Unity Catalog, Databricks SQL, Workflows, and Delta Sharing.
Proficiency in Python and Apache Spark.
Develop and manage Databricks notebooks for data transformation, exploration, and model deployment.
Expertise in Microsoft Azure services, including Azure SQL, Azure Data Factory (ADF), Azure Data Warehouse (Synapse Analytics), Azure Data Lake, and Stream Analytics
Experience with Microsoft Fabric.
Familiarity with CI/CD pipelines and infrastructure-as-code tools like Terraform or Azure Resource Manager (ARM).
Knowledge of taxonomies, metadata management, and masterdata management.
Familiarity with data stewardship, ownership, and data quality management.
Expertise in Big Data technologies and tools:
o BigData Platforms: HDFS, MapReduce, Pig, Hive.
o General DBMS experience with Oracle, DB2, MySQL, etc.
o No SQL databases such as HBase, Cassandra, DataStax, MongoDB, CouchDB, etc.
o Experience with non-Microsoft reporting and BI tools, such as Qlik, Cognos, MicroStrategy, Tableau, etc.
Tips for this job
Practical Job and Scholarship guidance. These tips do not replace official rules or create new eligibility requirements.
- Tailor the CV and application to the responsibilities and required skills stated on the official employer page.
- Use concrete evidence of relevant work, projects and measurable results rather than generic claims.
- Confirm location, work authorization, remote restrictions and sponsorship terms before applying.
- Apply through the original employer or official recruitment destination shown on this page.
Verification notes
laptop-ats-crawler v2
Job and Scholarship is the discovery and verification layer. Confirm eligibility, dates, salary/funding and application instructions on the original source before submitting anything.
Reply (lever) ↗Browse current Job and Scholarship listings from Reply (lever) →
