Senior Data Analyst (SQL, ETL, DevOps Engineering)

Hybrid every other week onsite/5 days in Merrimack, NH

Our client is seeking a Data Engineer to join a collaborative team focused on providing solutions for financial professionals The role centers on analyzing and building robust ETL pipelines, leveraging AWS cloud services, and delivering high-quality data assets that enable decision-making across the organization.

We are seeking a highly skilled Senior Data Analyst to join our team and play a pivotal role in the Agile development of analytical tools. This position is essential for implementing innovative solutions using the latest technology. You will work closely with two other data analysts and four data engineers in a collaborative environment that encourages creativity, innovation, and excellence. Your primary responsibility will be to deliver data-centric insights and integration solutions with transformation logic for our customers.

Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.

Rate: $60.00 to $68.00/hr. w2

Responsibilities

• Analyze and interpret complex datasets to provide actionable insights for portfolio construction tools.
• Collaborate with data engineers to design and develop ETL processes for data integration and transformation.
• Utilize advanced data manipulation languages and frameworks, including Python and JSON, to process and analyze data.
• Leverage AWS services to manage and analyze large datasets, ensuring data accuracy and security.
• Develop and maintain SQL queries and stored procedures to support data analysis and reporting.
• Participate in Agile development processes, contributing to sprint planning and execution.
• Communicate findings and insights effectively to stakeholders and team members.
• Assist in the development and maintenance of technical documentation for data processes and projects.

Required Skills and Qualifications:

Data Analysis and ETL:

• Strong experience with ETL processes and tools for data integration and transformation.
• Ability to analyze and interpret complex datasets to provide actionable insights.

Programming and Data Manipulation:

• Advanced proficiency in Python and JSON for data manipulation and analysis.
• Expert in SQL for querying and managing relational databases.

Cloud and DevOps:

• Experience with AWS services for data management and analysis.
• Familiarity with DevOps practices and tools for data processing and integration.

Communication and Collaboration:

• Excellent interpersonal and communication skills.
• Ability to work effectively with cross-functional teams, including data engineers and business stakeholders.

Additional Skills:

• Experience in an Agile development environment.
• Ability to create and maintain technical documentation for data processes.

If you are a seasoned data analyst with a passion for data-driven insights and have a strong background in ETL, Python, AWS, JSON, and SQL, we encourage you to apply. This is an opportunity to work in a dynamic environment and make a significant impact on our portfolio construction tools.

Experience Requirements

• 6+ years of data analysis or hybrid analyst/engineering experience with a strong foundation in ETL technologies.
• Expertise in designing and developing ETL reporting and analytics solutions.
• Knowledge of data warehousing methodologies and concepts (preferred).
• Advanced proficiency with Java, Python, and JSON.
• Hands-on experience with relational databases such as Snowflake and PostgreSQL.
• Strong knowledge of AWS services including IAM, EC2, S3, Lambda, and RDS.
• Proven ability to design and develop low to moderately complex data integration solutions.
• Experience with DevOps, CI/CD, and tools such as Maven, Jenkins, Stash, Ansible, and Docker (preferred).
• Expert-level SQL and stored procedure development on relational databases.
• Proficiency in debugging, analysis, and production support.
• Demonstrable experience with ETL tools such as Informatica or SnapLogic.
• Experience working with Python in an AWS environment.
• Ability to interact with business partners to translate business requirements into technical requirements.
• Working knowledge of Unix/Linux and shell scripting.
• Experience building sophisticated CI/CD pipelines including configuration management, test automation, version control, and static code analysis.
• Excellent interpersonal and communication skills with experience working on global Agile teams.
• Proven ability to operate in a fast-paced environment and handle ambiguity.
• Ability to mentor junior engineers and demonstrate technical leadership.
• Hands-on test case or plan preparation within JIRA (preferred).

Education Requirements

• Bachelor’s degree preferred.
• AWS-related certifications (preferred).

Recruitment Transparency Notice

Eliassen Group values transparency in our recruitment practices. Please be advised that Eliassen Group utilizes artificial intelligence (AI) tools as part of its initial application screening process. You may receive email and SMS notifications from the Eliassen Virtual Recruiting Team ( [email protected] , 781-808-2924) inviting you to complete a brief voice screening as part of your application process. These tools assist our hiring teams in different ways, including but not limited to, assistance in reviewing application materials to help identify candidates whose qualifications most closely match the requirements of the position. All AI-assisted evaluations and responses are reviewed by human recruiters before any hiring decisions are made. The use of AI in our process is intended to support fairness, efficiency, and consistency, and Eliassen Group takes measures to prevent bias or discrimination in connection with its hiring practices. By proceeding, you acknowledge, agree, and consent to Eliassen Group’s use of these tools, including AI tools, as part of the application and hiring process.

Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.

About Eliassen Group:

Eliassen Group is a leading strategic consulting company for human-powered solutions. For over 30 years, Eliassen has helped thousands of companies reach further and achieve more with their technology solutions, financial, risk & compliance, and advisory solutions, and clinical solutions. With offices from coast to coast and throughout Europe, Eliassen provides a local community presence, balanced with international reach. Eliassen Group strives to positively impact the lives of their employees, clients, consultants, and the communities in which they operate.

Eliassen Group is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Don’t miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!