Senior Data Architect

Halvik is a highly successful company that puts people first, and we are looking for someone just like you. We are committed to delivering smarter IT-driven solutions bolstered by quality and innovation to help our customers succeed. Come be a part of something truly special!

US Citizen or Green Card EAD required for Public Trust Clearance. Start date is 30 -45 days from date of acceptance.

What You Will Do:

• This position will be responsible for serving as the primary data solutions architect for a data services/visualization platform for a large federal agency. The architect will lead the design of data lakes, data warehouses, and visualization services and work with data/cloud engineers to design data pipelines to ingest, clean and transform both batch and streaming data.
• Leading the design of data warehouses, data lakes and datamarts including both the logical and physical models.
• Assist in soliciting and assessing requirements for the data warehouses/data lakes among data consumers/analysts, visualization specialists, programmers, and engineers.
• Optimizing the design and tuning the performance of data warehouses for efficient loading and high performance for data queries.
• Facilitating change control processes for the data model within the repositories including integrating with CI/CD pipelines.
• Designing and implementing a metadata repository to be used for data discovery/catalog services across the enterprise.
• Provide technical guidance and mentorship to other members of the technical team.

What You Need:

Data Warehousing/Data Architect Experience (10+ years).

• Data Architecting a data lake and/or data warehouse model including defining the use of standard conventions using cloud components (AWS S3, AWS Redshift, AWS Aurora Postgres).
• Creating logical and physical data models for data repositories containing a number of heterogenous sources.
• Creating work streams for the development team using an Agile framework; developing a roadmap Initiatives and Epics and work with a scrum master to define stories with clear acceptance criteria.
• Optimizing data warehouses for high performance for varying types of use cases (high frequency loads, large loads, high frequency queries).
• Implementing various archiving and partitioning approaches to optimize data ingestion, data storage costs and meet data retention requirements.
• Experience designing data models for transactional applications.
• Experience with data replication, high availability, and data migrations tools and techniques.

• Software Development, Leadership and Customer Experience (5+ years).

• The Solution Architect should be able to elicit requirements from the client including complex process flows and design data models that will support the development of the application. Ability to communicate effectively with senior leadership including translating complex technical concepts into specific and understandable technology recommendations.
• Demonstrate an understanding of cloud components in either AWS or Azure to design a cloud-native technical solution for the application e.g. the use of AWS Lambdas, SNS/queues, API Gateway, Cloudfront, CloudFormation. Will lead the data model and process flow controller design to support an efficient and intuitive user interface view for the application.
• The Solution Architect will be responsible for creating work streams for the development team to build out the functional infrastructure and create the application using an Agile framework; developing a roadmap Initiatives and Epics to accomplish the development plan within an Agile framework and work with a scrum master to define stories with clear acceptance criteria.

Preferred Skills:

• Use of integrating visualization tools, such as Tableau, Qlik, Socrata, with data lakes and data warehouses).
• Use of Big Data tools including Apache Spark, Databricks, Sagemaker and MLFlow.
• Experience with Azure data tools including Synapse and Data Factory.
• Net Core 5/6/7 Web Application development experience, particularly on Blazor and Syncfusion Blazor area.
• AWS Certified Solutions Architect
• Bachelor's Degree in a related area or equivalent experience.

Halvik offers a competitive full benefits package including:

Company-supported medical, dental, vision, life, STD, and LTD insurance

Benefits include 11 federal holidays and PTO.

401(k) with company matching

Flexible Spending Accounts for commuter, medical, and dependent care expenses

Tuition Assistance

Charitable Contribution matching

Halvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

Halvik's pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.