Search IT Jobs

Senior SSIS Developer

Dayton, OH

Posted: 08/21/2019 Employment Type: Direct Hire Job Category: Database Job Number: 11034

Senior SSIS Developer

Our client is looking for a talented Senior SSIS Developer to join a high-growth FinTech  company located in Dayton, Ohio!

The ideal candidate is adept at using large data sets to find opportunities for product and process optimization and using models to test the effectiveness of different courses of action. 

Here' s what you' ll be doing:
  • Collaborating  with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems
  • Collaborating  with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
  • Designing and developing large complex ETL jobs
  • Document  Data Integration Design to facilitate other developers to develop software code
  • Designing, implementing and maintaining database objects (tables, views, indexes, etc.) and database security
  • Validating  data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware
  • Maintaining the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
  • Ensuring  data quality through creation of audit controls, proactive monitoring and data cleansing techniques
  • Directing junior team members, leading the team, assigning tasks, monitoring  progress and reporting status

Here' s what our ideal candidate has:
  • 6+ years of experience in Data Warehousing and Business Intelligence
  • 4+ years in SSIS and use of Stored Procedures
  • 2+ years of experience in Azure Data Factory, SQL VMs, Azure Data Warehouse
  • 3+ Years in BI development leveraging the Microsoft SQL Server or PDW/APS data environments
  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts)
  • Deep understanding of relational database design concepts and SQL programming
  • Must have worked with several Terabytes of data and a complex data processing environment
  • Strong experience with business intelligence and data warehousing design principles and industry best practices

Benefits: Generous Salary plus bonus potential, comprehensive company benefits, casual work environment, flexible PTO, 401K with company match, many opportunities for advancement

Keywords:  ETL, Leadership, SQL, SSIS, Azure, Windows, Business Intelligence, Data Warehousing, Stored Procedures, Data Mining, AWS, Data Services, Data Quality, Master Data Management

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.