FASTTEK GLOBALpowered by Fast Switch - Great Lakes
info@fasttek.com
(734) 744-9373
Lansing, Michigan
Data Warehouse Architect 3 #905966
Job Description:
  • Design, implement, and support data warehousing. Implement business rules via stored procedures, middleware, or other technologies.
  • Install and upgrade Tableau server and perform server performance tuning for optimization.
  • Schedule data refreshes on Tableau Server for daily/weekly/monthly increments depending on the dashboard cadences.
  • Design, develop, conducts unit testing, and maintains complex Tableau reports for scalability, manageability, extensibility, performance, and re-use.
  • Work with team members to create useful reports and dashboards that provide insight, improve/automate processes, or otherwise add value to the team.
  • Perform routine maintenance of Tableau server by optimizing and decommissioning internal resource usage.
  • Generate Tableau dashboards with forecast and reference lines using parameters, sets, groups, and calculations.
  • Developing and maintaining the dashboards, related workflows
  • Architecting, Developing, and creating schedules using Tableau Prep Conductor for workflows
  • Optimize the workflows for performance
  • Work experience in Azure Data factory for ETL development
  • Define user interfaces and functional specifications. Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse.
  • Knowledge of data warehouse end-to-end implementation processes, from business
  • requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning.
  • Responsible for proper selection of appropriate hardware, software, tools, and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting and analytic tools.
  • Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality. Setting or enforcing standards and overall architecture for data warehouse systems.
  • Ability to educate the project teams on the standards and architecture of each component of the data warehouse architecture. Very strong written and oral communication skills, including some presentation skills.
  • Design and supervise overall development of Data Mart and Oracle-hosted dimensional models.
  • Create ETL designs to provide easy accession to data marts.
  • Develop data warehousing hardware and software platforms and integrate systems to ensure that integration is effective and meets client specifications.
  • Design and oversee the implementation of data transformation and change processing procedures to ensure that data from multiple sources is aggregated, normalize, and update and then publish to multiple target environments.
  • Establish data standards and policies, data modeling, systems architecture design, and migration system architectures to ensure access to and integrity of data assets.
  • Evaluate reusability of current data for additional analysis, while maintaining integrity and confidentiality of information.
  • Develop data warehousing hardware and software platforms and integrate systems to ensure that integration is effective and meets client specifications.
  • Install database management software and database patches in any environment.
  • Review, install, analyze, and implement security patches to be applied to remain CJIS compliant, Payment Cared Industry (PCI) compliant, and Michigan Cyber Security compliant.
  • Research, analyze, and determine appropriate changes to DBMS parameters to support future application and database needs.
  • Research, analyze, and determine appropriate hardware changes to support future application and database needs. Report recommendations to appropriate DBA specialist and/or technical services.
  • Implement data encryption.
  • Perform Data Export/Import/Load and data transformations between databases in production environments.
  • Perform production data file transfers between different systems, across state agencies, federal government, vendors, etc.
  • Must have thorough knowledge of Oracle materialized views, Oracle partitioning.
  • Perform database performance tuning by identifying index candidates, updating database statistics, using appropriate optimization techniques, optimizer hints and other methods. Document tuning procedures.
  • Implement defined initialization parameters, database instance memory structures and physical data layout for optimal performances
 
Requirements:
  • Database programming experience in data migration and conversion practices, Required 15+ years
  • Writing Oracle packages, procedures, and functions, Required 15+ years
  • Designing, creating, normalizing and maintenance of oracle database objects, Required 15+ years.
  • Experience in performance tuning, Required 15+ years.
  • Knowledge and experience in understanding and implementing of the CJIC poilicies. 10+ years
  • Experience in Oracle Database administration, PL/SQL, packages, security, and stored procedures, Required 12+ years.
  • Designing logical and physical database model, Required 12+ years
  • Knowledge in design, development, implementation, and documentation of data systems.
  • Vast experience in LINUX systems, Required 10+ years.
  • Data analysis and management, Required 10+ years
  • Experience in developing using ETL software. desired 10+ years
  • Experience in Data Modeling and designing Datawarehouse databases, Required 8+ years.
  • Experience in Tableau software Administration. Required 1-3 years
  • Experience in creating Dashboard and Tableau Prep conductor workflows. Required 1-3 years
  • Experience in Azure Data factory for ETL development 1-3 years
 
Additional Info:
 
At FastTek Global, Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories. Also, Doing the right thing is our mantra.  We act responsibly, give back to the communities we serve and have a little fun along the way.
We have been doing this with pride, dedication and plain, old-fashioned hard work for 24 years!
FastTek Global is a financially strong, privately held company that is 100% consultant and client focused.
We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things and we do them for Fortune 10, Fortune 500, and technology start-up companies.
Our benefits are second to none and thanks to our flexible benefit options you can choose the benefits you need or want, options include:
 
  • Medical and Dental (FastTek pays majority of the medical program)
  • Vision
  • Personal Time Off (PTO) Program
  • Long Term Disability (100% paid)
  • Life Insurance (100% paid)
  • 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
 
Plus, we have a lucrative employee referral program and an employee recognition culture.
FastTek Global was named one of the Top Work Places in Michigan by the Detroit Free Press in 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, and 2022!
To view all of our open positions go to: https://www.fasttek.com/fastswitch/findwork
Follow us on Twitter: https://twitter.com/fasttekglobal
Follow us on Instagram: https://www.instagram.com/fasttekglobal
Find us on LinkedIn: https://www.linkedin.com/company/fasttek
You can become a fan of FastTek on Facebook: https://www.facebook.com/fasttekglobal/