CA-Database Architect/Developer - Data Warehouse
About The Position
Sunayu, LLC has an exciting new opportunity to support the Defense Language Institute Foreign Language Center (DLIFLC). We are looking for professionals to help us manage and modernize the IT infrastructure that drives world-class language instruction for the DLIFLC’s diverse academic community. The person in this position is responsible for performing analysis, modification, documentation, and support of daily operations for the data warehousing and reporting system. Responsibilities include supporting the data development/sustainment lifecycle, including data profiling, ETL and data model design and development/sustainment, testing, and support. The duties will include planning, installation, maintenance during or after-work hours, troubleshooting, and managing all Database Developer servers and applications.
Requirements
- Minimum of 5 years of experience designing and developing data warehouses.
- Proven track record of successfully implementing complex data warehouse projects
- Experience with relational database design/modeling using tools.
- Expert-level SQL coding/querying skills in SQL Server and/or MySQL
- Proficient in SQL and advanced SQL query optimization techniques
- Expertise in data warehouse technologies like Snowflake, Redshift, or Teradata
- Knowledge of ETL tools and methodologies
- Familiarity with data modeling concepts (dimensional, star schema, snowflake schema)
- BA/BS degree with a minimum of 5+ years
- AA/AS degree with 7+ year’s experience
- 9+ years of relevant experience may be substituted for the degree requirement
- IAT Level I (A+ CE or Network+ CE) — required.
Nice To Haves
- Programming skills (Python, Java) may be beneficial depending on the environment
- IAT Level II (Security+, CySA+, or SSCP) — preferred for shift leads/escalation or when privileged admin access is assigned.
- Vendor OS cert (Windows or Apple) preferred for imaging/break-fix.
Responsibilities
- Performing analysis, modification, documentation, and support of daily operations for the data warehousing and reporting system.
- Supporting the data development/sustainment lifecycle, including data profiling, ETL and data model design and development/sustainment, testing, and support.
- Planning, installation, maintenance during or after-work hours, troubleshooting, and managing all Database Developer servers and applications.
Benefits
- 3 Medical Plan Options
- Dental and Vision
- FSA, DCFSA, HSA
- Life/AD&D Insurance
- Short-Term & Long-Term Disability
- Employee Assistance Program (EAP)
- Training and Educational Assistance
- Paid Time Off (PTO)
- 11 Federal holidays
- 401k plan with up to a 6% match (100% immediate vesting)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
