Data Engineer
Share
Job Location:
San Antonio, TX - USA
Monthly Salary:
USD 401 - 401
Posted on:
26 days ago
Vacancies:
1 Vacancy
Job Summary
Analytica has been recognized byInc. Magazineas 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:
- Bachelors 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 integratingsystems 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.
AboutAnalytica: 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 businessthat hasbeen recognized by Inc. Magazine each of the past three years as one of the 250 fastest-growingcompanies in the U.S. Analytica specializes in providing software and systems engineering information management analytics & visualization agile project management and management consulting services. The companyis appraised by the Software Engineering Institute (SEI) at CMMI Maturity Level 3 and is an ISO 9001:2008 certified provider.
Analytica LLC is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all individuals regardless of race color religion sex sexual orientation gender identity national origin age disability or any other characteristic protected by applicable federal state or local law. As a federal contractor we comply with the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA) and take affirmative action to employ and advance in employment qualified protected veterans.
We ensure that all employment decisions are based on merit qualifications and business needs. We prohibit discrimination and harassment of any kind. Analytica LLC also provides reasonable accommodations to applicants and employees with disabilities in accordance with applicable laws
When receiving email communication from Analytica please ensure that the email domain is to verify its authenticity.
Required Experience:
Manager
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Analytica is an award-winning federal consulting & IT solutions firm supporting federal health, civilian, & national security missions.
