Database Architect

Join to apply for the Database Architect role at Nyla Technology Solutions

2 days ago Be among the first 25 applicants

Design strategies for enterprise databases, data warehouse systems, and multidimensional networks. Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases or data warehouses. Create and optimize data models for warehouse infrastructure and workflow. Integrate new systems with existing warehouse structure and refine system performance and functionality.

Perform Extract, Transform, and Load (ETL) of data

• Ingesting and Cleaning of 2 to 3 new data sets
• Automate the cleaning and upload of new data-sets

Develop 2 new dashboards utilizing the new data sets

• Maintenance of Current Data Sets
• Extract data to S3 Advana Path

Create staging, fact and dimension tables using the extracted data

• Develop reporting tables

The annual base salary range for this role is $100,000-$135,000 (USD), excluding discretionary bonus and benefits. Actual compensation may vary based on location, experience, education, and skills.

• High proficiency in R and/or SQL for data manipulation, extraction, and transformation
• Support for exploratory data analysis efforts
• Experience with data pipelines, ETL platforms, and languages such as Databricks, Python, Spark, Scala, JavaScript/JSON, PL-SQL
• Hands-on experience maintaining and optimizing data pipelines and automation

• 3 to 10+ years of related experience and M.A./M.S.

• Experience with BI tools like Qlik
• Experience with cloud data structures such as AWS S3, delta, and external tables
• Detail-oriented with high-quality results
• Ability to work in cross-functional teams and communicate technical info effectively

Nyla delivers AI, Data Science, and Software Engineering services for the U.S. Government. Headquartered in Maryland, we focus on impactful solutions and innovative approaches. We offer competitive compensation, flexible benefits through our Nyla FLEX program, including flexible pay, leave, and schedules, comprehensive health coverage, 401k matching, professional development funds, student loan repayment, and community volunteering opportunities.

Nyla is an equal opportunity employer.

• Seniority level:
  Mid-Senior level
• Employment type:
  
  Full-time
• Job function:
  Information Technology
• Industries:
  Data Infrastructure and Analytics

Referrals increase your chances of interviewing at Nyla Technology Solutions by 2x.

Locations and recent similar roles are listed, with varying salaries and posting times.