Data Engineer

October 31

⚔️ Virginia – Remote

Although this job is listed in Virginia, this company may be open to hiring remote in other states.

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

Apply Now

Receive Emails with Similar Jobs

Analytica

WebsiteLinkedInAll Job Openings

B2B • Government • Consulting

Analytica is a rapidly growing SBA-Certified 8(a) Small Business that specializes in providing advanced analytics, digital transformation, and enterprise data management services primarily to federal agencies. The company focuses on simplifying complex data to enable its clients to make informed decisions, thereby driving success in their missions and citizen services. With a strong emphasis on management consulting and federal technology training, Analytica employs a data-driven approach to enhance the capabilities of government IT systems and organizations. The company is renowned for its collaborative culture and commitment to employee development, ensuring quality service delivery. Analytica is recognized for its support in public sector innovation and adheres to industry standards like Agile, SAFe, and CMMI. Their mission is to assist the government in utilizing digital tools and data analytics to improve service delivery to citizens.

51 - 200 employees

🤝 B2B

🏛️ Government

📋 Description

• 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. • Deploy application code and analytical models using CI/CD tools and techniques and provide support for deployed data applications and analytical models

🎯 Requirements

• 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.

🏖️ Benefits

• Competitive compensation • Opportunities for bonuses • Employer-paid health care • Training and development funds • 401k match