Data Architect (Remote) #3413

Careers

  • US-Remote Employee Location
  • Information Technology
Apply Now

GovCIO is a team of transformers–people who are passionate about transforming government I.T. We believe in making a difference by developing digital strategies and delivering the technology-related innovation that improves governmental operations each day.

But we can’t do it alone. We welcome and nurture an inclusive and diversified work culture. Because different backgrounds, experiences, abilities, and perspectives make us better decision-makers, problem solvers, and creators. We’re changing the face of I.T. – from our diverse staff to the end-products we develop. And we’re excited to expand our team. Are you ready to be a transformer?

 

Job Overview

 

GovCIO is seeking a candidate for the position of Data Architect to support the Department of Veterans Affairs (VA). In this role you will support the VA by applying their deep understanding of industry trends and findings and apply this state-of-the-art knowledge in devising strategies, evaluations, and redesigns to avoid or modify products that have negative impacts.

The ideal candidate will have experience in building and maintaining an Operational Data Store and Reporting Data Warehouse. Technical depth in data/database technologies is critical for this role, especially SQL Server. With a focus on software engineering and quality, you will collaborate with product owners, developers, and designers to provide the best value to our customers. You will internally help improve software engineering practices for the entire team.

 

 Responsibilities

  • Create, extend, and tune database schemas, stored procedures, and views in highly distributed, cloud-hosted SQL Server environments.
  • Design schemas with normalization and Fact/Dimension structures
  • Maintain T-SQL source code using Visual Studio Database Projects checked into Git.
  • Deploy SQL Server database changes using DACPAC in an automated DevOps pipeline
  • Provide datasets for reports using real-time data, SSRS, and PowerBI.
  • Create and maintain data models and data dictionaries.
  • Build and Maintain Operational Data Stores and Data Warehouses
  • Secure and protect private personal and health information.
  • Assist in building and maintaining SSIS packages for ETL and Data Transformation.
  • Work in a multi-disciplined team including human-centered designers, front-end specialists, DevOps engineers, and other software engineers.
  • Work with Product Owners and Scrum Teams in requirements decomposition, backlog refinement, breakdown of user stories and tasks.
  • Write unit and integration tests to ensure systems meet business needs.
  • Participate in GitHub Pull Request (PR) code reviews and merges.
  • Collaborate with multiple teams in troubleshooting complex technical or non-technical issues.
  • Develop complex systems capable of processing large volumes of documents (digital and scanned).

 

Qualifications

 

Required Skills and Experience

 

  • Education Requirements: Bachelor’s Degree in Computer Science, Information Systems, Engineering, Mathematics, Science, Technology, and related fields. 
  • 8 years of additional relevant experience may be substituted for education.
  • Must reside and work within the U.S. GovCIO does not provide H1B Visa sponsorship.
  • 5 or more years’ experience in SQL Server.
  • 5 or more years’ experience in T-SQL.
  • Experience in analyzing query execution plans, proficiency in SQL Server Profiler.
  • Experience in analyzing query execution plans, proficiency in SQL Server Profiler.
  • Knowledge of PowerBI.
  • Knowledge of SQL Server Reporting Services (SSRS).
  • Experience in ETL/ELT approaches including SSIS Packages.
  • Experience with SQL/database source control in Git using tools such as Redgate SQL Source Control or Microsoft SQL Server Data Tools.
  • Familiarity with C# as used in SSIS.
  • Familiarity with Azure Synapse as we will be migrating to Azure from On-Prem.
  • Must have strong, collaborative communication skills and writing skills.
  • Must be well versed in all Microsoft Office products.
  • Ability to work independently with minimal guidance and supervision

Preferred Skills and Experience

  • Strong Experience in TSQL Development.
  • Experience with Azure Synapse
  • Experience with conceptual, logical, and physical database modeling.
  • Strong Experience with SSIS C# scripting.
  • Experience with REST APIs
  • Experience in serverless cloud technologies.
  • VA or federal contracting experience.

#Dice

COVID Policy: New employees will be required to adhere to the Company’s and its clients’ COVID-19 safety procedures. In the event that the COVID-19 vaccination mandate for Federal Contractors is enforced, you must become fully vaccinated or request and be approved for an exemption. Employees working onsite at a client location must comply with our client’s COVID-19 requirements.

GovCIO is a team of professionals who want to make a difference. And that can only happen with a diverse, happy, and cared-for team. So, we prioritize your well-being, equity for all and look for ways to make work a better place for each of us every day.

We are an Equal Opportunity Employer. All qualified applicants receive consideration for employment without regard to race, ethnicity, religious affiliation, gender, gender identity or expression, sexual orientation, national origin, or disability status. EOE AA M/F/Vet/Disabled

Compensation Range (In compliance with Colorado's Equal Pay for Equal Work Act for remote or positions located in CO)

$113,000

Apply Now

Not The Right Fit?

Is this not the job you’re looking for? That’s ok! We’ve got plenty of other opportunities for you to peruse. Search all of our open positions by your area of interest or location.

View All Jobs