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