Sr. Data Analyst – Sr. ETL Developer Engineer

Assurety Consulting; Virginia; Hybrid; USD 80,000 - 110,000; Full time

Job summary

Join a dynamic and innovative team as a Sr. Data Analyst - ETL Developer Engineer. This role offers an exciting opportunity to work at the forefront of the postal/parcel ecosystem, where you will transform raw data into actionable insights. Collaborate with a talented team to implement state-of-the-art systems and technologies while contributing to meaningful projects that drive organizational success. With a focus on professional growth and a collaborative culture, you will thrive in an environment that values creativity and innovation. If you are passionate about data and eager to make a significant impact, this position is your chance to shine.

Benefits

Competitive Pay

Generous PTO

Outstanding Health Plan

401(k) with Company Match

Collaborative Team Atmosphere

Beverages and Snacks

Happy Hour Benefits

Paid Parental Leave

Qualifications

• 8+ years of experience in data analysis and technical analysis.
• Proficient in ETL processes and data integration.
• Strong skills in relational databases and reporting tools.

Responsibilities

• Collaborate with the team to maintain ETL infrastructure and workflows.
• Evaluate and recommend technology solutions for data management.
• Perform project management functions per PMI standards.

Skills

Data Analysis

ETL Processes

SAS

Teradata

Oracle

PowerPoint

Excel

Qlik

Power BI

Tableau

MicroStrategy

Relational Databases

Problem-solving

Education

Bachelor’s Degree

Tools

Statistical Analysis Software

Data Modeling Tools

Job description

Are you looking to join an energetic team? To learn from the industry’s most creative thinkers? To advance your career beyond just a job? Assurety values innovation, and understands how to foster talent in order to develop the next generation of leaders in technology. If this sparks your interest, apply now. Let’s grow together.

Sr. Data Analyst – Sr. ETL Developer Engineer

Job Code: 07222024

Location: Washington DC

Full Time / Hybrid (2 days on-site)

Experience: 8 Years

Reports To: The Project Manager

Benefits: Competitive Pay, Generous PTO, and Holiday Schedule, Outstanding Health Plan, 401(k), Collaborative Team Atmosphere.

Summary:

Assurety Consulting, a leader in the postal/parcel ecosystem, seeks highly qualified applicants for a Data Analyst position. The Sr. Data Analyst-ETL Engineer works with the Project Manager and is responsible for collaborating with the team and lead activities to maintain the infrastructure and workflows for ETL processes. ETL experts are part of a data team that transforms raw data into actionable insights. Implements state-of-the-practice systems and technology in the Client’s environment, using leading approaches, concepts, and ideas. Researches and evaluates system designs to select appropriate technology and use resources efficiently. Evaluate and recommend COTS applications and methodologies that can be acquired to provide technology solutions. Develops transition strategies and plans to cut over legacy systems. Performs Project Management functions by Project Management Institute (PMI) standards.

Conditions of Employment (REQUIRED):

• US Citizenship or Green Card.
• The position requires security clearance.
• Bachelor’s Degree is required for the position.

Preferred Applicant Characteristics:

• A data analyst who uses statistics, computer science, and business acumen to help organizations understand themselves and achieve their goals.
• Designing data storage systems, extracting, transforming, and loading data to build a data pipeline.
• Ensuring efficient and accurate data integration.
• Must have 8+ years’ business and technical analysis experience in a client-facing role with the ability to use PowerPoint, Excel, and other graphical tools such as Qlik, Power BI, Tableau, or MicroStrategy to report to upper management the results of the analysis.
• Must understand relational databases; past database development and data analysis experience is needed.
• Must have prior customer support experience to be able to work with customers and explain the report’s decisions and trends to them.
• Must have experience in SAS, Teradata and Oracle ETL processes and reporting.
• Possesses skills to convert client needs into software requirements.
• Problem-solving skills to recognize, analyze, and respond to business and technical problems.
• Ability to work independently without direct supervision for day-to-day tasks.
• Organized and attentive to details.

Experience Needed:

• At least 8 years experience in analyzing data needs, business needs, and performing business process engineering, proposing solutions.
• At least 8 years’ experience in business and technical analysis in a client-facing role.
• At least 7 years experience in data modeling activities.
• At least 7 years of experience in statistical analysis system (SAS) 9.0 or some equivalent analysis software.
• Verbal and written communication skills must be at a professional level.

Why you should join our team:

Collaborative & Inclusive Culture: Our colleagues work in small, self-organized and cross-functional teams that determine the best tactics to support the vision and strategy set by leadership. We encourage and welcome all ideas, taking an agile approach to creating an amazing product.

Design Thinking for Innovation: With focus on our colleague’s growth within Assurety we have developed a Learning Management System (LMS) that trains all colleagues on Design Thinking for Innovation, Security, BI & Analytics, and the business they are about to support. More trainings are added every year.

Recognition & Awards: Our Colleagues are recognized for their innovative problem solving, goodwill, candor with respect and excellence. We also give out spot bonuses besides the yearly performance bonus.

Workplace: While our headquarters is in Sterling, Virginia, and our largest client in Washington DC (on-site), our team lives across the globe. We partner with our team to help them achieve personal and professional alignment, helping our colleagues to define their own blend of work-life balance.

Office Perks: Colleagues that work out of one of our main offices enjoy beverages, snacks, lunches, and happy hour benefits.

Vacation & Holiday Schedule: We believe this is a partnership and we trust our colleagues to build their own time-off schedule and encourage our teams to take time for their well-being while minimizing impacts to Client’s deliverables.

Growth Opportunity: Through hands-on learning and development, the opportunities are endless.

Focus on Well-Being: We pride ourselves on offering numerous benefit options to best fit the needs of our colleagues and their families, including domestic partners. Benefits include medical (PPO & HDHP-HSA), dental, vision, flexible spending account, commuter benefit, discount programs, life & disability insurance, and accident insurance. We also offer a 401k program with company match and paid parental leave.

Live your Passion: Assurety encourages and promotes monetary and personnel involvement in the causes around the globe. We believe in our Value of Goodwill, and work to find new ways to give back to our communities and make a positive impact. We focus on initiatives in the following areas – technology, charity, volunteerism and honorary contributions.