Remote Data Warehouse contract jobs

Verstand AI

Verstand AI is a data driven consultancy and product development company that works in multiple commercial business verticals (e.g., retail, pharma, finance, energy) and global public sector entities. The firm specializes in both data governance and delivering insight for client stakeholders.

Our commercial practice is in need of data warehouse analysts that are key members of our delivery teams. As such, you'll have the ability to shape projects, bring on new technologies and interact with stakeholders to address important issues for various companies and society.

POSITION: Senior Data Warehouse Analyst/Modeler

LOCATION: Remote / Washington, DC Area

POSITION HIGHLIGHTS:

Verstand AI is seeking a Senior Data Warehouse Modeler with experience supporting enterprise data warehouse/ analytics data-driven environment. As a Data Warehouse Modeler, s/he will work with the business stakeholders to understand the requirements and design conceptual, logical and physical data models, conducts data risk assessments, data mappings/ and lifecycle and builds a data governance model. Develop relational databases and strategies for data warehouse implementations using industry best practices.

KEY RESPONSIBILITIES:

• Design and oversee data discovery process and instantiate data infrastructure.
• Design reporting facts and dimensions using data warehousing best practices.
• Create physical and logical data models.
• Document the data dictionary.
• Provide direction and definition of data modeling strategy and delivery
• Lead effort of delivering data modeling solutions and platform.
• Implements standards and best practices in support of the EIM vision and reference architecture.
• Develop technical standards and specifications for database models, data security and data warehouse performance
• Develop and coordinate regional and global project efforts. Serve as project leader on assigned projects. Assign tasks to project team; explain work methods, and check work for completeness, timeliness and accuracy.
• Modify, install and prepare technical documentation for Data Modeling tools

JOB REQUIREMENTS:

Minimum Experience, Skills and Education:

• Data auditing and evaluation
• Relational star-schema data model design
• Experience in Data Modeling (Dimensional and other techniques using modeling tools) role, including transactional systems, data warehouses and data marts
• Design, conceptual, logical and physical data models
• Maintain data dictionary and enterprise conceptual data models
• Experience with modeling normalized and de-normalized data structures
• Experience in developing and maintaining data mapping ETL/ELT needs and data lineage
• BI semantic-layer modeling
• Experience and knowledge of reporting platforms such as Microsoft Power BI, Tableau Looker, Data Studio, etc.
• Excellent organizational, time management and communication skills.
• Ability to communicate effectively with peers, management, business groups, contractors, consultants and vendors.
• Ability to define and explain work methods.
• Must maintain confidentiality of proprietary, financial and personal data.
• Experience with cloud databases such as AWS RDS/Redshift, Microsoft Azure Cosmos DB/SQL Server, or Google Cloud Platform BigQuery (preferred).

Education and Experience

• 4 year Bachelor Degree in Information Systems or related field.
• 5-7 years related experience and/or training, or equivalent combination of education and experience.
• Experience leading project teams, directing work, developing requirements working with business.
• Excellent written and verbal communication

WHY WORK AT VERSTAND AI?

All successful data engineers, business intelligence analysts, and data scientists share a love for solving interesting problems.

As a data team, we get to work in many different fields, ranging from healthcare to finance, energy to insurance, and public policy to law enforcement.

We can guarantee that you will never stop learning! Our energetic and engaging environment will help you tackle the hardest problems as part of a highly-cooperative team. So, if that sounds interesting, we'd love to hear from you.

Verstand AI is an equal opportunity employer and offers competitive compensation and benefits. The firm's goal is to make data manageable for its clients and provide the means for both commercial success and social good. To that end, Verstand staff have opportunities to work in multiple business verticals and take part in data for social benefit programs.

Job Types: Full-time, Contract

Benefits:

• 401(k)
• 401(k) Matching
• Dental Insurance
• Disability Insurance
• Flexible Spending Account
• Health Insurance
• Life Insurance
• Retirement Plan
• Tuition Reimbursement
• Vision Insurance

Schedule:

• Monday to Friday

Experience:

