Senior Systems Analyst / Microsoft SSIS Developer - $101 CTC - REMOTE - Chandra Technologies, Inc. - Remote | Dice.com

Chandra Technologies, Inc.

Apply Now

Senior Systems Analyst / Microsoft SSIS Developer - $101 CTC - REMOTE

Remote • Posted 4 hours ago • Updated 4 hours ago

Contract Independent

Contract W2

Remote

Depends on Experience

Apply Now

Chandra Technologies, Inc.

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

Acceptance Testing
Data Warehouse
GitHub
KPI
Microsoft Azure
Microsoft SSIS
Microsoft SSRS
Microsoft SharePoint
Microsoft Power BI
MuleSoft
Oracle
Microsoft SQL Server
Technical Writing

Summary

Job Description:

***Crop to Crop resumes are accepted

Essential Job Duties

SSIS / ETL ( 50%)

Design, develop, and maintain automated ETL solutions with Microsoft SSIS (project/deployment model, configurations, parameterization, robust error handling and logging).
Orchestrate data movement between SQL Server, Oracle, and Snowflake; where appropriate, integrate Azure Data Factory/Informatica and file automation (e.g., GoAnywhere/MuleSoft).
Implement CDC/incremental patterns; tune performance via staging/partitioning, set-based SQL, and workload scheduling to meet SLAs.
Follow change management and code migration processes (Azure DevOps/Git); promote from Dev Test/QA Prod with auditable approvals.
Troubleshoot build/run failures; create runbooks; monitor and optimize ETL runtimes and job dependencies.

System Analyst ( 50%)

Elicit and document data & reporting requirements (KPIs, filters, delivery cadence) and translate into functional/data specifications.
Produce and maintain S2T mappings, business rules, data dictionaries, and lineage/flow diagrams (current future state) spanning staging, integration, and presentation/reporting layers.
Define and execute data quality and reconciliation controls (row counts, checksums/hashes, referential integrity, threshold/exception reports); validate loads back to sources (SQL Server/Oracle/mainframe).
Support UAT for data changes/reports (test scenarios, expected results, sign-offs); coordinate remediation and re-tests.
Review database/report performance and suggest alternatives (indexing/partitioning/materialized views, pre-aggregations) to meet SLA and usability goals.
Communicate progress/risks/issues promptly; mentor junior staff; coordinate with SMEs, DBAs, ETL engineers, and reporting teams (Power BI/SSRS).
Maintain organized, audit-ready documentation in SharePoint/Confluence/Azure DevOps

Essential Job Duties

Development of automated ETL solutions with Microsoft SSIS and Oracle platforms.
Performs analysis and research of application functionality and interprets project requirements to develop technical specifications for application ETL functionality
Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems.
Practices current development methods/techniques and establishes development standards (which include coding standards, documentation standards, and testing standards) to ensure the quality and maintainability of automated solutions.
Communicates and/or collaborates with business area stakeholders to coordinate development efforts in support of business needs.
Leads the development and maintenance of documentation and ensures that the content of documentation is well organized, complete, and appropriate to the audience.
Ensures project schedules are met, and/or re-negotiated, and approved prior to target dates.
Communicates progress and issues affecting work assignments to management and/or Project Manager as soon as possible.
Follows established change management code migration processes.
Mentors junior level staff in the development, testing, and deployment of new and/or modified solutions.
Collaborates with other staff in the development, testing, and deployment of new and/or modified solutions.
Familiar with design best practices of data warehouse and application databases.
Reviews all application database change requests to determine any (downstream) effect on warehouse ETLs.
Consults the Data Dictionary for any dependencies and additional information that the data admin request may require.
Assist with the review of database performance and suggest alternative ways to resolve any performance issues
Creation of technical documentation for process and interface documentation is a key element of this role, as the Team is working on release two of a minimum four release effort.
Ability to review the work of others, troubleshoot, and provide feedback and guidance to meet tight deliverable deadlines is required.
Ability to promote the code from development environments to production.
Familiarity with Github or equivalent version control systems.
Extensive experience with Oil & Gas systems
Experience working with state agencies
Perform related work as assigned.

Required Skills:

