SQL Server Lead

3 weeks ago

Charlotte, United States Motion Recruitment Full time

SQL Server Lead / Azure Cloud / Big Data Engineer

Duration: 12+ Months (W2 Contract only)

Location: Charlotte, NC or Minneapolis, MN


Description:

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; and speak and write effectively and prepare effective reports.


Required Skills & Experience:


  • This classification must have a 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 years of experience in 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


  • Strong understanding of relational database concepts, SQL (Structured Query Language), and data modeling. Knowledge of various databases used in data warehousing, such as Oracle, SQL Server, PostgreSQL, or MySQL.
  • Proficiency in ETL tools like Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to extract data from various sources, transform it to fit the target schema, and load it into the data warehouse.
  • Ability to 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.
  • Expert on data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flow.
  • Proficient with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses.
  • Proficient in scripting languages like Python, Perl, or Shell scripting for automating ETL processes and data manipulation.
  • Understanding of data security principles and compliance regulations to protect sensitive information in the data warehouse.
  • Skills in optimizing data warehouse performance, including query optimization, index creation, and partitioning.
  • 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

  • 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 Lead

    1 week ago

    Charlotte, North Carolina, United States Motion Recruitment Full time

    Outstanding Long-Term Contract OpportunityA 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...

  • 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/SSIS Lead Developer

    3 weeks ago

    Charlotte, United States Aloden, Inc. Full time

    SQL/SSIS Lead Developer,Only W2 (Citizen, GC, GC EAD and H4EAD) Location: Charlotte, NC (Preference given to local candidates) Work Arrangement: Hybrid (3 days onsite, 2 days remote) Role: We are seeking a hands-on SQL/SSIS Lead Developer to join our team. This role involves actively developing and maintaining SQL Server-based integrations. The ideal...

  • 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...

  • SQL Server Lead

    3 weeks ago

    Charlotte, United States Motion Recruitment Full time

    SQL Server Lead / Azure Cloud / Big Data EngineerDuration: 12+ Months (W2 Contract only)Location: Charlotte, NC or Minneapolis, MNDescription: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...

  • SQL Server Integration Consultant

    3 weeks ago

    Charlotte, United States Aitek Group Full time

    ------------------------------------------------------------------------------Hiring ****SQL Server Integration Consultant **** Need to work on our W2---------------------------------------------------------------------------------Proficiency in ETL tools such as Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to...

  • SQL Server Integration Consultant

    3 weeks ago

    Charlotte, United States Aitek Group Full time

    ------------------------------------------------------------------------------Hiring ****SQL Server Integration Consultant **** Need to work on our W2---------------------------------------------------------------------------------Proficiency in ETL tools such as Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to...

  • 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...