Address
Form of workJOB OPPORTUNITY
CDW LLC
Vernon Hills, Illinois
Sr. Software Engineer I - Data
This notice is being provided as a result of the filing of an Application for Permanent Employment Certification (ETA Form 9089). The employer intends to permanently employ a foreign national in the job opportunity described below. Any person may provide documentary evidence bearing on the application to the Certifying Officer of the U.S. Department of Labor. The address of the Certifying Officer is as follows: U.S. Department of Labor, Employment and Training Administration, Office of Foreign Labor Certification, 200 Constitution Avenue NW, Room N-5311, Washington, DC 20210.
This notice will be posted between 30 and 180 days before filing the permanent labor certification application.
The Sr. Software Engineer I - Data will perform the following duties:
Develop business software solutions for complex and large-scale projects through object and data modeling, database design, programming, quality assurance, and implementation support utilizing knowledge of product lifecycle, object-oriented design, and programming techniques, focused on work with CDW's Master Data Management platforms.
Work with Lead and Senior Application Administrators to understand business needs and clarify requirements.
Develop applications to CDW coding standards and quality, to include writing software code to meet business specifications, writing database queries to collect the data needed by the business, and implementing database designs into the physical database.
Collaborate with other developers and architects to determine the optimal solution architecture to ensure application efficiency, maintainability, and scalability.
Develop system test plans, ensure software quality assurance (SQA) standards are achieved, and validate that business goals are accomplished.
Perform all stages of the software development lifecycle including requirements gathering, design, development, testing and implementation, using database design, data management, and data quality concepts.
Develop documentation for end users.
Regularly report project/task status to the appropriate Application Development Manager.
Ensure stakeholders are responded to in a timely and professional manner and foster open lines of communication with all parties.
Define Rest API schemas and perform regression testing, smoke testing and performance testing using JMeter, Git, Tosca DI, Jenkins and Splunk.
Document new and existing processes and demonstrate new development to the team.
Use Informatica MDM to design, develop, optimize, and support MDM for various domains.
Participate in daily scrums using TFS and Kanban board; follow Agile methodologies for CDW EBI Finance and Accounting team.
Write SQL database queries.
Streamline ETL processes to extract data from iSeries, SQL Server, IBMi, add transformations and load into Datawarehouse using SSIS, SQL and .NET.
Develop and maintain data models using SSAS, MDX, SQL and data warehousing concepts.
Support data governance activities using Azure Purview, Azure Data Lake and Azure Data Factory.
Utilize a variety of other technologies and tools including Object Oriented Concepts, Database Design Concepts, XML, Eclipse, SQL Server, SSIS, Java, JSON, Informatica Toolset, TFS, Git, GitHub, Postman, REST APIs, Azure based services, Tosca DI, Python, P360, JMeter, Jenkins, SSAS, Splunk, Excel, and testing.
Minimum requirements: Bachelor's degree in computer science or a related technology field plus at least 5 years post baccalaureate, progressive full software development lifecycle (SDLC) experience including work with ETL processes, SQL, SSAS, and SSIS. Alternatively, CDW will accept a master's degree in computer science or a related technology field plus at least 2 years full software development lifecycle (SDLC) experience including work with ETL processes, SQL, SSAS and SSIS.
The job is based out of CDW's Vernon Hills, IL headquarters but the employee may work remotely from anywhere in the U.S. Salary: $144,560. Please apply via this website.
