Data Engineer

StraitSys Inc

Regular

PRIMARY FUNCTION

StraitSys is seeking a skilled Data Engineer / SQL Server DBA to manage, optimize, and enhance our SQL Server environments. This role is responsible for designing and maintaining SQL Server Integration Services (SSIS) ETL pipelines and supporting database operations across multiple environments. You will play a key role in the administration, configuration, development, and deployment of SSIS services, ensuring seamless execution of automated processes and enabling efficient data integration from various sources.

While SSIS expertise is critical for immediate projects, we value forward-thinking individuals who are eager to expand their skills, as we continue to evolve our data architecture and explore opportunities to leverage cloud-native tools. This role offers a unique opportunity to support both immediate business needs and to grow with the organization as we continually work to modernize.

ESSENTIAL FUNCTIONS

SSIS Development & Deployment:
Design, develop, and maintain enterprise-grade SSIS ETL pipelines to facilitate data integration from various data sources.
SSIS Administration & Configuration:
Install, configure, and manage SSIS environments across development, testing, and production environments. You will ensure that SSIS services are properly configured for automated execution, including security settings, service accounts, and failover capabilities.
Cross-Environment Deployment:
Deploy SSIS-developed services across multiple environments, ensuring automated execution on the appropriate servers. You will configure, fine-tune, monitor, and support the continuous execution of ETL services.
Data Engineering:
Perform data engineering tasks, including data cleansing, transformation, and integration, to optimize data flows and support business-critical processes.
Database Performance & Optimization:
Monitor and optimize database performance, addressing bottlenecks in SSIS ETL workflows and/or SQL queries, and ensuring efficient use of resources across the system.
SQL Server Administration:
Manage SQL Server instances, including backup, recovery, query optimization, performance tuning, and security management.
Data Pipelines & Automation:
Automate data workflows using SQL Server Agent jobs, ensuring efficient execution of scheduled jobs across environments.
Security & Compliance:
Maintain database security, encryption, and access controls, ensuring compliance with Security Technical Implementation Guides (STIGs), industry standards, and internal security policies. Implement and audit security configurations to ensure databases adhere to required security benchmarks and best practices.
Collaboration with Development Teams:
Partner with application development teams to design and implement database solutions that align with business needs and application requirements.
Backup & Recovery:
Ensure high availability and data integrity through robust backup and recovery processes, minimizing downtime.
SUPERVISORY RESPONSIBILITIES

None

DESIRED KNOWLEDGE, SKILLS, & ABILITIES:
Experience with additional ETL tools such as Informatica, Talend, or DataStage is highly valued.
Experience supporting development teams building ASP.NET applications backed by SQL Server databases is desired.
Knowledge of cloud data solutions and experience with modern data platforms, with the interest and capacity to grow into cloud-native tools as opportunities arise.
Familiarity with DevSecOps practices and CI/CD for data pipelines is a plus.
Strong problem-solving abilities, with a focus on optimizing data workflows and improving system performance.
Excellent communication and collaboration skills to work effectively across technical and business teams.
QUALIFICATIONS:
Active Top-Secret Clearance.
Bachelor's degree in business, Management Information Systems or related discipline.
Engineering, computer science, information systems, or related discipline
3+ years of related job experience
Must be a US Citizen
Ability to successfully pass a pre-employment drug test
Extensive experience in SSIS/ETL development and deployment, with strong skills in building and managing ETL pipelines in complex environments.
Hands-on experience in SSIS Administration & Configuration, including installing and setting up new environments.
Proficiency in T-SQL for advanced query optimization, performance tuning, and database development.
Strong experience in SQL Server administration, including database management, optimization, and security.
Hands-on experience in data engineering, particularly with data transformation, integration, and workflow automation.
Expertise in deploying and managing SSIS services for automated execution across multiple environments.
Strong scripting skills in PowerShell (or similar) to automate and optimize database tasks.
Proven experience managing database security, including encryption and access control, ensuring adherence to internal and external compliance standards.
Experience with data consolidation from various data sources into SQL Server.
Ability to work effectively across multiple environments, ensuring consistency and performance across systems.

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.