Offer summary

Qualifications:

5+ years of experience in database development, ETL, and BI solutions., Strong expertise in SSIS, SQL Server, T-SQL, and stored procedures., Hands-on experience in Power BI with DAX and Power Query., Knowledge of data warehousing concepts and familiarity with Azure Data Factory is a plus..

Key responsibilities:

Design, develop, and deploy SSIS packages for ETL processes.

Create and optimize SQL queries and stored procedures for performance.

Develop interactive Power BI dashboards and ensure data accuracy.

Maintain SQL Server databases and automate repetitive tasks.

Job description

This is a remote position.

Overview :

We are seeking an experienced Database Technology Specialist with strong expertise in SQL Server Integration Services (SSIS) packaging, ETL processes, and Power BI report development. The ideal candidate will design, develop, and optimize data integration solutions, create insightful dashboards, and ensure efficient data workflows to support business intelligence initiatives.

Key Responsibilities:

ETL & Data Integration:

Design, develop, and deploy SSIS packages for efficient data extraction, transformation, and loading (ETL).
Optimize SQL queries, stored procedures, and data workflows for performance and scalability.
Troubleshoot and resolve data integration issues.

Power BI Development:

Develop interactive Power BI dashboards and reports with DAX, Power Query, and advanced visualizations.
Connect to multiple data sources (SQL Server, APIs, flat files) and implement data modeling best practices.
Ensure data accuracy, security, and compliance with business requirements.

Database Management:

Maintain and optimize SQL Server databases, including indexing, partitioning, and performance tuning.
Collaborate with stakeholders to understand data needs and deliver scalable solutions.

Automation & Documentation:

Automate repetitive tasks using SQL Server Agent, PowerShell, or other scripting tools.
Document technical specifications, data mappings, and deployment processes.

Requirements

Required Skills & Experience:

5+ years of experience in database development, ETL, and BI solutions.
Strong expertise in SSIS, SQL Server, T-SQL, and stored procedures.
Hands-on experience in Power BI (DAX, Power Query, data modeling).
Knowledge of data warehousing concepts (star schema, slowly changing dimensions).
Familiarity with Azure Data Factory, Synapse, or other cloud data tools (a plus).
Strong analytical and problem-solving skills.

Benefits

Diversity Inclusion:

At Exavalu, we are committed to building a diverse and inclusive workforce. We welcome applications for employment from all qualified candidates, regardless of race, color, gender, national or ethnic origin, age, disability, religion, sexual orientation, gender identity or any other status protected by applicable law. We nurture a culture that embraces all individuals and promotes diverse perspectives, where you can make an impact and grow your career.

Exavalu also promotes flexibility depending on the needs of employees, customers and the business. It might be part-time work, working outside normal 9-5 business hours or working remotely.. We also have a welcome back program to help people get back to mainstream after a long break due to health or family reasons.

Required profile