"Alerted.org

We are looking for a skilled SSIS/T-SQL Developer with good experience (7+ years) to join our dynamic team. The ideal candidate will be responsible for developing, deploying, and maintaining SSIS packages, as well as writing and optimizing T-SQL queries, stored procedures, and functions. The role involves working closely with stakeholders to understand data requirements and deliver high-quality data solutions.

Key Responsibilities:

+ Design, develop, and deploy SSIS packages to extract, transform, and load (ETL) data from various sources into target databases.

+ Write complex SQL queries, stored procedures, views, and functions to support application development and reporting requirements.

+ Optimize existing SQL queries for performance improvements and troubleshoot any data-related issues.

+ Collaborate with business analysts and other developers to understand data needs and deliver appropriate solutions.

+ Perform data analysis to identify trends, discrepancies, and areas for improvement.

+ Maintain documentation of database designs, ETL processes, and data models.

+ Implement best practices for database design, development, and maintenance.

+ Ensure data quality, integrity, and security across all databases and ETL processes.

+ Participate in code reviews and provide constructive feedback to other developers.

+ Assist in the design and development of data warehouses and data marts.

+ Monitor and maintain data integration processes to ensure consistent and reliable data flow.

+ Provide production support for data-related issues and troubleshoot as necessary.

Required Experience:

+ SQL Server:

+ SQL Server Management Studio (SSMS): Proficiency in querying, managing, and troubleshooting databases.

+ T-SQL: skills in Transact-SQL for creating queries, stored procedures, triggers, and functions.

+ SQL Server Integration Services (SSIS):

+ Knowledge of ETL (Extract, Transform, Load) processes using SSIS.

+ Knowledge in creating packages for data migration, data cleansing, and transformations.

+ Familiarity with different data sources, such as flat files and databases.

+ SQL Server Reporting Services (SSRS):

+ Designing, developing, and deploying reports using SSRS.

+ Understanding of report parameters, dynamic reports, and using expressions.

+ Familiarity with report deployment, security, and performance optimization.

+ ETL Concepts:

+ Strong understanding of ETL processes, data integration, and transformation logic.

+ Ability to optimize ETL processes for large datasets if needed.

+ Data Modeling: Understanding data models for BI/ETL solutions, including normalization and denormalization, star schema and snowflake schema.

+ Scripting and Automation:

+ Scripting knowledge for automation (PowerShell, batch scripting, or SQL scripts).

+ Understanding of how to automate ETL jobs, report generation, and data processing.

+ Performance Tuning and Optimization:

+ Knowledge of performance tuning techniques for SQL queries, SSRS reports, and SSIS packages.

+ Understanding indexing, query optimization, and using execution plans.

+ Version Control: Familiarity with version control systems like Git, Team Foundation Server (TFS), or Azure DevOps.

+ Experience in Azure and Scrum boards would be required

+ Optional: Power BI:

+ Knowledge of creating interactive dashboards and reports.

+ Experience connecting Power BI to various data sources (SQL, Excel, etc.).

+ Understanding of data transformations in Power Query.

+ Expertise in DAX (Data Analysis Expressions) for calculations and analysis.

Soft Skills:

+ Excellent problem-solving and analytical skills.

+ Strong communication skills and the ability to work effectively with cross-functional teams.

+ Attention to detail and a commitment to producing high-quality work

#LI-SB1 #LI-Remote

What Makes HTC A Great Place To Build Your Future

HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you’ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You’ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.

At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.

Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.