Data Engineer

· Adept at using large data sets to find opportunities for product and process optimization and using models to test the effectiveness of different courses of action

· Advanced SQL development skills, broad exposure to all language constructs

· Experience with Microsoft On-premise SQL Server (2017 or higher) and Azure SQL Server technologies including broad experience with SQL Server capabilities and tools (e.g., CDC, Columnstore Index, In-memory Table, SSAS Tabular, DAX, T-SQL, SSIS)

· Experience in Power BI, Power BI Embedded, Power BI Services, Power BI Gateway, and Power BI Dataflow

· Experience with Azure products and services including Azure Data Lake Gen2, Azure Databricks, Azure Databricks Unity Catalog, Databricks API, Databricks Row-level security, Databricks error logging, Azure SQL Server, and Azure Analysis Services.

· Experience using Azure DevOps and CI/CD as well as Agile tools and processes including Git, Jenkins, Jira, and Confluence

· Experience with data integration through APIs, Web Services, SOAP, and/or REST services

· Experience with Lakehouse architecture and design for multi-tenant, OLTP data modeling, dimensional data modeling, composite modeling, data transformation, row-level security, and designing the most optimal analytical data structures for near real-time data analytics

· Additional programming experience is a plus (preferably.NET) or other languages such as Python, Scala, R.

Education or Prior Work Experience

· Bachelor's degree in CS

· 10+ years of experience with designing and developing complex data analytics solutions

· 5+ years of experience with Microsoft Big Data solutions

Topics will be covered in Interview

• Ten plus years industry experience with at least 5 years working with Azure
• Azure cost modeling
• Experience working with multi-tenant Azure applications
• Advance knowledge of data security and standards
• Data Modeling: Proficiency in designing and implementing data models
• Experience performance tuning
• Data Warehousing: Hands-on experience with data warehousing solutions, particularly in Azure, including performance optimization and cost management.
• Programming Languages: Proficiency in programming languages such as Python and SQL
• ETL/ELT Processes: Strong experience in building and managing ETL/ELT pipelines using Azure Data Factory or similar tools.
• DevOps: Experience with CI/CD pipelines, version control (Git), and infrastructure as code (IaC) using tools like Azure DevOps and Terraform.
• Desired certifications in Azure including Data Engineer Associate, Azure Solutions Architect and other relevant certifications in data engineering and cloud computing