Data Analyst/ETL Developer

Base One Technologies; Boston, Northern (MA, KY); Hybrid; USD 95,000 - 125,000; Full time

Job summary

Base One Technologies is hiring an ETL Developer/Business Liaison in the Boston area to drive data integration and digital transformation for partner projects. You will research technologies, recommend solutions, and set best practices across the software development lifecycle.

You will interface with stakeholders, craft architecture artifacts, and mentor peers. The role requires hands-on ETL work, strong SQL and Unix scripting, and a willingness to operate in a hybrid in-office schedule.

Qualifications

• Bachelor's degree or equivalent is required.
• At least 3 years of Informatica IICS ETL experience.
• Strong Snowflake and data warehouse knowledge.
• Experience with multiple ETL platforms (SSIS, ODI, CDATA).
• Proven SQL and Unix shell scripting skills.
• Candidate must be able to work from Boston with hybrid schedule.

Responsibilities

• Participate in crafting architecture documents aligned with requirements.
• Create design artifacts and prototypes to support POCs.
• Deliver high quality code and assist with quality checks and documentation.
• Lead validation activities for various testing types.
• Support Go Live planning and execution under SLAs.
• Perform root-cause analysis and implement solutions post-implementation.
• Conduct knowledge transfer sessions and transition support.
• Bridge business and IT gaps by communicating changes clearly.
• Mentor team members to improve overall effectiveness.

Skills

SQL

Unix shell scripting

Informatica IICS ETL

Snowflake

Data warehousing

ETL design

Education

Bachelor's degree or equivalent

Tools

SSIS

ODI

CDATA

Job description

We are seeking an ETL Developer/Business Liaison. In this role, you will enable digital transformation for our partners in a global delivery model, research on technologies independently, recommend appropriate solutions and give technology-specific best practices and standards. You will be responsible for interfacing with key stakeholders and applying your technical proficiency across different stages of the Software Development Process. You will be part of a learning culture, where partnership and collaboration are encouraged, excellence is rewarded, and diversity is respected and valued.

Key Responsibilities

• Participate in crafting application architecture document to provide work you're doing in line with architectural requirements
• Create design artifacts and support prototyping through creation of POCs
• Delivery high quality code work and support peers in quality checks such that design requirements are met. Create documentation for the assigned modules
• Lead validation activities for the assigned modules for all types of testing e.g., Functional, Integration, System, User Experience etc.
• Support the creation of “Go Live” plan and lead assigned activities in the plan
• Perform root-cause analysis of any issues that arise post-implementation and work on appropriate solutions
• Participate in Knowledge Transfer sessions, prepare system appreciation documents and support the transition process
• Conduct impact analysis of issues logged, prioritize and ensure that production support is provided as per committed SLAs
• Support and mentor other team members to bolster the team’s effectiveness
• Effectively communicate IT changes to the business, ensuring smooth transitions and minimal downtime
• Bridge the technical gap between the business and IT – understand and be excellent in both areas to be as effective as possible

Required Qualifications

• Candidate must be located within commuting distance of Boston, MA. Current hybrid model requires 2-3 days per week in office.
• Bachelor's degree or equivalent required from an accredited institution. Will also consider three years of dynamic experience in the specialty in lieu of every year of education
• At least 3 years of experience in Informatica IICS ETL
• At least 3 years of experience in Snowflake
• Experience with other ETL platforms (SSIS, ODI, CDATA)
• Good experience in end-to-end implementation of data warehouse and data marts
• U.S. Citizenship and those authorized to work in the U.S. are encouraged to apply. We are not able to sponsor at this time
• Strong knowledge and hands-on experience in SQL, Unix shell scripting

Preferred Qualifications

• Snowflake certification(s)
• Good understanding of data integration, data quality and data architecture
• Experience in Relational Modeling, Dimensional Modeling and Modeling of Unstructured Data
• Good understanding of Agile software development frameworks