Qureos Mentor

Amalgamated Sugar Company

<div><p>Amalgamated Sugar Company is looking for a Data and Database Engineer to implement, manage &amp; support the SQL-Server environment for Amalgamated Sugar. Support and develop reporting and business intelligence solutions for use by business users leveraging data from DB2, SQL Server, or other existing systems and sources. As a good team player, I collaborate and coordinate on developing information delivery, WEB, other applications, and business solutions. Requires the ability to take requirements given to you by an IT customer and turn them into a solution.</p>
<p><b>
ACCOUNTABILITY:</b> Reports To IT Infrastructure Manager</p><br>
<p></p>
<p><b>
ESSENTIAL JOB FUNCTIONS:</b></p>
<div>
<div><div><div><ul><li>Provide installation, configuration, and ongoing support for SQL Server Database, reporting, and BI environments</li></ul>
<ul><li>Develop SQL queries and stored procedures to satisfy data and reporting requirements.</li></ul>
<ul><li>Design and develop data warehouse platform, capabilities, data schemas, and models</li></ul>
<ul><li>Design, build, and maintain ETL pipelines to support data and analytical needs.</li></ul>
<ul><li>Write queries to support data analysis</li></ul>
<ul><li>Ability to create source-to-target mapping documents</li></ul>
<ul><li>Perform unit testing on all published deliverables and track/document test cases</li></ul>
<ul><li>Advanced level of SQL programming for data analysis is required</li></ul>
<ul><li>Proven ability in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization</li></ul>
<ul><li>Must have demonstrated the ability to solve complex problems with minimal direction</li></ul>
<ul><li>Must be able to interact effectively and patiently with customers, especially while under pressure.</li></ul>
<ul><li>The ability to work on multiple projects/tasks simultaneously to meet project deadlines for self and others as required</li></ul></div></div><br>
<p></p>
</div>
</div><p></p><p><b>REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES:</b></p>
<div>
<div><div><div><ul><li>Bachelor's degree in Computer Science, IT, or Mathematics</li></ul>
<ul><li>5 + years of demonstrated coding in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors, and Common Table Expressions using SQL or T-SQL.</li></ul>
<ul><li>5 + years of experience in Data Mining (i.e., SQL, ETL, complex data warehouses)</li></ul>
<ul><li>5 + years of experience working with ETL tools like SSIS</li></ul>
<ul><li>5 + years of experience in designing and developing data models for Transactions and Reporting.</li></ul>
<ul><li>&bull; 2+ years of experience building analytics using BI tools, such as Power Bi</li></ul>
<ul><li>Proficiency in Business Intelligence/Data Warehouse environment with involvement in design, development, implementation, troubleshooting, and support of ETL process</li></ul></div></div><div><br>
<div>
<ul><li>Strong query and stored procedure writing</li></ul></div></div><div><br>
<div>
<ul><li>Familiarity with entity/relationship diagramming and database theory</li></ul></div></div><div><br>
<div>
<ul><li>Experience with performance tuning</li></ul></div></div><div><br>
<div>
<ul><li>Ability to make design recommendations based on business rules and use case documents</li></ul>
<ul><li>Ability to train and mentor others</li></ul></div></div><br>
</div>
</div><p></p><p><b>ACCEPTABLE EXPERIENCE AND TRAINING:</b></p>
<ul>
<li>Experience or familiarity with .NET programming (C#)</li>
<li>Experience or familiarity with Python</li>
<li>Experience or familiarity with DB2 SQL Queries and general Database technologies</li>
<li>Practical experience using version control software like GIT Hub or Visual Source Safe in a team environment</li></ul></div>

Data & Database Engineer

Join Amalgamated Sugar Company and explore 1   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

Amalgamated Sugar Company

About Company

Data & Database Engineer