• Data Warehouse: 3 years (Required)
• Cloud Computing: 3 years (Preferred)
• Data Modeling: 3 years (Required)

Education:

• Bachelor's (Required)

Contract Renewal:

• Likely

Full Time Opportunity:

• Yes

Work Location:

• Fully Remote

This Company Describes Its Culture as:

• Outcome-oriented -- results-focused with strong performance culture
• People-oriented -- supportive and fairness-focused
• Team-oriented -- cooperative and collaborative

Company's website:

• www.verstand.ai

Benefit Conditions:

• Only full-time employees eligible

Work Remotely:

• Yes

Esri ArchGIS Developer
Atlanta, GA 30308
Contract (1) Year
Pay: $ 64.51

Universal Business Solutions is seeking a Sr. Esri ArcGIS Developer to work on a project converting existing Esri Silverlight API applications into standard Esri ArcGIS Enterprise 10x (Javascript API/WebApp Builder) applications within SharePoint web sites/integrated applications/mobile solutions. This individual will be working in the Enterprise GIS Team of IT Applications. Will work with supporting IT team members (database, network, server, etc.) and interacting with business units. The candidate will follow internal SLDC, standards, and accepted best practices for developed solutions. The team develops enterprise GIS services, applications, and databases. The team coordinates with client, server, network, and database/data warehouse personnel to support and develop the underlying IT solutions.

The Enterprise GIS team is composed of 2 ArcGIS developers, 2 System Administrators, a data manager, and team leader. The team supports over 180 ArcGIS Desktop users and approximately 60,000 annual ArcGIS Server web visits. Applications support GIS portal, feature mapping, project planning, emergency operations, permitting, safety, and traffic records.

Job Responsibilities:

* Develops customized web applications, web services, mobile, and enterprise solutions
* Develops geoprocessing and GIS web services
* Develops GIS web editing/mapping applications
* Conducts performance, unit, system, integration, and quality assurance testing of applications
* Maintains existing applications/services
* Upgrades and migrates existing applications/services to current version/systems architecture
* Provides end user support and creates support documentation
* Works closely with other developers and architects
* Estimates work effort and proposes development solutions
* Assists in the integration of Esri Roads and Highways and Agile Assets

All candidates submitted for this or any other Job Posting that are currently working under a VISA, Employment Authorization Card, or any other authorized programs of the Federal Government must have a current active VISA or status in order to be submitted. Candidates that have an expired VISA or are in the process of applying for an extension, transfer, or a new VISA, should not be submitted.

Position will be working remotely during COVID-19 and transition to on-site in Atlanta GA 30308 as per workforce re-entry plans.

Apply by creating/using an account
Quick Apply

Job Type: Contract

Pay: $63.00 - $64.51 per hour

Benefits:

• Dental Insurance
• Flexible Spending Account
• Health Insurance
• Paid Time Off
• Referral Program
• Tuition Reimbursement
• Vision Insurance

Experience:

• software development: 5 years (Required)
• GIS Developer: 5 years (Required)
• ArcGIS: 5 years (Required)

Education:

• High school or equivalent (Required)

Contract Length:

• 1 year

Contract Renewal:

• Likely

Work Location:

• One location

Schedule:

• Monday to Friday

Work Remotely:

• Temporarily due to COVID-19

Software SQL Engineer (US or Green Card only)

Contract- 6 months plus to Direct

Description:

• The primary purpose of this role is to provide technical support for assigned applications.

• Company is looking for a talented report analyst/developer to join its Data Management team as it builds out a Revenue Cycle BI platform using Microsoft SQL Server technologies. This role will be involved in all aspects of development lifecycle, including analysis, technical design and specifications, development and rollout to end-users. The individual will work directly with team members, leadership and partners to design scalable and extendable solutions, visual and interactive dashboards and reports.

ESSENTIAL FUNCTIONS / JOB DUTIES:

