### Job Description: Lead Data Engineer - ETL, SSIS Developer
**Position:** Lead Data Engineer - ETL, SSIS Developer
**Experience Level:** 5-8 years
**Location:** [Remote]
**Type:** Full-Time, Immediate Joining
**About the Role:**
We are seeking a skilled and experienced Lead Data Engineer - ETL, SSIS Developer to join our dynamic team. As a Data Engineer, you will play a crucial role in optimizing data retrieval, analysis, and reporting processes using various tools. Your responsibilities will include designing efficient data models, writing SQL queries, developing SSIS packages, and ensuring optimal performance across our data infrastructure.
You will interface with business stakeholders to understand their objectives, craft effective data solutions, and build the necessary technical queries and pipelines to achieve business goals. The ideal candidate should excel in dealing with ambiguity, possess strong analytical skills, and adapt to complex business and technical scenarios.
**Key Responsibilities:**
- Design, develop, and maintain efficient data models and ETL processes.
- Write and optimize complex SQL queries and SSIS packages.
- Develop and maintain data pipelines using SQL, Python, and other relevant technologies.
- Collaborate with business stakeholders to gather requirements and translate them into technical solutions.
- Ensure optimal performance of data infrastructure and troubleshoot issues as they arise.
- Implement data warehousing concepts, including dimensional modeling and data governance.
- Utilize AWS services (RDS, DynamoDB, ElastiCache, EC2, etc.) for data management and processing.
- Work with Microsoft BI Toolkit (SQL, VBA, SSIS, SSAS, SSRS, Power BI) to develop and maintain BI solutions.
- Maintain version control using Github production and other relevant tools.
- Adhere to company policies and procedures, ensuring HIPAA compliance.
**Knowledge, Skills, and Abilities:**
- **Education:** Bachelor’s degree in Computer Science, Information Systems, or a related field. A master’s degree is a plus.
- **Experience:** 5-8 years in data engineering, SQL development, and ETL processes.
- **Technical Proficiency:**
- Proven experience as a Google BigQuery SQL Developer or similar role.
- Extensive experience in building Enterprise Data Warehouses.
- Proficient with SQL and at least one programming language (Python, Java, Scala).
- Solid experience with AWS services (RDS, DynamoDB, ElastiCache, EC2) and other cloud databases.
- Extensive experience with Microsoft BI Toolkit (SQL, VBA, SSIS, SSAS, SSRS, Power BI).
- **Skills:**
- Strong data modeling, ETL, and data warehousing skills.
- Excellent analytical and problem-solving abilities with attention to detail.
- Strong communication and interpersonal skills for effective collaboration.
- Ability to work independently, prioritize tasks, and meet deadlines.
- Proficiency in Python or R is a plus.
- Certifications in relevant BI tools and technologies are a plus.
- Experience with healthcare, RCM, financial systems, and large healthcare EMRs is highly desirable.
- Familiarity with HIPAA compliance and healthcare data management.
We don't provide sponsorship - Can be on EAD Visa, Green Card , US Citizen -
And we don't accept those looking for C2C or H1B
**What We Offer:**
- Competitive salary and benefits package.
- Opportunities for professional growth and development.
- A collaborative and innovative work environment.
- Remote working conditions and support for work-life balance.
**How to Apply:**
If you are a motivated and skilled Data Engineer ready for immediate joining, we encourage you to apply. Please submit your resume and a cover letter detailing your relevant experience and why you are a great fit at info@logichire-ss.com
---
**Join us and be a part of a team that drives innovation and excellence in data engineering!**