Microsoft Ssis

Microsoft Ssis Engineer Jobs

2 jobs found

Today

Sr Data Engineer

Connection Merrimack, NH

Merrimack, NH

Today

$97k - $125k/yr Full time Senior Data Engineer Data Integration

Apply Now

Job Description

This Senior Data Engineer role at Connection focuses on delivering data and application integration across multiple database platforms. The position includes designing, developing, testing, deploying, and supporting data integration and migration solutions, along with technical leadership and on-call production support.

Onsite Location

Merrimack, NH (onsite)

Compensation

USD 97,000 - 125,000 per yearly

Key Responsibilities

Designs and develops data integration and data migration solutions, including documentation for technical specifications, deployment, and support procedure manuals.
Creates database integration solutions covering requirement specifications, impact analysis, functional and technical design, programming, documentation, testing, data conversion, and implementation.
Collaborates with business partners, analysts, and project managers to design and support new or modified database systems.
Provides technical leadership and mentoring to help developers strengthen their skills.
Leads complex production support initiatives and applies long-term solutions as appropriate.
Delivers on-call support for database integration solutions.
Tracks project hours using time management software.
Performs other duties or special projects as assigned.

Required Skills and Qualifications

Strong working knowledge of SQL programming.
Strong working knowledge of SQL Server and/or Oracle relational database systems, including cloud data solutions such as Databricks.
Strong working knowledge of source control applications such as Git or Bitbucket.
Strong working knowledge of multiple data integration tools, including SQL Server Integration Services (SSIS), Databricks Transformation capabilities, and replication engines.
Strong working knowledge of principles and techniques of the application development process.
Strong working knowledge of principles and techniques for system integration and software dependencies.
Strong working knowledge of logical and physical database design concepts.
Basic working knowledge of business intelligence applications such as Microsoft Power BI.
Analyzes functional requirements to design and build technical solutions.
Analyzes data and develops logical solutions to problems.
Establishes development estimates and meets agreed upon target dates, including accurate scope analysis and estimates for large projects.
Conducts knowledge transfer sessions and technical walk-throughs.
Works independently while adhering to company policies and standards.
Interfaces effectively with business partners and co-workers.
Effective verbal and written communication skills.
Flexible ability to manage multiple projects concurrently.

Technologies

SQL
SQL Server
Oracle
Databricks
Git
Bitbucket
SQL Server Integration Services (SSIS)
Databricks Transformation capabilities
Replication engines
Microsoft Power BI

Benefits

401k plans
Medical insurance
Free therapy visits
Mental health coaching and tools
Meditation resources
Generous paid time off package including vacation and sick time
Wellness and Volunteer Time Off days

Additional Eligibility Requirement

Applicants must be authorized to work for any employer in the U.S.

Connection is unable to sponsor or take over sponsorship of an employment visa at this time.

View full job page →

Today

Senior Data Engineer

Wintrust Financial Corporation Rosemont, IL

Rosemont, IL

Today

$161k - $161k/yr Full time Senior Azure DevOps CI/CD

Apply Now

Job Description

Wintrust Financial Corporation is seeking a Senior Data Engineer to design, build, and continuously improve complex data systems and pipelines that support analytics and data science needs. This hybrid role is based in Rosemont, IL, with an expectation to be in the Rosemont office once a week.

In this position, you will focus on end-to-end data enablement, including ETL/ELT development, data modeling, governance practices such as lineage and quality validation, and performance and security of data processing solutions. The role also includes implementing CI/CD pipelines for data workflows using Azure DevOps.

What you’ll do

Design, develop, and continuously improve complex data systems.
Build processes for data transformations and structures, including metadata, dependencies, and workload management.
Ensure data governance policies are followed through implementation and validation of data lineage, quality checks, and classification.
Support, enhance, and create Daily/Monthly ETL/ELT processes to ensure business continuity and deliver high performance with best-in-class standards.
Create enterprise data sets for analytics and data scientist teams to support advanced analytics.
Develop Conceptual/Logical/Physical Data Models for data solutions.
Identify opportunities for continuous process improvement by automating manual steps and optimizing data delivery.
Analyze requirements and prepare technical specifications and detailed level design documents.
Act as a resource for internal and third-party team members on escalated issues and provide analysis and design support for less experienced team members.
Design, develop, test, and implement best-in-class data processing solutions, including data modeling, loading, delivery, availability, performance, and security.
Engage across the data enablement lifecycle and mentor less experienced team members as needed.
Design and build data pipelines that move and transform data for ODS, Staging, Data Warehousing and Data Marts, MDM, including middleware integrations.
Process semi-structured and unstructured files using SQL and modern object-oriented scripting languages such as Python.
Build CI/CD pipelines for data pipelines using Azure DevOps.

Required qualifications

Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, Engineering, Math, or a related field, plus 7 years of experience in a related occupation.
Equivalent alternative: Master’s degree in a related field plus 5 years of experience in a related occupation.
5 years of experience in Data Engineering, designing and implementing data persistence, data processing, and data integration.
5 years of experience designing and building complete data pipelines for ODS, Staging, Data Warehousing, and Data Mart environments.
5 years of experience processing semi-structured and unstructured files using Microsoft SSIS and SQL.
3 years of experience with medium-scale data and query optimization techniques.
Experience with Data Warehouse concepts, including 3NF and dimensional data modeling.
Experience implementing and validating data lineage, quality checks, and classification.
Experience creating, enhancing, and supporting ETL/ELT processes that ensure business continuity, best-in-class standards, and high performance.
Experience analyzing requirements, preparing technical specifications, and producing detailed level design documents.
Experience building CI/CD pipelines for data pipelines using Azure DevOps.

Technologies

Python
SQL
Microsoft SSIS
Azure DevOps

Compensation and benefits

Salary: USD 160,555 per year.
Eligibility to earn an annual bonus.

Location

Rosemont, IL (hybrid)
Some telecommuting flexibility, with a requirement to physically be in the Rosemont, IL office once a week.

View full job page →

Microsoft Ssis Engineer Jobs

Sr Data Engineer

Senior Data Engineer

Get Microsoft Ssis Engineer Jobs alerts