• Implement the reporting responsibilities in the data warehouse
• Design report solutions that align with data management principles, policies, standards and best practices
• Support reporting cycles (ie daily, weekly, monthly)
• Adhere and develop all documentation standards, development lifecycle tasks, and status reporting requirements
• Efficiently deliver high-quality solutions through formalized technical design documents and specifications, proactive testing and on-going quality monitoring
• Work under the direction of the Manager to provide technical application solutions for assigned business areas.
• Identify the common causes of the defects, prioritize them and systematically remove them so that they do not reoccur in further development work.
• Participate in focus groups and workshops, attend vendor training and demonstrations.
• Possess technical knowledge of assigned application technology.
• Work with Business Analyst to understand the customer’s product-specific requirements and configuration and translate them to technical design specifications and data flow from which programs are developed and coded.
• Codes, tests, debugs, implements, and documents programs or technical configuration.
• Ensure programs meet technical specifications and standards.
• Interact with Business Analysts during the software build or configuration and testing process.
• Perform technical application configuration and configure /run reports at user request.
• Design and execute unit, system and integration test plans for new developments/releases/reports.
• Maintain technical documentation based on standard operating procedures in support of the assigned application.
• Perform application maintenance activities
• Provide production support.
• Interface with Business Analyst to assist in resolving support calls escalated by the Service Desk.

PREFERRED SKILLS/EXPERIENCE/QUALIFICATIONS:

• Bachelor's degree in Computer Science, Information Systems, or related field; or equivalent work experience
• Minimum 5 years of experience in SQL and report development
• Proficient in MS SQL Server 2008 R2 – MS SQL SERVER 2019 including T-SQL, SSIS, SSRS and SSAS
• Proficient in Microsoft development in C#, Windows Powershell, Visual Basic and Crystal Reporting
• Effective troubleshooting and performance tuning skills - should be able to identify and resolve moderate performance issues
• Demonstrated understanding of relational database design and architecture
• Demonstrated ability to develop online reporting solutions that meet business need
• Experience designing and building interactive and visual dashboards for delivering information for senior leadership
• Customer service with ability to develop effective partnerships across the organization
• Strong communication (written and verbal) and analytical skills
• Ability to organize, plan, and carry out multiple concurrent objectives or activities, and effectively make judgments in prioritizing and time allocation
• Ability to work independently as well as under the direction of senior team members

Experience:

• 2-4 years Healthcare Industry experience preferred
• 2-5 years practical experience in providing technical support and maintenance in assigned product preferred
• BA or BS degree preferred or other relevant combination of training and experience.

Travel Requirements:

• May require local travel

• May require other travel for business needs

Working Arrangements:

• May require after hours on call support

• Work is performed in a standard office environment with minimal exposure to health or safety hazards

Job Type: Contract

Salary: $50.00 to $57.00 /hour

Experience:

• USA or Green Card Citizen: 1 year (Required)
• SQL Server: 5 years (Required)
• T-SQL: 2 years (Required)
• SSIS: 3 years (Required)
• Healthcare: 2 years (Preferred)
• C#: 1 year (Preferred)
• PowerShell: 1 year (Preferred)
• SQL: 5 years (Required)
• Crystal Reports: 1 year (Required)

Education:

• Bachelor's (Required)

Location:

• Melville, NY 11747 (Required)

Work authorization:

• United States (Required)

Required travel:

• 25% (Required)

Contract Length:

• 5 - 6 months

Full Time Opportunity:

• Yes

Work Location:

• One location
• Fully Remote

Benefits:

• None

Schedule:

• Monday to Friday

Work Remotely:

• Temporarily due to COVID-19

• Minimum 5 years of experience with Azure data platform including Azure SQL, Azure Data Factory, Azure Databricks, Azure SQL Data Warehouse (Synapse Analytics), Azure Data Lake Storage, Azure Cosmos DB, SQL Server, SSIS, SSRS, etc.
• Strong Object/relational mapping experience with UML modeling and OO modeling.
• Demonstrated experience of estimation and planning
• Excellent written and verbal communication skills
• Minimum 5 years of experience with T-SQL, Power BI and Azure Analysis Services
• Experience working with Healthcare data and proven track of implementation experience in EDI data formats.
• Minimum 6 years in job roles involving metadata management, relational/dimensional modeling and big data solution approaches with native Azure Data Platform tools or 1st party services.

