Senior SSIS Developer job Dayton Ohio
Senior SSIS Developer job Dayton Ohio
My Spider Scam Awareness Contacting Us F. A. Q.
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
Search Resumes
Browse Resumes
Post a Job

Senior SSIS Developer Job

Employer Name: SpiderID: 8897668
Location: Dayton, Ohio Date Posted: 8/28/2019
Wage: Up to $0.00 per year Category: Information Technology
Job Code: BBBH11034

Job Description:

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

Job Criteria:
Start Date:
Position Type: Full-Time Permanent
Years of Experience Required:
Education Required:
Overnight Travel:
Vacation Time:

Contact Information:
Contact Name: Agile Company Type:
Company: Agile

Send ad to a friend


© 2020 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links