Data Warehouse Architect
To provide data modeling for the Data Management team and Data Tool project to include design concepts and documentation for the creation of data marts that will be used in MicroStrategy for enterprise dashboard creation. Design, develop, and ensure proper documentation is completed, reviewed, and accepted. Participate in peer review of all project documentation, processes, code, etc. Validate and document that modeling items are within scope of requirements. Ensure proper alignment to standards as defined by the unit and Commonwealth. Test and support for the Data Tool project - to include test scenario documentation and UAT support: Support testing tasks and coordinate with the team to help define testing strategies and execution. Support testing tasks to include issue investigation and resolution. Operations and Support for the Data Tool project - to include issue investigation and resolution, training, etc: Ensure data marts are monitored on a timely basis and implement corrective measures to ensure dashboard functionality. Research and document new and existing data modeling/development environments and tools. Have working knowledge of on-going efforts to better plan for future requirements and services. Provide continual improvements on current processes. Schedule and complete technology training as required, and train users on new or modified processes/marts/dashboards. Other duties as assigned, supporting priority projects as needed at discretion of ADS Data Management lead.
Must have experience with Data Model tools (ERStudio, Navicat, or similar), Microsoft SQL Server (SSIS, SSMS) , Source Control, BI tools (Microstrategy, Power BI or similar). The candidate will need to have the ability to work under pressure, adapt to changing environments, multi-task, possess a collaborative working style and the ability to work independently in a team environment. They should be a self-starter, a strong contributor and comfortable working with all members of the Data Management team, engineering, support and business members within the Department of Corrections.
- Data Model tools (ERStudio, Navicat, or similar), Required 5 Years
- Microsoft SQL Server (SSIS, SSMS) Required 5 Years
- BI tools (Microstrategy, Power BI or similar) Required 5 Years
- KEY SKILLS
Job Types: Full-time, Contract
Pay: $54.00 - $56.00 per year
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
- Monday to Friday
- Are you a U.S. Citizen OR Green Card Holder?
- Data Model Tools: 5 years (Preferred)
- SQL Server, SSIS, SSMS: 5 years (Preferred)
- BI Tools: 5 years (Preferred)
- Fully Remote
Let us know
Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if: