Sr. Data Engineer
AhmedabadFull-timeSenior levelPosted 1 week ago
Senior data science role at Artic Consulting in Ahmedabad. Needs an M.Sc, B.Tech or B.E..
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
Good to have
- DAX
- Python
- Data warehousing
- Data modelling
- Azure Data Factory
- LLMs