(Remote) SSIS Developer Job at JK Moving Services
Overview:
JK Benefits
Performs as data & integration engineer and performs hands-on development to create, enhance and maintain data solutions that ensure seamless integration and flow of data across our data ecosystem. Responsible for designing and developing data ingestion and processing/transformation frameworks that provide insights into raw data and manage diverse sources of data seamlessly. The SSIS Developer will reverse engineer existing integrations to understand the data architecture and perform detailed source data analysis.
Responsibilities:
- Work with stakeholders to collect requirements and translate them into database models and data flows.
- Design and develop advanced SQL queries, stored procedures, triggers, scripts, and help fine tune databases.
- Rewrite integrations, written with Scribe Insights, to SSIS.
- Examine SQL stored procedures and determine areas of code improvement following SQL best practices.
- Assess various business needs and requirements for a consistent and flexible set of data rules and standards.
- Translate data and technology requirements into our ETL architecture.
- Work with standard ETL tools and techniques, sourcing, maintaining, and updating data, data warehousing, data cleansing, and other analytical techniques required for data usage.
- Deploy data processing jobs to production, configure and schedule data pipeline.
- Ensure solutions exhibits high levels of performance, security, scalability, maintainability, appropriate reusability, and reliability upon deployment.
- Clearly document dataflow, ETL pipelines.
- Perform unit testing on solutions.
- Hands-on experience optimizing ETL pipelines and query performance tuning with SQL Server Integration Services (SSIS).
- Demonstrated ability to write ad-hoc queries, stored procedures, user-defined functions, views, and indexes.
- Expertise with DDL and DML statements, RDBMSs, and data dictionaries.
- Performance tuning complex queries, stored procedures and indexing strategies.
- Advanced data analysis, validation, and processing skills.
- Strong problem solving and troubleshooting abilities.
- Technical aptitude and experience learning new technologies and understanding relevant cloud trend.
- Familiarity with Scribe Insights preferred.
- Familiarity with Microsoft Dynamics (both on-premises and 365 versions) preferred.
- Familiarity with data warehousing concepts.
- Hands-on experience in DevOps, automation, and deploying packages between different environments a plus.
As the largest office moving company in the greater DC area, JK delivers superior relocation, storage, records management, and technology services to commercial and industrial clients from museums and universities to data centers, laboratories, and medical facilities. For the third year running, JK Moving Services has been ranked #1 commercial mover by Washington Business Journal. JK actively seeks dedicated professionals ready to positively impact the office moving community.
JK places high standards on the care of its employees. From charitable giving to competitive compensation to fun corporate events, JK invests in each employee’s professional and personal growth. This level of commitment sets JK apart from other companies – why not consider joining JK Moving Services today!
JK Benefits
In addition to comprehensive medical, dental, and vision insurance, JK Moving offers:- World-class retirement savings programs including Company-funded profit sharing and safe harbor 401(k)
- Recruitment and customer referral bonuses
- Company-paid life insurance and accidental death benefits
- Voluntary protection programs for employees and their families
- Service recognition programs
- Safety & performance bonuses
- Tuition reimbursement and student loan repayment assistance
- Discounted membership @ Gold’s Gyms (corporate locations) nationwide
- Global employee wellness programs and Employee Assistance Program (EAP) for employees and their families
- Medical and Dependent Care Flexible Spending Accounts (FSAs)
- Health Savings Account (HSA) with employer matching contribution
Equal Opportunity/Affirmative Action Employer
Please Note :
epokagency.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, epokagency.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.