Software Engineer 4 - Contingent - Apex Systems

Job#: 2049605

Job Description:

Job Description: In this contingent resource assignment, you may: Consult on complex initiatives with broad impact and large-scale planning for Software Engineering. Review and analyze complex multi-faceted, larger scale or longer-term Software Engineering challenges that require in-depth evaluation of multiple factors including intangibles or unprecedented factors. Contribute to the resolution of complex and multi-faceted situations requiring solid understanding of the function, policies, procedures, and compliance requirements that meet deliverables. Strategically collaborate and consult with client personnel. Required Qualifications: 5+ years of Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work or consulting experience, training, military experience, education.
Skills: ENTIRE TEAM IS OOO LAST 2 WEEKS OF THE YEAR INCLUDING CONTRACTORS - PLEASE MAKE SURE THEY ARE AWARE PRIOR TO SUBMISSIONJob 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.Skills:1. 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.2. 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.3. Ability to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis.4. Expert in data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouse.5. Expert on data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flow.6. Proficient with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses.7. Proficient in scripting languages like Python, Perl, or Shell scripting for automating ETL processes and data manipulation.8. Understanding of data security principles and compliance regulations to protect sensitive information in the data warehouse.9. Skills in optimizing data warehouse performance, including query optimization, index creation, and partitioning.10. Experience in Azure Storage Containers, Key Vault, Log Analytics, and Synapse11. Experience in Synapse Integration runtimes, Linked Services, Serverless SQL Pool, Spark Pool12. Experience in Synapse Triggers and Pipeline Monitoring13. Experience in Synapse pipeline activities and notebooks (Pyspark, Spark SQL)14. Experience in Lake Database, Delta Lake, Medallion architectureWork Experience Required: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.1) 3 years of experience in the past 4 years in working with SQL database architecture, data modeling, normalization, and performance optimization.2) 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) 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 Teradata4) 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 Kafka5) 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.6) 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.
Additional Skills: ENTIRE TEAM IS OOO LAST 2 WEEKS OF THE YEAR INCLUDING CONTRACTORS - PLEASE MAKE SURE THEY ARE AWARE PRIOR TO SUBMISSIONJob 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.Skills:1. 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.2. 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.3. Ability to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis.4. Expert in data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouse.5. Expert on data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flow.6. Proficient with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses.7. Proficient in scripting languages like Python, Perl, or Shell scripting for automating ETL processes and data manipulation.8. Understanding of data security principles and compliance regulations to protect sensitive information in the data warehouse.9. Skills in optimizing data warehouse performance, including query optimization, index creation, and partitioning.10. Experience in Azure Storage Containers, Key Vault, Log Analytics, and Synapse11. Experience in Synapse Integration runtimes, Linked Services, Serverless SQL Pool, Spark Pool12. Experience in Synapse Triggers and Pipeline Monitoring13. Experience in Synapse pipeline activities and notebooks (Pyspark, Spark SQL)14. Experience in Lake Database, Delta Lake, Medallion architectureWork Experience Required: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.1) 3 years of experience in the past 4 years in working with SQL database architecture, data modeling, normalization, and performance optimization.2) 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) 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 Teradata4) 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 Kafka5) 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.6) 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.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.