Data Engineer I

StraitSys Inc

Regular

PRIMARY FUNCTION

We are looking for a qualified Data Engineer to design and build reliable, efficient, and compliant data pipelines and architectures, according to our company’s needs. You will be responsible for developing, testing, improving, and maintaining new and existing processes that support data transformation, workload management, data structures, and metadata.

As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.

Ultimately, you should be able to integrate, transform, and consolidate data from various structured and unstructured data systems into structures that are suitable for building analytics solutions.

ESSENTIAL FUNCTIONS

Build the infrastructure required for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources

Create and maintain optimal data pipeline architecture

Design stable, reliable and effective databases

Optimize and maintain legacy systems

Modify databases according to requests and perform tests

Solve database usage issues and malfunctions

Liaise with developers to improve applications and establish best practices

Gather user requirements and identify new features

Develop technical and training manuals

Provide data management support to users

Ensure all database programs meet company and performance requirements

Research and suggest new database products, services and protocols

SUPERVISORY RESPONSIBILITIES

N/A

KNOWLEDGE, SKILLS, & ABILITIES:

Hands-on experience with Data integration software packages. Ex. Azure Data Factory, Databricks, Azure Synapse Analytics, SQL Server Integration Services, Apache Nifi, etc.

Leveraging Cloud-based architectures (Azure \ Snowflake)

Strong understanding and hands-on experience writing performant SQL in SQL Server

Experience in data analytics, building business intelligence dashboards

In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)

Knowledge of software development and user interface web applications

Strong background in PowerBI with experience in extracting data, modeling, creating visualizations, and scheduling data refreshes

Experience in PowerBI Desktop to create visualizations using Tables Charts, Maps, Calculated columns, measures, including Data Analysis Expressions (DAX)

Familiarity working with SQL and Python

Excellent analytical and organization skills

An ability to understand front-end users requirements and a problem-solving attitude

Excellent verbal and written communication skills

QUALIFICATIONS:

BS degree in Computer Science or relevant field

Minimum 2 years of experience designing and programming Microsoft SQL Server database applications.

Minimum 2 years of experience using Microsoft Visual Studio and SQL Server Management Studio

Demonstrated expertise in building and modifying SQL queries.

Must be able to maintain and obtain a Government Security Clearance

PREFERENCE STATEMENT

Preference will be given to Calista shareholders and their descendants and to spouses of Calista shareholders, and to shareholders of other corporations created pursuant to the Alaska Native Claims Settlement Act, in accordance with Title 43 U.S. Code 1626(g).

REASONABLE ACCOMMODATION

It is Calista and Subsidiaries' business philosophy and practice to provide reasonable accommodations, according to applicable state and federal laws, to all qualified individuals with physical or mental disabilities.

The statements contained in this job description are intended to describe the general content and requirements for performance of this job. It is not intended to be an exhaustive list of all job duties, responsibilities, and requirements.

This job description is not an employment agreement or contract. Management has the exclusive right to alter the scope of work within the framework of this job description at any time without prior notice.