Data Engineer (Analytics)

Integrityone Partners; Washington (District of Columbia); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Mentorship programs

Ongoing training and certification opportunities

Competitive raises, bonuses, and promotions

Job summary

Integrityone Partners is seeking a Data Engineer (Analytics) in Washington, D.C. to deliver data solutions for federal law enforcement clients. The ideal candidate will work onsite and should excel in report development, relational databases, and analytics tools.

Key qualifications include US citizenship, technical expertise in SQL and AWS, and a collaborative spirit. Enjoy benefits like mentorship programs and ongoing training. Join us in making an impactful contribution to our nation's safety.

Qualifications

• US Citizenship required to obtain DHS 6C Public Trust clearance.
• Ability to work 100% onsite in Washington D.C.
• 3+ years relevant experience preferred.

Responsibilities

• Gather requirements and collect data for reports.
• Develop scalable, high-performance queries.
• Communicate with clients and collaborate with teams.
• Respond to client needs in tight timeframes.

Skills

Report and Dashboard Development Skills

Relational database experience in Oracle or Postgres

ElasticSearch/OpenSearch query experience

Strong SQL & Data Concepts Knowledge

Education

Bachelor's degree or higher

Tools

AWS (S3, RDS, EC2, Lambda)

PowerBI

Tableau

Jenkins

Git

Job description

INTEGRITYOne Partners - Data Engineer (Analytics)

Location: Washington, D.C.

100% Onsite Full-Time (Monday to Friday)

The Role

You'll be at the forefront of delivering data and software solutions that directly impact our clients' law enforcement mission. You'll work with dedicated team members and clients to solve analytical and technical problems that help federal law enforcement agencies keep our country safe and secure.

Ideal Candidate Profile

• Demonstrates intellectual curiosity and a passion for continuous learning; willing to learn emerging technologies
• Thrives in a collaborative, fast-paced environment; adapts to evolving requirements and complex challenges
• Exhibits strong problem-solving skills and attention to detail; able to troubleshoot data issues and propose effective solutions
• Excellent communication and interpersonal skills; can explain technical concepts to non-technical stakeholders

Required Technical Skills

• Report and Dashboard Development Skills
• Relational database experience in Oracle or Postgres
• ElasticSearch/OpenSearch query experience
• Experience researching, understanding, and combining disparate data sources
• Strong SQL & Data Concepts Knowledge

Desired Technical Skills

• AWS (S3, RDS, EC2, Lambda, Step Function, EventBridge, OpenSearch/ElasticSearch)
• JSON and JSON format mediation techniques
• Reporting and Dashboard building with PowerBI and Tableau
• DevSecOps tools and techniques (Jenkins, Git)
• Familiarity with data management and aggregation patterns such as data warehouse, data mart, data lake, delta lake, lakehouse, data mesh

Key Responsibilities

• Gather requirements, collect data, design and create reports in response to emerging stakeholder needs
• Develop scalable, high-performance queries and analytics tools
• Communicate effectively with clients and collaborate with cross-functional teams
• Respond to client requirements in tight timeframes

Required Qualifications

• US Citizenship (ability to obtain and maintain a DHS 6C Public Trust clearance)
• Bachelor's degree or higher (computer science background recommended but not required with suitable experience)
• Ability to work 100% onsite in Washington D.C. during core business hours

Experience

• Candidates should possess at least 3 years of relevant experience; however we are actively hiring across multiple experience levels, including more senior candidates.
• Leveling and compensation will be determined based on years of experience, technical expertise, and overall qualifications
• Experience working in government or high-security environments is a plus

Career Development & Benefits

• Mentorship programs
• Ongoing training and certification opportunities
• Clear path for advancement within the organization
• Exposure to cutting-edge technologies and high-impact projects
• Competitive raises, bonuses, and promotions

INTEGRITYOne Partners is an equal opportunity employer. Minorities / Females / Veterans / Disabilities. All qualified applicants will be considered without regard to race, ethnicity, color, national origin, religion, sexual orientation, gender identity, veteran status, or status as a qualified individual with a disability or any other personal characteristic protected by law.