SQL Server Lead

1 week ago

Charlotte, North Carolina, United States Motion Recruitment Full time
Outstanding Long-Term Contract Opportunity

A well-known Financial Services Company is seeking a Lead Engineer in Charlotte, NC (Hybrid).

Work with the brightest minds at one of the largest financial institutions in the world.

This is a long-term contract opportunity that includes a competitive benefit package.

Our client has been around for over 150 years and is continuously innovating in today's digital age.

If you want to work for a company that truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.

Key Responsibilities:
  • Design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis.
  • Expert in data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouse.
  • Proficient with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses.
  • Experience in Azure Storage Containers, Key Vault, Log Analytics, and Synapse.
  • Experience in Synapse Integration runtimes, Linked Services, Serverless SQL Pool, Spark Pool.
  • Experience in Synapse Triggers and Pipeline Monitoring.
  • Experience in Synapse pipeline activities and notebooks (Pyspark, Spark SQL).
  • Experience in Lake Database, Delta Lake, Medallion architecture.
Requirements:
  • Minimum of seven (7) years of experience in electronic data processing systems study, design, and programming.
  • At least four (4) years of that experience must have been in a lead capacity.
  • 3 years of experience in the past 4 years in working with SQL database architecture, data modeling, normalization, and performance optimization.
  • 3 years of experience in the past 4 years in working with Microsoft Azure Cloud platform, including familiarity with other Azure services like Azure Data Lake Storage, Azure Databricks, Azure Data Factory, and Azure DevOps.
  • 3 years of experience in the past 4 years in working with designing and developing data warehouses using other platforms like Microsoft SQL Server, Oracle, or Teradata.
  • 3 years of experience in the past 4 years in working with big data technologies such as Apache Hadoop, Apache Spark, or Apache Kafka.
  • 3 years of experience in the past 4 years in working with data visualization tools like Power BI to create insightful visualizations and reports based on data stored in Synapse Data Warehouse.
  • 3 years of experience in the past 4 years in working with data cleansing, data profiling, and data validation techniques to ensure high data integrity in the data warehouse.
What You Will Be Doing:

The Lead Engineer will possess knowledge and experience in applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software.

Operating systems installation and configuration procedures; organization's operational environment.

Software design principles, methods and approaches; principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components.

Pertinent government regulations; infrastructure requirements, such as bandwidth and server sizing.

Database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing.

Functionality and operability of the current operating environment; systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainability.

Optimization concepts and methods; establish and maintain cooperative working relationships with those contacted in the course of the work.

Speak and write effectively and prepare effective reports.

Benefits:
  • Medical Insurance - Four medical plans to choose from for you and your family.
  • Dental & Orthodontia Benefits.
  • Vision Benefits.
  • Health Savings Account (HSA).
  • Health and Dependent Care Flexible Spending Accounts.
  • Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance.
  • Hospital Indemnity Insurance.
  • 401(k) including match with pre and post-tax options.
  • Paid Sick Time Leave.
  • Legal and Identity Protection Plans.
  • Pre-tax Commuter Benefit.
  • 529 College Saver Plan.

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer, including Veterans/Disability/Women.

