Sr. Data Engineer

About the role

Sr. Data Engineer at Artic Consulting. Hands-on experience building and maintaining OLTP databases, including relational data modeling, schema design, normalization, SQL query development, indexing.

What you'll do

• Hands-on experience building and maintaining OLTP databases, including relational data modeling, schema design, normalization, SQL query development, indexing
• Design, develop, and maintain Power BI reports, dashboards, DAX expressions, KPIs, and scorecards using both Import and DirectQuery modes
• Build and orchestrate scalable ETL/ELT workflows using Fabric Data Pipelines, Dataflows Gen2, and Azure Data Factory
• Write and tune complex T-SQL and KQL queries, stored procedures, and views for performance in Synapse SQL and SQL Server environments
• Implement data models based on star/snowflake schemas and support modern data warehousing and Lakehouse architectures using Microsoft Fabric

What you need

• SQL
• ETL
• Spark
• Power BI
• Azure
• Machine learning
• M.Sc or B.Tech or B.E. or B.Sc or BCA or M.Tech or MCA

Good to have

• DAX
• Python
• Data warehousing
• Data modelling
• Azure Data Factory
• LLMs