The Role
The Data Engineer will design and implement data models and ETL processes for a federal client, ensuring high performance and compliance with standards.
Summary Generated by Built In
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):
Basic Qualifications:
Preferred Qualifications:
About ANALYTICA: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD, the company is an established SBA 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 9001:2008 certified provider.
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
Basic Qualifications:
- 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.
Preferred Qualifications:
- 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. Founded in 2009 and headquartered in Bethesda, MD, the company is an established SBA 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 9001:2008 certified provider.
Top Skills
Amazon Redshift
Aws Glue
Aws Lambda
Dbeaver
Git
Git
Microsoft Sql Server
Visual Studio
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Analytica is an award-winning consulting and technology services provider that supports public-sector health, civilian, and national security. We specialize in data-driven solutions, which have been recognized by organizations such as NYU’s Governance Lab for driving public sector modernization and innovation. Analytica is an SBA Certified 8(a), HUBZone that has been honored as one of the 250 fastest-growing businesses in the U.S. for three consecutive years by Inc.
For information on the company visit: www.analytica.net
For exciting career opportunities visit: careers.analytica.net
.png)