Experience working in a medium to large information technology environment to include ever-increasing responsibility for development, design, and/or deployment actions.
Knowledge and skill using Microsoft SQL Server Integration Services (SSIS)
Knowledge and skill using Microsoft Azure DevOps and Git required, with emphasis on deployment, version control and project tracking
Skill with Microsoft Office tools, particularly with Word, Excel, PowerPoint, Visio, and SharePoint
Hands on Experience in RBDMS (Risk Based Data Management ) platform
Knowledge and at least 2 years of experience with Oracle databases with some of that experience being Oracle version 12c
Knowledge and skill using Microsoft SQL Server
Knowledge and skill using Microsoft Azure Cloud database services
Knowledge of database object migration/validation tools
Knowledge and understanding of ETL development, monitoring, batch and/or data processing in an automated scheduled environment
Knowledge of database structures and theories
Knowledge of enterprise information management processes and methodologies, relational database management systems, and metadata management
Knowledge of local, state, and federal laws and regulations (PII) relevant to data management and data governance
General knowledge of technology across all network layers and computer platforms
Knowledge and experience with the Software Development Life Cycle (SDLC) and project plan understanding
Excellent written and verbal communication skills, including the
ability to present and communicate complex technical information (including on-the-job training) clearly and concisely, both orally and in writing, to diverse audiences which includes coworkers, project team members, and IT management.
Experience in working in fast-paced and ever-changing environments; achieving project s deliverables and deadlines; exercising sound judgment in making critical decisions; analyzing complex information and developing plans to address identified issues.
Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various levels of personnel.

Desired Skills:

ETL development and data warehouse monitoring
Development using Oracle or Microsoft SQL Server, SQL, systems analysis, systems design, other relevant information technology experience
Development experience using Microsoft SQL Server Integration Services (SSIS)
Development experience using Microsoft Azure Cloud databases
Experience utilizing Microsoft Azure DevOps and Git
General knowledge of Informatica or similar ETL tool.
Knowledge of master data, metadata, reference data, data warehousing, and business intelligence principles and process, including technical architecture
Experience in data focused projects, like moving from Legacy to newer systems.
Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10121151
Position Id: TXRRC-SSA1110
Posted 4 hours ago

Company Info

About Chandra Technologies, Inc.

Chandra Technologies, is a leading consulting and IT services company providing value-added, software-led IT solutions and services to large, medium and small scale organizations.

Starting from the strategy consulting right through to implementing IT solutions for clients, at Chandra Technologies we go beyond providing solutions, we work with our clients through technology and business changes that shape their competitive advantages.

We continue to reiterate our key imperatives of focusing on our technology competencies and keeping pace with continuous growth and learning.

Through our commitment, experience, and expertise Chandra Technologies has established a business relationship with our customers that will last a lifetime!

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Remote

•

6d ago

Job Description: Crop to Crop resumes are accepted Location Requirement: If the Vendor is headquartered in Texas, this position is eligible for telecommuting from within the Continental United States. Conversely, if the Vendor is not headquartered in Texas, this position is eligible for telecommuting from within Texas only. The Worker(s) will provide the following services: As a Systems Analyst in the IT Project Management Office, responsible for overseeing the analysis, design, and implementa

Easy Apply

Contract

Depends on Experience

Senior SSIS Developer - Remote

Remote or Springfield, Illinois

•

Today

DivIHN (pronounced divine ) is a CMMI ML3-certified Technology and Talent solutions firm. Driven by a unique Purpose, Culture, and Value Delivery Model, we enable meaningful connections between talented professionals and forward-thinking organizations. Since our formation in 2002, organizations across commercial and public sectors have been trusting us to help build their teams with exceptional temporary and permanent talent. Visit us at to learn more and view our open positions. Please apply o

Easy Apply

Contract, Third Party

$70

Senior Analyst, IT Systems - Technical Project Manager - Mobile Apps - Remote

Remote or Long Beach, California

•

Today

Job Description Knowledge/Skills/Abilities Mentors and leads 2-10 software engineers on multiple projects for project deliverables, assess deliverables' quality, plan and implement corrective and preventive actions to improve application quality. Evaluates alternative systems solutions and recommends solution that best meets the need of the business. Develops the BRDs along with business stakeholders, Conceptual Designs for multiple projects concurrently. SOX compliant Project deliveries and Pr

Full-time

Senior Database Administrator

Remote

•

6d ago

Apptech Group is seeking a Senior Database Administrator to join their team in supporting and modernizing database systems and related applications for a state government initiative. The role focuses on maintaining, upgrading, and optimizing SQL Server environments, ensuring performance, reliability, and security across multiple systems. This position requires expertise in SQL Server administration, ETL and SSIS processes, and close collaboration with application and infrastructure teams to impl

Easy Apply

Contract

Depends on Experience

Senior Systems Analyst / Microsoft SSIS Developer - $101 CTC - REMOTE

Chandra Technologies, Inc.

Dice Job Match Score™

Dice Job Match Score™

Job Details

Skills

Summary

Company Info

About Chandra Technologies, Inc.

Similar Jobs

Dice Job Match Score™

Emily Koel