Job Type: Contract

Salary: $65.00 to $66.00 /hour

Short Description:
Convert existing Esri Silverlight API applications into standard Esri ArcGIS Enterprise 10x (Javascript API/WebApp Builder) applications within SharePoint web sites/integrated applications/mobile solutions for the Georgia Dept. of Transportation.

Complete Description:
Responsibilities:

• Develops customized web applications, web services, mobile, and enterprise solutions
• Develops geoprocessing and GIS web services
• Develops GIS web editing/mapping applications
• Conducts performance, unit, system, integration, and quality assurance testing of applications
• Maintains existing applications/services
• Upgrades and migrates existing applications/services to current version/systems architecture
• Provides end user support and creates support documentation
• Works closely with other developers and architects
• Estimates work effort and proposes development solutions
• Assists in the integration of Esri Roads and Highways and Agile Assets

Candidate will be working in the Enterprise GIS Team of IT Applications. Candidates will work with supporting IT team members (database, network, server, etc.) and interacting with business units. The candidate will follow internal SLDC, standards, and accepted best practices for developed solutions.

The Enterprise GIS team is composed of 2 ArcGIS developers, 2 System Administrators, a data manager, and team leader. The team supports over 180 ArcGIS Desktop users and approximately 60,000 annual ArcGIS Server web visits. Applications support GIS portal, feature mapping, project planning, emergency operations, permitting, safety, and traffic records.

The team develops enterprise GIS services, applications, and databases. The team coordinates with client, server, network, and database/data warehouse personnel to support and develop the underlying IT solutions.

The position end date is set for the end of the Georgia DOT fiscal year. Georgia DOT may exercise the option to renew contracts in one year increments. Several successful consultants have continued working for several years with contract extensions. However, Georgia DOT is under no obligation to extend contracts and may terminate employment at any time.

GDOT will not increase the pay rate within 2 years of active engagement. After 2 years of engagement, GDOT at its sole discretion may assess pay rate increases. Pay rate increases will be dependent on engagement performance and GDOT budget constraints. GDOT expects pay rate increases to be allocated directly to the person and not suppliers.

All candidates submitted for this or any other Job Posting that are currently working under a VISA, Employment Authorization Card, or any other authorized programs of the Federal Government must have a current active VISA or status in order to be submitted. Candidates that have an expired VISA or are in the process of applying for an extension, transfer, or a new VISA, should not be submitted.

The Department has 12 holidays, which consultants are not allowed to work nor make up any time for those holiday weeks without management's approval.

GDOT will not be providing any raises within the first 2 years. After that point the rate increase will be based on performance and budget dependent.

Position will be working remotely during COVID-19 and transition to on-site at 600 West Peachtree Street NW, Atlanta GA 30308 as per GDOT workforce re-entry plans.
Skills:

Skill
Required /Desired
Amount
of Experience

ArcGIS Online or ArcGIS Portal for Organization experience as Administrator
Required
3
Years

Programming/application development experience
Required
8
Years

Esri JavaScript API (must be capable of developing widgets and not just using Web App Builder)
Required
5
Years

Esri ArcGIS Server services and GeoProcessing services development
Required
4
Years

PL/SQL, SQL
Required
5
Years

Python Scripting
Required
5
Years

Esri WebApp Builder
Required
3
Years

Esri Geoevent Processor, Roads and Highways, and/or Image Server Experience
Required

Experience with industry-standard technologies such as HTML, CSS, XML, XSLT, Git, HTML5, Dojo, Kendo UI, Angular, Dijit, etc.
Required

Bachelor's in geography, GIS, computer science, or a related field
Required

Ability to clearly communicate technical ideas, whether to other technical peers or non-technical project managers or customers
Required

Excellent communication, collaboration, and teamwork skills
Required

Ability to isolate/solve any number of problems from code bugs to database connectivity to application server or operating system failures
Required

Knowledge of geospatial and mapping concepts such as spatial analysis, map projections, etc.
Required

