Data Engineer with Databricks and SSIS - Contract - W2 Only - Remote - Ampcus Incorporated
Bloomfield, CT 06152
About the Job
Data Engineer with Databricks and SSIS
This is a W-2 position only (no staffing agencies or contractors). Candidates must currently reside in the U.S.
REMOTE POSITION. Monday-Friday, 40 hours per week. Core hours: 8 AM to 5 PM EST.
Summary:
This is for a production support/developer at Customer Data Marts. Trouble Shoot / Install and troubleshoot SSIS Package
- Databricks
- SSIS
- ETL
- SQL
- Some BA capabilities
Duties:
- Provides expert content and professional leadership on complex engineering assignments and projects.
- Designs and develops a consolidated, conformed enterprise data warehouse that stores all critical data across Customer, Provider, Claims, Client, and Benefits data.
- Designs, develops, and implements methods, processes, tools, and analyses to sift through large volumes of data in a data warehouse or data mart to identify relationships and patterns.
- Participates in delivering the definitive enterprise information environment that enables strategic decision-making across the enterprise through analytics and reporting.
- Exercises considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives.
- Uses deep professional knowledge and expertise to advise functional leaders.
- Focuses on providing thought leadership within Information Management while working on broader projects that require a wider business understanding.
- Recognized internally as a subject matter expert.
- Completes day-to-day business development tasks without immediate supervision but has ready access to guidance from more experienced team members.
Skills:
- Advanced analytical and strategic thinking skills.
- Experience designing and maintaining a Databricks environment.
- Experience designing and maintaining a SQL Server environment.
- Experience querying relational databases (SQL Server, Oracle, Teradata).
- Experience with Agile methodology for software development.
- Experience with ETL processes and tools, specifically SSIS.
- Strong organizational skills.
- Strong mentoring skills.
- Ability to design solutions that are innovative, thorough, practical, and aligned with organizational objectives.
- Demonstrated ability to prioritize workload and meet project deadlines.
- Excellent troubleshooting skills.
- Analytical and detail-oriented in all work activities.
- Customer-focused in all work activities.
- Ability to communicate and present professionally and effectively.
- Ability to mentor internal customers in the use of software applications.
- Demonstrated team collaboration experience.
- Ability to handle and balance multiple projects or tasks simultaneously.
- Ability to solve complex problems.
- Ability to quickly learn and use new libraries, APIs, and software applications.
- Ability to adapt in a dynamic work environment and make independent decisions.
- Familiarity with the healthcare or PBM industry is a plus.
Education:
- BA/BS required; MS/MA preferred.
Years of Experience:
- 5 years of relevant experience or a Master’s degree with 2 years of relevant experience.
- 1-2 years of client experience preferred.
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 identity, national origin, age, protected veterans or individuals with disabilities.