Data Engineer

Aristotle, a prominent figure in the computer software industry, is presently in search of a skilled and motivated Data Engineer to join our vibrant team. At Aristotle, our belief in the significance of the democratic process is deeply ingrained, forming the basis for all our operations. We devote ourselves to promoting democracy globally through inventive software solutions that empower both organizations and individuals. As a Data Engineer, you'll play a crucial role in our mission to revolutionize data usage. You'll get a chance to work and learn in a team-oriented environment where your views are genuinely valued. We embrace passionate individuals who are committed to advancing the democratic process, irrespective of their political stands. Become part of Aristotle and appreciate what you do while contributing to a noble cause. Aristotle's Integrity division is a top supplier of identity and age verification services across various industries. Our age/identity verification solutions are utilized by firms to fulfill different regulatory obligations such as AML, KYC, and Age Verification. Please visit https://integrity.aristotle.com for more information about this division. Responsibilities Data Load and Transformation: Develop data load methods for efficient data storage and retrieval from databases and other file systems. Create data conversion and transformation processes and utilities for managing large datasets. Solution Development: Use .NET/SSIS/SQL Server technologies to design and deploy solutions that correspond to data consumer needs and abide by business rules. Web-Based Reporting: Develop web-based reporting systems to monitor system performance, transaction metrics, and error rates. Data Transformation Rules: Cooperate in defining and documenting data transformation rules to maintain data integrity and accuracy. ETL Design and Performance: Concentrate on the design, development, and performance tuning of ETL (Extract, Transform, Load) processes to maximize data processing efficiency. Collaborative Development: Collaborate closely with other developers to provide data services to both existing and new applications. This involves modifying production data, creating and optimizing stored procedures, functions, views, and more. System Performance Enhancement: Develop and analyze strategies to enhance system performance, ensuring efficient data processing and retrieval. Documentation and Testing: Prepare thorough documentation and testing procedures to guarantee the reliability and quality of developed solutions. Industry Standard Practices: Develop software using industry-standard programming techniques to maintain code quality and consistency. Unit Testing and Debugging: Conduct unit testing and debugging of application components to identify and resolve issues promptly. Requirements Bachelor's or Associate's degree in Computer Science or a related field. At least 2 years of practical experience with ETL (Extract, Transform, Load) processes. Proficiency in T-SQL programming and experience with Microsoft SQL Server 2005 and 2008. A profound understanding of the SQL Server Query Processing Engine is necessary. Knowledge and experience in designing, developing, debugging, and deploying SQL Server stored procedures, T-SQL scripts, DTS (Data Transformation Services), and SSIS (SQL Server Integration Services) packages. Ability to manage multiple priorities, stick to project plans, and consistently meet project deliverables. Proficiency in Microsoft SQL versions 2000, 2005, and 2008, as well as Microsoft SQL Server Reporting Services. Familiarity with MS Office applications, including Word and Excel. Demonstrated ability to quickly learn and adapt to new technologies as needed. Desired Requirements Proficiency in using Microsoft Visio for creating sequence diagrams, component diagrams, and other UML (Unified Modeling Language) diagrams. Proficiency in data modelling using tools such as MS Visio or Erwin data modeler. Familiarity with identity verification for fraud, marketing, and risk mitigation solutions within the industry. Knowledge of internet technologies, including XML, DHTML, CSS, and JavaScript. Familiarity with ASP.NET 2.0, C#, and Traditional ASP (Active Server Pages). Benefits All positions are Full-Time, with competitive compensation, medical benefits, paid leave, 401k plan and stock options. Informal dress code and a non-corporate atmosphere make this a fun place to work and learn in a team environment. Please visit our website at www.aristotle.com.