Experience with current technology implementation patterns including service-oriented and cloud
Not Required

Knowledge of IT security concepts and implementation patterns within Esri technology
Required

Geodatabase Administration experience with multi-user versioned environment
Highly desired

Experience with Esri Roads and Highways, Dynamic segmentation and linear referencing systems/methods, transportation data models
Highly desired

Experience with ArcGIS Apps - Collector, Navigator, Survey 123, Operations Dashboard, etc.
Required

URISA GISP or Esri Enterprise Certification
Highly desired

Experience with SafeSoftware Feature Manipulation Engine (FME)
Highly desired

Job Types: Full-time, Contract

Experience:

• ArcGIS: 1 year (Preferred)

Work Remotely:

• No

Job Title : Sr GIS Developer

Location : Atlanta , GA

Duration : 12+ Months

Rate : $60/hrly to $70/hrly based on Good Resume , Experience

Immediate interview

Local to Atlanta , GA Consultants needed.

Senior Consultant is Required .

Minimum 10 years or more Experience Required.

Convert existing Esri Silverlight API applications into standard Esri ArcGIS Enterprise 10x (Javascript API/WebApp Builder) applications within SharePoint web sites/integrated applications/mobile solutions for the Georgia Dept. of Transportation.
Responsibilities:

• Develops customized web applications, web services, mobile, and enterprise solutions
• Develops geoprocessing and GIS web services
• Develops GIS web editing/mapping applications
• Conducts performance, unit, system, integration, and quality assurance testing of applications
• Maintains existing applications/services
• Upgrades and migrates existing applications/services to current version/systems architecture
• Provides end user support and creates support documentation
• Works closely with other developers and architects
• Estimates work effort and proposes development solutions
• Assists in the integration of Esri Roads and Highways and Agile Assets

Candidate will be working in the Enterprise GIS Team of IT Applications. Candidates will work with supporting IT team members (database, network, server, etc.) and interacting with business units. The candidate will follow internal SLDC, standards, and accepted best practices for developed solutions.

The Enterprise GIS team is composed of 2 ArcGIS developers, 2 System Administrators, a data manager, and team leader. The team supports over 180 ArcGIS Desktop users and approximately 60,000 annual ArcGIS Server web visits. Applications support GIS portal, feature mapping, project planning, emergency operations, permitting, safety, and traffic records.

The team develops enterprise GIS services, applications, and databases. The team coordinates with client, server, network, and database/data warehouse personnel to support and develop the underlying IT solutions.

The position end date is set for the end of the Georgia DOT fiscal year. Georgia DOT may exercise the option to renew contracts in one year increments. Several successful consultants have continued working for several years with contract extensions. However, Georgia DOT is under no obligation to extend contracts and may terminate employment at any time.

GDOT will not increase the pay rate within 2 years of active engagement. After 2 years of engagement, GDOT at its sole discretion may assess pay rate increases. Pay rate increases will be dependent on engagement performance and GDOT budget constraints. GDOT expects pay rate increases to be allocated directly to the person and not suppliers.

All candidates submitted for this or any other Job Posting that are currently working under a VISA, Employment Authorization Card, or any other authorized programs of the Federal Government must have a current active VISA or status in order to be submitted. Candidates that have an expired VISA or are in the process of applying for an extension, transfer, or a new VISA, should not be submitted.

The Department has 12 holidays, which consultants are not allowed to work nor make up any time for those holiday weeks without management's approval.

GDOT will not be providing any raises within the first 2 years. After that point the rate increase will be based on performance and budget dependent.

Position will be working remotely during COVID-19 and transition to on-site at 600 West Peachtree Street NW, Atlanta GA 30308 as per GDOT workforce re-entry plans.

