Impact Makers · 3 hours ago
SSIS Engineer - Engineering & Maintenance
DFW Metroplex
Contract
Onsite
Senior Level
5+ years expImpact Makers is a mission-driven management and technology consulting company dedicated to delivering exceptional value. They are seeking a Senior Data Engineer to support a key client by engineering and maintaining business-critical data platforms built on the SQL Server ecosystem, focusing on understanding existing systems and enhancing data operations.
ConsultingInformation TechnologyManagement Consulting
Hiring Manager
Christopher Horoschak
Responsibilities
Take time to understand existing data platforms, including architecture, data flows, and dependencies
Build a clear picture of how data is modeled, processed, and consumed across the organization
Ask thoughtful technical and business questions to establish shared understanding
Translate what you learn into clear plans for stabilization and improvement
Design, develop, and maintain SSIS packages and SQL Server Agent jobs
Write and optimize SQL including stored procedures, views, triggers, and functions
Work confidently with relational data models, understanding how tables, keys, and relationships support reporting and analytics
Tune performance using indexes, statistics, execution plans, and query design
Support large datasets and frequently used tables with a focus on reliability and scalability
Help ensure data pipelines run predictably and consistently
Investigate and resolve data issues in a structured, calm manner
Reduce repeat issues through thoughtful, durable improvements
Balance short-term fixes with longer-term enhancements
Work within an Agile delivery model, participating in planning and retrospectives
Use Git for version control and collaborate through structured release processes
Support smooth promotion of changes across environments (Dev → QA → UAT → Prod)
Take ownership of work from start to finish, with a focus on quality and follow-through
Work directly with business and client stakeholders, including in-person collaboration with the Plano-based team
Explain data structures, dependencies, and impacts in clear, accessible language
Collaborate with analytics, application, infrastructure, and platform teams
Qualification
Required
Strong experience with SQL Server (on-premise)
Advanced SQL skills, including performance tuning
Hands-on experience with SSIS
Solid understanding of relational database concepts and data modeling
Experience supporting production data systems
Comfortable learning existing systems and building context before making changes
Strong communication skills
5+ years of experience in data engineering or database engineering
Experience with established data platforms and relational databases preferred
Preferred
Experience with SSAS
Working knowledge of Oracle / PL-SQL
Shell scripting for automation
Experience with Azure Data Factory (ADF)
Exposure to Azure, AWS, or GCP
Familiarity with Microsoft Fabric
Experience with Power BI
Exposure to Snowflake
Familiarity with open orchestration tools such as Airflow
Experience with Azure DevOps, Jira, or similar tools
Benefits
Healthcare plans with generous contributions to premiums
401(k) with matching
Generous PTO
Flexible, dog-friendly work environment
Company sponsored events
Pro bono opportunities
Company
Impact Makers
Impact Makers is a management and technology consulting company.
51-200 employees
Funding
Current Stage
Growth StageTotal Funding
$1.5M2016-01-29Series Unknown· $1.5M
Leadership Team
Michael Pirron
Founder and Chief Mission Officer
Company data provided by crunchbase