Data Engineer

Analytica is seeking a Data Engineer to support a key, long-term federal government client program and software product. The ideal candidate will be comfortable working in an agile, multi-faceted team that involves direct, collaborative client engagement to design and develop software products. 
 
Analytica 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 not limited to):  

• Design and implement star schema dimensional models (fact and dimensions tables) in SQL Server to support business intelligence and analytics requirements 

• Write and optimize scripts for data operations including table creation, indexing strategies, appropriate primary and foreign keys, and slowly changing dimensions. 

• Provide business analysis and develop ETL code and scripting to meet all technical specifications and business requirements according to the established designs. 

• Develop application systems that comply with the standard system development methodology and concepts for design, programming, backup, and recovery to deliver solutions that have superior performance and integrity. 

• Contribute to determining programming approach, tools, and techniques that best meet the business requirements. 

• Provide subject matter expertise in the analysis, preparation of specifications and plans for the development of data processes. 

• Deploys application code and analytical models using CI/CD tools and techniques and provides support for deployed data applications and analytical models 

• Bachelor’s degree in Computer Science, Engineering, IT, or other scientific or quantitative fields 

• 5+ years’ experience designing conceptual, physical and logical data models using enterprise data modeling tools 

• 5+ years’ experience in strategic data planning, governance and standards 

• 5+ years’ experience in leveraging enterprise data warehouse modeling constructs and star schema best practices to ensure flexible, scalable and high performing physical databases 

• Previous hands on experience integrating systems with big data / data lake repositories using ETL tools 

• Experience with technologies such as Microsoft SQL Server, Amazon Redshift, Dbeaver, Visual Studio. 

• Experience with data mining & data warehousing is a must 

• Excellent communication skills, presentation and interpersonal skills are required. Ability to communicate clearly with both business and technical resources 

• Ability to secure a US Federal Clearance. 

• Experience with technologies such as AWS (Glue, Lambda), Git & Github,  

• Certification in SQL Server or data management (CDMP, MCSA, etc) 

• Background in defense healthcare domain.   

 
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 certified 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 3 and is an ISO