| Skill | Required / Desired | Amount of Experience needed | Candidate Experience
| ArcGIS Online or ArcGIS Portal for Organization experience as Administrator | Required | 3+ years |
| Programming/application development experience | Required | 8+ years |
| Esri JavaScript API (must be capable of developing widgets and not just using Web App Builder) | Required | 5+ years |
| Esri ArcGIS Server services and Geo Processing services development | Required | 4+ years |
| PL/SQL, SQL | Required | 5+ years |
| Python Scripting | Required | 5+ years |
| Esri WebApp Builder | Required | 3+ years |
| Esri Geoevent Processor, Roads and Highways, and/or Image Server Experience | Required | |
| Experience with industry-standard technologies such as HTML, CSS, XML, XSLT, Git, HTML5, Dojo, Kendo UI, Angular, Dijit, etc. | Required | |
| Bachelor’s in geography, GIS, computer science, or a related field | Required | |
| Ability to clearly communicate technical ideas, whether to other technical peers or non-technical project managers or customers | Required | |
| Excellent communication, collaboration, and teamwork skills | Required | |
| Ability to isolate/solve any number of problems from code bugs to database connectivity to application server or operating system failures | Required | |
| Knowledge of geospatial and mapping concepts such as spatial analysis, map projections, etc. | Required | |
| Experience with current technology implementation patterns including service-oriented and cloud | Not Required | |
| Knowledge of IT security concepts and implementation patterns within Esri technology | Required | |
| Geodatabases Administration experience with multi-user versioned environment | Highly desired | |
| Experience with Esri Roads and Highways, Dynamic segmentation and linear referencing systems/methods, transportation data models | Highly desired | |
| Experience with ArcGIS Apps - Collector, Navigator, Survey 123, Operations Dashboard, etc. | Required | |
| URISA GISP or Esri Enterprise Certification | Highly desired | |
| Experience with Safe Software Feature Manipulation Engine (FME) | Highly desired | |

Job Types: Full-time, Contract

Pay: $60.00 - $70.00 per hour

Schedule:

• Monday to Friday
• Day shift
• 8 hour shift

Work Remotely:

• Temporarily due to COVID-19

One of our Fortune 500 client based out of Oregon is looking to hire 3 Azure Data Engineers on a full time basis. Prior experience working on Azure is a must

Area of Responsibility

• Participate in design, implementation, and support of a data warehouse and analytics platform utilizing Azure cloud technology
• Design and implement data load processes from On Premises sources into Azure Data Lake and subsequent Azure SQL & SQL Data Warehouse
• Migrate existing processes and data from our On Premises SQL Server and other environments to Azure Data Lake
• Design, develop, and support Azure SQL Database Data Marts for functional area data consumers
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using Microsoft SSIS and/or Azure cloud technology.
• Troubleshoot and support Microsoft SSIS ETL processes for On Premises SQL Data Warehouse
• Explore and learn the latest Azure technologies to provide new capabilities and increase efficiency
• Work with top-notch technical professionals developing complex systems at scale and with a focus on sustained operational excellence
• Collaborate with DW developers; for products that require reporting data and ensure that datasets are in place and are used consistently internally/externally
• Collaborate with data governance; ensure all existing data is created in the right way, and that new data is created according to appropriate standards and with proper documentation
• Read, write, and configure code for end-to-end service telemetry, alerting and self-healing capabilities
• Strive for continuous improvement of code quality and development practices
• Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers

Job Types: Full-time, Contract

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

Benefits:

• 401(k)
• 401(k) Matching
• Dental Insurance
• Disability Insurance
• Employee Discount
• Flexible Schedule
• Flexible Spending Account
• Health Insurance
• Paid Time Off
• Retirement Plan
• Vision Insurance

Schedule:

• Monday to Friday

Experience:

• Azure: 1 year (Preferred)

Application Question:

• Work is remote but you may be asked to travel during Critical Go Live (Which is less than 10% of the time). Are you open for the limited travel?

Contract Length:

• More than 1 year

Work Location:

• Fully Remote

Visa Sponsorship Potentially Available:

• Yes: Other non-immigrant work authorization (e.g. L-1, TN, E-3, O-1, etc.)
• No: Not providing sponsorship for this job

Company's website:

• www.samayconsulting.com

Benefit Conditions:

• Only full-time employees eligible

Work Remotely:

• Yes