Overview
Skills
Job Details
We are seeking a highly skilled Senior Data Analyst to lead the migration of on-premises data sources to a modern Lakehouse architecture leveraging Databricks. This role requires advanced technical expertise in SQL, Python, SSRS, and Tableau, along with a meticulous approach to data quality assurance. The ideal candidate will also be responsible for creating and monitoring business-owned datasets to support analytics and reporting needs.
Key Responsibilities:
- Data Migration & Transformation
- Convert on-premises data sources into Lakehouse-compatible structures using Databricks.
- Develop and optimize ETL pipelines for efficient data ingestion and transformation.
- Programming & Automation
- Write robust Python scripts for data processing, validation, and automation tasks.
- Implement reusable code modules for scalability and maintainability.
- Data Analysis & Visualization
- Design and develop SSRS reports and Tableau dashboards to deliver actionable insights.
- Ensure reports and dashboards are accurate, timely, and aligned with business requirements.
- Data Quality & Governance
- Perform intensive data quality checks to ensure accuracy, completeness, and consistency.
- Document and enforce data validation rules and standards.
- Business-Owned Data Sets
- Develop, maintain, and monitor curated datasets for business consumption.
- Collaborate with business teams to understand requirements and ensure data availability.
Skills:
- Technical Expertise
- 5+ Years - Strong proficiency in SQL for complex queries, optimization, and data modeling.
- 3+ Years - Advanced Python skills for data manipulation, automation, and integration.
- Hands-on experience with Databricks and Lakehouse architecture.
- 5+ Years - Expertise in SSRS for report development and deployment.
- 2+ Years - Proficiency in Tableau for interactive dashboards and data visualization.
- Data Quality
- Experience in implementing data validation frameworks and performing root cause analysis for data issues.
- Soft Skills
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration abilities.
Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.
Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.
Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.
iTech Solutions, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.