Data Engineer-Secret Clearance Required

About the role

The Consulting Data Engineer role requires experience in both traditional warehousing technologies and modern database/data warehouse technologies, with a focus on how these technologies affect business outcomes. This role supports engagements such as data lake design, data management, migrations of data warehouses to the cloud, and database security models.

Responsibilities

• Develops high performance distributed data warehouses, distributed analytic systems and cloud architectures
• Participates in developing relational and non-relational data models designed for optimal storage and retrieval
• Develops, tests, and debugs batch and streaming data pipelines (ETL/ELT) to populate databases and object stores from multiple data sources using a variety of scripting languages; provide recommendations to improve data reliability, efficiency and quality
• Works alongside data scientists, supporting the development of high-performance algorithms, models and prototypes
• Implements data quality metrics, standards, guidelines; automates data quality checks / routines as part of data processing frameworks; validates flow of information
• Ensures that Data Warehousing and Big Data systems meet business requirements and industry practices including but not limited to automation of system builds, security requirements, performance requirements and logging/monitoring requirements

Qualifications

• Bachelor’s Degree in Arts/Sciences (BA/BS) or related field
• A minimum of 3- 5 years progressive experience in a related field
• Experience with at least one traditional data warehousing technology (e.g., Teradata, Oracle, SQL Server) and/or modern platforms (e.g., AWS, GCP, Azure)
• Experience in one scripting language ie python, java or scala
• Experience in SQL scripting, tuning, indexing, partitioning, data access patterns, and scaling strategies
• Experience with data integrations and data processing for business intelligence and analytics workloads
• Knowledge of reporting tools like Power BI , Tableau etc
• Ability to translate complex business problems into data-driven solutions
• Hands on experience in setting up End to End cloud based data lakes
• Hands-on experience in database development using views, SQL scripts and transformations
• Ability to translate complex business problems into data-driven solutions
• Flexibility in working across different database technologies and propensity to learn new platforms on-the-fly
• Strong interpersonal skills
• Team player prepared to lead or support depending on situation

Benefits

• Health and Wellbeing: Health, Dental, and Vision Care, Onsite Health Centers, Employee Assistance Program, Wellness program
• Financial Benefits: Competitive pay, Profit Sharing, 401k Plan with Company Matching, Life and Disability Insurance, Tuition Reimbursement
• Paid Time Off: PTO and Sick Leave (starting at 20 days per year) & Holidays (10 per year), Parental Leave, Military Leave, Bereavement
• Additional Perks: Nursing Mothers Benefits, Voluntary Legal, Pet Insurance, Employee Discount Program