What are the responsibilities and job description for the Data Analyst position at Steneral Consulting?
Must work onsite / HYBRID at Seneca One Tower (1 Seneca Street); hybrid may be possible.
Rate is $74/hr on W2 all inclusive, without benefits
Client need to have top notch SW Engineer with deep understanding of SQL Server to include SSIS, DBA skills, data architecting and deployment of distributed systems.
They are looking for someone with this type of skill set:
Highly skilled Data Analyst in database management, SQL Server, SSIS, and data architecture. Proven expertise in designing and deploying distributed systems, optimizing ETL processes, and ensuring high data quality and integrity. Adept at collaborating with cross- functional teams to deliver actionable business insights and drive data-driven decision-making. Strong background in SQL Server administration, including performance tuning, backup/recovery, and data governance. Known for reducing operational inefficiencies, improving reporting speed, and enhancing system reliability. Committed to leveraging technical skills to solve complex data challenges and support organizational goals.
EXPERIENCE
Data Analyst
- SQL Server Optimization: Optimized and tuned complex SQL queries, reducing query execution time by 35%, leading to more efficient reporting and analysis across 10 departments.
- ETL Process Design (SSIS): Designed and implemented over 50 ETL processes using SSIS, streamlining data extraction, transformation, and loading tasks for various business units, improving data processing efficiency by 40%.
- Data Quality & Accuracy: Improved data quality standards by 25%, ensuring accuracy and integrity in reports through regular validation and testing in SQL Server.
- Deployment of Distributed Systems: Led the successful deployment of distributed data systems, reducing system downtime by 15% and improving system reliability for 20 core business operations.
- Collaboration with Cross-Functional Teams: Collaborated with business analysts, data scientists, and IT teams to provide insights and solutions, contributing to a 20% improvement in overall business decision-making processes.
- DBA Skills (Database Management): Managed and maintained over 50 production SQL Server databases, achieving 99.9% uptime and improving backup and recovery processes, reducing data recovery time by 30%.
Data Analyst
- SQL Server Data Integration: Integrated and migrated large datasets (10 million rows) from legacy systems into SQL Server, enhancing data access speed by 40% and reducing reporting delays.
- SSIS Package Deployment: Developed, tested, and deployed more than 30 SSIS packages, ensuring seamless data flow from transactional databases to the reporting database with 100% accuracy.
- Data Modeling & Architecture: Assisted in the development of data models and the design of an enterprise data warehouse, improving data accessibility for over 50 analysts and cutting report generation time by 30%.
- Data Governance Implementation: Played a key role in implementing data governance processes that improved data security and compliance, achieving 100% adherence to internal and regulatory policies.
Salary : $74