Data Analyst – ETL Engineer

Performs systems and application engineering through life cycle as an analyst, develops understanding of client's organization, develops user and system.
Data Analyst – ETL Engineer
Job Code: 07222024-1
Department: Professional Services
Minimum Experience: 3-5 Years
Job Location: Washington DC

Full Time / Hybrid (2 days on-site)

Washington, DC

Experience: 3-5 Years

Professional Services

Reports To: The Project Manager

Benefits: Competitive Pay, Generous PTO, 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. This is a full-time position in Washington, D.C., with a remote hybrid working opportunity 2-3 days a week. This position requires a US Postal Service (USPS) security clearance and the applicant must be either a US citizen or a Green Card holder.

The Data Analyst-ETL Engineer works under the Team lead/Project Manager and is responsible for collaborating with the team to perform 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.

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 3+ 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.
  • Proficiency in Excel (Pivot Tables) and Programming Languages (SQL, R, Python, Tableau, JavaScript, C#).
  • 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 3 years experience in analyzing data needs, business needs, and performing business.process engineering, proposing solutions.
  • At least 3 years’ experience in business and technical analysis in client client-facing role.
  • At least 3 years experience in data modeling activities.
  • At least 3 years 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.

See What our colleagues Say about Working at Assurety

Slide

“They give you the tools to do what you do best.”Bernie Fedor

Business Analyst

A voice of experience settles in at
Assurety

Slide

“What stood out immediately is the company’s diversity.”Monique Anthony

Statistical Data Scientist

An epidemiologist finds the perfect workplace with Assurety.

Slide

“We work collaboratively as a team and across teams.”Aisha Khan

Functional Business Analyst

Collaboration isn’t just encouraged, it’s part of Assurety’s culture.

Slide

“It feels like a family.”Esther Ball

Senior Technical Analyst

Assurety employee took a hiatus to explore her dream of serving her country.

Slide

“My contributions are valued....”John Hosier

Senior Technical Analyst

This seasoned professional loves Assurety’s culture.

Slide

“I have more personal interaction with the team... It’s more fun.”Walter Ndi

Senior Data Analyst & Lead

Long-term employee advances his career with courses offered by Assurety.

Who is Assurety Consulting & Solutions:Assurety is a leader and innovator in multiple governmental and commercial sectors, including postal/parcel, marketing, financial, retail and higher education. We harness the power of our 16+ years of experience and the expertise of our professional staff to leverage technology and data to solve the toughest problems facing our clients. Data plays a critical role in almost all workstreams we serve. We encourage colleagues at all levels to participate in problem-solving discussions, and encourage design thinking for innovation in each interaction and deliverable. We have developed a culture that promotes participation and ownership in the process of creating effective solutions to complex problems. As a result, our organization delivers some of the most innovative advanced business and technical solutions in the industry. Our colleagues help our clients save lives, cut costs, improve revenue, directly impact the US economy, and improve their customers’ experience.

Equal Employment Opportunity Policy:Assurety is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at Assurety are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. Assurety Consulting will not tolerate discrimination or harassment based on any of these characteristics. Assurety encourages applicants of all ages.

Apply for this position

Allowed Type(s): .pdf, .doc, .docx
Who is Assurety Consulting & Solutions:

Assurety is a leader and innovator in multiple governmental and commercial sectors, including postal/parcel, marketing, financial, retail and higher education. We harness the power of our 16+ years of experience and the expertise of our professional staff to leverage technology and data to solve the toughest problems facing our clients. Data plays a critical role in almost all workstreams we serve. We encourage colleagues at all levels to participate in problem-solving discussions, and encourage design thinking for innovation in each interaction and deliverable. We have developed a culture that promotes participation and ownership in the process of creating effective solutions to complex problems. As a result, our organization delivers some of the most innovative advanced business and technical solutions in the industry. Our colleagues help our clients save lives, cut costs, improve revenue, directly impact the US economy, and improve their customers’ experience.

Assurety is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at Assurety are based on business needs, job requirements and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. Dell will not tolerate discrimination or harassment based on any of these characteristics. Assurety encourages applicants of all ages.

Maria

ASSURETY CONSULTING & SOLUTIONSHeadquarters

100 Carpenter Drive, Suite 206,
Sterling, VA 20164

OUR LOCATIONWhere to find us?

https://www.assuretyconsulting.com/wp-content/uploads/2022/07/map-1New1point.png

GET IN TOUCHAssurety Consulting & Solutions Social links

Find us on these social network sites
ASSURETY CONSULTING & SOLUTIONSHeadquarters
100 Carpenter Drive, Suite 206,
Sterling, VA 20164
OUR LOCATIONWhere to find us?
https://www.assuretyconsulting.com/wp-content/uploads/2022/07/map-1New1point.png
Washington DC
Toronto
Dubai
Kuala Lumpur
Casablanca
Karachi
GET IN TOUCHAssurety Consulting & Solutions Social links
Find us on these social network sites

Mail Entry and Payment Technology

Pritha Mehra (Vice President)

As a USPS contractor, Assurety defined B2B solutions for the mailing and shipping supply chain, and for the following USPS system functionalities: • Definition and development of solutions for Full-Service Intelligent Mail including: Full-Service ACS, Mail Tracking, Informed Visibility data reporting and communications, Rules for mail preparations, classification and verifications, MID/GRID creation, management and communication functionality, Qualification reports, Postage Statements, FAST appointment scheduling Content Management and B2B transactional functionality MicroStrategy OLAP reports design, Surface Visibility functionality; and The SASP (Seamless Acceptance) system.