Must be US Citizen

Position Title: Data Modeler

Are you excited at the prospect of unlocking the secrets held by a data set? When you dig through data, are you able to find the business value contained within it? In other words, can you dive beneath the surface to answer the question, “So what?” If so, you might be just the type of person we’re seeking.

We are building a system that enables the VA to make its IT policy actionable by bridging the distance between its Technical Reference Model (TRM) and the system inventories provided by BigFix and SCCM. We’re tying together data from many other parts of VA to create a set of tools that will help VA reduce its risk footprint and protect our veterans’ data. Binding these disparate data sources and extracting valuable data is a challenging job. We’re looking for you, a data architect who will understand the datasets and find ways to unify them into something that will drive change.

We have two databases: transactional and data warehouse. The transactional database enables us to integrate new datasets as they are identified so we can find new value; the data warehouse database is optimized for our reporting. We need you to have the expertise to know how each should be architected to extract its maximum value—both from the perspective of our end users, and our developers who will be using them.

You will be joining a collaborative team made up of innovators and smart problem-solvers who aren’t afraid to collectively roll up their sleeves to tackle tough problems that bring value to our client. Join us as we build a system to change the Department of Veterans Affairs for the better.

Must Have:

· 5+ years of experience working in a professional work environment

· 3+ years or substantive experience with SQL Server and T-SQL

· Expertise building relational, star, and snowflake schemas

· Experience designing and implementing effective database solutions and models to store and retrieve complex data.

· Experience preparing detailed reports for management and other departments by analyzing and interpreting data

· Experience with data analysis, including authoring complex SQL queries and stored procedures

· Ability to provide excellent verbal/written communication, explain processes, innovation, and decision-making exercising good judgement

· Bachelors' degree in Computer Science, Math, or technical equivalent with 10 years of professional experience or a total of 18 in lieu of education.

Nice to haves:

• Experience with the Department of Veterans Affairs
• Experience with Power BI, ingesting, exporting, and visualizing data, models, and relationships.
• Experience with PowerShell, Splunk, Python, or JSON
• Experience working with and establishing APIs
• Experience and understanding of VA’s Technical Reference Model
• Experience with software inventory systems – BigFix, SCCM, and their associated reporting capabilities
• Experience with Machine Learning
• Knowledge of Power Aps and Data Migration

Clearance:
Applicants selected may be subject to a government investigation and may need to meet eligibility requirements of the U.S. government client.

Job Types: Full-time, Contract

Pay: $100,000.00 - $110,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Life insurance
• Referral program
• Vision insurance

Schedule:

• 8 hour shift

Application Question(s):

• Are you US Citizen?

Experience:

• Data modeling: 5 years (Preferred)

Work Location: Remote

Please Note :
epokagency.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, epokagency.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.