Job Description
Key Responsibilities
SQL Server Development
- Design, implement, and optimize SQL queries, stored procedures, views, and triggers.
- Work on database schema design, indexing strategies, and normalization.
- Monitor, analyze, and optimize SQL Server database performance.
- Implement ETL (Extract, Transform, Load) processes to move data between systems.
- Troubleshoot and resolve database-related issues efficiently.
Python Development
- Develop Python scripts to automate data processing and analysis tasks.
- Integrate Python with SQL Server for data extraction, transformation, and reporting.
- Use Python libraries such as Pandas, NumPy, and SQLAlchemy for data manipulation and analytics.
- Build APIs and integrations to streamline internal workflows.
- Create data visualizations using libraries such as Matplotlib and Plotly to present insights.
Excel Expertise
- Perform advanced data analysis using Excel formulas, pivot tables, and functions.
- Automate repetitive tasks using Excel VBA (macros).
- Create structured reports, dashboards, and charts for business users.
- Ensure data accuracy, consistency, and integrity across Excel-based reports.
PowerPoint Reporting
- Develop clear, visually engaging PowerPoint presentations to communicate insights.
- Translate complex technical findings into actionable business insights for leadership.
- Design professional presentations to support data-driven decision-making.
Collaboration & Support
- Work closely with cross-functional teams to gather requirements and deliver data solutions.
- Provide support for ad-hoc reporting and business intelligence requests.
- Assist in the development, maintenance, and optimization of data pipelines and reporting systems.
Required Qualifications
Education
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
Experience
- Minimum 3+ years of experience in SQL Server development with strong query optimization skills.
- Hands-on experience in Python development for data automation and analytics.
- Strong working experience with Microsoft Excel, including VBA automation.
- Proven ability to create impactful PowerPoint presentations for business stakeholders.
Technical Skills
- Strong proficiency in SQL Server Management Studio (SSMS).
- Practical experience with Python data libraries (Pandas, NumPy, SQLAlchemy).
- Knowledge of data visualization techniques and best practices.
- Experience working with ETL and data integration processes.
- Familiarity with cloud platforms such as Snowflake, AWS, or Azure is an added advantage.
Soft Skills
- Excellent verbal and written communication skills.
- Ability to present complex technical information to non-technical audiences.
- Strong analytical thinking, problem-solving skills, and attention to detail.
- Ability to work independently as well as collaboratively in a fast-paced environment.
- Strong time management skills with the ability to handle multiple tasks simultaneously.
Preferred Skills
- Experience with BI tools and advanced SQL/Python analytics.
- Familiarity with version control tools such as Git.
- Understanding of Agile development methodologies.
Key Skills
- Advanced SQL
- Python
- Microsoft Excel (VBA, Pivot Tables)
- BI Tools
- Data Analysis & Reporting
