We are seeking a Data Analyst for one of our clients located in the Cincinnati area. This is a full-time permanent position.
Position Summary:
As an SSIS Data Analyst, you will play a crucial role in developing and maintaining data integration solutions that support our business operations. You will be responsible for designing, building, and optimizing SSIS packages to ensure seamless data flow within our SaaS platform.
Key Responsibilities:
SSIS Package Development:
- Design and develop robust SSIS packages to extract, transform, and load (ETL) data from various sources (e.g., databases, files, APIs)
- Optimize SSIS packages for performance and scalability
- Implement error handling and logging mechanisms to ensure data integrity
Data Integration:
- Integrate data from multiple systems and sources
- Ensure data consistency and accuracy throughout the integration process
Data Transformation:
- Perform data transformations where required, including cleaning, filtering, aggregating, and formatting
- Develop data quality rules and validation checks
Automation:
- Automate routine data integration tasks using SSIS and other automation tools
Documentation:
- Create clear and comprehensive documentation for SSIS packages and data integration processes
Collaboration:
- Collaborate with other team members to understand data requirements and deliver effective solutions
Qualifications:
- Strong proficiency in SSIS development and data integration concepts
- Experience with SQL and SQL Server
- Knowledge of data warehousing and data modeling principles
- Ability to write efficient and optimized SQL queries
- Understanding of ETL processes and best practices
- Excellent problem-solving and troubleshooting skills
- Strong attention to detail and accuracy
- Ability to work independently and as part of a team
Bonus Qualifications:
- Experience with cloud-based data platforms (AWS Glue)
- Knowledge of scripting languages (e.g., Python, PowerShell)
- Experience with data quality tools and techniques
Benefits:
- 401K
- Health, Dental, Vision, Life, and Disability Insurance Offerings
- Paid Time Off
- Dedicated to sustainable work-life balance
- A hybrid work environment
- Friendly and casual work environment