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).

EEO STATEMENT
Additionally, it is our policy to select, place, train and promote the most qualified individuals based upon relevant factors such as work quality, attitude and experience, so as to provide equal employment opportunity for all employees in compliance with applicable local, state and federal laws and without regard to non-work related factors such as race, color, religion/creed, sex, national origin, age, disability, marital status, veteran status, pregnancy, sexual orientation, gender identity, citizenship, genetic information, or other protected status. When applicable, our policy of non-discrimination applies to all terms and conditions of employment, including but not limited to, recruiting, hiring, training, transfer, promotion, placement, layoff, compensation, termination, reduction in force and benefits.

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.