All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available.

Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP's Employment Accommodation policy. Applicants need to make their needs known in advance.

  • SQL Server Lead

    5 days ago

    Charlotte, North Carolina, United States Motion Recruitment Partners LLC Full time

    Job Title: SQL Server LeadAbout the Role: We are seeking a highly skilled SQL Server Lead to join our team at Motion Recruitment Partners LLC. As a SQL Server Lead, you will be responsible for designing, developing, and implementing data warehouse solutions using Microsoft SQL Server and Azure Cloud platform.Key Responsibilities: Design and develop data...

  • SQL Server Lead

    4 days ago

    Charlotte, North Carolina, United States Motion Recruitment Partners LLC Full time

    Job Title: SQL Server LeadAbout the Role:We are seeking a highly skilled SQL Server Lead to join our team at Motion Recruitment Partners LLC. As a key member of our engineering team, you will be responsible for designing, developing, and implementing data warehouse solutions using Microsoft SQL Server and Azure Cloud platform.Key Responsibilities:• Design...

  • SQL Server Lead

    2 weeks ago

    Charlotte, North Carolina, United States Motion Recruitment Partners LLC Full time

    Job Title: SQL Server LeadWe are seeking a highly skilled SQL Server Lead to join our team at Motion Recruitment Partners LLC. As a key member of our data engineering team, you will be responsible for designing, developing, and implementing data warehouse solutions using SQL Server and Azure Cloud technologies.Job Summary:The SQL Server Lead will possess a...

  • SQL Server Lead

    2 weeks ago

    Charlotte, North Carolina, United States Motion Recruitment Full time

    Job Title: SQL Server LeadWe are seeking a highly skilled SQL Server Lead to join our team at Motion Recruitment. As a key member of our team, you will be responsible for leading the design, development, and implementation of complex database solutions using SQL Server and Azure Cloud technologies.Key Responsibilities:Design and develop scalable and...

  • SQL Server Developer

    2 weeks ago

    Charlotte, North Carolina, United States PDSSOFT INC. Full time

    Job Title: SQL Server DeveloperWe are seeking a skilled SQL Server Developer to join our team at PDSSOFT INC.Key Responsibilities:Design, develop, and deploy ETL processes using Microsoft SSISManage and maintain Microsoft SQL databases, ensuring optimal performance and data integrityDevelop and implement data analytics solutions using SQL Server 2008 and...

  • SQL Server Database Administrator

    5 days ago

    Charlotte, North Carolina, United States Vaco Full time

    Job SummaryWe are seeking a highly skilled SQL Server Database Administrator to join our team at Vaco. As a key member of our IT department, you will be responsible for managing and monitoring enterprise-level database systems, ensuring optimal availability and functionality.Key Responsibilities: Oversee database performance, error detection, and backup...

  • SQL Server Database Administrator

    4 days ago

    Charlotte, North Carolina, United States LTI Mindtree Full time

    About LTIMindtree:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies.As a digital transformation partner to more than 700 clients, LTIMindtree brings extensive domain and technology expertise to help...

  • Senior Microsoft SQL Server Developer

    1 week ago

    Charlotte, North Carolina, United States PDSSOFT INC. Full time

    Job Title: Senior Microsoft SQL Server DeveloperJob Summary:We are seeking a highly skilled Senior Microsoft SQL Server Developer to join our team at PDSSOFT INC. The ideal candidate will have extensive experience with Microsoft SQL databases, SSIS development, and data analytics.Key Responsibilities:Design, develop, and deploy ETL processes using Microsoft...

  • Microsoft SQL Server Developer

    1 month ago

    Charlotte, North Carolina, United States BI-Tek LLC Full time

    BI-Tek LLC is seeking a skilled Microsoft SQL Server developer to join our team. As a key member of our development team, you will be responsible for designing, implementing, and maintaining complex database solutions using Microsoft SQL Server 2012/2014/2016/2019/2022. Your expertise will be crucial in creating and modifying stored procedures, importing and...

  • Microsoft SQL Server Developer

    1 month ago

    Charlotte, North Carolina, United States BI-Tek LLC Full time

    BI-Tek LLC is seeking a skilled Microsoft SQL Server developer to join our team. As a key member of our development team, you will be responsible for designing, implementing, and maintaining complex database solutions using Microsoft SQL Server 2012/2014/2016/2019/2022. Your expertise will be essential in creating and modifying stored procedures, importing...

  • Microsoft SQL Server Developer

    4 weeks ago

    Charlotte, North Carolina, United States BI-Tek LLC Full time

    Job Title: Microsoft SQL DeveloperWe are seeking a skilled Microsoft SQL Server developer to join our team at BI-Tek LLC. As a key member of our development team, you will be responsible for designing, implementing, and maintaining complex database systems using Microsoft SQL Server.Key Responsibilities:Create and modify complex stored procedures to optimize...

  • Microsoft SQL Server Developer

    3 weeks ago

    Charlotte, North Carolina, United States BI-TEK LLC Full time

    Job OpportunityBI-Tek LLC is seeking a skilled Microsoft SQL Server developer to join our team in Charlotte, North Carolina.Key ResponsibilitiesCreate and modify complex stored proceduresImport and export data using MS SQLRespond to internal staff to troubleshoot bugs and performance issuesDevelop database objects such as tables, views, and stored...

  • SQL Server Administrator/UAM Application Support Specialist

    2 weeks ago

    Charlotte, North Carolina, United States Triunity Software Full time

    Job Title: SQL Server Administrator/UAM Application SupportWe are seeking a highly skilled SQL Server Administrator to join our team at Triunity Software. As a key member of our IT team, you will be responsible for ensuring the smooth operation of our SQL Server infrastructure and providing top-notch support for our UAM application.About UsTriunity Software...

  • SQL Database Administrator

    1 week ago

    Charlotte, North Carolina, United States Vaco Full time

    Job SummaryVaco is seeking a skilled SQL Database Administrator to manage and monitor enterprise-level database systems. This role involves maintaining current databases, deploying new ones, troubleshooting issues in production and non-production environments, and supporting both internal and external projects while aligning with team objectives.Key...

  • SQL Server Administrator/UAM Application Support Expert

    5 days ago

    Charlotte, North Carolina, United States Triunity Software Full time

    About the Role:As a SQL Server Administrator/UAM Application Support professional at Triunity Software, you will be responsible for proficiently managing MS SQL Server Administration and providing excellent communication skills to our clients. Our goal is to develop a long-term partnership with businesses and help them get a competitive advantage by...

  • Senior SQL Database Administrator

    3 weeks ago

    Charlotte, North Carolina, United States Insight Global Full time

    Job Title: Senior SQL DBAWe are seeking a highly skilled Senior SQL DBA to join our team at Insight Global. As a key member of our database team, you will be responsible for designing, implementing, and maintaining large-scale SQL Server databases in Azure.Key Responsibilities:Design and implement high-performance SQL Server databases in AzureDevelop and...

  • MS SQL Developer

    2 weeks ago

    Charlotte, North Carolina, United States Strategic Staffing Solutions Full time

    Job SummaryWe are seeking a highly skilled MS SQL Engineer to join our team at Strategic Staffing Solutions. As a key member of our development team, you will be responsible for designing and implementing database solutions using MS SQL server and .NET Core technologies.Key ResponsibilitiesDesign and develop database solutions using MS SQL server and .NET...

  • SQL Developer

    2 weeks ago

    Charlotte, North Carolina, United States Innova Solutions Full time

    Job Title: SSIS DeveloperInnova Solutions is seeking a skilled SSIS Developer to join our team. As a key member of our data integration team, you will be responsible for designing, developing, and implementing complex data integration solutions using Microsoft SQL Server Integration Services (SSIS).Key Responsibilities:Design and develop SSIS packages to...

  • Senior Hadoop Developer with Java and SQL Expertise

    1 week ago

    Charlotte, North Carolina, United States raag solutions Full time

    Job Requirements:As a Senior Hadoop Developer with Java and SQL expertise, you will be responsible for designing, building, and testing large-scale data processing systems using Hadoop and SQL. You will work with multiple database platforms, including SQL Server, Oracle, and Exadata, and have a strong understanding of data warehousing concepts and Spark. Key...

  • Power BI/SQL Developer

    4 weeks ago

    Charlotte, North Carolina, United States Apex Systems Full time

    Job SummaryThis developer will be part of a team focused on supporting and enhancing proprietary in-house and 3rd-party applications and data processes. The ideal candidate will have a strong understanding of.NET, SQL Server, and PowerBI, with excellent analytical and problem-solving skills.The developer will work closely with business partners throughout...