ETL Developer Job at Analytica, Washington DC

NnRoU0JHVHV5b3c4K1F0T24zYzVEKzE4VFE9PQ==
  • Analytica
  • Washington DC

Job Description

Analytica is seeking a remote  ETL Developer to support a federal government client.  The ideal candidate is able to work in a consultative approach with clients, has solid experience in ETL development experience. The ETL Developer will be loading data on a weekly basis in a large Compliance Data Warehouse.  

 
Our company has been recognized by Inc. Magazine as one of the fastest-growing 250 businesses in the US for 3 years. We work with U.S. government clients in health, civilian, and national security missions to build better technology products that impact our day-to-day lives. The company offers competitive compensation with opportunities for bonuses, employer-paid health care, training and development funds, and 401k match. 

   Responsibilities include (But Are Not Necessarily Limited To):  
  • Support extract, transform, and load (ETL) processes for SAP/Sybase IQ database and support programs and processes to load update. 
  • Create and maintain SQL scripts, stored procedures, and other program logic to create, update, and delete data. 
  • Design and implement schema changes, manage indexes, and alter data objects to optimize performance. 
  • Design efficient data models from a logical design based on business requirements and available use patterns. 
  • Identify entity relationships, referential integrity constraints, and primary key structures. Perform analysis of tradeoffs between alternative schemas. 
  • Create and maintain documentation that includes file specifications, schema, core record layouts, programs, business requirements, test plans, and other artifacts used in the administration, creation, and execution of database operations
  • Ability to mentor other developers; Experience leading projects and/or teams a plus
Basic Qualifications: 
  • Bachelor’s Degree in Computer Science, IT, Computer Engineering, or related field 
  • Strong SQL development experience, data modeling and database security 
  • Knowledge of /familiar with, Sap Data Services 
  • Experience using SQL tools
  • Experience using Bash and Shell scripting
  • Experience conducting ETL processes on large XML, flat files, and database table data sources 
  • Experience working in Unix and Linux 
  • Familiarity with tax and financial data a plus 

About  ANALYTICA : Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. The company is an award winning   SBA 8(a) small business that has been recognized by Inc. Magazine each of the past three years as one of the 250 fastest-growing companies in the U.S.  Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at  CMMI® Maturity Level 3and is an  ISO 9001:2008 certified provider. 

 

Analytica LLC. is an Equal Employment Opportunity and Affirmative Action employer. We value diversity at all levels. All individuals, regardless of personal characteristics, are encouraged to apply. All qualified applicants will receive consideration for employment without regard to sex, pregnancy, race, religion or religious creed, color, gender, gender identity, gender expression, national origin, ancestry, physical or mental disability, medical condition, genetic information, marital status, registered domestic partner status, age, sexual orientation, military or veteran status, protected veteran status, or any other basis protected by federal, state, local law, ordinance, or regulation and will not be discriminated against on these bases

When receiving email communication from Analytica, please ensure that the email domain is analytica.net to verify its authenticity.

Job Tags

Full time, Local area, Remote job,

Similar Jobs

Better Talent

Remote Executive Assistant Job at Better Talent

 ...Were looking for someone uniquely qualified for a remote role as a Full Time Executive Assistant (30-40) hours per week) to join our team and support...  ...operations of our company. As the owner's right-hand person, you will manage their day-to-day schedule and tasks... 

Walmart Inc.

Senior, Data Engineer | Marketplace | Seller Risk Mitigation Job at Walmart Inc.

 ...Sponsorship .** About Team : Marketplace Engineering team is at the forefront of building core platforms and services to enable Walmart to deliver vast selection at competitive prices and with best-in-class customer experience by enabling third-party sellers to the... 

Scandinavian Market Björk Cafe & Bistro

Junior Sous Chef Job at Scandinavian Market Björk Cafe & Bistro

 ...Junior Sous Chef Bjrk Cafe & Bistro at Scandinavia House About the Role: Bjrk Cafe & Bistro is looking for an experienced and passionate Junior Sous Chef to lead both restaurant and catering operations. This role is ideal for someone with the skills and motivation... 

Spark Driver

Grocery Delivery Driver Job at Spark Driver

 ...boss this holiday season! With the Spark Driver app, you can make some extra holiday...  ...be 18 years of age or older to complete deliveries with the Spark Driver platform. A clean...  ...driver's license Be authorized to perform services as an independent contractor in the U.S.... 

Management Recruiters of Tallahassee

Production Manager Job at Management Recruiters of Tallahassee

 ...equivalent work experience Three (3+) plus years of experience in a production leadership experience in an aluminum or metal fabrication...  ...corrective action Experience or knowledge of CNC machining, mig welding, aerosol painting and/or vinyl printing would be a plus...