Snr SQL Developer

Bengaluru, Karnataka, India🕖 10 months ago

This is a remote position.Work Experience : 5 to 8 YearsWork Timings : India Shift

Spektra Systems is seeking software developers who possess a passion for solving problems and for emerging technologies. This is a technical role responsible for designing, maintaining, and ensuring accuracy of reports built from various data sources. You’ll have an opportunity to work on the latest and greatest technologies such as Cloud, and many more.As a Developer, you are expected to work independently on application development with high-level guidance/instructions from the lead architect. You will be part of Spektra's flagship products engineering team.

Responsibilities:Review and fine-tune the existing database architecture.Design a new schema to hold data for the product that is evolving every day.Keep a tab on the performance of the SQL queries used in the application.Ability to create monitoring tasks for effective management of the storage and for enhancing the performance of the application and any other reports that rely on the data.Understand fundamentals of data preparation/data modelling necessary for the visualization purpose.Capture reporting requirements from various stakeholders, architect the solution/report, understand/analyze the source data and deliver the reports in timely manner.Create Data Sets and Data models to build intelligence upon.Strong expertise in designing intuitive and interactive reports/dashboards using Power BI for data driven decisions.Develop and own various integration tools and data points.Extract, Transform and Load data from multiple systems for reporting into BI platform.Work closely with the Project manager to deliver on business requirements OTIF (on time in full)Understand the cross-functional business data points thoroughly and be SPOC for all data-related queries.

RequirementsStrong at SQLStrong experience in Data and Data warehouse modeling techniques and SQL queries.A good understanding of designing, developing, deploying, and maintaining Power BI report solutions.Ability to create KPIs, visualizations, reports, and dashboards based on business requirements.Knowledge and experience in prototyping, designing, and requirement analysis.Be able to implement row-level security on data and understand application security layer models in Power BIProficiency in making DAX queries in Power BI desktop.Expertise in using advanced-level calculations on data sets.

Technical SkillsStrong Knowledge in developing SQL Queries.Strong knowledge in SQL database & and SQL DW.

Additional skills:

Good knowledge of DWH concepts.Knowledge in Power BI (DAX + Power Query + Power BI Service + Power BI Desktop Visualizations)Implementing Access Control and impose required Security.

IndustryIT Services and IT ConsultingEmployment TypeFull-time

Key Skills

Spektra Systems

Related Jobs

Canonical - Jobs

Security Engineer Ubuntu

Hamburg, Hamburg, Germany💰 USD70K - USD120K🕖 2 years ago
LimeSurvey

Senior Software Engineer

EUROPE💰 USD50K - USD80K🕖 2 years ago
Covariant

Test Automation Engineer

Berkeley, CA💰 USD60K - USD100K🕖 2 years ago
Plenty of Fish

Senior Android Engineer

🌏 Worldwide💰 USD60K - USD120K🕖 2 years ago
LeadSimple

Lead Software Engineer

🌏 Worldwide💰 USD120K - USD140K🕖 2 years ago
Iterative

Senior Frontend Engineer

🌏 Worldwide💰 USD50K - USD180K🕖 2 years ago
Wander

Data Engineer

🌏 Worldwide💰 USD10K - USD100K🕖 2 years ago
Covariant

Production Engineer

United States💰 USD60K - USD100K🕖 2 years ago
Commit

Senior Back End Developer

Canada💰 USD110K - USD140K🕖 2 years ago
AON3D

Senior Frontend Engineer Platform

Montreal, Qc or Remote USA or Canada💰 USD60K - USD120K🕖 2 years ago
Philo

IT Engineer

San Francisco, California, United States💰 USD70K - USD120K🕖 2 years ago
Canonical - Jobs

Senior Software Engineer Cloud Images

Syracuse, New York, United States💰 USD70K - USD120K🕖 2 years ago
Levity AI

Senior Product Designer

🌏 Worldwide💰 USD60K - USD70K🕖 2 years ago
Clevertech

Hands On Engineering Manager

🌏 Worldwide💰 USD50K - USD130K🕖 2 years ago
SOCi

Full Stack Software Engineer

🌏 Worldwide💰 USD100K - USD140K🕖 2 years ago
Zuplo

Senior Front End Developer

🌏 Worldwide💰 USD80K - USD150K🕖 2 years ago
Tettra

Customer Success Manager

🇺🇸 Remote US💰 USD60K - USD100K🕖 2 years ago
Angi

Senior Software Engineer .NET Core

San Francisco, California, United States💰 USD65K - USD120K🕖 2 years ago
Ethereum

Front End TypeScript Developer

Remote💰 USD60K - USD120K🕖 2 years ago
Toptal

Senior UX UI Designer

🌏 Worldwide💰 USD50K - USD300K🕖 2 years ago