Motion Recruitment
SQL Server Lead / Azure Cloud / Big Data Engineer
Motion Recruitment, Charlotte, North Carolina, United States, 28245
Outstanding long-term contract opportunity! A well-known Financial Services Company is looking for a Lead Engineer in Charlotte, NC (Hybrid).
Work with the brightest minds at one of the largest financial institutions in the world. This is 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 is not only a household name, but also truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.
Contract Duration: 12+ Months
Required Skills & ExperienceStrong 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 SynapseExperience in Synapse Integration runtimes, Linked Services, Serverless SQL Pool, Spark PoolExperience in Synapse Triggers and Pipeline MonitoringExperience in Synapse pipeline activities and notebooks (Pyspark, Spark SQL)Experience in Lake Database, Delta Lake, Medallion architectureThis 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 Teradata3 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 Kafka3 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 softwareOperating systems installation and configuration procedures; organization's operational environmentSoftware design principles, methods and approaches; principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems componentsPertinent government regulations; infrastructure requirements, such as bandwidth and server sizingDatabase management principles and methodologies, including data structures, data modeling, data warehousing and transaction processingFunctionality and operability of the current operating environment; systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainabilityOptimization concepts and methods; establish and maintain cooperative working relationships with those contacted in the course of the workSpeak and write effectively and prepare effective reports
You will receive the following benefits:
Medical Insurance - Four medical plans to choose from for you and your familyDental & Orthodontia BenefitsVision BenefitsHealth Savings Account (HSA)Health and Dependent Care Flexible Spending AccountsVoluntary Life Insurance, Long-Term & Short-Term Disability InsuranceHospital Indemnity Insurance401(k) including match with pre and post-tax optionsPaid Sick Time LeaveLegal and Identity Protection PlansPre-tax Commuter Benefit529 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.
Posted by:
Chris Clark
Specialization:
Data Engineering
Work with the brightest minds at one of the largest financial institutions in the world. This is 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 is not only a household name, but also truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.
Contract Duration: 12+ Months
Required Skills & ExperienceStrong 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 SynapseExperience in Synapse Integration runtimes, Linked Services, Serverless SQL Pool, Spark PoolExperience in Synapse Triggers and Pipeline MonitoringExperience in Synapse pipeline activities and notebooks (Pyspark, Spark SQL)Experience in Lake Database, Delta Lake, Medallion architectureThis 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 Teradata3 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 Kafka3 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 softwareOperating systems installation and configuration procedures; organization's operational environmentSoftware design principles, methods and approaches; principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems componentsPertinent government regulations; infrastructure requirements, such as bandwidth and server sizingDatabase management principles and methodologies, including data structures, data modeling, data warehousing and transaction processingFunctionality and operability of the current operating environment; systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainabilityOptimization concepts and methods; establish and maintain cooperative working relationships with those contacted in the course of the workSpeak and write effectively and prepare effective reports
You will receive the following benefits:
Medical Insurance - Four medical plans to choose from for you and your familyDental & Orthodontia BenefitsVision BenefitsHealth Savings Account (HSA)Health and Dependent Care Flexible Spending AccountsVoluntary Life Insurance, Long-Term & Short-Term Disability InsuranceHospital Indemnity Insurance401(k) including match with pre and post-tax optionsPaid Sick Time LeaveLegal and Identity Protection PlansPre-tax Commuter Benefit529 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.
Posted by:
Chris Clark
Specialization:
Data Engineering